Open main menu

Wikipedia β

Transbase is a relational database management system, developed and maintained by Transaction Software GmbH, Munich. The development of Transbase was started in the 1980s by Rudolf Bayer under the name „Merkur“ at the department of Computer Science of the Technical University of Munich (TUM).[1]

Transbase
Developer(s) Transaction Software GmbH
Initial release 1987 (1987)[1]
Stable release
Transbase 7.2 / 2015; 3 years ago (2015)[1]
Written in C, Java, .Net
Operating system Cross-platform
Available in English
Type RDBMS
License proprietary EULA
Website www.transaction.de

Transbase largely conforms with the SQL standard „SQL2 intermediate level“ (SQL-92) and supports various features of SQL2 follow-on versions (SQL:1999, SQL:2003 etc.).[2]

Contents

HistoryEdit

As a professor of the computer science department of the Technical University of Munich, Rudolf Bayer developed a database management system called "Merkur" in the 1980s. The development involved a larger number of diploma and PHD students and resulted in 1987 in a new company, called Transaction Software GmbH, founded by Rudolf Bayer and several co-workers of his institute at TUM. In 1989 „Merkur“ was renamed and called "Transbase". The wide use of Transbase, especially as basis for repair part management and documentation systems in the automobile industry soon led to a considerable number of ports to diverse operating systems, such as UNIX derivatives, Linux, Windows, VMS, and Mac OS. Major steps in the further development of Transbase were the integration of functions for distributed queries to several databases in parallel, the fulltext-search extension and the support of foreign languages, („Myriad“[3]) such as Chinese and Japanese, as well as the support of data warehouse functions („Transbase Hypercube“[4]) and the dynamic, parallel execution of queries.[5]

Properties and functionsEdit

Standard SQL propertiesEdit

Transbase supports all important functions of the SQL standard:[6] extensive transaction concept, complex queries with included subqueries, referential integrity (primary keys, foreign keys, check constraints and others),set operations, updatable views, trigger, interface for C, C++, Java/JDBC, PHP, ODBC export and import of data as well as database schema. The database is extensible via additional functions and custom data types.

ExtensionsEdit

ROM-OperationEdit

The TransbaseCD database option can use read-only storage media such as CD, DVD or Blu-ray Discs. In addition, a persistent disk cache can be utilized to store data for performance improvement and/or for updates of data supplied originally as read-only media.

Hypercube searchEdit

Transbase Hypercube supports Relational Online Analytical Processing (ROLAP), which is primarily used in data warehouse applications. The search function for OLAP data cubes („hyper cubes“) is accelerated dramatically through the use of UB-Trees (in comparison to queries using standard indices).

EncryptionEdit

Transbase offers optional encryption of data stored on disk, using the DES algorithm, as well as encryption of data transferred through database connections.

Parellism of queriesEdit

Transbase provides parallel execution of queries via dynamic multithreading technology. This feature executes parts of the query tree in separate threads or splits query sequences into separate threads.

ReplicationEdit

Transbase supports replication of a master database in several slave database instances.

LimitsEdit

The following summarizes the current limits as implemented in version 6.9 of Transbase:

  • The size of the database is limited to 2^31 pages or 128 Terabyte.
  • The size of a (data) page can vary between 4 kB und 64 kB.
  • The size of a table is limited solely by the maximum size of the database itself.
  • The maximum size of BLOB (Binary Large Objects) is 2 GB.
  • The number of attributes per table is limited to 256. In addition, the length of a record is limited to one data page.
  • The number of records per table is not limited except as given by the maximum size of the database.

ReferencesEdit

  1. ^ a b c "Etappen und Meilensteine unserer Unternehmensentwicklung", transaction.de, Transaction Software GmbH, 29 August 2013, retrieved 29 August 2013 
  2. ^ "Transbase® SQL Sprachumfang", transaction.de, Transaction Software GmbH, 29 August 2013, retrieved 29 August 2013 
  3. ^ Rudolf Bayer (1993), "OMNIS/Myriad: Elektronische Verwaltung und Publikation von multimedialen Dokumenten", GI Jahrestagung, pp. 482–487, ISBN 3-540-57192-2 
  4. ^ Volker Markl; Frank Ramsak; Roland Pieringer; Robert Fenk; Klaus Elhardt; Rudolf Bayer (2001), "The Transbase Hypercube RDBMS: Multidimensional Indexing of Relational Tables", ICDE Demo Sessions, pp. 4–6 
  5. ^ Ralph Acker; Christian Roth; Rudolf Bayer (2008), "Parallel Query Processing in Databases on Multicore Architectures", Lecture Notes in Computer Science, 5022, pp. 2–13, ISBN 978-3-540-69500-4 
  6. ^ Transbase® SQL Reference Manual—Version 6.8.1.40 (PDF), Transaction Software GmbH, 2 November 2010, retrieved 29 August 2013 

External linksEdit