Universal database schema
OwnerWolfgang Flatowinventor
Life of this patent
Estimating the term…
Abstract
The invention provides a computer software product (18) that contains machine readable instructions for execution by an electronic processor to provide a database management system in accordance with a schema (24), the schema includes a first table (34) to store the names of various entity types; a second table (36) related to the first table to store the names of entities of the various entity types; a third table (38) related to the first table to store the names of fields in respect of the various entity types; and one or more value storage tables (40) related to the second and third tables to associate stored field values with entities. The schema includes identifiers, e.g. “EntityType”, “Entity”, “Field”, “FieldType” to indicate the nature of the data to be stored in each of said tables
Claims22
A computer software product containing machine readable instructions for execution by an electronic processor to provide a database management system in accordance with a schema, the schema including:
- a first table to store the names of various entity types;
- a second table related to the first table to store the names of entities of the various entity types;
- a third table related to the first table to store the names of fields in respect of the various entity types;
- one or more value storage tables related to the second and third tables to associate stored field values with entities;
- and
- identifiers to indicate the nature of the data to be stored in each of said tables.
A method implemented by means of an electronic processor to store data, said data concerning a number of entities of various entity types and relationships between the various entity types, the method including:
- storing identifiers of each of the entity types in a first table;
- storing identifiers of each of the number of entities in a second table related to the first table;
- storing identifiers of each of a number of field types for the various entity types in a third table related to the first table;
- and
- storing field values associated with the entities in one or more value storage tables related to the second and third tables.
Dependencies are inferred from the claim text.