System, method and software for creating or maintaining local or distributed mapping and transparent persistence of complex data objects and their data relationships

• US 20080189240A1
• Filed: 02/05/2007
• Published: 08/07/2008
• Est. Priority Date: 02/05/2007
• Status: Abandoned Application

• Current Assignee: Alexandre J. Martins, Ward R. Mullins
• Original Assignee: Alexandre J. Martins, Ward R. Mullins
• Inventors: Mullins, Ward R., Martins, Alexandre J.
• Application Number:
  US11/702,955
• Publication Number:
  US 20080189240A1
• Time in Patent Office: Days
• US Class Current: 707/2
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

The invention provides computer systems, computer data stores and methods and software for accessing and utilizing data stores. More particularly, the present invention provides systems, methods and software for creating or maintaining local or distributed mapping and optional transparent persistence of data objects, objects for stored procedures, complex data objects, data object graphs and associated data stores. The present invention further provides a computer system and software implemented method for a development mapping workspace for improved project management of mapping and persistence development activities along with a system implemented organization of mapping projects. In another aspect, the invention provides a computer system and software implemented methods for automatically mapping objects to one or more data source with an interface for setting variable stringency for such automatic mapping with an optional interface for editing the resulting system generated mapping, which system and software implemented methods may be collectively referred to as a “magic mapper” system. Further, such systems and software implemented methods are optionally integrated with IDEs, case tools and other third party platform or development environments to provide an extension of functionality or alternative functionality to such IDEs, third party platforms and other development environments, and to optionally provide for improved automatic or semi-automatic logic code generation.

Claims

1. A local or distributed computer system comprising a user interface, a working memory storage area and at least one device for permanently storing information, wherein a portion of said memory of said system is loaded with at least one portion of a computer software program containing logic for an object to object application or object to data source mapping system that utilizes a mapping workspace comprising at least two sets of meta data or having access to at least two sets of meta data, wherein one of the two sets provides the meta data for an object application logic program and the other set provides the meta data for at least one data source wherein computer the workspace utilizes computer implemented methods for creating or maintaining mapping for object to object, object to relational or object to XML and optional transparent batch persistence of a complex data object, a complex data object graph model, or a portion of a complex data object graph without the end user being required to understand the underlying object schemas, underlying data source schemas, or relationships and mismatches of both the underlying object schemas and underlying data source schemas.

2. A system according to claim 1, that does not require any modifications to an object model or the inclusion of any persistence byte code in the object model in order to provide persistence for all or a portion of the complex data object graph as a batch process.

3. A system according to claim 2, which provides persistence for a complex data object graph model on a distributed network environment.

4. A computer system and software implemented methods according to claim 1, further comprising computer implemented methods and software for automatically mapping objects to one or more object models, to one or more data sources, or both with an interface for setting mapping variables logic stringency for such automatic mapping and further including an optional interface for editing the resulting system generated mapping.

5. A system and software implemented methods according to claim 4, comprising the further step of providing such a system and software implemented methods that generate mapping output as one or more XML files that can be edited to fine tune, to change, or to add or delete objects, mapping relationships, or both.

6. A system and computer implemented software methods according to claim 1, further providing and utilizing an open and extensible mapping, business logic, and stored procedures repository structure that provides independence from how the mapping of object to object model, object to logic, or object to data source mapping metadata is stored or managed internally by the mapping system and allows standards compatibility with possible user customization and extensibility.

7. A system and computer implemented software methods according to claim 1, further providing a system and computer implemented software methods designed for static and deferred SQL map generation, such that static compilation of SQL logic at runtime permits a developer to interfere or manipulate the SQL used at runtime, while dynamic compilation permits the developer to avoid having to deal with details on how SQL is generated.

8. A system and computer implemented software methods of according to claim 1, further providing integration of the mapping system, including one or more of a mapping workspace system, automatic mapping system, open repository architecture and static or deferred mapping option, with one or more third party IDEs, case tools, or development platforms as an extension or replacement component for such IDEs, case tools, or development platforms by integration of some or all of the above functionality into the third party platform or development environment so that the developer can have access to the system and software implemented methods as an add on to their development environment and can be incorporated into their development process.

9. A system and computer implemented software methods of according to claim 1, further providing integration of the mapping system, including one or more of a mapping workspace system, automatic mapping system, open repository architecture and static or deferred mapping option, with systems and computer implemented logic for automatic, tunable, extensible, or managed code generation facilities to provide better code generation and manageability between the O/R, object to object application, or other object to data source mapping and subsequent code generation output in an automatic generation as a consequence of using the systems and computer implemented methods for one or more of a mapping workspace system, automatic mapping system, open repository architecture and static or deferred mapping option system.

10. A system and software implemented method according to claim 1, wherein the system and methods are adapted for using with a dot net type of system and software that utilizes dot net components as an alternative or replacement for the java software language logic based system.