SQL CONSTRUCTS PORTED TO NON-SQL DOMAINS

• US 20130110853A1
• Filed: 10/31/2011
• Published: 05/02/2013
• Est. Priority Date: 10/31/2011
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Smith, Burton, Meijer, Henricus Johannes Maria, Wecker, David B., Isard, Michael, Parastatidis, Savas, Stojanovic, Alexander Sasha
• Application Number:
  US13/286,152
• Publication Number:
  US 20130110853A1
• Time in Patent Office: Days
• US Class Current: 707/756
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

The subject disclosure relates to using structured query language constructs in non-structured query language domains. For example, through mathematical and logical transformation of concepts from a key, value pair domain associated with structured query language data structures to graphical-related data structures, the value originating in the structured query language domain can be modified for use in non-structured query language domains. This can open up options in analytics and can solve some of the problems associated with liner algebra.

Claims

1. A system, comprising:

a data access component configured to obtain data represented in a first format; and

an abstraction component configured to transform a representation of the data from the first format to a second format based on a defined end result of the data, wherein the data in the first format is defined in a structured query language construct and the representation of the data in the second format is in a non-structured query language domain.

2. The system of claim 1, further comprising a query enhancement component configured to analyze the defined end result and determine a suitable format type for the representation of the data, wherein the suitable format type is determined based on efficiency or ease of implementation.

3. The system of claim 1, wherein the abstraction component is further configured to hide details related to the transform and the second format from a programmer.

4. The system of claim 1, wherein the data access component is configured to obtain the data in an input data format and a processing component is configured to transform the representation of the data from the input data format to a storage format, the storage format is independent of the input data format.

5. The system of claim 1, further comprising a conversion component configured to change a data representation to be compatible with another data representation.

6. The system of claim 1, further comprising a storage component configured to retain the representation of the data in a third format that is independent of the first format and the second format, wherein the third format is a structured query language domain or a non-structured query language domain.

7. The system of claim 1, wherein the second format is one of a table, a matrix, a tuple, a graph, or a hypergraph.

8. The system of claim 1, wherein the first format and the second format are different representations of the same data.

9. The system of claim 1, further comprising an interface component configured to receive a request for the data, the abstraction component obtains the data in a storage format and transforms the data from the storage format to a format that corresponds to the received request.

10. The system of claim 1, wherein the abstraction component is further configured to utilize structured query language constructs in non-structured query language domains.

11. A method, comprising:

obtaining data in a structured query language format;

interpreting a representation of the data;

transforming the representation of the data from the structured query language format to a non-structured query language format, wherein the non-structured query language format provides an efficiency function or a simplicity function; and

outputting the data in the non-structured query language format.

12. The method of claim 11, wherein the interpreting comprises receiving an explicit definition of a desired result, wherein the transforming is a result of the explicit definition.

13. The method of claim 11, wherein the interpreting comprises inferring a definition of a desired result as a function of one or more data inputs, wherein the transforming is based on the inferred definition.

14. The method of claim 11, wherein the structured query language format and the non-structured query language format provide equivalent results.

15. The method of claim 11, further comprises storing the data in a structured query language format or a non-structured query language.

16. The method of claim 11, wherein the obtaining comprises receiving a request for the data.

17. The method of claim 11, wherein the obtaining comprises accessing the data from a storage media.

18. A computer-readable storage medium comprising computer-executable instructions stored therein that, in response to execution, cause a computing system to perform operations, comprising:

gathering data represented in a first format; and

transforming, in real-time, a representation of the data from the first format to a second format based on a defined end result of the data, the data in the first format is defined in a structured query language construct and the representation of the data in the second format is in a non-structured query language domain, wherein the second format is selected based on an efficiency in obtaining the defined end result.

19. The computer-readable storage medium of claim 18, the operations further comprising:

hiding details of the transforming from one or more users.

20. The computer-readable storage medium of claim 18, wherein the first format and the second format are different representations of the data.