MaxDB by MySQL

Database backend for MySAP
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

Main features:

  • Reduced cost of your SAP implementation
  • Easy configuration and low administration
  • Elaborate backup and restore capabilities
  • Continuous operation, no scheduled downtimes required
  • Designed for large number of users and high workloads
  • Scales to database sizes in the terabytes
  • High availability through cluster and hot-standby support
  • Synchronization Manager to control enterprise-wide data replication
  • Easy-to-use graphical database tools
  • Available for all enterprise HW/OS platforms
  • Supports all major SAP solutions

last updated on:
October 25th, 2010, 6:26 GMT
license type:
GPL (GNU General Public License) 
developed by:
Oracle Corporation
ROOT \ Database \ Database Engines
MaxDB by MySQL
Download Button

In a hurry? Add it to your Download Basket!

user rating 1



Rate it!

Add your review!