Transbase

Last updated
Transbase
Developer(s) Transaction Software GmbH
Initial release1987 (1987) [1]
Stable release
Transbase 8.3 / 2022;2 years ago (2022) [1]
Written in C, Java, .Net
Operating system UNIX, Linux, Windows, Mac OS, iOS, Raspberry Pi OS, Embedded Linux, Android
Available inEnglish
Type RDBMS
License proprietary, evaluation license free
Website www.transaction.de

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]

Contents

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]

History

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 functions

Standard SQL properties

Transbase supports all important functions of the SQL standard: [2]

The database is extensible via additional functions and custom data types.

Extensions

ROM-Operation

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. Optionally, TransbaseCD pages can be compressed. This saves half of storage requirement and response times, typically.

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).

Encryption

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

Parallelism of queries

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.

Replication

Transbase supports replication of a master database in several slave database instances. Replication can be configured synchronous (for hot-standby databases) or asynchronous for distributing database changes to a huge number of recipients. Replicated databases can even be cascaded in the latter case.

Transbase Crowd

Transbase Crowd was designed to store IoT data in local edge databases that are connected to a Transbase Crowd database that distributed query processing automatically over all connected edge databases and thus produces global results. Edge resources are perfectly utilised and data transfer is minimized. This database architecture provides perfect scalability for rapidly growing numbers of IoT devices.

Limits

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

Related Research Articles

<span class="mw-page-title-main">Database</span> Organized collection of data in computing

In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a database system. Often the term "database" is also used loosely to refer to any of the DBMS, the database system or an application associated with the database.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source object relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A database management system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems are equipped with the option of using SQL for querying and updating the database.

<span class="mw-page-title-main">Ingres (database)</span> Database software

Ingres Database is a proprietary SQL relational database management system intended to support large commercial and government applications.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.

Online analytical processing, or OLAP, is an approach to answer multi-dimensional analytical (MDA) queries swiftly in computing. OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining. Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas, with new applications emerging, such as agriculture.

SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model database server developed by Sybase Corporation, which later became part of SAP SE. ASE was developed for the Unix operating system, and is also available for Microsoft Windows.

The following tables compare general and technical information for a number of relational database management systems. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

The Access Database Engine is a database engine on which several Microsoft products have been built. The first version of Jet was developed in 1992, consisting of three modules which could be used to manipulate a database.

A spatial database is a general-purpose database that has been enhanced to include spatial data that represents objects defined in a geometric space, along with tools for querying and analyzing such data.

SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP. SQL Anywhere was known as Sybase SQL Anywhere prior to the acquisition of Sybase by SAP.

SAP IQ is a column-based, petabyte scale, relational database software system used for business intelligence, data warehousing, and data marts. Produced by Sybase Inc., now an SAP company, its primary function is to analyze large amounts of data in a low-cost, highly available environment. SAP IQ is often credited with pioneering the commercialization of column-store technology.

Microsoft SQL Server Compact is a discontinued relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile Edition.

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Polyhedra is a family of relational database management systems offered by ENEA AB, a Swedish company. The original version of Polyhedra was an in-memory database management system which could be used in high availability configurations; in 2006 Polyhedra Flash DBMS was introduced to allow databases to be stored in flash memory. All versions employ the client–server model to ensure the data are protected from misbehaving application software, and they use the same SQL, ODBC and type-4 JDBC interfaces. Polyhedra is targeted primarily for embedded use by Original Equipment Manufacturers (OEMs), and big-name customers include Ericsson, ABB, Emerson, Lockheed Martin, United Utilities and Siemens AG.

DataBlitz is a general purpose main memory database management system, developed by Lucent Bell Labs Research from 1993 to 1995. It replaced various home-grown database products used throughout Lucent beginning in 1997.

Volt Active Data is an in-memory database designed by Michael Stonebraker, Sam Madden, and Daniel Abadi.

<span class="mw-page-title-main">Actian Zen</span>

Actian Zen is an ACID-compliant, zero-DBA, embedded, nano-footprint, multi-model, Multi-Platform database management system (DBMS) developed originally by Pervasive Software, which was acquired by Actian Corporation in 2013.

The following is provided as an overview of and topical guide to databases:

<span class="mw-page-title-main">Oracle NoSQL Database</span> Distributed database

Oracle NoSQL Database is a NoSQL-type distributed key-value database from Oracle Corporation. It provides transactional semantics for data manipulation, horizontal scalability, and simple administration and monitoring.

References

  1. 1 2 3 "History", transaction.de, Transaction Software GmbH , retrieved 7 February 2023
  2. 1 2 Transbase® V8.4 documentation, Transaction Software GmbH , retrieved 7 February 2023
  3. ↑ Rudolf Bayer (1993), "OMNIS/Myriad: Elektronische Verwaltung und Publikation von multimedialen Dokumenten", GI Jahrestagung, pp. 482–487, ISBN   978-3-540-57192-6
  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, vol. 5022, pp. 2–13, doi:10.1007/978-3-540-69501-1_2, ISBN   978-3-540-69500-4
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.