Component for extracting content-index data and properties from a rich structured type

• US 20080005062A1
• Filed: 06/30/2006
• Published: 01/03/2008
• Est. Priority Date: 06/30/2006
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Saifee, Arif, Trdinich, Joseph Robert, Gupta, Anurag, Muthukrishnan, Sambavi, Acharya, Srinivasmurthy, Venkatraman, Mahadevan
• Application Number:
  US11/480,140
• Publication Number:
  US 20080005062A1
• Time in Patent Office: Days
• US Class Current: 707/2
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

Installing the content-index definitions includes parsing content-index definitions in a schema, generation of appropriate SQL statements for data extraction and storing the SQL statements. A run time infrastructure for extracting data to be content-indexed from the highly structured entity types is provided. This logic includes looking up the type of the item and its associated entities that need to be content-indexed, executing the corresponding data extraction code (SQL statements) and sending it to a protocol handler for content-indexing. Also included is an execution infrastructure for utilizing the generated SQL from the mappings to extract search properties from items.

Claims

1. A method for providing content index information and search properties for a data item of a defined type comprising:

extracting data to be content indexed using stored query language statements generated based on a schema containing content index definitions for the item; and

extracting individual search properties for the item using mappings of search properties of the item to a corresponding second set of other individual search properties utilized by a database search system, file system, or other storage system.

2. The method of claim 1 further comprising exposing the extracted individual search properties whenever an item of the defined type is created or modified.

3. The method of claim 2 wherein the extracting comprises:

looking up a type of the item;

looking up the item'"'"'s associated entities that are to be content indexed;

executing stored query language statements associated with the entities that are to be content indexed.

4. The method of claim 3 further comprising content indexing the extracted data.

5. The method of claim 4 wherein the data to be content indexed is from a rich structured data type.

6. The method of claim 5 further comprising marking for content indexing properties of the rich structured data type and sub-parts of the rich structured data type.

7. A computer readable medium having instructions thereon for performing the steps of claim 1.

8. A computer readable medium having instructions thereon for performing the steps of claim 2.

9. A computer readable medium having instructions thereon for performing the steps of claim 3.

10. A computer readable medium having instructions thereon for performing the steps of claim 4.

11. A computer readable medium having instructions thereon for performing the steps of claim 5.

12. A computer readable medium having instructions thereon for performing the steps of claim 6.

13. A system for providing content index information and search properties for a data item of a defined type comprising:

means for extracting data to be content indexed using stored query language statements generated based on a schema containing content index definitions for the item; and

means for extracting individual search properties for the item using mappings of search properties of the item to a corresponding second set of other individual search properties utilized by a database search system, file system, or other storage system.

14. The system of claim 13 further comprising means for exposing the extracted individual search properties whenever an item of the defined type is created or modified.

15. The system of claim 14 wherein the extracting comprises:

means for looking up a type of the item;

means for looking up the item'"'"'s associated entities that are to be content indexed;

means for executing stored query language statements associated with the entities that are to be content indexed.

16. The system of claim 15 further comprising means for content indexing the extracted data.

17. The system of claim 16 wherein the data to be content indexed is from a rich structured data type.

18. The system of claim 17 further comprising means for marking for content indexing properties of the rich structured data type and sub-parts of the rich structured data type.

19. A component for providing content index information and search properties for a data item of a defined type comprising:

means for extracting content-index data from the data item of the defined type; and

means for extracting search properties from data item of the defined type.

20. The component of claim 19 wherein the data item of the defined type is of a rich structured type.