HETEROGENEOUS DATA MANAGEMENT METHODOLOGY AND SYSTEM

• US 20140317154A1
• Filed: 03/12/2014
• Published: 10/23/2014
• Est. Priority Date: 03/15/2013
• Status: Abandoned Application

• Current Assignee: Traxld LLC
• Original Assignee: Traxld LLC
• Inventors: Loi, Duke
• Application Number:
  US14/206,455
• Publication Number:
  US 20140317154A1
• Time in Patent Office: Days
• US Class Current: 707/807
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

A system for storing and processing heterogeneous data comprises a common data layer configured to manage and store abstracted data using a standard relational database, the common data layer comprises a template repository storing a plurality of data-logic templates and user data. The system further includes a data abstraction layer comprising rules for processing user data and handling a user-interface, an intelligence layer comprises context sensitive processing logic of user inputs and data from the data abstraction layer according to the data-logic templates, and a user interface layer configured to present the processed data and capture user inputs for the system.

Claims

1. A system for storing and processing heterogeneous data comprising:

a common data layer configured to manage and store abstracted data using a standard relational database, the common data layer comprises a template repository storing a plurality of data-logic templates and user data;

a data abstraction layer comprising rules for processing user data and handling a user-interface;

an intelligence layer comprises context sensitive processing logic of user inputs and data from the data abstraction layer according to the data-logic templates; and

a user interface layer configured to present the processed data and capture user inputs for the system.

2. The system of claim 1, wherein data-logic templates are adapted to define data types, data attributes, and rules for each data type, and rules for data interaction between different data types.

3. The system of claim 1 wherein the data-logic templates are adapted to define how different data types are stored and managed in common database tables for different assets and work orders.

4. The system of claim 1 wherein the data-logic templates are adapted to define data sets including field names, data types, data attributes, and rules for each data type.

5. The system of claim 1 further comprising different data fields stored in common database tables that are shared by different object types at the common data layer.

6. The system of claim 1 wherein the data abstraction layer is adapted to apply data field names, data types, data attributes, and rules to the raw data in common data layer based on predefined data-logic template of a specific asset or work order type.

7. The system of claim 1 wherein the user interface layer is adapted to present each data field according to data-logic template definition and how the system validates the user input.

8. The system of claim 1 wherein the common data layer comprises:

a general data section containing key data fields used to identify, locate and interpret detail data sections; and

at least one detail data section containing data-logic defined datasets that can be interpreted by data-logic template definitions.

9. The system of claim 8 wherein the common data layer further comprises data pointers linking the general data section and the at least one detail data section.

10. A system for processing heterogeneous data comprising:

a common data layer including a plurality of data-logic templates defining data types, data attributes, and rules for data interaction between different data types;

an abstraction layer comprising rules for processing user data and handling a user-interface;

an intelligence layer comprises context sensitive processing logic of user inputs and data from the data abstraction layer according to the data-logic templates; and

a user interface layer adapted to present the processed data and capture user inputs for the system.

11. The system of claim 10, wherein the data-logic templates are adapted to define how different data types are stored in common database tables for different assets categories and work order types.

12. The system of claim 10 further comprising different data fields stored in common database tables that are shared by different object types at the common data layer.

13. The system of claim 12 wherein the data abstraction layer is adapted to apply data field names, data types, data attributes, and rules to the raw data in common data layer based on predefined data-logic template of a specific asset or work order type.

14. The system of claim 10 wherein the user interface layer is adapted to present each data field according to data-logic template definition.

15. The system of claim 10 wherein the user interface layer is adapted to validate user input according to the data-logic template definition.

16. The system of claim 10 wherein the common data layer comprises:

a general data section containing key data fields used to identify, locate and interpret detail data sections; and

at least one detail data section containing data-logic defined datasets that can be interpreted by data-logic template definitions.

17. The system of claim 16 wherein the common data layer further comprises data pointers linking the general data section and the at least one detail data section.

18. A method of managing heterogeneous data comprising:

providing data-logic templates which defines how data types are stored and managed in common database tables for different assets or work orders, data sets that include field names, data types, data attributes, and rules for each types of assets or work orders, and data interaction between work order data and asset data;

storing data according to the data-logic template definitions;

processing data according to the data-logic template definitions;

displaying data fields according to the data-logic template definitions; and

receiving and validating user input according to the data-logic template definitions.

19. The method of claim 18, wherein storing data comprises storing data in a a common data layer including a general data section containing key data fields used to identify, locate and interpret detail data sections, and at least one detail data section containing data-logic defined datasets that can be interpreted by data-logic template definitions.

20. The method of claim 18, further comprising encoding and decoding data stored in a common data layer according to the data-logic template definitions.