Light data integration

• US 9,613,108 B1
• Filed: 12/09/2015
• Issued: 04/04/2017
• Est. Priority Date: 12/09/2015
• Status: Active Grant

• Current Assignee: Jitterbit, Inc.
• Original Assignee: Vinyl Development LLC (Jitterbit, Inc.)
• Inventors: Kennedy, Jr., Thomas R.
• Primary Examiner(s): HASAN, SYED HAROON
• Application Number:
  US14/963,562
• Time in Patent Office: 482 Days
• Field of Search: None
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

Methods, systems, and apparatus, including computer programs encoded on computer storage media, for a light integration. One of the methods includes receiving a plurality of objects from a functional logic tier of an application, each object representative of data stored in a data tier of the application, a first portion of the stored data being stored in a first persistent data store and a second portion of the stored data being stored in a second persistent data store. The method includes presenting in a first area of the user interface information from the plurality of objects, the information selected from the first portion of the data. The method includes receiving an indication of an object being selected from the plurality of objects. The method includes presenting in a second area of the user interface information from the second part of data corresponding to the selected business object.

Claims

1. A computer-implemented method, comprising:

receiving, by a user interface in a presentation tier, a plurality of objects from a functional logic tier of an application, each object representative of data stored in a data tier of the application, a first portion of the stored data being stored in a first persistent data store and a second portion of the stored data being stored in a second persistent data store different from the first persistent data store;

presenting in a first area of the user interface information from the plurality of objects, the information selected from the first portion of the data;

receiving an indication of an object being selected from the plurality of objects in the user interface;

in response to receiving the indication, obtaining the second portion of data from the second persistent data store using information from the first portion of the data;

combining the first portion of the data and the second portion of the data in the selected object in the functional tier;

obtaining, by the user interface, data from the second portion from the selected object;

presenting in a second area of the user interface the data from the second portion of data obtained from the selected object.

2. The computer-implemented method of claim 1, wherein the first persistent data store is a SQL database and the second data store is a NoSQL database.

3. The computer-implemented method of claim 1, wherein at least one of the first data store and the second data store are selected from a group consisting of a relational database, a cloud database, a column database, a document database, a key value database, a graph database, and a multi-model database.

4. The computer-implemented method of claim 1, wherein the second portion of the data includes a key that references the first portion of the data.

5. The computer-implemented method of claim 1, wherein an interface of the object does not distinguish data based on which persistent data store stores the data.

6. The computer-implemented method of claim 1, further comprising storing a key references the first portion of the data in the second portion of the data.

7. A non-transitory computer storage medium encoded with computer program instructions that when executed by one or more computers cause the one or more computers to perform operations comprising:

receiving, by a user interface, a plurality of objects from a functional logic tier of an application, each object representative of data stored in a data tier of the application, a first portion of the stored data being stored in a first persistent data store and a second portion of the stored data being stored in a second persistent data store different from the first persistent data store;

presenting in a first area of the user interface information from the plurality of objects, the information selected from the first portion of the data;

receiving an indication of an object being selected from the plurality of objects in the user interface;

in response to receiving the indication, obtaining the second portion of data from the second persistent data store using information from the first portion of the data;

combining the first portion of the data and the second portion of the data in the selected object in the functional tier;

obtaining, by the user interface, data from the second portion from the selected object;

presenting in a second area of the user interface the data from the second portion of data obtained from the selected object.

8. The non-transitory computer storage medium of claim 7, wherein the first persistent data store is a SQL database and the second data store is a NoSQL database.

9. The non-transitory computer storage medium of claim 7, wherein at least one of the first data store and the second data store are selected from a group consisting of a relational database, a cloud database, a column database, a document database, a key value database, a graph database, and a multi-model database.

10. The non-transitory computer storage medium of claim 7, wherein the second portion of the data includes a key that references the first portion of the data.

11. The non-transitory computer storage medium of claim 7, wherein an interface of the object does not distinguish data based on which persistent data store stores the data.

12. The non-transitory computer storage medium of claim 7 further comprising storing a key references the first portion of the data in the second portion of the data.

13. A system comprising:

one or more computers and one or more storage devices storing instructions that are operable, when executed by the one or more computers, to cause the one or more computers to perform operations comprising;

receiving, by a user interface, a plurality of objects from a functional logic tier of an application, each object representative of data stored in a data tier of the application, a first portion of the stored data being stored in a first persistent data store and a second portion of the stored data being stored in a second persistent data store different from the first persistent data store;

presenting in a first area of the user interface information from the plurality of objects, the information selected from the first portion of the data;

receiving an indication of an object being selected from the plurality of objects in the user interface;

in response to receiving the indication, obtaining the second portion of data from the second persistent data store using information from the first portion of the data;

combining the first portion of the data and the second portion of the data in the selected object in the functional tier;

obtaining, by the user interface, data from the second portion from the selected object;

presenting in a second area of the user interface the data from the second portion of data obtained from the selected object.

14. The system of claim 13, wherein the first persistent data store is a SQL database and the second data store is a NoSQL database.

15. The system of claim 13, wherein at least one of the first data store and the second data store are selected from a group consisting of a relational database, a cloud database, a column database, a document database, a key value database, a graph database, and a multi-model database.

16. The system of claim 13, wherein the second portion of the data includes a key that references the first portion of the data.

17. The system of claim 13, wherein an interface of the object does not distinguish data based on which persistent data store stores the data.

18. The system of claim 13, further comprising storing a key references the first portion of the data in the second portion of the data.