초록 ▼

A method and systems are provided for managing database data. A data repository stores existing immediate mode data in the form of immediate mode database records. Transaction mode database records for modifying and adding to the immediate mode records are created and stored, with the transaction mo

A method and systems are provided for managing database data. A data repository stores existing immediate mode data in the form of immediate mode database records. Transaction mode database records for modifying and adding to the immediate mode records are created and stored, with the transaction mode records being organized into transactions. Each transaction includes a definition, such as a transaction definition record, and transaction mode records are associated with a transaction using a field in each transaction mode record including a reference to a transaction. A transaction can be posted, causing values stored in the transaction mode records associated with the transaction to be used to create added or modified immediate mode records. Transactions can also be used in operations providing views to show the effects of the transaction mode records, or to create data structures for export.

대표청구항 ▼

1. A computer implemented method for managing data in a database where the database is stored and maintained in a computer data server, the method comprising the steps of: creating a plurality of immediate mode records in the database for relatively permanent storage of data where each of the plural

1. A computer implemented method for managing data in a database where the database is stored and maintained in a computer data server, the method comprising the steps of: creating a plurality of immediate mode records in the database for relatively permanent storage of data where each of the plurality of immediate mode records includes pricing information;creating a plurality of transaction definition records in the database where each of the transaction definition records includes a rule for supplementing or modifying the data stored in one or more of the plurality of immediate mode records;creating a plurality of transaction mode records in the database where each of the plurality of transaction mode records is associated with one immediate mode record, a transaction and one transaction definition record and where each of the plurality of transaction mode records includes transaction data;creating and populating a data structure by applying additions and changes reflected in transaction mode records associated with the transaction, where creating and populating the data structure is accomplished using additions and changes applied to data retrieved from immediate mode records without modifications to immediate mode records, where creating and populating the data structure further includes posting transaction data reflected in transaction mode records associated with the transaction to create new or modify immediate mode records, where creating and populating the data structure also includes using data retrieved from the new or modified immediate mode records, where creating and populating the data structure further includes exclusion of one or more immediate mode records from the data structure where transaction mode records includes transaction data excluding the one or more associated immediate mode records and wherein the exclusion of one or more immediate mode records from the data structure includes creation of one or more transaction mode records each associated with an immediate mode record where the one or more transaction mode records include indicia indicating exclusion of the associated immediate mode record; andretrieving data from a first of the plurality of immediate mode records and using a first of the plurality of transaction mode records associated with the first immediate mode record to apply the rule of a first of the plurality of transaction definition records associated with the first transaction mode record to supplement or modify the retrieved data using the transaction data from the first transaction mode record without applying the rule for supplementing or modifying the data stored in the first immediate mode record. 2. A system for managing data in a database, comprising: a computer readable medium storing instructions for the steps of: creating a plurality of immediate mode records in the database for relatively permanent storage of data in a central location where each of the plurality of immediate mode records includes price information for an item;defining a transaction in the database;creating a plurality of transaction mode records in the database, each transaction mode record including: a field storing values referring to an identifier for the transaction and a field storing values referring to an identifier for an immediate mode record;creating and populating a data structure by applying additions and changes reflected in transaction mode records associated with the transaction, where creating and populating the data structure is accomplished using additions and changes applied to data retrieved from immediate mode records without modifications to immediate mode records, where creating and populating the data structure further includes posting transaction data reflected in transaction mode records associated with the transaction to create new or modify immediate mode records, where creating and populating the data structure also includes using data retrieved from the new or modified immediate mode records, where creating and populating the data structure further includes exclusion of one or more immediate mode records from the data structure where transaction mode records includes transaction data excluding the one or more associated immediate mode records and wherein the exclusion of one or more immediate mode records from the data structure includes creation of one or more transaction mode records each associated with an immediate mode record where the one or more transaction mode records include indicia indicating exclusion of the associated immediate mode record; andretrieving data from one of the plurality of immediate mode records and following commands associated with the transaction to modify the data retrieved from the one of the plurality of immediate mode records with the transaction mode records associated with the transaction without modifying data stored in the one of the plurality of immediate mode records. 3. A system for management of item pricing data, comprising: a database for hosting the data in data structures where the data structures includes a plurality of database records including immediate mode records stored in relatively permanent form in the database and transaction mode records where each of the transaction mode records includes transaction data and is associated with one of the immediate mode records and a transaction definition record defining the treatment and use of each of the transaction mode records; anda processing system for storing the data to and retrieving the data from the database, the processing system comprising: a processor; anda memory;where the processing system stores data in an immediate mode record and an associated transaction mode record, the transaction mode record having no immediate effect to modify or to update the data stored in the immediate mode record as defined by an associated transaction definition record and where the processing system retrieves data from the immediate mode record and applies to the retrieved data, transaction data from the transaction mode record as defined by the associated transaction definition record to modify or update the data retrieved from the immediate mode record and where the processing system creates and populates a data structure by applying additions and changes reflected in transaction mode records associated with transaction definition records, where creating and populating the data structure is accomplished using additions and changes applied to data retrieved from immediate mode records without modifications to immediate mode records, where creating and populating the data structure further includes posting transaction data reflected in transaction mode records to create new or modify immediate mode records, where creating and populating the data structure also includes using data retrieved from the new or modified immediate mode records, where creating and populating the data structure further includes exclusion of one or more immediate mode records from the data structure where transaction mode records includes transaction data excluding the one or more associated immediate mode records and wherein the exclusion of one or more immediate mode records from the data structure includes creation of one or more transaction mode records each associated with an immediate mode record where the one or more transaction mode records include indicia indicating exclusion of the associated immediate mode record.