Graph representation of data extraction for use with a data repository

Patent metadata

Field	Value
Publication number	US-2016103871-A1
Application number	US-201514749045-A
Country	US
Kind code	A1
Filing date	Jun 24, 2015
Priority date	Oct 10, 2014
Publication date	Apr 14, 2016
Grant date	—

Abstract

A graph representation is described that may be used for data extraction for a data repository. In one example, the graph representation defines an extraction dataset from an object. A selection from a user for a root node is received. Additional are presented for selection by the user based on fields and properties of the selected root node. The root node and selected additional objects are presented as a data graph. The selected objects are joined and presented in the data graph. Finally a dataset is extracted from the object-oriented database based on the data graph.

First claim

What is claimed is:

1 . A database system-implemented comprising:
receiving a selection from a user for a root node, the root node being an object in an object-oriented database; presenting additional objects in the object-oriented database related to the root node to the user on a display device for selection by the user based on fields and properties of the selected root node in the object-oriented database; receiving a selection of one or more of the additional objects by the user; presenting the root node and selected additional objects as a data graph to the user on the display device; joining the selected objects; presenting the joins in the data graph to the user on the display device; and extracting a dataset from the object-oriented database based on the data graph.

2 . The method of claim 1 , further comprising:
automatically joining objects in the object-oriented database based on fields and properties; receiving selections from a user to select one or more of the automatic joins; and modifying the data extraction in response to the received automatic join selections.

3 . The method of claim 2 , wherein modifying the joins comprises adding joins.

4 . The method of claim 2 , wherein modifying the joins comprises deleting joins.

5 . The method of claim 1 , wherein presenting the data graph comprises representing selected objects and presenting additional objects for selection is performed on a single screen.

6 . The method of claim 1 , wherein receiving a selection of one or more of the additional objects comprises receiving a definition of object relationships, joins, and fetches, the method further comprising modifying the data graph after each received user selection.

7 . The method of claim 1 , wherein presenting additional objects comprises applying a data dictionary to database objects to define possible joins and extractions based on fields and properties in the database.

8 . The method of claim 1 , wherein presenting additional objects comprises applying metadata stored in lookup field definitions of objects to display and assemble join conditions.

9 . The method of claim 1 , wherein extracting a dataset comprises generating an Object Query Language query for a flattened dataset and using the query to extract the dataset.

10 . The method of claim 1 , further comprising presenting a preview of the extracted dataset upon receiving a user command to present a preview, the preview including a portion of the data that will be extracted in extracting the data in a denormalized form.

11 . A non-transitory machine-readable medium comprising a plurality of instructions which, when executed by a processing device, cause the processing device to perform one or more operations comprising:
receiving a selection from a user for a root node, the root node being an object in an object-oriented database; presenting additional objects in the object-oriented database related to the root node to the user on a display device for selection by the user based on fields and properties of the selected root node in the object-oriented database; receiving a selection of one or more of the additional objects by the user; presenting the root node and selected additional objects as a data graph to the user on the display device; joining the selected objects; presenting the joins in the data graph to the user on the display device; and extracting a dataset from the object-oriented database based on the data graph.

12 . The medium of claim 11 , further comprising:
automatically joining objects in the object-oriented database based on fields and properties; receiving selections from a user to select one or more of the automatic joins; and modifying the data extraction in response to the received automatic join selections.

13 . The medium of claim 12 , wherein modifying the joins comprises adding joins.

14 . The medium of claim 12 , wherein modifying the joins comprises deleting joins.

15 . The medium of claim 11 , wherein presenting the data graph comprises representing selected objects and presenting additional objects for selection is performed on a single screen.

16 . A system comprising:
a processor and a memory to execute instructions at the system; and a mechanism to: receive a selection from a user for a root node, the root node being an object in an object-oriented database; present additional objects in the object-oriented database related to the root node to the user on a display device for selection by the user based on fields and properties of the selected root node in the object-oriented database; receive a selection of one or more of the additional objects by the user; present the root node and selected additional objects as a data graph to the user on the display device; join the selected objects; present the joins in the data graph to the user on the display device; and extract a dataset from the object-oriented database based on the data graph.

17 . The system of claim 16 , wherein receiving a selection of one or more of the additional objects comprises receiving a definition of object relationships, joins, and fetches, the method further comprising modifying the data graph after each received user selection.

18 . The system of claim 16 , wherein presenting additional objects comprises applying a data dictionary to database objects to define possible joins and extractions based on fields and properties in the database.

19 . The system of claim 16 , wherein presenting additional objects comprises applying metadata stored in lookup field definitions of objects to display and assemble join conditions.

20 . The system of claim 16 , further comprising presenting a preview of the extracted dataset upon receiving a user command to present a preview, the preview including a portion of the data that will be extracted in extracting the data in a denormalized form.

Assignees

• Salesforce Com Inc

Inventors

• Zheng Zuye
• Moktali Amruta
• Deshpande Suyog Anil

Classifications

• G06F16/9024

  Graphs; Linked lists (G06F16/9027 takes precedence) · CPC title

• G06F16/284

  Relational databases · CPC title

• G06F16/254 Primary

  Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses · CPC title

• G06F16/289

  Object oriented databases · CPC title

• G06F3/04842

  Selection of displayed objects or displayed text elements (G06F3/0482 takes precedence) · CPC title