EXtremeDB#Kernel mode deployment

{{Short description|Embedded database management system}}

{{Multiple issues|

{{Advert|date=July 2020}}

{{Undisclosed paid|date=July 2020}}

}}

{{Lowercase title}}

{{Infobox software

|name = eXtremeDB

|logo =

|caption =

|developer = McObject LLC.

|genre = DBMS

|license = Commercial license

|website = {{URL|www.mcobject.com}}

|latest_release_version = 8.2

|latest release date = {{Start date and age|2021}}

|operating_system = Cross-platform

}}

eXtremeDB is a high-performance, low-latency, ACID-compliant embedded database management system using an in-memory database system (IMDS) architecture and designed to be linked into C/C++ based programs. It runs on Windows, Linux, and other real-time and embedded operating systems.

History

eXtremeDB was introduced in 2001 by McObject LLC, targeting embedded systems running in resource-constrained environments (i.e. with limited random-access memory and relatively low-powered central processing units). eXtreme DB has a small code size, only about 150KB. It has native C language application programming interface and available source code. eXtremeDB has a high degree of portability to support the varied processors and operating systems used in embedded systems. Early deployments by customers included integration in digital TV set-top boxes, manufacturing and industrial control systems, and telecom/networking devices. eXtremeDB emerged to manage what industry analysts, and McObject, portray as significant growth in the amount of data managed on such devices.[http://www.eetimes.com/electronics-products/processors/4073887/Cold-hard-data-that-s-deep?pageNumber=1 Cold, hard data that’s deep], eeProductCenter (EE Times)2/28/05{{Cite web |url=http://blogs.forrester.com/tech_product_management/2009/11/remember-the-kiss-principle.html |title=Remember the KISS principle? | Forrester Blogs |access-date=2012-01-26 |archive-url=https://web.archive.org/web/20131029202636/http://blogs.forrester.com/tech_product_management/2009/11/remember-the-kiss-principle.html |archive-date=2013-10-29 |url-status=bot: unknown }} Forrester Research, 11/13/2009[https://www.scribd.com/doc/18222887/ReInventing-Embedded-Database-Technology-For-Embedded-Systems-and-Intelligent-Devices Re-inventing embedded database technology for embedded systems and intelligent devices]. McObject white paper hosted on Scribd.com, 2009

Later editions targeted the high-performance non-embedded software market, including capital markets applications and real-time caching for Web-based applications, including social networks and e-commerce.[http://blog.vdcresearch.com/embedded_sw/2010/06/mcobjects-new-business-looks-anything-but-embedded.html McObject’s New Business Looks Anything Like Embedded], Embedded Software Blog, VDC Research, 6/30/2010

Product features

= Core eXtremeDB engine =

eXtremeDB supports the following features across its product family.[http://www.mcobject.com/embedded-database-features Key eXtremeDB Features], http://www.mcobject.com

== Application programming interfaces ==

== Database indexes ==

== Concurrency mechanisms ==

eXtremeDB supports multiple concurrent users, offering ACID-compliant transactions (as defined by Jim GrayGray, Jim, and Reuter, Andreas (1993), Distributed Transaction Processing: Concepts and Techniques, Morgan Kaufmann, {{ISBN|1-55860-190-2}}) using either of two transaction managers: a multiple-reader, single writer (MURSIW) locking mechanism, or multiversion concurrency control (MVCC) transaction manager (optimistic non-locking model).[http://drdobbs.com/database/221600850 McObject updates eXtremeDB real-time database system], Dr. Dobb’s Journal, 11/9/2009Gerhard Weikum; Gottfried Vossen (2002). "5 Multiversion Concurrency Control". Transactional Information Systems. Morgan Kaufmann. pp. 211–213. {{ISBN|1-55860-508-8}}

== Supported data types ==

eXtremeDB can work with virtually all C language data types including complex types including structures, arrays, vectors, and BLOBs. Unicode is supported.

== Security ==

= Optional features =

== Distributed database management abilities ==

The eXtremeDB high availability edition supports both synchronous (2-safe) and asynchronous (1-safe) database replication, with automatic failover.[http://eetimes.com/electronics-news/4132717/Database-serves-five-nines-embedded-systems Database serves five-nines embedded systems], eWeek, 3/12/2003 eXtremeDB Cluster edition provides for shared-nothing database clustering. eXtremeDB also supports distributed query processing, in which the database is partitioned horizontally and the DBMS distributes query processing across multiple servers, CPUs, and CPU cores.{{cite web|url=http://www.linuxfordevices.com/c/a/News/McObject-ExtremeDB-Cluster/|title=In-memory database released in clustering version|access-date=2012-01-26|archive-url=https://archive.today/20120903185145/http://www.linuxfordevices.com/c/a/News/McObject-ExtremeDB-Cluster/|archive-date=2012-09-03|url-status=dead}}, LinuxDevices.com, 7/20/2011 eXtremeDB supports heterogeneous client platforms (e.g. a mix of Windows, Linux, and RTOSs) with its clustering and high availability features. A single partitioned database can include shards running on hardware and OS platforms.

== Hybrid storage ==

The eXtremeDB Fusion edition provides the option of persistent storage (disk or flash) for specific tables, via a database schema notation.[http://www.epn-online.com/page/50236/mcobject-releases-extremedb-fusion-embedded-database.html McObject releases eXtremeDB Fusion embedded database], Electronic Product News, 5/3/2007 {{Webarchive|url=https://archive.today/20130122151815/http://www.epn-online.com/page/50236/mcobject-releases-extremedb-fusion-embedded-database.html |date=2013-01-22 }}

== Transaction logging ==

The eXtremeDB Transaction Logging edition records changes made to the database and uses this log to recover in the event of device or system failure. This edition includes eXtremeDB Data Relay technology that replicates selected changes to external systems such as enterprise applications and database systems.

== SQL ODBC/JDBC ==

The eXtremeSQL edition provides SQL ODBC support in eXtremeDB and a version 4, level 4 JDBC driver.[http://www.eetimes.com/electronics-news/4135756/McObject-adds-ODBC-API-support-to-eXtremeDB McObject adds ODBC API to eXtremeDB], EE Times, 8/8/2007{{Dead link|date=September 2018}}{{cite web|url=http://www.linuxfordevices.com/c/a/News/McObject-ExtremeDB-45/|title=In-memory DBMS boosts Java|access-date=2012-01-26|archive-url=https://archive.today/20120909042454/http://www.linuxfordevices.com/c/a/News/McObject-ExtremeDB-45/|archive-date=2012-09-09|url-status=dead}}, SQL, and HA abilities. LinuxDevices.com, 11/16/2011{{Dead link|date=September 2018}}

== Kernel mode deployment ==

The eXtremeDB Kernel Mode edition deploys the database system within an operating system kernel, to provide database functions to kernel-based applications logic.[http://embedded-computing.com/kernel-mode-gets-data-faster Kernel mode gets data faster]. Embedded Computing Design, 4/3/2008{{Dead link|date=September 2018}}

== Features for managing market data ==

The eXtremeDB Financial Edition provides features for managing market data (tick data).{{cite web|title=eXtremeDB Financial Edition homepage|url=http://financial.mcobject.com/extremedb-financial-edition/platform/|accessdate=26 December 2012}} A “sequences” data type supports columnar data layout and enables eXtremeDB to offer the benefits of a column-oriented database in handling time series data. The Financial Edition also provides a library of vector-based statistical functions to analyze data in sequences, and a performance monitor.

Benchmarks

McObject published reports on benchmark tests employing eXtremeDB. Main-Memory vs. RAM-Disk Databases: a Linux-Based Benchmark examined IMDS performance versus that of a traditional on-disk DBMS deployed on a RAM disk, on identical application tasks. The benchmark’s stated goal was to test the thesis that an IMDS streamlined architecture delivers a performance benefit beyond that provided by memory-based storage.[http://www.iapplianceweb.com/story/OEG20020104S0070.htm Examining Main Memory Databases] {{Webarchive|url=https://web.archive.org/web/20120310124429/http://www.iapplianceweb.com/story/OEG20020104S0070.htm |date=2012-03-10 }}, iApplianceWeb, 1/4/2002 Another benchmark, the Terabyte-Plus In-Memory Database System (IMDS) Benchmark, documented IMDS scalability and performance in the size range of large enterprise application (versus embedded systems) databases. For the test, engineers created a 1.17 terabyte, 15.54 billion row database with eXtremeDB on a 160-core SGI Altix 4700 system running SUSE Linux Enterprise Server 9.[http://www.mcobject.com/terabyte-plus-benchmark Terabyte-Plus In-Memory Database Benchmark], http://www.mcobject.com

In November, 2012 a marketing report was published for Dell servers with Mellanox InfiniBand.{{cite web|title=Securities Technology Analysis Center Web site|url=http://www.stacresearch.com/mcobject?q=taxonomy/term/461,3|archive-url=https://archive.today/20130203011232/http://www.stacresearch.com/mcobject?q=taxonomy/term/461,3|url-status=dead|archive-date=3 February 2013|accessdate=26 December 2012}}

In late 2014, two more audited benchmark reports were dedicated to eXtremeDB Financial Edition. The first, dated October 29, evaluated McObject's DBMS performance on IBM POWER8 hardware, while the second, on November 18, detailed its application in cloud computing. In 2016, an additional report was conducted to gauge the capabilities of the eXtremeDB Financial Edition.{{Cite web |title= STAC Report: eXtremeDB & IBM at scale under STAC-M3 |work= STAC web site |url= https://stacresearch.com/news/2016/05/09/XTR160413 |date= May 9, 2016 |access-date= March 17, 2017 }}

See also

References

{{reflist}}