MaxDB
Encyclopedia
MaxDB is an ANSI
SQL-92
(entry level) compliant relational database management system (RDBMS) from SAP AG
, which was delivered also by MySQL AB
from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite
and other applications that require enterprise-level database functionality. It is able to run terabyte-range data in continuous operation.
headed by Rudolf Munz. In the early 1980s it became a database product that subsequently was owned by Nixdorf Computer
, Siemens-Nixdorf, Software AG
and today by SAP AG
. Along this line it has been named VDN, RDS, Reflex, Supra 2, DDB/4, Entire SQL-DB-Server and Adabas D
. In 1997 SAP acquired the software from Software AG and developed it as SAP DB, releasing the source code under the GNU General Public License in October 2000.
In 2003 SAP AG and MySQL AB joined a partnership and re-branded the database system to MaxDB. In October 2007 this reselling was terminated and sales and support of the database reverted back to SAP . SAP AG is now managing MaxDB development, distribution, and support. Source code
of MaxDB is no longer available under the GNU General Public License. SAP also stated that "Further commercial support concepts to cover mission critical use requirements outside of SAP scenarios are currently subject to discussion."
Version 7.5 of MaxDB is a direct advancement of the SAP DB 7.4 code base. Therefore, the MaxDB software version 7.5 can be used as a direct upgrade of previous SAP DB versions starting 7.2.04 and higher.
for JDBC; ODBC; SQLDBC (native C/C++ interface); Precompiler; PHP
; Perl
; Python
; WebDAV
; OLE DB
, ADO
, DAO
, RDO
and .NET
via ODBC; Delphi
and Tcl
via Third Party Programming Interfaces. MaxDB is Cross-platform
, offering releases for HP-UX
, IBM AIX, Linux
, Solaris, Microsoft Windows 2000, Microsoft Windows Server 2003, and Microsoft Windows XP. SAP users should check the details of the platform availability on the SAP product pages for the product that will be used together with MaxDB. MaxDB is subjected to SAP AG's quality assurance process before it is shipped.
MaxDB is an ANSI
SQL-92
(entry level) compliant relational database management system (RDBMS) from SAP AG
, which was delivered also by MySQL AB
from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite
and other applications that require enterprise-level database functionality. It is able to run terabyte-range data in continuous operation.
headed by Rudolf Munz. In the early 1980s it became a database product that subsequently was owned by Nixdorf Computer
, Siemens-Nixdorf, Software AG
and today by SAP AG
. Along this line it has been named VDN, RDS, Reflex, Supra 2, DDB/4, Entire SQL-DB-Server and Adabas D
. In 1997 SAP acquired the software from Software AG and developed it as SAP DB, releasing the source code under the GNU General Public License in October 2000.
In 2003 SAP AG and MySQL AB joined a partnership and re-branded the database system to MaxDB. In October 2007 this reselling was terminated and sales and support of the database reverted back to SAP . SAP AG is now managing MaxDB development, distribution, and support. Source code
of MaxDB is no longer available under the GNU General Public License. SAP also stated that "Further commercial support concepts to cover mission critical use requirements outside of SAP scenarios are currently subject to discussion."
Version 7.5 of MaxDB is a direct advancement of the SAP DB 7.4 code base. Therefore, the MaxDB software version 7.5 can be used as a direct upgrade of previous SAP DB versions starting 7.2.04 and higher.
for JDBC; ODBC; SQLDBC (native C/C++ interface); Precompiler; PHP
; Perl
; Python
; WebDAV
; OLE DB
, ADO
, DAO
, RDO
and .NET
via ODBC; Delphi
and Tcl
via Third Party Programming Interfaces. MaxDB is Cross-platform
, offering releases for HP-UX
, IBM AIX, Linux
, Solaris, Microsoft Windows 2000, Microsoft Windows Server 2003, and Microsoft Windows XP. SAP users should check the details of the platform availability on the SAP product pages for the product that will be used together with MaxDB. MaxDB is subjected to SAP AG's quality assurance process before it is shipped.
MaxDB is an ANSI
SQL-92
(entry level) compliant relational database management system (RDBMS) from SAP AG
, which was delivered also by MySQL AB
from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite
and other applications that require enterprise-level database functionality. It is able to run terabyte-range data in continuous operation.
headed by Rudolf Munz. In the early 1980s it became a database product that subsequently was owned by Nixdorf Computer
, Siemens-Nixdorf, Software AG
and today by SAP AG
. Along this line it has been named VDN, RDS, Reflex, Supra 2, DDB/4, Entire SQL-DB-Server and Adabas D
. In 1997 SAP acquired the software from Software AG and developed it as SAP DB, releasing the source code under the GNU General Public License in October 2000.
In 2003 SAP AG and MySQL AB joined a partnership and re-branded the database system to MaxDB. In October 2007 this reselling was terminated and sales and support of the database reverted back to SAP . SAP AG is now managing MaxDB development, distribution, and support. Source code
of MaxDB is no longer available under the GNU General Public License. SAP also stated that "Further commercial support concepts to cover mission critical use requirements outside of SAP scenarios are currently subject to discussion."
Version 7.5 of MaxDB is a direct advancement of the SAP DB 7.4 code base. Therefore, the MaxDB software version 7.5 can be used as a direct upgrade of previous SAP DB versions starting 7.2.04 and higher.
for JDBC; ODBC; SQLDBC (native C/C++ interface); Precompiler; PHP
; Perl
; Python
; WebDAV
; OLE DB
, ADO
, DAO
, RDO
and .NET
via ODBC; Delphi
and Tcl
via Third Party Programming Interfaces. MaxDB is Cross-platform
, offering releases for HP-UX
, IBM AIX, Linux
, Solaris, Microsoft Windows 2000, Microsoft Windows Server 2003, and Microsoft Windows XP. SAP users should check the details of the platform availability on the SAP product pages for the product that will be used together with MaxDB. MaxDB is subjected to SAP AG's quality assurance process before it is shipped.
(OLTP) performance combined with relatively low hardware requirements.
High availability mode and small fault record is another historically observed feature of MaxDB, which holds some appraisal from the open source software and db communities.
One possible future feature for 7.7.00 is the use of Multiversion Concurrency Control
(MVCC) instead of the current lock based implementation.
the GPL
with exceptions for projects released under other Open Source
licenses.
SAP DB 7.3 and 7.4 were licensed as GPL with LGPL drivers. MaxDB 7.5 was offered under dual licensing.i.e. licensed as GPL with GPL drivers or a commercial license.
From version 7.5 through version 7.6 onwards distribution of MaxDB (previously SAP DB) to the open source community was provided by MySQL AB, the same company that develops the open-source software database, MySQL
.
Development was done by SAP AG, MySQL AB
and the open-source software
community.
In October 2007, SAP assumed full sales and commercial support for MaxDB. MaxDB 7.6 is now closed source, available free-of-charge (without support, and with usage restrictions) for use with non-SAP applications. Commercial support models for using MaxDB outside of SAP environments are under consideration.
Ansi
Ansi is a village in Kaarma Parish, Saare County, on the island of Saaremaa, Estonia....
SQL-92
SQL-92
SQL-92 was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. For all but a few minor incompatibilities, the SQL-89 standard is forwards-compatible with SQL-92....
(entry level) compliant relational database management system (RDBMS) from SAP AG
SAP AG
SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software...
, which was delivered also by MySQL AB
MySQL AB
MySQL AB was a software company. MySQL AB is the creator of MySQL, a relational database management system, as well as related products such as MySQL Cluster...
from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite
MySAP Business Suite
SAP Business Suite is a bundle of business applications that provide integration of information and processes, collaboration, industry-specific functionality, and scalability.SAP Business Suite is based on SAP's technology platform called NetWeaver....
and other applications that require enterprise-level database functionality. It is able to run terabyte-range data in continuous operation.
History
The database development started in 1977 as a research project at the Technical University of BerlinTechnical University of Berlin
The Technische Universität Berlin is a research university located in Berlin, Germany. Translating the name into English is discouraged by the university, however paraphrasing as Berlin Institute of Technology is recommended by the university if necessary .The TU Berlin was founded...
headed by Rudolf Munz. In the early 1980s it became a database product that subsequently was owned by Nixdorf Computer
Nixdorf Computer AG
Nixdorf Computer AG was a computer company founded by Heinz Nixdorf in 1952. Headquartered in Paderborn, Germany, it became the fourth largest computer company in Europe, and a worldwide specialist in banking and point-of-sale systems...
, Siemens-Nixdorf, Software AG
Software AG
Founded in 1969, Software AG is an enterprise software company with over 10,000 enterprise customers in over 70 countries. The company is the second largest software vendor in Germany, the fourth in Europe and among the top 25 globally...
and today by SAP AG
SAP AG
SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software...
. Along this line it has been named VDN, RDS, Reflex, Supra 2, DDB/4, Entire SQL-DB-Server and Adabas D
Adabas D
Adabas D is a relational database management system owned by Software AG since 1994, when Software AG acquired SQL-Datenbanksysteme GmbH from Siemens Nixdorf AG....
. In 1997 SAP acquired the software from Software AG and developed it as SAP DB, releasing the source code under the GNU General Public License in October 2000.
In 2003 SAP AG and MySQL AB joined a partnership and re-branded the database system to MaxDB. In October 2007 this reselling was terminated and sales and support of the database reverted back to SAP . SAP AG is now managing MaxDB development, distribution, and support. Source code
Source code
In computer science, source code is text written using the format and syntax of the programming language that it is being written in. Such a language is specially designed to facilitate the work of computer programmers, who specify the actions to be performed by a computer mostly by writing source...
of MaxDB is no longer available under the GNU General Public License. SAP also stated that "Further commercial support concepts to cover mission critical use requirements outside of SAP scenarios are currently subject to discussion."
Version 7.5 of MaxDB is a direct advancement of the SAP DB 7.4 code base. Therefore, the MaxDB software version 7.5 can be used as a direct upgrade of previous SAP DB versions starting 7.2.04 and higher.
Features
MaxDB is delivered with a set of administration and development tools. Most tools are GUI based and have CLI (Command Line Interface) based counterparts. It offers bindingsLanguage binding
In computing, a binding from a programming language to a library or OS service is an API providing that service in the language.Many software libraries are written in systems programming languages such as C or C++...
for JDBC; ODBC; SQLDBC (native C/C++ interface); Precompiler; PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
; Perl
Perl
Perl is a high-level, general-purpose, interpreted, dynamic programming language. Perl was originally developed by Larry Wall in 1987 as a general-purpose Unix scripting language to make report processing easier. Since then, it has undergone many changes and revisions and become widely popular...
; Python
Python (programming language)
Python is a general-purpose, high-level programming language whose design philosophy emphasizes code readability. Python claims to "[combine] remarkable power with very clear syntax", and its standard library is large and comprehensive...
; WebDAV
WebDAV
Web-based Distributed Authoring and Versioning is a set of methods based on the Hypertext Transfer Protocol that facilitates collaboration between users in editing and managing documents and files stored on World Wide Web servers...
; OLE DB
OLE DB
OLE DB is an API designed by Microsoft for accessing data from a variety of sources in an uniform manner. It is a set of interfaces implemented using the Component Object Model ; it is otherwise unrelated to OLE...
, ADO
ActiveX Data Objects
Microsoft's ActiveX Data Objects is a set of Component Object Model objects for accessing data sources. A part of MDAC, it provides a middleware layer between programming languages and OLE DB...
, DAO
Data Access Object
In computer software, a data access object is an object that provides an abstract interface to some type of database or persistence mechanism, providing some specific operations without exposing details of the database. It provides a mapping from application calls to the persistence layer...
, RDO
Remote Data Objects
Remote Data Objects is the name of an obsolete data access application programming interface primarily used in Microsoft Visual Basic applications on Windows 95 and later operating systems. This includes database connection, queries, stored procedures, result manipulation, and change commits...
and .NET
.NET Framework
The .NET Framework is a software framework that runs primarily on Microsoft Windows. It includes a large library and supports several programming languages which allows language interoperability...
via ODBC; Delphi
Delphi
Delphi is both an archaeological site and a modern town in Greece on the south-western spur of Mount Parnassus in the valley of Phocis.In Greek mythology, Delphi was the site of the Delphic oracle, the most important oracle in the classical Greek world, and a major site for the worship of the god...
and Tcl
Tcl
Tcl is a scripting language created by John Ousterhout. Originally "born out of frustration", according to the author, with programmers devising their own languages intended to be embedded into applications, Tcl gained acceptance on its own...
via Third Party Programming Interfaces. MaxDB is Cross-platform
Cross-platform
In computing, cross-platform, or multi-platform, is an attribute conferred to computer software or computing methods and concepts that are implemented and inter-operate on multiple computer platforms...
, offering releases for HP-UX
HP-UX
HP-UX is Hewlett-Packard's proprietary implementation of the Unix operating system, based on UNIX System V and first released in 1984...
, IBM AIX, Linux
Linux
Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
, Solaris, Microsoft Windows 2000, Microsoft Windows Server 2003, and Microsoft Windows XP. SAP users should check the details of the platform availability on the SAP product pages for the product that will be used together with MaxDB. MaxDB is subjected to SAP AG's quality assurance process before it is shipped.
MaxDB is an ANSI
Ansi
Ansi is a village in Kaarma Parish, Saare County, on the island of Saaremaa, Estonia....
SQL-92
SQL-92
SQL-92 was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. For all but a few minor incompatibilities, the SQL-89 standard is forwards-compatible with SQL-92....
(entry level) compliant relational database management system (RDBMS) from SAP AG
SAP AG
SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software...
, which was delivered also by MySQL AB
MySQL AB
MySQL AB was a software company. MySQL AB is the creator of MySQL, a relational database management system, as well as related products such as MySQL Cluster...
from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite
MySAP Business Suite
SAP Business Suite is a bundle of business applications that provide integration of information and processes, collaboration, industry-specific functionality, and scalability.SAP Business Suite is based on SAP's technology platform called NetWeaver....
and other applications that require enterprise-level database functionality. It is able to run terabyte-range data in continuous operation.
History
The database development started in 1977 as a research project at the Technical University of BerlinTechnical University of Berlin
The Technische Universität Berlin is a research university located in Berlin, Germany. Translating the name into English is discouraged by the university, however paraphrasing as Berlin Institute of Technology is recommended by the university if necessary .The TU Berlin was founded...
headed by Rudolf Munz. In the early 1980s it became a database product that subsequently was owned by Nixdorf Computer
Nixdorf Computer AG
Nixdorf Computer AG was a computer company founded by Heinz Nixdorf in 1952. Headquartered in Paderborn, Germany, it became the fourth largest computer company in Europe, and a worldwide specialist in banking and point-of-sale systems...
, Siemens-Nixdorf, Software AG
Software AG
Founded in 1969, Software AG is an enterprise software company with over 10,000 enterprise customers in over 70 countries. The company is the second largest software vendor in Germany, the fourth in Europe and among the top 25 globally...
and today by SAP AG
SAP AG
SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software...
. Along this line it has been named VDN, RDS, Reflex, Supra 2, DDB/4, Entire SQL-DB-Server and Adabas D
Adabas D
Adabas D is a relational database management system owned by Software AG since 1994, when Software AG acquired SQL-Datenbanksysteme GmbH from Siemens Nixdorf AG....
. In 1997 SAP acquired the software from Software AG and developed it as SAP DB, releasing the source code under the GNU General Public License in October 2000.
In 2003 SAP AG and MySQL AB joined a partnership and re-branded the database system to MaxDB. In October 2007 this reselling was terminated and sales and support of the database reverted back to SAP . SAP AG is now managing MaxDB development, distribution, and support. Source code
Source code
In computer science, source code is text written using the format and syntax of the programming language that it is being written in. Such a language is specially designed to facilitate the work of computer programmers, who specify the actions to be performed by a computer mostly by writing source...
of MaxDB is no longer available under the GNU General Public License. SAP also stated that "Further commercial support concepts to cover mission critical use requirements outside of SAP scenarios are currently subject to discussion."
Version 7.5 of MaxDB is a direct advancement of the SAP DB 7.4 code base. Therefore, the MaxDB software version 7.5 can be used as a direct upgrade of previous SAP DB versions starting 7.2.04 and higher.
Features
MaxDB is delivered with a set of administration and development tools. Most tools are GUI based and have CLI (Command Line Interface) based counterparts. It offers bindingsLanguage binding
In computing, a binding from a programming language to a library or OS service is an API providing that service in the language.Many software libraries are written in systems programming languages such as C or C++...
for JDBC; ODBC; SQLDBC (native C/C++ interface); Precompiler; PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
; Perl
Perl
Perl is a high-level, general-purpose, interpreted, dynamic programming language. Perl was originally developed by Larry Wall in 1987 as a general-purpose Unix scripting language to make report processing easier. Since then, it has undergone many changes and revisions and become widely popular...
; Python
Python (programming language)
Python is a general-purpose, high-level programming language whose design philosophy emphasizes code readability. Python claims to "[combine] remarkable power with very clear syntax", and its standard library is large and comprehensive...
; WebDAV
WebDAV
Web-based Distributed Authoring and Versioning is a set of methods based on the Hypertext Transfer Protocol that facilitates collaboration between users in editing and managing documents and files stored on World Wide Web servers...
; OLE DB
OLE DB
OLE DB is an API designed by Microsoft for accessing data from a variety of sources in an uniform manner. It is a set of interfaces implemented using the Component Object Model ; it is otherwise unrelated to OLE...
, ADO
ActiveX Data Objects
Microsoft's ActiveX Data Objects is a set of Component Object Model objects for accessing data sources. A part of MDAC, it provides a middleware layer between programming languages and OLE DB...
, DAO
Data Access Object
In computer software, a data access object is an object that provides an abstract interface to some type of database or persistence mechanism, providing some specific operations without exposing details of the database. It provides a mapping from application calls to the persistence layer...
, RDO
Remote Data Objects
Remote Data Objects is the name of an obsolete data access application programming interface primarily used in Microsoft Visual Basic applications on Windows 95 and later operating systems. This includes database connection, queries, stored procedures, result manipulation, and change commits...
and .NET
.NET Framework
The .NET Framework is a software framework that runs primarily on Microsoft Windows. It includes a large library and supports several programming languages which allows language interoperability...
via ODBC; Delphi
Delphi
Delphi is both an archaeological site and a modern town in Greece on the south-western spur of Mount Parnassus in the valley of Phocis.In Greek mythology, Delphi was the site of the Delphic oracle, the most important oracle in the classical Greek world, and a major site for the worship of the god...
and Tcl
Tcl
Tcl is a scripting language created by John Ousterhout. Originally "born out of frustration", according to the author, with programmers devising their own languages intended to be embedded into applications, Tcl gained acceptance on its own...
via Third Party Programming Interfaces. MaxDB is Cross-platform
Cross-platform
In computing, cross-platform, or multi-platform, is an attribute conferred to computer software or computing methods and concepts that are implemented and inter-operate on multiple computer platforms...
, offering releases for HP-UX
HP-UX
HP-UX is Hewlett-Packard's proprietary implementation of the Unix operating system, based on UNIX System V and first released in 1984...
, IBM AIX, Linux
Linux
Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
, Solaris, Microsoft Windows 2000, Microsoft Windows Server 2003, and Microsoft Windows XP. SAP users should check the details of the platform availability on the SAP product pages for the product that will be used together with MaxDB. MaxDB is subjected to SAP AG's quality assurance process before it is shipped.
MaxDB is an ANSI
Ansi
Ansi is a village in Kaarma Parish, Saare County, on the island of Saaremaa, Estonia....
SQL-92
SQL-92
SQL-92 was the third revision of the SQL database query language. Unlike SQL-89, it was a major revision of the standard. For all but a few minor incompatibilities, the SQL-89 standard is forwards-compatible with SQL-92....
(entry level) compliant relational database management system (RDBMS) from SAP AG
SAP AG
SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software...
, which was delivered also by MySQL AB
MySQL AB
MySQL AB was a software company. MySQL AB is the creator of MySQL, a relational database management system, as well as related products such as MySQL Cluster...
from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite
MySAP Business Suite
SAP Business Suite is a bundle of business applications that provide integration of information and processes, collaboration, industry-specific functionality, and scalability.SAP Business Suite is based on SAP's technology platform called NetWeaver....
and other applications that require enterprise-level database functionality. It is able to run terabyte-range data in continuous operation.
History
The database development started in 1977 as a research project at the Technical University of BerlinTechnical University of Berlin
The Technische Universität Berlin is a research university located in Berlin, Germany. Translating the name into English is discouraged by the university, however paraphrasing as Berlin Institute of Technology is recommended by the university if necessary .The TU Berlin was founded...
headed by Rudolf Munz. In the early 1980s it became a database product that subsequently was owned by Nixdorf Computer
Nixdorf Computer AG
Nixdorf Computer AG was a computer company founded by Heinz Nixdorf in 1952. Headquartered in Paderborn, Germany, it became the fourth largest computer company in Europe, and a worldwide specialist in banking and point-of-sale systems...
, Siemens-Nixdorf, Software AG
Software AG
Founded in 1969, Software AG is an enterprise software company with over 10,000 enterprise customers in over 70 countries. The company is the second largest software vendor in Germany, the fourth in Europe and among the top 25 globally...
and today by SAP AG
SAP AG
SAP AG is a German software corporation that makes enterprise software to manage business operations and customer relations. Headquartered in Walldorf, Baden-Württemberg, with regional offices around the world, SAP is the market leader in enterprise application software...
. Along this line it has been named VDN, RDS, Reflex, Supra 2, DDB/4, Entire SQL-DB-Server and Adabas D
Adabas D
Adabas D is a relational database management system owned by Software AG since 1994, when Software AG acquired SQL-Datenbanksysteme GmbH from Siemens Nixdorf AG....
. In 1997 SAP acquired the software from Software AG and developed it as SAP DB, releasing the source code under the GNU General Public License in October 2000.
In 2003 SAP AG and MySQL AB joined a partnership and re-branded the database system to MaxDB. In October 2007 this reselling was terminated and sales and support of the database reverted back to SAP . SAP AG is now managing MaxDB development, distribution, and support. Source code
Source code
In computer science, source code is text written using the format and syntax of the programming language that it is being written in. Such a language is specially designed to facilitate the work of computer programmers, who specify the actions to be performed by a computer mostly by writing source...
of MaxDB is no longer available under the GNU General Public License. SAP also stated that "Further commercial support concepts to cover mission critical use requirements outside of SAP scenarios are currently subject to discussion."
Version 7.5 of MaxDB is a direct advancement of the SAP DB 7.4 code base. Therefore, the MaxDB software version 7.5 can be used as a direct upgrade of previous SAP DB versions starting 7.2.04 and higher.
Features
MaxDB is delivered with a set of administration and development tools. Most tools are GUI based and have CLI (Command Line Interface) based counterparts. It offers bindingsLanguage binding
In computing, a binding from a programming language to a library or OS service is an API providing that service in the language.Many software libraries are written in systems programming languages such as C or C++...
for JDBC; ODBC; SQLDBC (native C/C++ interface); Precompiler; PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
; Perl
Perl
Perl is a high-level, general-purpose, interpreted, dynamic programming language. Perl was originally developed by Larry Wall in 1987 as a general-purpose Unix scripting language to make report processing easier. Since then, it has undergone many changes and revisions and become widely popular...
; Python
Python (programming language)
Python is a general-purpose, high-level programming language whose design philosophy emphasizes code readability. Python claims to "[combine] remarkable power with very clear syntax", and its standard library is large and comprehensive...
; WebDAV
WebDAV
Web-based Distributed Authoring and Versioning is a set of methods based on the Hypertext Transfer Protocol that facilitates collaboration between users in editing and managing documents and files stored on World Wide Web servers...
; OLE DB
OLE DB
OLE DB is an API designed by Microsoft for accessing data from a variety of sources in an uniform manner. It is a set of interfaces implemented using the Component Object Model ; it is otherwise unrelated to OLE...
, ADO
ActiveX Data Objects
Microsoft's ActiveX Data Objects is a set of Component Object Model objects for accessing data sources. A part of MDAC, it provides a middleware layer between programming languages and OLE DB...
, DAO
Data Access Object
In computer software, a data access object is an object that provides an abstract interface to some type of database or persistence mechanism, providing some specific operations without exposing details of the database. It provides a mapping from application calls to the persistence layer...
, RDO
Remote Data Objects
Remote Data Objects is the name of an obsolete data access application programming interface primarily used in Microsoft Visual Basic applications on Windows 95 and later operating systems. This includes database connection, queries, stored procedures, result manipulation, and change commits...
and .NET
.NET Framework
The .NET Framework is a software framework that runs primarily on Microsoft Windows. It includes a large library and supports several programming languages which allows language interoperability...
via ODBC; Delphi
Delphi
Delphi is both an archaeological site and a modern town in Greece on the south-western spur of Mount Parnassus in the valley of Phocis.In Greek mythology, Delphi was the site of the Delphic oracle, the most important oracle in the classical Greek world, and a major site for the worship of the god...
and Tcl
Tcl
Tcl is a scripting language created by John Ousterhout. Originally "born out of frustration", according to the author, with programmers devising their own languages intended to be embedded into applications, Tcl gained acceptance on its own...
via Third Party Programming Interfaces. MaxDB is Cross-platform
Cross-platform
In computing, cross-platform, or multi-platform, is an attribute conferred to computer software or computing methods and concepts that are implemented and inter-operate on multiple computer platforms...
, offering releases for HP-UX
HP-UX
HP-UX is Hewlett-Packard's proprietary implementation of the Unix operating system, based on UNIX System V and first released in 1984...
, IBM AIX, Linux
Linux
Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds...
, Solaris, Microsoft Windows 2000, Microsoft Windows Server 2003, and Microsoft Windows XP. SAP users should check the details of the platform availability on the SAP product pages for the product that will be used together with MaxDB. MaxDB is subjected to SAP AG's quality assurance process before it is shipped.
Distinguishing features
MaxDB offers built-in hot backup, does not need any online reorganizations and claims to be SQL 92 Entry-Level compatible. One current development goal is "zero administration" and by this "low TCO". It is also fair to expect good online transaction processingOnline transaction processing
Online transaction processing, or OLTP, refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing...
(OLTP) performance combined with relatively low hardware requirements.
High availability mode and small fault record is another historically observed feature of MaxDB, which holds some appraisal from the open source software and db communities.
Future releases
The next release will have the name MaxDB 7.7.00.One possible future feature for 7.7.00 is the use of Multiversion Concurrency Control
Multiversion concurrency control
Multiversion concurrency control , in the database field of computer science, is a concurrency control method commonly used by database management systems to provide concurrent access to the database and in programming languages to implement transactional memory.For instance, a database will...
(MVCC) instead of the current lock based implementation.
Licensing
MaxDB was licensed under the GNU GPL from versions 7.2 through 7.6. Programming interfaces were licensed underthe GPL
GNU General Public License
The GNU General Public License is the most widely used free software license, originally written by Richard Stallman for the GNU Project....
with exceptions for projects released under other Open Source
Open source
The term open source describes practices in production and development that promote access to the end product's source materials. Some consider open source a philosophy, others consider it a pragmatic methodology...
licenses.
SAP DB 7.3 and 7.4 were licensed as GPL with LGPL drivers. MaxDB 7.5 was offered under dual licensing.i.e. licensed as GPL with GPL drivers or a commercial license.
From version 7.5 through version 7.6 onwards distribution of MaxDB (previously SAP DB) to the open source community was provided by MySQL AB, the same company that develops the open-source software database, MySQL
MySQL
MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
.
Development was done by SAP AG, MySQL AB
MySQL AB
MySQL AB was a software company. MySQL AB is the creator of MySQL, a relational database management system, as well as related products such as MySQL Cluster...
and the open-source software
Open-source software
Open-source software is computer software that is available in source code form: the source code and certain other rights normally reserved for copyright holders are provided under a software license that permits users to study, change, improve and at times also to distribute the software.Open...
community.
In October 2007, SAP assumed full sales and commercial support for MaxDB. MaxDB 7.6 is now closed source, available free-of-charge (without support, and with usage restrictions) for use with non-SAP applications. Commercial support models for using MaxDB outside of SAP environments are under consideration.
See also
- List of relational database management systems
- Comparison of relational database management systemsComparison of relational database management systemsThe following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. This article is not all-inclusive or necessarily up to date...
- Comparison of database toolsComparison of database toolsThe following tables compare general and technical information for a number of available database administrator tools. Please see individual product articles for further information...
External links
- MaxDB Wiki on SAP Developer NetworkSAP Developer NetworkSAP Developer Network is an online community for SAP developers. It is a resource and collaboration channel for SAP developers, architects, consultants and integrators. SDN Hosts forums, expert blogs, a technical library, downloads, a code gallery, Elearning catalog , a Wiki and more...