MaxDB by MySQL

Database backend for MySAP

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!
send us
an update
GPL (GNU General Public License) 
4.0/5 1
Oracle Corporation
ROOT \ Database \ Database Engines
MaxDB is a heavy-duty, SAP-certified open source database for OLTP and OLAP usage which offers high reliability, availability, scalability and a very comprehensive feature set. MaxDB by MySQL is targetted for large mySAP Business Suite environments and other applications that require maximum enterprise-level database functionality and complements the MySQL database server.

Today, about 6,000 customer installations are using MaxDB technology globally, including Toyota, Intel, DaimlerChrysler, Braun-Gillette, Bayer, Colgate, Yamaha, and Deutsche Post (the German Post Office).

High performance, availability, operational reliability, scalability, ease of use, and low total cost of ownership are just a few of the demands that enterprise environments place on a DBMS infrastructure. MaxDB helps you meet these demands. It is a powerful, state-of-the-art DBMS built for enterprise usage scenarios.

Some other features of MaxDB;

Description Maximum Value
Database size 32 TB (with 8 KB page size)
Number of files/volumes per database 64...4096, specified by a configuration parameter
File/volume size (data) 518 ...8 GB (dependent on operating system limitations)
File/volume size (log) 16 TB (dependent on operating system limitations)
SQL statement length >= 16 KB (Default value 64 KB, specified by a system variable)
Identifier length 32 characters
Numeric precision 38 places
Number of tables unlimited
Number of columns per table (with KEY) 1024
Number of columns per table (without KEY) 1023
Number of primary key columns per table 512
Number of columns in an index 16
Number of foreign key columns per table 16
Number of columns in an ORDER or a GROUP clause 128
Number of columns in a SELECT statement 1023
Number of columns in an INSERT statement 1024
Number of columns in a result table 1023
Number of join tables in a SELECT statement 64
Number of triggers per Basis table 3
Number of indexes per table 255
Number of referring CONSTRAINT definitions (foreign key dependencies) per table unlimited
Number of references per table unlimited
Number of rows per table limited by database size
Internal length of a table row 8088 Bytes
Total of internal lengths of all primary key columns 1024 Bytes
Total of internal lengths of all foreign key columns 1024 Bytes
Total of internal lengths of all columns belonging to an index 1024 Bytes
Internal length of a LONG column 2 GB
Length of columns in an ORDER or a GROUP clause 1020 Bytes
Nested trigger levels unlimited
Nested subqueries 127
Number of join conditions in a WHERE clause of a SELECT statement 128
Number of correlated columns in an SQL statement 64
Number of correlated tables in an SQL statement 16
Number of parameters in an SQL statement 2000

Last updated on October 25th, 2010

feature list

#database backend #MySAP backend #MaxDB #backend #MySAP

Add your review!