Smart database

• US 7,730,097 B2
• Filed: 02/10/2005
• Issued: 06/01/2010
• Est. Priority Date: 02/12/2004
• Status: Active Grant

• Current Assignee: MobileFrame LLC
• Original Assignee: MobileFrame LLC
• Inventors: Oswalt, Lonny Lee
• Primary Examiner(s): Alam; Hosain T
• Assistant Examiner(s): Ng; Amy
• Application Number:
  US11/055,941
• Publication Number:
  US 20050182785A1
• Time in Patent Office: 1,937 Days
• Field of Search: 707/101, 707/100, 707/102, 707/103.R, 707/103.Z, 707/104.1, 707/793, 707/803
• US Class Current: 707/793
• CPC Class Codes: G06F 16/2228 Indexing structures
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/289 Object oriented databases

Abstract

A solution is provided wherein only primary keys are used as meta-data to construct many-to-many relationships between table, resulting in amore robust, efficient database structure. Once tables of user-specific data are bound to the database as meta-data using their primary keys, the system may automatically ensure the handling of the records as related units. This eliminates the traditional heavy-weight dependence on foreign key relationships.

Claims

1. A computer-implemented method for storing data in a database, the data containing ordinary data and meta data, the method comprising:

persisting the meta data in the database as at least a parent and a child object definition, each of said object definitions linked to one or more attribute definitions, each of said object definitions describing a format in which to store ordinary data, wherein each of said object definitions includes an identification and a table name;

saving the ordinary data in the database as at least a parent instance storing ordinary data in the format described by the parent object definition and a child instance storing ordinary data in the format described by the child object definition, each of said instances of object definitions linked to one or more instances of attribute definitions, wherein each of said attribute definitions includes an identification and a column name; and

storing identifiers of said parent and child object definition and said parent and child instances of said parent and child object in a relationship table in the database, wherein said storing includes storing an identification of a parent object definition and an identification of a parent instance of said parent object definition in a relationship table along with an identification of a child object definition and an identification of a child instance of said child object definition.

2. The computer-implemented method of claim 1, wherein at least one of said attribute definitions is linked to a list definition.

3. The computer-implemented method of claim 2, wherein at least one of said instances of attribute definitions is linked to an instance of a list definition.

4. The computer-implemented method of claim 1, wherein each of said object definitions further includes a system type allowing the object definition to be defined as private, public, or protected.

5. The computer-implemented method of claim 1, wherein each of said attribute definitions further includes a system type allowing the attribute definition to be defined as private, public, or protected.

6. An apparatus for storing data in a database, the data containing ordinary data and meta data, the apparatus comprising:

a memory;

an object definition and attribute definition meta data persister configured to persist the meta data in the database as at least a parent and a child object definition, each of said object definitions linked to one or more attribute definitions, each of said object definitions describing a format in which to store ordinary data, wherein each of said object definitions includes an identification and a table name;

an object definition instance and attribute definition instance ordinary data saver configured to save the ordinary data in the database as at least a parent instance storing ordinary data in the format described by the parent object definition and a child instance storing ordinary data in the format described by the child object definition, each of said instances of object definitions linked to one or more instances of attribute definitions, wherein each of said attribute definitions includes an identification and a column name;

an object definition and object definition instance relationship table storer coupled to said object definition and attribute definition meta data persister and to said object definition instance and attribute definition instance ordinary data saver, configured to store identifiers of said parent and child object definition and said parent and child instances of said parent and child object in a relationship table in the database, wherein said storing includes storing an identification of a parent object definition and an identification of a parent instance of said parent object definition in a relationship table along with an identification of a child object definition and an identification of a child instance of said child object definition; and

a processor configured to operate the object definition and attribute definition meta data persister, the definition instance and attribute definition instance ordinary data saver, and the object definition and object definition instance relationship table storer.

7. An apparatus for storing data in a database, the data containing ordinary data and meta data, wherein the meta data describes a name for each item of ordinary data, the apparatus comprising:

means for persisting the meta data in the database as at least a parent and a child object definition, each of said object definitions linked to one or more attribute definitions, each of said object definitions describing a format in which to store ordinary data, wherein each of said object definitions includes an identification and a table name;

means for saving the ordinary data in the database as at least a parent instance storing ordinary data in the format described by the parent object definition and a child instance storing ordinary data in the format described by the child object definition, each of said instances of object definitions linked to one or more instances of attribute definitions, wherein each of said attribute definitions includes an identification and a column name;

means for storing identifiers of said parent and child object definition and said parent and child instances of said parent and child object in a relationship table in the database, wherein said storing includes storing an identification of a parent object definition and an identification of a parent instance of said parent object definition in a relationship table along with an identification of a child object definition and an identification of a child instance of said child object definition; and

a processor coupled to the means for persisting, the means for saving, and the means for storing.

8. The apparatus of claim 7, wherein at least one of said attribute definitions is linked to a list definition.

9. The apparatus of claim 8, wherein at least one of said instances of attribute definitions is linked to an instance of a list definition.

10. The apparatus of claim 7, wherein each of said object definitions further includes a system type allowing the object definition to be defined as private, public, or protected.

11. The apparatus of claim 7, wherein each of said attribute definitions further includes a system type allowing the attribute definition to be defined as private, public, or protected.

12. A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform a method for storing data in a database, the data containing ordinary data and meta data, wherein the meta data describes a name for each item of ordinary data, the method comprising:

persisting the meta data in the database as at least a parent and a child object definition, each of said object definitions linked to one or more attribute definitions, each of said object definitions describing a format in which to store ordinary data, wherein each of said object definitions includes an identification and a table name;

saving the ordinary data in the database as at least a parent instance storing ordinary data in the format described by the parent object definition and a child instance storing ordinary data in the format described by the child object definition, each of said instances of object definitions linked to one or more instances of attribute definitions, wherein each of said attribute definitions includes an identification and a column name; and

storing identifiers of said parent and child object definition and said parent and child instances of said parent and child object in a relationship table in the database, wherein said storing includes storing an identification of a parent object definition and an identification of a parent instance of said parent object definition in a relationship table along with an identification of a child object definition and an identification of a child instance of said child object definition.