Method and apparatus for exploiting master-detail data relationships to enhance searching operations

• US 8,407,255 B1
• Filed: 05/13/2011
• Issued: 03/26/2013
• Est. Priority Date: 05/13/2011
• Status: Active Grant

• Current Assignee: Adobe Inc.
• Original Assignee: Adobe Systems Incorporated (Adobe Inc.)
• Inventors: Srivastava, Sharad, Sagar, Vikas
• Primary Examiner(s): Woo, Isaac M
• Application Number:
  US13/107,083
• Time in Patent Office: 683 Days
• Field of Search: 707600-899
• US Class Current: 707/791
• CPC Class Codes: G06F 16/2456 Join operations

Abstract

A method and apparatus for exploiting a master-detail relationship between a first structured data and at least one second structured data to enhance searching operations of a database containing the first data structure and the at least one second data structure, comprising accessing a first structured data and at least one second structured data of the database; and in response to orthogonal data filter characteristics, augmenting the first structured data with information related to the at least one second structured data to enhance searching of the database.

Claims

1. A computer implemented method for exploiting a master-detail relationship between a first structured data and at least one second structured data to enhance searching operations of a database containing the first data structure and the at least one second data structure, comprising:

accessing a first structured data and at least one second structured data of the database, wherein the first structured data and the at least one second structured data have a master-detail relationship; and

in response to orthogonal data filter characteristics, augmenting the first structured data with information related to the at least one second structured data to enhance searching of the database.

2. The method of claim 1 further comprising executing a query that applies orthogonal data filters having the orthogonal data filter characteristics to the first structured data to produce search results.

3. The method of claim 2, wherein, while executing the query, the first structured data is not joined with the at least one second data structure.

4. The method of claim 2, wherein the orthogonal data filters comprise at least two data filters, wherein a first data filter and a second data filter are applied to the first structured data.

5. The method of claim 1, wherein the first structured data comprises a master data table and the at least one second structured data comprises at least one detail data table.

6. The method of claim 1, wherein augmenting further comprises selecting the orthogonal filters to apply to the database during a subsequent search of the database.

7. The method of claim 1, wherein the information is derived from content of the at least one second structured data.

8. An apparatus for exploiting a master-detail relationship between a first structured data and at least one second structured data to enhance searching operations of a database containing the first data structure and the at least one second data structure, comprising:

a search module for accessing a first structured data and at least one second structured data of the database, wherein the first structured data and the at least one second structured data have a master-detail relationship; and

in response to orthogonal data filter characteristics, for augmenting the first structured data with information related to the at least one second structured data to enhance searching of the database.

9. The apparatus of claim 8 further comprising orthogonal data filters having the orthogonal data filter characteristics that are applied to the first structured data to produce search results.

10. The apparatus of claim 9, wherein the first structured data is not joined with the at least one second data structure.

11. The apparatus of claim 9, wherein the orthogonal data filters comprise at least two data filters, wherein a first data filter and a second data filter are applied to the first structured data.

12. The apparatus of claim 8, wherein the first structured data comprises a master data table and the at least one second structured data comprises at least one detail data table.

13. The apparatus of claim 8, wherein augmenting further comprises selecting the orthogonal filters to apply to the database during a subsequent search of the database.

14. A computer readable medium for storing processor executable instructions that, when executed by a computing system, causes the computing system to perform a method for exploiting a master-detail relationship between a first structured data and at least one second structured data to enhance searching operations of a database containing the first data structure and the at least one second data structure, comprising:

accessing a first structured data and at least one second structured data of the database, wherein the first structured data and the at least one second structured data have a master-detail relationship; and

in response to orthogonal data filter characteristics, augmenting the first structured data with information related to the at least one second structured data to enhance searching of the database.

15. The computer readable medium of claim 14 further comprising executing a query that applies orthogonal data filters having the orthogonal data filter characteristics to the first structured data to produce search results.

16. The computer readable medium of claim 15, wherein, while executing the query, the first structured data is not joined with the at least one second data structure.

17. The computer readable medium of claim 15, wherein the orthogonal data filters comprise at least two data filters, wherein a first data filter and a second data filter are applied to the first structured data.

18. The computer readable medium of claim 14, wherein the first structured data comprises a master data table and the at least one second structured data comprises at least one detail data table.

19. The computer readable medium of claim 14, wherein augmenting further comprises selecting the orthogonal filters to apply to the database during a subsequent search of the database.

20. The computer readable medium of claim 14, wherein the information is derived from content of the at least one second structured data.