AUTOMATED TRANSFORMATION OF STRUCTURED AND UNSTRUCTURED CONTENT

• US 20080208830A1
• Filed: 02/22/2008
• Published: 08/28/2008
• Est. Priority Date: 02/27/2007
• Status: Abandoned Application

• Current Assignee: QL2 Software LLC
• Original Assignee: QL2 Software LLC
• Inventors: Lauckhart, Greg, Kushmerick, Nicholas
• Application Number:
  US12/036,141
• Publication Number:
  US 20080208830A1
• Time in Patent Office: Days
• US Class Current: 707/4
• CPC Class Codes: G06F 16/332 Query formulation

Abstract

A device, system, and method are directed towards enabling a user to employ a set of database-like structured query expressions to manage data retrieval over a network, and the transformation and/or normalization of the data. In one embodiment, the retrieval expressions are configured as database-like structured query commands that may be performed upon at least a non-database arrangement of content over the network. In one embodiment, retrieved data is converted to at least one format intermediate to a first and second format in a sequence of transformations.

Claims

1. A system useable for managing data over a network, comprising:

a retrieval component that is configured to retrieve data using a database-like structured syntax language query, wherein the retrieved data is retrieved from at least one data source indicated in the query;

a transformer component that is configured to transform at least a portion of the retrieved data from a first Internet Media Type (IMT) to a second IMT by transforming the retrieved data from the first IMT into at least one other IMT before transforming the received data into the second IMT using an automatically generated sequence of transformations between different IMTs; and

a normalizer component that is configured to validate that the transformed data is in an application specific format consistent with a query clause in the query.

2. The system of claim 1, wherein the automatically generated sequence is determined at least based on a shortest path between the first and second IMTs in a translation graph.

3. The system of claim 1, wherein if the normalizer component determines that the transformed data is inconsistent with the query clause, then the normalizer component is configured to perform actions, including modifying the transformed data into a format consistent with the query clause.

4. The system of claim 1, wherein the transformer component automatically generates the sequence of transformations by performing actions, including:

determining the first IMT based on the retrieved data;

determining the second IMT based on an explicit query clause in the query; and

determining a selection scheme from one of a plurality of predetermined selection schemes including at least one of a logically shortest sequence, a sequence with a lowest computational cost, or a computationally fastest sequence.

5. The system of claim 1, wherein the at least one other IMT is independent of an explicit indication of the at least one other IMT within any query clause in the query.

6. The system of claim 1, wherein the automatically generated sequence is determined using a computational cost factor associated with each available transformation between one IMT and another IMT.

7. The system of claim 1, wherein the at least one other IMT is determined based on a query clause in the query that indicates at least one component object from which at least one record is extracted from the retrieved data.

8. A computer readable storage medium encoded with instructions that when executed by a computer cause the computer to perform actions for retrieving data, comprising:

retrieving data using a database-like structured syntax language query, wherein the retrieved data is retrieved from at least one data source indicated in the query;

transforming at least a portion of the retrieved data from a first Internet Media Type (IMT) to a second IMT by transforming the retrieved data from the first IMT into at least one other IMT before transforming the received data into the second IMT using an automatically generated sequence of transformations between different IMTs; and

validating that the transformed data is in an application specific format consistent with a query clause in the query.

9. The computer readable storage medium of claim 8, wherein the automatically generated sequence is determined based on a shortest path between the first and second IMTs in a translation graph.

10. The computer readable storage medium of claim 8, wherein if the transformed data is inconsistent with the query clause, further performing actions, including modifying the transformed data into a format consistent with the query clause.

11. The computer readable storage medium of claim 8, wherein the at least one other IMT is independent of an explicit indication of the at least one other IMT within any query clause in the query.

12. The computer readable storage medium of claim 8, wherein the actions further comprise generating a sequence of transformations by performing actions, including:

determining the first IMT based on the retrieved data;

determining the second IMT based on an explicit query clause in the query; and

determining a selection scheme from one of a plurality of predetermined selection schemes that includes at least one of a logically shortest sequence, lowest computational cost, or computational fastest sequence.

13. The computer readable storage medium of claim 8, wherein retrieving the data further comprises:

initiating execution of a remote application;

automatically interacting with the remote application by providing an input to a request for input from the application; and

receiving at least one response data from the executing remote application.

14. The computer readable storage medium of claim 8, wherein the automatically generated sequence is determined using a computational cost factor associated with each available transformation between one IMT to another IMT.

15. The computer readable storage medium of claim 8, wherein the at least one other IMT is determined based on a query clause in the query that indicates at least one component object from which at least one record is extracted from the retrieved data.

16. A network device for retrieving data, comprising:

a processor; and

a memory storing data that when executed by the processor performs actions, comprising;

retrieving data using a database-like structured syntax language query, wherein the retrieved data is retrieved from at least one data source indicated in the query;

transforming at least a portion of the retrieved data from a first Internet Media Type (IMT) to a second IMT by transforming the retrieved data from the first IMT into at least one other IMT before transforming the received data into the second IMT using an automatically generated sequence of transformations between different IMTs; and

validating that the transformed data is in an application specific format consistent with a query clause in the query.

17. The network device of claim 16, wherein if the transformed data is inconsistent with the query clause, then further performing actions, including modifying the transformed data into a format consistent with the query clause.

18. The network device of claim 16, wherein the actions comprise generating a sequence of transformations by performing further actions, including:

determining the first IMT based on the retrieved data;

determining the second IMT based on an explicit query clause in the query; and

determining a selection scheme from one of a plurality of predetermined selection schemes that includes at least one of a logically shortest sequence, lowest computational cost, or computational fastest sequence.

19. The network device of claim 16, wherein the automatically generated sequence is determined using a computational cost factor associated with each available transformation between one IMT to another IMT.

20. The network device of claim 16, wherein the at least one other IMT is determined based on a query clause in the query that indicates at least one component object from which at least one record is extracted from the retrieved data.