Micro edition dynamic object-driven database manipulation and mapping system

• US 20040006549A1
• Filed: 03/24/2003
• Published: 01/08/2004
• Est. Priority Date: 03/22/2002
• Status: Abandoned Application

• Current Assignee: Robert Boucher, Ward Mullins
• Original Assignee: Robert Boucher, Ward Mullins
• Inventors: Boucher, Robert, Mullins, Ward
• Application Number:
  US10/396,216
• Publication Number:
  US 20040006549A1
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

The present invention provides a micro computer system and method for dynamic object-driven database manipulation and mapping system which relates in general to correlating or translating one type of database to another type of database or to an object programming application. Correlating or translating involves relational to object translation, object to object translation, relational to relational, or a combination of the above. Thus, the present invention is directed to dynamic mapping of databases to selected objects that can be used on both a micro computer system and in a larger computer system. Also provided are systems and methods that optionally include caching components, security features, data migration facilities, and components for reading, writing, interpreting and manipulating XML and XMI data files.

Claims

1. A micro computer system comprising at least one data source and a mapping system wherein object programming applications are tailored to delegate both the accessing of a data source and the generation of SQL strings to a runtime library repository, which repository can access the database directly or through a database driver, such as a JDBC driver, without the need to embed specific database accessing mechanisms in the application code.

2. A system according to claim 1, wherein the micro computer system is an embedded device that is a portion of a larger system other than a traditional desktop or laptop computer.

3. A system according to claim 2, wherein the embedded system is a portable or cellular phone, an automobile computing system, part of a home electronic sound or entertainment system, a portable sound or entertainment system, an electronic security system, a smart video game console, or a combination thereof.

4. A system according to claim 1, wherein the micro computer system is a standalone computer system other than a traditional mainframe, desktop, or laptop system.

5. A system according to claim 4, wherein the standalone computer is smart mobile phone, a personal organizer, a portable stock market trading device, a hand held computer or a PDA.

6. A system according to claim 5, wherein standalone computer is adaptable to or includes portable internet access.

7. A system according to claim 1, having a concurrent parameter setting mechanism wherein the runtime library repository can be set to access a particular data source and to generate data source specific database calls and SQL strings.

8. A computer system according to claim 1, wherein the mapping system portion is designed to provide different maps for particular objects to different users and does not permit direct access of computer system users to JDBC drivers for any mapped data sources of the computer system, and wherein the mapping system provides varying levels of access to the mapped data sources for at least two different users of the same system, whereby a user only has access to a particular list of maps that are available to the security level of that user.

9. A computer system according to claim 1, wherein the mapping system portion is designed to provide to a system user who is accessing, creating or updating maps, or accessing objects on a system to make data changes related to a particular object and to promulgate the changes to that object as either local or global changes on the computer system.

10. A computer system according to claim 9, wherein the mapping system portion provides an interface permitting an authorized user to edit or create the tables, fields, or attributes of a data map for an object as a table format or XML file format without requiring the user to have extensive knowledge of a particular relational database as a source of the data, or extensive knowledge about how to directly access that relational database.

11. A computer system according to claim 1, wherein the mapping system provides an interface and features that permit a user to access, create, or update the metadata of a map as a dynamic computer system update, without requiring the user to either open a new connection to the data source or to restart an object application program that is running while the user is dynamically evaluating or changing metadata for a map, and wherein the metadata of a map that a user can dynamically evaluate or change includes a map description of data or relationships between data, and wherein such map description is at least one member selected from the group consisting of a data source relationship, a relationship between at least two objects of an object application, and both a data source relationship and a relationship between at least two objects of an object application.

15. A object language software program that can run in a micro computer system according to claim 1, or in a virtual machine that emulates such a micro computer system, and can generate application programming code from database maps and thereby provide a programming application that will run on a micro computer system, which delegates to a runtime library repository both of the functions of accessing a database and generating SQL strings that are specific to a database or to a JDBC driver for a type of database.

16. An object language software program according to claim 15, wherein the runtime library repository can be modified and tailored to optimize database access calls and to optimize the generation of SQL strings for a particular database.

17. An object language software program according to claim 16, wherein the software program provides the ability to synchronize internal data and/or objects on the micro computer or virtual machine emulator system with an external data store and to provide transparent persistence of data and/or objects between the internal and external data stores.

18. An object language software program according to claim 17, wherein the synchronization and transparent persistence is implemented through communication between directly connected systems or by indirectly communicated machines via telephone, intranet, internet, or satellite communication, or through a combination thereof.

12. A local or distributed computer system which is an intranet, internet or satellite communicated system, wherein the local or distributed system includes a micro computer system or an embedded system comprising a fully synchronized data system and an O/R repository that permits persistence and synchronizing of data between a data source on the micro computer system and a main data source on a larger computer system.

13. The computer system of claim 12, further comprising a mapping system wherein object programming applications are tailored to delegate both the accessing of a data source and the generation of SQL strings to a runtime library repository, which repository can access the database directly or through a database driver, such as a JDBC driver, without the need to embed specific database accessing mechanisms in the application code, and wherein the persistence manager calls the mapping system and in the call delegates accessing or updating of data in the data source to the repository layer, and wherein the a persistence monitor does not complete a transaction until it is notified by the mapping system that a data source has been updated by the mapping system such that any changes to the data will automatically be synchronized with the primary data source or record upon completion, including commit or roll-back of changes for both data sources.

14. The computer system of claim 13, wherein at least one temporary data source can be set up on a microcomputer system or embedded system and is synchronized with the persistence monitor with a data source on a larger system wherein the larger system can be accessed by a JDBC driver and is not merely a duplicate of the micro computer system data source.