openXB for miva merchant 4
TECHNICAL OVERVIEW
OpenXB™ allows you to run Miva Merchant™ with a MySQL™ backend database. OpenXB provides a transparent data access layer that allows any MivaScript v4+ application to take advantage of the performance and stability MySQL by intercepting all xbase database calls and translating them into native MySQL queries.
OpenXB Architecture
The Miva Merchant Virtual Machine (MVM), depicted on the right, provides several application programming interfaces (APIs) for the purpose of extending the capabilities of the MivaScript language.
OpenXB provides a set of plug-in libraries for the MVM for the purpose of utilizing the MySQL Relational Database Management System (RDBMS). Since the OpenXB libraries itegrate directly beneath the MivaScript Application Execution layer, use of the MySQL engine is transparent to the application itself.
Any application written in pure MivaScript can take advantage of the MySQL server backend database without code modifications.
Industry Demand for Standards Based RDBMS Systems
The choice of the database foundation for an application critically affects the performance, speed and data integrity of the software. Many successful software applications have been deployed on flat file databases; however, demand for database migration to a true RDBMS has never been higher in the SMB market. This demand for RDBMS backend systems can be attributed to increasingly complex business environments and the declining cost of client-server database technology. In recent years, the prevelance of web-based application deployment has increased dramatically; and with this increase comes the demand for integration of disparate systems. Migration of proprietary systems to SQL92 based systems paves the way to full system integration.
RMXB Technology Foundation
OpenXB is built on our patent-pending RMXB technology. RMXB technology provides a binary-compatible application interface that permits xbase applications to utilize external database servers.
The RMXB Connector is a library suitable for linking directly into an existing application, and is comprised of two interface components - the Client-Side Connector and the Server-Side Connector. When a client-side connector and a server-side connector are joined, they define an RMXB Connector that allows an existing application written for one specific database type to utilize a different database backend without modifying the application.
Client Side Connector
The client-side connector is custom programmed to be binary compatible with the database interface of an existing application. In the case of OpenXB, the client side connector is an xbase3 interfaced wrapped within the MVM Database API. The MVM Database API is a database abstraction layer designed to route MivaScript database calls through an external library. This API permits third parties to add database functionality directlry into the MivaScript language. The OpenXB Client-Side connector is binary compatible with the Miva Merchant Virtual Machine.
 Server Side Connector
The server-side connector is custom programmed to be binary compatible with a particular database engine. In the case of OpenXB, the server-side connector provides a native communications interface to the MySQL server. The MySQL server is a robust SQL92 compliant RDBMS and is available at no cost under the GPL open source license and also under a non-GPL commercial license. The OpenXB library is binary compatible with the MySQL RDBMS.
RMXB AutoMigration Technology
OpenXB features an extension of the core RMXB technology called RMXB AutoMigration Technology. This provides automatic database and index migration from xbase to MySQL. When a script attempts to open a database (table) or index that does not exist within the MySQL database, OpenXB will attempt to open the xbase version of the database or index. If the xbase file exists, the information from the xbase database or index will automatically be migrated into the MySQL tables. The auto-migration algorithm is transparent to the user and permits application data to be transferred from xbase to MySQL on demand.
Order Now »
| 
