eXtremeDB™ Database’s New ODBC Support Adds Flexibility, Connectivity
August 8, 2007 — McObject® has added support for the Open Database Connectivity (ODBC) application programming interface (API) to its eXtremeDB in-memory embedded database system. The new feature greatly expands eXtremeDB’s ability to share data with systems ranging from mainframes to servers to desktop applications, and enables developers to create new eXtremeDB-based applications using an open and familiar database API.
eXtremeDB’s new ODBC support is included in eXtremeSQL 3.1, the new version of McObject’s SQL embedded database interface, on all platforms, including Linux, UNIX, real-time operating systems and Microsoft Windows. The ODBC driver is also available separately to provide Windows 32-bit applications with ODBC access to eXtremeDB databases residing on both Windows and non-Windows operating systems.
The ODBC interface works with all eXtremeDB editions (In-Memory, High Availability, Transaction Logging, and 64-bit) and with eXtremeDB Fusion, McObject’s hybrid on-disk/in-memory embedded database.
Based on the Call Level Interface specified by the SQL Access Group, ODBC is a library of functions that lets any ODBC-enabled application connect to any database for which an ODBC driver exists, and retrieve/insert/update/delete data using SQL statements. Support for this API first became common in Microsoft Windows systems. However, an ODBC driver manager and ODBC drivers now also exist on UNIX, Linux and many other platforms, creating a universe of systems that can potentially share data with eXtremeDB.
McObject’s technical implementation of ODBC sustains the benefits of high performance and minimal code footprint for which eXtremeDB is known. While applications gain access to most ODBC-compliant databases via driver and driver manager software layers, eXtremeDB also exposes the ODBC application programming interface as direct library calls. This streamlined approach eliminates the driver manager and associated program execution steps, leading to faster performance and smaller code size.
“In a world of heterogeneous systems, ODBC can exponentially increase the value of database contents. Now users can easily access data stored in eXtremeDB on Windows, Linux, UNIX and real-time platforms, and leverage it for a wide range of business purposes. In addition, in certain developer communities, such as Microsoft Windows, knowledge of ODBC is so ubiquitous that developers can use eXtremeDB right away with very little learning curve,” McObject President and CEO Steve Graves said. Graves cited the following among likely usage scenarios for eXtremeDB’s ODBC support:
– Extracting data from eXtremeDB databases embedded in Linux-based military equipment for analysis in Windows desktop applications;
– Transferring customer call records from eXtremeDB databases within telecommunications systems to mainframe billing systems;
– Passing data from real-time, in-memory UNIX-based securities trading systems to Enterprise database systems for archiving and trend analysis.
With eXtremeDB, McObject offers a small footprint, highly portable embedded database management system that meets the unique performance requirements and resource constraints of intelligent devices and real-time systems. eXtremeDB provides critical data management features—including transactions, concurrent access, High Availability and a high-level data definition language—while maintaining a minimal code footprint. As an in-memory database system (IMDS), eXtremeDB delivers the real-time responsiveness demanded in many application categories that cannot tolerate the response latency of on-disk database systems.
eXtremeDB also provides sophisticated development capabilities, such as support for complex data and varied query methods, a powerful debugging environment including a self-diagnostic API that catches a wide range of common programming errors before they slip into runtime code, and optional XML and SQL interfaces.
Founded by embedded database and real-time systems experts, McObject offers proven data management technology that makes intelligent devices smarter, more reliable and more cost-effective to develop and maintain. McObject counts among its customers industry leaders such as Chrysler, EADS, JVC, Tyco Thermal Controls, F5 Networks, CA, Motorola and Lockheed Martin. McObject, based in Issaquah, WA, is committed to providing innovative technology and first-rate services to customers and partners. The company can be reached at +1-425-888-8505, or visit www.mcobject.com.
McObject, eXtremeDB and eXtremeSQL are trademarks or registered trademarks of McObject LLC or its suppliers. All other company or product names mentioned herein are trademarks or registered trademarks of their respective owners.