Managing business objects data sources

• US 9,092,478 B2
• Filed: 12/27/2011
• Issued: 07/28/2015
• Est. Priority Date: 12/27/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Vaitheeswaran, Ganesh, Tripathy, Manasa Ranjan, Nagaraja, Raghavendra, Bhattacharjee, Arindam, Jha, Rahul Kumar, Kamath, Nithin Moolky
• Primary Examiner(s): BOWEN, RICHARD L
• Application Number:
  US13/337,990
• Publication Number:
  US 20130166573A1
• Time in Patent Office: 1,309 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/242 Query formulation

Abstract

Methods, computer-readable media, and systems for managing business objects data sources. A search query that includes multiple query terms is received. Each query term at least partially represents metadata associated with one of multiple business objects data sources that each stores multiple data items. Multiple search index documents are searched to identify one or more business objects data sources that are each associated with metadata at least partially represented by each query term. Multiple metadata tables are searched to identify metadata associated with each identified business objects data source. The identified business objects data sources are searched for data items that satisfy the identified metadata. Representations of the data items and the metadata are provided in response to receiving the search query.

Claims

1. A computer-implemented method for searching business objects data sources, the method comprising:

providing a plurality of computer-readable master tables, each computer-readable master table associated with a respective business objects data source of a plurality of business objects data sources, each business objects data source stores a plurality of data items;

receiving a search query including one or more query terms, each query term represents first metadata included in metadata associated with a plurality of business objects data sources

identifying, for each query term, one or more business objects data sources that are associated with the first metadata by searching a plurality of computer-searchable index documents, each computer-searchable index document references the metadata;

identifying, for each query term, the metadata associated with the identified one or more business objects data sources by searching the plurality of computer-readable master tables, wherein the identified metadata associated with the identified one or more business objects data sources includes the first metadata and additional metadata associated with the identified one or more business objects data sources;

searching the identified one or more business objects data sources for data items that satisfy the identified metadata; and

providing representations of the data items and identified metadata in response to receiving the search query.

2. The method of claim 1, further comprising, for each business objects data source, representing a respective plurality of data items stored in a respective business objects data source in a table structure including one or more tables including one or more columns, each column including one or more cells representing the respective plurality of data items.

3. The method of claim 2, wherein, for each query term, identifying one or more business objects data sources that are each associated with the first metadata comprises identifying one or more columns that satisfy the query term.

4. The method of claim 3, wherein identifying the metadata associated with the identified one or more business objects sources comprises:

identifying one or more data items that satisfy the query term by searching the plurality of computer-searchable index documents; and

identifying one or more columns in which the identified one or more data items are stored.

5. The method of claim 1, wherein searching one or more business objects data sources to identify data items of the plurality of data items stored in each of the searched one or more business objects data sources for data items that satisfy the identified metadata comprises identifying a plurality of tuples, each tuple including a first metadata portion and a second metadata portion, each of which satisfies the respective query term.

6. The method of claim 5, wherein the first metadata portion is a measure and represents a number that satisfies the respective query term.

7. The method of claim 6, wherein the second metadata portion is a description of the number represented by the first metadata portion.

8. The method of claim 5, further comprising validating each tuple of the plurality of tuples.

9. The method of claim 5, further comprising ranking the plurality of tuples according to a relevance to the search query.

10. The method of claim 5, further comprising providing the plurality of tuples in response to receiving the search query.

11. The method of claim 5, further comprising:

generating a query that includes each tuple; and

executing the generated query against the multiple business objects data sources to identify data items that satisfy each tuple.

12. The method of claim 5, wherein the search query is a Structure Query Language (SQL) query.

13. The method of claim 1, further comprising:

identifying the one or more query terms by parsing the search query to exclude terms that are not query terms; and

stemming one of more of the query terms.

14. The method of claim 1, wherein providing representations of the data items and the identified metadata in response to receiving the search query further comprises:

providing a value that represents the data items and the identified metadata; and

providing additional values that are related to the value.

15. The method of claim 14, wherein the additional values include top values associated with the data items and the identified metadata.

16. A non-transitory computer-readable medium tangibly encoding computer program instructions executable by data processing apparatus to perform operations comprising:

providing a plurality of computer-readable master tables, each computer-readable master table associated with a respective business objects data source of a plurality of business objects data sources, each business objects data source stores a plurality of data items;

receiving a search query including one or more query terms, each query term represents first metadata included in metadata associated with a plurality of business objects data sources;

identifying, for each query term, one or more business objects data sources that are associated with the first metadata by searching a plurality of computer-searchable index documents, each computer-searchable index document references the metadata associated with a respective business objects data sources;

identifying, for each query term, the metadata associated with the identified one or more business objects data sources by searching the plurality of computer-readable master tables, wherein the identified metadata associated with the identified one or more business objects data sources includes the first metadata and additional metadata associated with the identified one or more business objects data sources;

searching the identified one or more business objects data sources for data items that satisfy the identified metadata; and

providing representations of the data items and identified metadata in response to receiving the search query.

17. The medium of claim 16, the operations further comprising, for each business objects data source, representing a respective plurality of data items stored in a respective business objects data source in a table structure including one or more tables including one or more columns, each column including one or more cells representing the respective plurality of data items.

18. The medium of claim 17, wherein, for each query term, identifying one or more business objects data sources that are each associated with the first metadata comprises identifying one or more columns that satisfy the query term.

19. The medium of claim 18, wherein identifying the metadata associated with the identified one or more business objects sources comprises:

identifying one or more data items that satisfy the query term by searching the plurality of computer-searchable index documents; and

identifying one or more columns in which the identified one or more data items are stored.

20. The medium of claim 16, wherein searching one or more business objects data sources to identify data items of the plurality of data items stored in each of the searched one or more business objects data sources for data items that satisfy the identified metadata comprises identifying a plurality of tuples, each tuple including a first metadata portion and a second metadata portion, each of which satisfies the respective query term.

21. The medium of claim 20, wherein the first metadata portion is a measure and represents a number that satisfies the respective query term.

22. The medium of claim 21, wherein the second metadata portion is a description of the number represented by the first metadata portion.

23. The medium of claim 20, the operations further comprising validating each tuple of the plurality of tuples.

24. The medium of claim 20, the operations further comprising ranking the plurality of tuples according to a relevance to the search query.

25. The medium of claim 20, the operations further comprising providing the plurality of tuples in response to receiving the search query.

26. The medium of claim 20, the operations further comprising:

generating a query that includes each tuple; and

executing the generated query against the multiple business objects data sources to identify data items that satisfy each tuple.

27. The medium of claim 20, wherein the search query is a Structure Query Language (SQL) query.

28. The medium of claim 16, the operations further comprising:

identifying the one or more query terms by parsing the search query to exclude terms that are not query terms; and

stemming one of more of the query terms.

29. The medium of claim 16, wherein providing representations of the data items and the identified metadata in response to receiving the search query further comprises:

providing a value that represents the data items and the identified metadata; and

providing additional values that are related to the value.

30. The medium of claim 29, wherein the additional values include top values associated with the data items and the identified metadata.

31. A system comprising:

one or more data processing apparatus; and

a non-transitory computer-readable medium tangibly encoding computer program instructions executable by the one or more data processing apparatus to perform operations comprising;

providing a plurality of computer-readable master tables, each computer-readable master table associated with a respective business objects data source of a plurality of business objects data sources, each business objects data source stores a plurality of data items;

receiving a search query including one or more query terms, each query term represents first metadata included in metadata associated with a plurality of business objects data sources;

identifying, for each query term, one or more business objects data sources that are associated with the first metadata by searching a plurality of computer-searchable index documents, each computer-searchable index document references the metadata associated with a respective business objects data sources;

identifying, for each query term, the metadata associated with the identified one or more business objects data sources by searching the plurality of computer-readable master tables, wherein the identified metadata associated with the identified one or more business objects data sources includes the first metadata and additional metadata associated with the identified one or more business objects data sources;

searching the identified one or more business objects data sources for data items that satisfy the identified metadata; and

providing representations of the data items and identified metadata in response to receiving the search query.

32. The system of claim 31, the operations further comprising, for each business objects data source, representing a respective plurality of data items stored in a respective business objects data source in a table structure including one or more tables including one or more columns, each column including one or more cells representing the respective plurality of data items.

33. The system of claim 31, wherein, for each query term, identifying one or more business objects data sources that are each associated with the first metadata comprises identifying one or more columns that satisfy the query term.

34. The system of claim 32, wherein identifying the metadata associated with the identified one or more business objects sources comprises:

identifying one or more data items that satisfy the query term by searching the plurality of computer-searchable index documents; and

identifying one or more columns in which the identified one or more data items are stored.

35. The system of claim 31, wherein searching one or more business objects data sources to identify data items of the plurality of data items stored in each of the searched one or more business objects data sources for data items that satisfy the identified metadata comprises identifying a plurality of tuples, each tuple including a first metadata portion and a second metadata portion, each of which satisfies the respective query term.

36. The system of claim 35, wherein the first metadata portion is a measure and represents a number that satisfies the respective query term.

37. The system of claim 36, wherein the second metadata portion is a description of the number represented by the first metadata portion.

38. The system of claim 35, the operations further comprising validating each tuple of the plurality of tuples.

39. The system of claim 35, the operations further comprising ranking the plurality of tuples according to a relevance to the search query.

40. The system of claim 35, the operations further comprising providing the plurality of tuples in response to receiving the search query.

41. The system of claim 35, the operations further comprising:

generating a query that includes each tuple; and

executing the generated query against the multiple business objects data sources to identify data items that satisfy each tuple.

42. The system of claim 35, wherein the search query is a Structure Query Language (SQL) query.

43. The system of claim 31, the operations further comprising:

identifying the one or more query terms by parsing the search query to exclude terms that are not query terms; and

stemming one of more of the query terms.

44. The system of claim 31, wherein providing representations of the data items and the identified metadata in response to receiving the search query further comprises:

providing a value that represents the data items and the identified metadata; and

providing additional values that are related to the value.

45. The system of claim 44, wherein the additional values include top values associated with the data items and the identified metadata.