Managing product information versions

• US 9,280,572 B2
• Filed: 01/12/2009
• Issued: 03/08/2016
• Est. Priority Date: 01/12/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Gopalakrishnan, Prasanth, Johal, Amanjit Singh
• Primary Examiner(s): Le, Debbie
• Assistant Examiner(s): MENG, JAU SHYA
• Application Number:
  US12/352,237
• Publication Number:
  US 20100185595A1
• Time in Patent Office: 2,612 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477

Abstract

Systems and methods for managing versions of product attribute information are described. A database management system that manages a database for storing attribute information of a product is described. The database management system in this implementation comprises a version control system and a querying system. The version control system is configured to enable a user to insert one or more versions of product information in the database. Each version has an effective date and is divided into a plurality of attribute groups, each attribute group containing a plurality of attributes. One or more attribute groups are modified with respect to a previous version. The version control system is further configured to record which attributes of a modified attribute group are changed. The querying system is configured to enable a user to search the database based on the effective dates of the versions.

Claims

1. A product information versioning system comprising:

a processor; and

a memory, coupled to the processor, storing a database including;

a product information table including information describing a product as different versions, a first version including a version number, an effective date, and a plurality of attribute groups, a first attribute group including a name, a plurality of attribute data values and a bit map defining which attribute data values have changed from a previous version, and

a reference information table including, for the first version, a reference version number for the first attribute group, the reference version number indicating the previous version containing the previous attribute data values for the first attribute group,

wherein the memory stores instructions that, when executed by the processor, control product versioning, comprising;

modifying one or more attribute data values within the first attribute group in the first version in the product information table,

creating a bitmap for the modified first attribute group, the bitmap including one bit for each attribute data value in the modified first attribute group, each bit indicating whether the respective attribute data value has changed or whether the respective attribute data value has not changed,

creating a new entry for a second version in the product information table, including;

for each bit in the bitmap indicating that the respective attribute data value has changed, storing the modified attribute data value in a first attribute group in the second version, and

for each bit in the bitmap indicating that the respective attribute data value has not changed, storing the unmodified attribute data value in the first attribute group in the second version, and

creating a new entry for the second version in the reference information table, including;

storing the version number of the first version as the reference version number of the first attribute group in the second version, and

storing the reference version number of an unmodified attribute group in the first version as the reference version number of the unmodified attribute group in the second version.

2. The product information versioning system of claim 1, further comprising input/output devices, coupled to the processor, configured to communicate information between a user and the product information versioning system.

3. The product information versioning system of claim 1, wherein the instructions that control product versioning further comprise canceling one or more existing versions.

4. The product information versioning system of claim 1, wherein the instructions that control product versioning further comprise querying the database to retrieve relevant product information associated with a version.

5. The product information versioning system of claim 1, wherein the instructions that control product versioning further comprise automatically purging outdated versions having an effective date prior to an effective date of a currently effective version, and updating the currently effective version with at least a portion of the information contained in the purged versions.

6. A database management system, comprising:

a processor; and

a memory, coupled to the processor, storing a database including;

a product information table including information describing a product as different versions, a first version including a version number, an effective date, and a plurality of attribute groups, a first attribute group including a name, a plurality of attribute data values and a bit map defining which attribute data values have changed from a previous version, and

a reference information table including, for the first version, a reference version number for the first attribute group, the reference version number indicating the previous version containing the previous attribute data values for the first attribute group,

wherein the memory stores instructions that, when executed by the processor, manage the database, comprising;

inserting a new version of product information into the database, including;

modifying one or more attribute data values within the first attribute group in the first version in the product information table,

creating a bitmap for the modified first attribute group, the bitmap including one bit for each attribute data value in the modified first attribute group, each bit indicating whether the respective attribute data value has changed or whether the respective attribute data value has not changed,

creating a new entry for a second version in the product information table, including;

for each bit in the bitmap indicating that the respective attribute data value has changed, storing the modified attribute data value in a first attribute group in the second version, and

for each bit in the bitmap indicating that the respective attribute data value has not changed, storing the unmodified attribute data value in the first attribute group in the second new version, and

creating a new entry for the second version in the reference information table, including;

storing the version number of the first version as the reference version number of the first attribute group in the second version, and

storing the reference version number of an unmodified attribute group in the first version as the reference version number of the unmodified attribute croup in the second version, and

searching the database based on the effective dates of the versions.

7. The database management system of claim 6, wherein the managing further comprises determining a valid version based on the most recent effective date with respect to a current date.

8. The database management system of claim 7, wherein the managing further comprises purging versions having an effective date prior to an effective date of the valid version.

9. The database management system of claim 8, wherein the managing further comprises updating the remaining versions by retrieving product information stored in association with the purged versions and storing the product information in association with the remaining versions.

10. The database management system of claim 6, wherein the managing further comprises canceling one or more existing versions.

11. A computer-based version control method, comprising:

storing a database in a memory, the database including;

a product information table including information describing a product as different versions, a first version including a version number, an effective date, and a plurality of attribute groups, a first attribute group including a name, a plurality of attribute data values and a bit map defining which attribute data values have changed from a previous version, and

a reference information table including, for the first version, a reference version number for the first attribute group, the reference version number indicating the previous version containing the previous attribute data values for the first attribute group;

inserting a new version of product information into the database, including;

entering an effective date associated with the inserted version to establish when the inserted version becomes effective,

modifying one or more attribute groups within the first attribute group in the first version in the product information table,

creating a bitmap for each modified attribute group, the bitmap including one bit for each attribute data value in the modified first attribute group, each bit indicating whether the respective attribute data value has changed with respect to the attribute data value of the previous version or whether the respective attribute data value has not changed,

creating a new entry for a second version in the product information table, including;

for each bit in the bitmap indicating that the respective attribute data value has changed, storing the modified attribute data value in a first attribute group in the second version, and

for each bit in the bitmap indicating that the respective attribute data value has not changed, storing the unmodified attribute data value in the first attribute group in the second new version, and

creating a new entry for the second version in the reference information table, including;

storing the version number of the first version as the reference version number of the first attribute group in the second version, and

storing the reference version number of an unmodified attribute group in the first version as the reference version number of the unmodified attribute group in the second version; and

searching the database based on the effective dates of the versions.

12. The version control system of claim 11, further comprising canceling a version.

13. The version control system of claim 12, wherein canceling a version includes modifying a reference to one or more prior versions when the reference is made to a version to be cancelled.

14. The version control system of claim 13, further comprising updating one or more versions when a version is inserted or cancelled.

15. The version control system of claim 14, wherein updating one or more versions includes purging outdated versions and update versions that reference the purged versions.

16. A non-transitory computer readable medium storing instructions that, when executed by a processor, manage a database, the instructions comprising:

storing a database in a memory, the database including;

a product information table including information describing a product as different versions, a first version including a version number, an effective date, and a plurality of attribute groups, a first attribute group including a name, a plurality of attribute data values and a bit map defining which attribute data values have changed from a previous version, and

a reference information table including, for the first version, a reference version number for the first attribute group, the reference version number indicating the previous version containing the previous attribute data values for the first attribute group;

inserting a new version of product information into the database, including;

entering an effective date associated with the inserted version to establish when the inserted version becomes effective, modifying one or more attribute groups within the first attribute group in the first version in the product information table,

creating a bitmap for each modified attribute group, the bitmap including one bit for each attribute data value in the modified first attribute group, each bit indicating whether the respective attribute data value has changed with respect to the attribute data value of the previous version or whether the respective attribute data value has not changed,

creating a new entry for a second version in the product information table, including;

for each bit in the bitmap indicating that the respective attribute data value has changed, storing the modified attribute data value in a first attribute group in the second version, and

for each bit in the bitmap indicating that the respective attribute data value has not changed, storing the unmodified attribute data value in the first attribute group in the second new version, and

creating a new entry for the second version in the reference information table, including;

storing the version number of the first version as the reference version number of the first attribute group in the second version, and

storing the reference version number of an unmodified attribute group in the first version as the reference version number of the unmodified attribute group in the second version; and

searching the database based on the effective dates of the versions.

17. The non-transitory computer readable medium of claim 16, wherein the instructions further comprise determining a valid version based on the most recent effective date with respect to a current date.

18. The database management system of claim 17, wherein the instructions further comprise purging versions having an effective date prior to an effective date of the valid version.

19. The database management system of claim 18, wherein the instructions further comprise updating the remaining versions by retrieving product information stored in association with the purged versions and storing the product information in association with the remaining versions.

20. The database management system of claim 16, wherein the instructions further comprise canceling one or more existing versions.