Transbase
Trans Base is a relational database management system of the company Transaction Software GmbH. Its development began in the 1980s at the Department of the database pioneer Rudolf Bayer under the name " Mercury ".
Trans base is largely compliant with the SQL standard " SQL2 intermediate level " (SQL -92 ) and supports various language constructs of the SQL2 successor versions (SQL: 1999, SQL: 2003, etc.).
History
In the 1980s, Rudolf Bayer, developed at the Technical University of Munich, along with many graduate and undergraduate students the database management system " Mercury ". Founded in 1987 Rudolf Bayer and some members of his chair the company Transaction Software GmbH, which sells " Mercury " on since then and commercially. 1989 " Mercury " renamed " Trans Base".
Due to the wide use of trans base in the automotive industry, specifically for the creation of spare parts management and documentation systems, took place very early in porting to a larger number of platforms ( variety of UNIX flavors, Linux, Windows, VMS, Mac OS).
The major development of Trans Base were the integration of functions for distributed queries on multiple databases, the addition of a full- text search system especially for languages such as Japanese and Chinese ( "Myriad " ), support for data warehouse functions ("Trans Base Hypercube " ) and the dynamic parallel processing of requests.
Properties
Standard SQL features
Trans base our supports all essential properties required by the SQL standard:
- Comprehensive transaction concept
- Complex queries with nested subqueries
- Referential integrity (among primary keys, foreign keys, check constraints )
- Set Operations
- Updatable Views
- Trigger
- Interfaces to C, C , Java / JDBC, PHP and ODBC
- Export and import of both data and database structures (schemas )
- Extensibility through functions and user definable data types
Extensions
ROM operation
TransbaseCD can operate on read-only media such as CD, DVD, Bluray directly or with a so-called disk cache. The disk cache is persistent and is used both to increase performance ( as a hard disk faster than a read-only memory ) and save the changes. TransbaseCD pages can optionally be compressed, resulting in a factor of 2 results in the rule of space - saving and usually also on processing speed.
Hypercube search
Trans Base Hypercube supports analysis method Relational Online Analytical Processing ( ROLAP ), which is used in particular in the implementation of data warehouse solutions. Search within this set OLAP cube (English hypercubes ) is indexed by UB- trees greatly accelerated (compared to search queries where only classical secondary indexes are used ).
Encoding
Trans Base optionally encrypted all the pages that are stored on disk, according to the Advanced Encryption Standard. In the main memory they are unencrypted for performance reasons.
Parallelization
Trans Base provides parallel query processing using dynamic multithreading technology. Either individual tree parts of the operator tree processed by their own threads or tree paths are repeatedly instantiated by each in their own threads.
Replication
Trans Base supports replication of a master database to multiple slave databases.
Limits
The restrictions described herein relate to the version 6.9:
- The database size is limited to 2 ^ 31 pages or 128 terabyte.
- The page size can be selected between 4 Kbytes and 64 Kbytes.
- The table size is only limited by the maximum database size.
- The maximum BLOB / CLOB size is 2 GB.
- The number of columns in a table is limited to 256. In addition, a tuple must fit into one page.
- The number of rows per table is limited and not only by the size of the database.