Transbase
| Transbase | |
|---|---|
| Basic data
|
|
| developer | Transaction Software GmbH |
| Current version | Transbase 7.1 |
| operating system | Unix derivatives , Linux , Windows , Mac OS , Embedded Linux |
| programming language | C , Java , .NET |
| category | Database management system , server |
| License | proprietary |
| German speaking | No |
| www.transaction.de | |
Transbase is a relational database management system from Transaction Software GmbH . Its development began in the 1980s at the chair of database pioneer Rudolf Bayer under the name "Merkur".
Transbase largely conforms to 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 the database management system "Merkur" at the Technical University of Munich together with many doctoral and diploma students. In 1987, Rudolf Bayer and a number of employees in his chair founded the company Transaction Software GmbH , which since then has been developing "Merkur" and selling it commercially. In 1989 "Merkur" was renamed "Transbase".
Due to the widespread use of Transbase in the automotive industry, especially for the creation of spare parts management and documentation systems, it was ported to a larger number of platforms (various UNIX derivatives, Linux, Windows, VMS, Mac OS) very early on.
The main development steps of Transbase were the integration of functions for distributed inquiries on several databases, the extension of a full text search system especially for languages like Japanese and Chinese ("Myriad"), the support of data warehouse functions ("Transbase Hypercube") as well as the dynamic parallel processing of requests.
properties
Standard SQL properties
Transbase supports all the essential properties required by the SQL standard:
- Comprehensive transaction concept
- Complex queries with nested subqueries
- Referential integrity (including 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)
- Expandability through functions and user-definable data types
Extensions
ROM operation
TransbaseCD can be operated on read-only media such as CD , DVD , Blu-ray directly or with a so-called disk cache. The disk cache is persistent and is used both to increase performance (since a hard disk is faster than a read-only memory) and to save changes. TransbaseCD pages can optionally be compressed, which usually results in a factor of 2 in storage space savings and usually also in processing speed.
Hypercube search
Transbase Hypercube supports the Relational Online Analytical Processing (ROLAP) analysis method , which is used in particular in the implementation of data warehouse solutions. The search within the OLAP cube ( hypercubes ) used is greatly accelerated by indexing using UB trees (compared to search queries that only use classic secondary indexes ).
Encryption
Transbase optionally encrypts all pages that are saved on the hard drive in accordance with the Advanced Encryption Standard . For performance reasons, they are unencrypted in the main memory.
Parallelization
Transbase offers parallel request processing using dynamic multithreading technology. Either individual parts of the operator tree are processed by their own threads or tree paths are instantiated several times by their own threads.
Replication
Transbase supports the replication of a master database to several slave databases.
restrictions
The restrictions described here apply to version 6.9:
- The database size is limited to 2 ^ 31 pages or 128 Tbytes.
- The page size can be selected between 4 kByte and 64 kByte.
- 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 on one side.
- The number of rows per table is not limited or only limited by the size of the database.
Individual evidence
- ↑ Stages and milestones in our corporate development. (No longer available online.) In: transaction.de. Archived from the original on February 16, 2015 ; Retrieved August 29, 2013 . Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice.
- ↑ Transbase® SQL language range. (No longer available online.) In: transaction.de. Archived from the original on August 29, 2013 ; Retrieved August 29, 2013 . Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice.
- ^ Rudolf Bayer: OMNIS / Myriad: Electronic administration and publication of multimedia documents . In: GI annual conference . 1993, ISBN 3-540-57192-2 , pp. 482-487 .
- ↑ Volker Markl, Frank Ramsak, Roland Pieringer, Robert Fenk, Klaus Elhardt, Rudolf Bayer: The Transbase Hypercube RDBMS: Multidimensional Indexing of Relational Tables . In: ICDE Demo Sessions . 2001, p. 4-6 .
- ↑ Ralph Acker, Christian Roth, Rudolf Bayer: Parallel Query Processing in Databases on Multicore Architectures . In: Lecture Notes in Computer Science . tape 5022 , 2008, ISBN 978-3-540-69500-4 , pp. 2–13 ( electronic version at link.springer.com ).
- ↑ cf. Transbase® SQL Reference Manual. (PDF; 960 kB) (No longer available online.) In: transaction.de. Archived from the original on January 24, 2014 ; accessed on May 15, 2013 . Info: The archive link was inserted automatically and has not yet been checked. Please check the original and archive link according to the instructions and then remove this notice.
