US 6,651,068 B1 · Fact participant database architecture

Abstract

An event database table architecture includes an event table having information such as, for example, date, time, and activity. An event table has a field for identifying one of a plurality of participating tables, and a field for identifying a row within the identified participating table. A participant table has a field for identifying one of a plurality of participating tables, a second field for identifying a row within the identified participating table, a role code, and a row number identifying the event in the event table. Thus, each entry in the participant table relates to a unitary entry in the event table and also relates to a unitary row in one of the participating tables. Each event, participant, and act of participating can be accessed from any other related data item without accessing extraneous or unrelated data items.

Claims16

Dependent claims

A method for storing data representative of an event comprising:

creating a plurality of participating tables for representing the identification of individuals participating in a particular business event;
creating a business event table for representing the identification of one participating table relating to each business event and for identifying one row within the identified participating table relating to each event;
creating a participant table for representing the individuals participating in each event, and for storing information relating to each participating table corresponding to a particular individual;
and
using the relationship among each entry in the participant table with a unitary entry in the event table, and a unitary row in one participating table, to store or retrieve data representative of an event.

2 more elements

A method for storing data representative of an event comprising the machine implemented method of:

means for creating a plurality participating tables, each having a plurality of rows and columns representing the identification of an individual participating in a particular business event;
means for creating an event table having a plurality of rows and columns wherein
each event table row corresponds to a particular business event, and wherein
each event table column corresponds to an information field for storing information relating to each business event;
means for creating a first event table field for identifying one of the plurality of participating tables relating to each event table row;
means for creating a second event table field for identifying one row within the identified participating table relating to each business event;
means for creating a participant table having a plurality of rows and columns wherein each participant table row corresponds to an individual participating in a particular event, and wherein each participant table column corresponds to an information field for storing information relating to each participating table corresponding to an individual participating in a particular event;
means for creating a first participant table field for identifying one of the plurality of participating tables relating to each participant table row;
means for creating a second participant table field for identifying one row within the identified participating table;
means for creating a third participant table field for identifying the role of the individual in the particular event;
and
means for creating a forth participant table field identifying a row in the event table to which the individual in the particular event relates.

9 more elements

A program storage device readable by machine, tangibly embodying a program of instructions executable by machine to perform a method for storing data representative of an event comprising, the method comprising:

creating a plurality participating tables, each having a plurality of rows and columns representing the identification of an individual participating in a particular business event;
creating an event table having a plurality of rows and columns wherein
each event table row corresponds to a particular business event, and wherein
each event table column corresponds to an information field for storing information relating to each business event;
creating a first event table field for identifying one of the plurality of participating tables relating to each event table row;
creating a second event table field for identifying one row within the identified participating table relating to each business event;
creating a participant table having a plurality of rows and columns wherein
each participant table row corresponds to an individual participating in a particular event, and wherein
each participant table column corresponds to an information field for storing information relating to each participating table corresponding to an individual participating in a particular event;
creating a first participant table field for identifying one of the plurality of participating tables relating to each participant table row;
creating a second participant table field for identifying one row within the identified participating table;
creating a third participant table field for identifying the role of the individual in the particular event;
and
creating a forth participant table field identifying a row in the event table to which the individual in the particular event relates.

11 more elements

Dependencies are inferred from the claim text.

Fact participant database architecture

Life of this patent

Fact participant database architecture

Life of this patent

Abstract

Claims16