Managing business objects data sources

• US 8,938,475 B2
• Filed: 12/27/2011
• Issued: 01/20/2015
• Est. Priority Date: 12/27/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Vaitheeswaran, Ganesh, Bhattacharjee, Arindam, Nagaraja, Raghavendra, Tripathy, Manasa Ranjan, Kamath, Nithin Moolky, Jha, Rahul Kumar
• Primary Examiner(s): Ehichioya, Fred
• Assistant Examiner(s): BOWEN, RICHARD L
• Application Number:
  US13/338,027
• Publication Number:
  US 20130166598A1
• Time in Patent Office: 1,120 Days
• Field of Search: 707/792
• US Class Current: 707/792
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

Methods, non-transitory computer-readable media, and systems for managing business objects data sources. Multiple business objects data sources, each storing multiple data items, are accessed. For each data source, multiple computer-searchable index documents and multiple metadata tables, including master tables and mapping tables, are generated. The multiple computer-searchable index documents and the multiple metadata tables are provided to perform a search for data items in the multiple business objects data sources.

Claims

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

accessing a plurality of business objects data sources, each business objects data source storing a plurality of data items;

for each business objects data source, generating a plurality of computer-searchable index documents including a first search index document associated with a respective business objects data source and a plurality of second search index documents, each second search index document associated with each data item of the plurality of data items stored in the respective business objects data source, and

generating a plurality of computer-readable master tables including a first master table storing metadata of the respective business objects data source and a plurality of second master tables, each second master table storing metadata describing the plurality of data items stored in the respective business objects data source;

storing in the first master table a name of the respective business objects data source and an identifier that uniquely identifies the respective business objects data source;

providing the plurality of computer-searchable index documents and the plurality of computer-readable master tables to perform a search for data items in the plurality of business objects data sources;

representing the respective business objects data source in a table format that includes one or more tables, each table including one or more columns, each column including one or more cells, each cell storing a data item of the plurality of data items stored in the respective business objects data source;

generating a third master table storing metadata of the one or more tables; and

including in the third master table, a name of each of the one or more tables.

2. The method of claim 1, further comprising:

generating a plurality of computer-readable mapping tables, each mapping table storing mapping associated with the respective business objects data source; and

providing the plurality of computer-readable mapping tables to perform the search for data items.

3. The method of claim 2, wherein at least a portion of the plurality of master tables is a duplication of at least a portion of the plurality of computer-searchable index documents, and wherein the plurality of computer-readable master tables and the plurality of computer-readable mapping tables are stored in a relational database.

4. The method of claim 1, wherein generating the plurality of computer-searchable index documents comprises:

generating a respective first search index document for each table;

generating a respective second search index document for each cell; and

generating a respective third search index document for each column.

5. The method of claim 4, further comprising, storing the plurality of computer-searchable index documents in an inverted index data structure.

6. The method of claim 1, further comprising storing in each second master table, a data type and an analysis type of each data item of the plurality of data items stored in the respective business objects data source.

7. The method of claim 1, wherein generating a plurality of computer-readable mapping tables, each mapping table storing mapping associated with the respective business objects data source, comprises:

generating a table-to-table mapping tables storing join data;

generating a table-to-object mapping table storing a mapping between a particular table and one or more columns included in the particular table;

generating an index document-table mapping table storing mapping between a particular index document and a particular table indexed by the particular index document;

generating an index document-object mapping table storing mapping between the particular index document and one or more particular columns in the particular table; and

generating a data source-to-table mapping storing mapping between a respective business objects data source and tables including the particular table.

8. The method of claim 1, wherein at least a portion of the plurality of computer-searchable index documents and at least a portion of the plurality of master tables are generated in parallel or wherein at least a portion of the plurality of master tables and at least a portion of the plurality of mapping tables are generated after and based on at least a portion of the plurality of computer-searchable index documents.

9. The method of claim 1, wherein accessing the plurality of business objects data sources, each business objects data source storing a plurality of data items comprises:

crawling each business objects data source; and

extracting metadata from each business objects data source.

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

accessing a plurality of business objects data sources, each business objects data source storing a plurality of data items;

for each business objects data source, generating a plurality of computer-searchable index documents including a first search index document associated with a respective business objects data source and a plurality of second search index documents, each second search index document associated with each data item of the plurality of data items stored in the respective business objects data source, and

generating a plurality of computer-readable master tables including a first master table storing metadata of the respective business objects data source and a plurality of second master tables, each second master table storing metadata describing the plurality of data items stored in the respective business objects data source;

storing in the first master table a name of the respective business objects data source and an identifier that uniquely identifies the respective business objects data source;

providing the plurality of computer-searchable index documents and the plurality of computer-readable master tables to perform a search for data items in the plurality of business objects data sources;

representing the respective business objects data source in a table format that includes one or more tables, each table including one or more columns, each column including one or more cells, each cell storing a data item of the plurality of data items stored in the respective business objects data source;

generating a third master table storing metadata of the one or more tables; and

including in the third master table, a name of each of the one or more tables.

11. The medium of claim 10, the operations further comprising:

generating a plurality of computer-readable mapping tables, each mapping table storing mapping associated with the respective business objects data source; and

providing the plurality of computer-readable mapping tables to perform the search for data items.

12. The medium of claim 11, wherein at least a portion of the plurality of master tables is a duplication of at least a portion of the plurality of computer-searchable index documents, and wherein the plurality of computer-readable master tables and the plurality of computer-readable mapping tables are stored in a relational database.

13. The medium of claim 10, wherein generating the plurality of computer-searchable index documents comprises:

generating a respective first search index document for each table;

generating a respective second search index document for each cell; and

generating a respective third search index document for each column.

14. The medium of claim 13, the operations further comprising, storing the plurality of computer-searchable index documents in an inverted index data structure.

15. The medium of claim 10, the operations further comprising storing in each second master table, a data type and an analysis type of each data item of the plurality of data items stored in the respective business objects data source.

16. The medium of claim 10, wherein generating a plurality of computer-readable mapping tables, each mapping table storing mapping associated with the respective business objects data source, comprises:

generating a table-to-table mapping tables storing join data;

generating a table-to-object mapping table storing a mapping between a particular table and one or more columns included in the particular table;

generating an index document-table mapping table storing mapping between a particular index document and a particular table indexed by the particular index document;

generating an index document-object mapping table storing mapping between the particular index document and one or more particular columns in the particular table; and

generating a data source-to-table mapping storing mapping between a respective business objects data source and tables including the particular table.

17. The medium of claim 10, wherein at least a portion of the plurality of computer-searchable index documents and at least a portion of the plurality of master tables are generated in parallel or wherein at least a portion of the plurality of master tables and at least a portion of the plurality of mapping tables are generated after and based on at least a portion of the plurality of computer-searchable index documents.

18. The medium of claim 10, wherein accessing the plurality of business objects data sources, each business objects data source storing a plurality of data items comprises:

crawling each business objects data source; and

extracting metadata from each business objects data source.

19. 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;

accessing a plurality of business objects data sources, each business objects data source storing a plurality of data items;

for each business objects data source, generating a plurality of computer-searchable index documents including a first search index document associated with a respective business objects data source and a plurality of second search index documents, each second search index document associated with each data item of the plurality of data items stored in the respective business objects data source, and

generating a plurality of computer-readable master tables including a first master table storing metadata of the respective business objects data source and a plurality of second master tables, each second master table storing metadata describing the plurality of data items stored in the respective business objects data source;

storing in the first master table a name of the respective business objects data source and an identifier that uniquely identifies the respective business objects data source;

providing the plurality of computer-searchable index documents and the plurality of computer-readable master tables to perform a search for data items in the plurality of business objects data sources;

representing the respective business objects data source in a table format that includes one or more tables, each table including one or more columns, each column including one or more cells, each cell storing a data item of the plurality of data items stored in the respective business objects data source;

generating a third master table storing metadata of the one or more tables; and

including in the third master table, a name of each of the one or more tables.

20. The system of claim 19, the operations further comprising:

generating a plurality of computer-readable mapping tables, each mapping table storing mapping associated with the respective business objects data source; and

providing the plurality of computer-readable mapping tables to perform the search for data items.

21. The system of claim 20, wherein at least a portion of the plurality of master tables is a duplication of at least a portion of the plurality of computer-searchable index documents, and wherein the plurality of computer-readable master tables and the plurality of computer-readable mapping tables are stored in a relational database.

22. The system of claim 19, wherein generating the plurality of computer-searchable index documents comprises:

generating a respective first search index document for each table;

generating a respective second search index document for each cell; and

generating a respective third search index document for each column.

23. The system of claim 22, the operations further comprising, storing the plurality of computer-searchable index documents in an inverted index data structure.

24. The system of claim 19, the operations further comprising storing in each second master table, a data type and an analysis type of each data item of the plurality of data items stored in the respective business objects data source.

25. The system of claim 19, wherein generating a plurality of computer-readable mapping tables, each mapping table storing mapping associated with the respective business objects data source, comprises:

generating a table-to-table mapping tables storing join data;

generating a table-to-object mapping table storing a mapping between a particular table and one or more columns included in the particular table;

generating an index document-table mapping table storing mapping between a particular index document and a particular table indexed by the particular index document;

generating an index document-object mapping table storing mapping between the particular index document and one or more particular columns in the particular table; and

generating a data source-to-table mapping storing mapping between a respective business objects data source and tables including the particular table.

26. The system of claim 19, wherein at least a portion of the plurality of computer-searchable index documents and at least a portion of the plurality of master tables are generated in parallel or wherein at least a portion of the plurality of master tables and at least a portion of the plurality of mapping tables are generated after and based on at least a portion of the plurality of computer-searchable index documents.

27. The system of claim 19, wherein accessing the plurality of business objects data sources, each business objects data source storing a plurality of data items comprises:

crawling each business objects data source; and

extracting metadata from each business objects data source.