GLOBAL PRODUCT DATABASE

• US 20130054551A1
• Filed: 08/24/2011
• Published: 02/28/2013
• Est. Priority Date: 08/24/2011
• Status: Abandoned Application

• Current Assignee: SAP AG (SAP SE)
• Original Assignee: SAP AG (SAP SE)
• Inventors: Lange, Stephan
• Application Number:
  US13/216,948
• Publication Number:
  US 20130054551A1
• Time in Patent Office: Days
• US Class Current: 707/706
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

A system can include a column-oriented database including data associated with multiple products and multiple properties. Each property can be associated with at least one product from the multiple products. The data can be defined in a data table that is stored in a main memory of the system, and each property can be defined in a separate column of the data table. A query engine can be configured to receive a query for a product that includes at least one property associated with the product. The query engine can locate at least one product in the database based on a comparison of the query and a search of only the relevant columns in the data table associated with the at least one property and a central processing unit cache can receive data associated with the relevant columns in the data table associated with the at least one property.

Claims

1. A system including instructions recorded on a non-transitory computer-readable medium and executable by at least one processor, the system comprising:

a column-oriented database including product identification data associated with a plurality of products and product property data associated with a plurality of properties for each of the products identified by the product identification data, each of the data being defined in a data table stored in a main memory of the system, each property from the plurality of properties being defined in a separate column of the data table corresponding to each product identification for each product;

a query engine configured to receive a query for a product, the query including at least one property associated with the product, the query engine further configured to locate at least one product from the plurality of products in the database based on a comparison of the query and a search of only the relevant columns in the data table associated with the at least one property identified in the query; and

a central processing unit, a cache of the central processing unit configured to receive data associated with the relevant columns in the data table associated with the at least one property identified in the query.

2. The system of claim 1, wherein the data table is a first data table, the database further including a second data table, the second data table including a plurality of product categories, each of the products from the plurality of products stored in the database being associated with at least one category in the second data table.

3. The system of claim 1, wherein the data table includes at least one link to a web site associated with a provider of at least one product from the plurality of products.

4. The system of claim 1, wherein the central processing unit is configured to generate a results list including at least one product from the plurality of products located by the query engine based on the query, the results list including at least one link to a web site associated with a product located by the query engine.

5. The system of claim 1, wherein the data table is a first data table, the database further including a second data table, the second data table including information entered by at least one third party, the information entered being associated with a product to be stored in the first data table.

6. The system of claim 1, wherein the database is configured to receive data associated with a property entered by a third party, the property entered by the third party being different than each property from the plurality of properties stored in the database, the property entered by the third party being defined in a column in the data table.

7. The system of claim 1, wherein each property from the plurality of properties in the data table is selectable by a user of the system to be associated with a product from the plurality of products.

8. A computer-implemented method comprising executing, using at least one processor, instructions recorded on a non-transitory computer-readable storage medium, the method comprising:

storing in a main memory of a server, a column-oriented database including product identification data associated with a plurality of products and product property data associated with a plurality of properties for each of the products identified by the product identification data, the database including a data table, each property from the plurality of properties being defined in a separate column of the data table corresponding to each product identification for each product;

receiving a query for a product, the query including at least one property associated with the product;

locating at least one product from the plurality of products stored in the database based on a comparison of the query and a search of only the relevant columns in the data table associated with the at least one property identified in the query; and

transferring to a cache of a central processing unit, the data associated with the relevant columns in the data table associated with the at least one property identified in the query.

9. The method of claim 8, wherein the data table is a first data table, the database further including a second data table, the second data table including a plurality of product categories, each of the products from the plurality of products stored in the database being associated with a product category in the second data table, the method further comprising:

receiving a selection of a product category from the plurality of product categories.

10. The method of claim 8, wherein the data table includes at least one link to a web site associated with a provider of at least one product from the plurality of products.

11. The method of claim 8, further comprising:

generating a results list including at least one product from the plurality of products located by the query engine based on the query, the results list including at least one link to a web site associated with at least one product located by the query engine based on the query.

13. The method of claim 8, further comprising:

receiving from a third party, information associated with a product to be stored in the data table; and

receiving a selection of at least one property from the plurality of properties to be associated with the product information entered by the third party.

14. The method of claim 8, further comprising:

receiving from a third party, data associated with a property, the property being different than each property from the plurality of properties stored in the database; and

defining the data associated with the property in a column in the data table.

12. (canceled)

15. A non-transitory computer program product, the non-transitory computer program product being tangibly embodied on a computer-readable storage medium and comprising instructions that, when executed, are configured to:

store in a main memory of a server, a column-oriented database including product identification data associated with a plurality of products and product property data associated with a plurality of properties for each of the products identified by the product identification data, the database including a data table, each property from the plurality of properties defined in a separate column of the data table corresponding to each product identification for each product;

receive a query for a product, the query including at least one property associated with the product;

locate at least one product from the plurality of products stored in the database based on a comparison of the query and a search of only the relevant columns in the data table associated with the at least one property identified in the query; and

transfer to a cache of a central processing unit, the data associated with the relevant columns in the data table associated with the at least one property identified in the query.

16. The computer product of claim 15, wherein the data table is a first data table, the database further including a second data table, the second data table including a plurality of product categories, each of the products from the plurality of products stored in the database being associated with a product category in the second data table, the computer product further comprising instructions to:

receive a selection of a product category from the plurality of product categories.

17. The computer product of claim 15, wherein the data table includes at least one link to a web site associated with a provider of at least one product from the plurality of products.

18. The computer product of claim 15, further comprising instructions to:

generate a results list including at least one product from the plurality of products located by the query engine based on the query, the results list including at least one link to a web site associated with at least one product located by the query engine.

19. The computer product of claim 15, further comprising instructions to:

receive from a third party, information associated with a product to be stored in the data table; and

receive a selection of at least one property from the plurality of properties to be associated with the information associated with a product entered by the third party.

20. The computer product of claim 15, further comprising instructions to:

receive from a third party, data associated with a property, the property being different than each property from the plurality of properties stored in the database; and

defining the data associated with the property as a column in the data table.