MAPPING BETWEEN DISPARATE DATA MODELS VIA ANONYMOUS FUNCTIONS

• US 20090150907A1
• Filed: 12/07/2007
• Published: 06/11/2009
• Est. Priority Date: 12/07/2007
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Aharoni, Avner Y., Meijer, Erik
• Application Number:
  US11/952,281
• Publication Number:
  US 20090150907A1
• Time in Patent Office: Days
• US Class Current: 719/318
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

Systems and methods that transform an input stream to an output stream by employing a hybrid of declarative features and procedural features. A transformation component includes a declaration component that identifies data types, which enables users to define customized event(s) whereupon user functions can be called, and a procedural component that executes the logic of the functions that are called to perform operations of the functions.

Claims

1. A computer implemented system comprising:

a declaration component that identifies a data type(s) and enables users to define customized events; and

a procedural component that executes functions called by the customized events, the declaration component and the procedural component form a transformation component that transform the data type(s) to another type of data.

2. The computer implemented system of claim 1, the customized events include events of interests described by predicates.

3. The computer implemented system of claim 1 further comprising an API that advances through XML streams to insert results in appropriate tables of a relational data store.

4. The computer implemented system of claim 1, the data type(s) includes an XML stream that inserts results of transformation based on hierarchy of XML elements.

5. The computer implemented system of claim 1, the declaration component in form of a scheduling component to call events that satisfy configured predicates.

6. The computer implemented system of claim 5 further comprising an artificial intelligence component that facilitates adaptation of the procedural component.

7. The computer implemented system of claim 6, the events specify codes that are to be executed.

8. The computer implemented system of claim 6 further comprising a streaming interface that receives a data stream that includes the data type.

9. The computer implemented system of claim 6 individual transformations connect event handlers to events.

10. A computer implemented method comprising:

receiving a data type via a transformation component; and

transforming the data type via a hybrid of declarative features and procedural features.

11. The computer implemented method of claim 10 further comprising defining events by users as part of the declarative features.

12. The computer implemented method of claim 11 further comprising calling functions as part of the declarative features.

13. The computer implemented method of claim 12 further comprising performing mapping via user defined functions.

14. The computer implemented method of claim 13 further comprising calling functions for an element and inserting results to tables.

15. The computer implemented method of claim 14 further comprising adaptively training mapping functions.

16. The computer implemented method of claim 14 further comprising customizing programs of users to perform mapping transformations.

17. The computer implemented method of claim 14 further comprising implementing a new data structure as part of an output stream.

18. The computer implemented method of claim 17 further comprising indicating points to halt a data stream that is received by the transformation component.

19. The computer implemented method of claim 17 further comprising associating event handlers with events to specify codes to be executed.

20. A computer implemented system comprising:

means for receiving a data stream; and

means for transforming a data type of the data stream to another data type via procedural features and declarative features.