COMPUTER IMPLEMENTED METHOD FOR CREATING DATABASE STRUCTURES WITHOUT KNOWLEDGE ON FUNCTIONING OF RELATIONAL DATABASE SYSTEM

• US 20150081747A1
• Filed: 08/27/2014
• Published: 03/19/2015
• Est. Priority Date: 08/30/2013
• Status: Active Grant

• Current Assignee: Datawalk Spolka Akcyjna
• Original Assignee: DataWalk SA
• Inventors: PIECKO, Krystian
• Granted Patent: US 9,747,312 B2
• Time in Patent Office: Days
• US Class Current: 707/803
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/8358 Query translation

Abstract

Computer implemented methods for storing ad hoc relations between previously unrelated database objects assigned to different database structures using an electronic computing device are presented, the methods including: causing the electronic computing device to define at least three database structures: structure A, structure B and structure C, where each of the at least three database structures each includes a number of objects, where there exists at least one relation between objects of structure A and objects of structure B, and where there exists at least one relation between objects of structure B and objects of structure C; filtering data of structure A; accessing structure B using a first selected relation between structure A and structure B; storing information about filtering of structure A and information on a first selected path between structure A and structure B; filtering results obtained from structure B.

Claims

1. A computer implemented method for storing ad hoc relations between previously unrelated database objects assigned to different database structures using an electronic computing device, the method comprising:

causing the electronic computing device to define at least three database structures;

structure A, structure B and structure C, wherein each of the at least three database structures each includes a plurality of objects, wherein there exists at least one relation between objects of structure A and objects of structure B, and wherein there exists at least one relation between objects of structure B and objects of structure C;

filtering data of structure A;

accessing structure B using a first selected relation between structure A and structure B;

storing information about filtering of structure A and information on a first selected path between structure A and structure B;

filtering results obtained from structure B;

accessing structure C using a second selected relation between structure B and structure C; and

storing information about filtering of structure B and information on a second selected path between structure B and structure C.

2. The method according to claim 1 wherein the information stored is kept in a form of an XML file.

3. The method according to claim 2 wherein the XML file includes information related to selected structures, selected relations and selected filters.

4. The method according to claim 1 wherein the steps of filtering, accessing and storing are executed with respect to a further structure D related to the structure C.

5. The method according to claim 1 wherein the database comprises:

a first data structure, stored in a memory, comprising a definition of at least one data set wherein each data set comprises a data set identifier and logically holds data objects of a same type;

a second data structure, stored in the memory, comprising definitions of properties of objects wherein each property comprises an identifier of the property and an identifier of a set, from the first data structure, the property is assigned to;

a third data structure, stored in the memory, comprising definitions of objects wherein each object comprises an identifier and an identifier of a set, from the first data structure, the object is assigned to;

a fourth data structure, stored in the memory, comprising definitions of properties of each object wherein each property of an object associates a value with an object, from the third data structure, and a property of the set, from the second data structure, the object is assigned to;

a fifth data structure, stored in the memory, comprising definitions of relations wherein each relation comprises an identifier of the relation; and

a sixth data structure, stored in the memory, for storing definitions of relations between objects wherein each objects relation associates a relation, from the fifth data structure, to two objects from the third data structure.

6. A computing device program product for storing ad hoc relations between previously unrelated database objects assigned to different database structures using an electronic computing device, the computing device program product comprising:

a non-transitory computer readable medium;

first programmatic instructions for causing the electronic computing device to define at least three database structures;

structure A, structure B and structure C, wherein each of the at least three database structures each includes a plurality of objects, wherein there exists at least one relation between objects of structure A and objects of structure B, and wherein there exists at least one relation between objects of structure B and objects of structure C;

second programmatic instructions for filtering data of structure A;

third programmatic instructions for accessing structure B using a first selected relation between structure A and structure B;

fourth programmatic instructions for storing information about filtering of structure A and information on a first selected path between structure A and structure B;

fifth programmatic instructions for filtering results obtained from structure B;

sixth programmatic instructions for accessing structure C using a second selected relation between structure B and structure C; and

seventh programmatic instructions for storing information about filtering of structure B and information on a second selected path between structure B and structure C.

7. The computing device program product according to claim 6 wherein the information stored is kept in a form of an XML file.

8. The computing device program product according to claim 7 wherein the XML file includes information related to selected structures, selected relations and selected filters.

9. The computing device program product according to claim 6 wherein the steps of filtering, accessing and storing are executed with respect to a further structure D related to the structure C.

10. The computing device program product according to claim 6 wherein the database comprises:

a first data structure, stored in a memory, comprising a definition of at least one data set wherein each data set comprises a data set identifier and logically holds data objects of a same type;

a second data structure, stored in the memory, comprising definitions of properties of objects wherein each property comprises an identifier of the property and an identifier of a set, from the first data structure, the property is assigned to;

a third data structure, stored in the memory, comprising definitions of objects wherein each object comprises an identifier and an identifier of a set, from the first data structure, the object is assigned to;

a fourth data structure, stored in the memory, comprising definitions of properties of each object wherein each property of an object associates a value with an object, from the third data structure, and a property of the set, from the second data structure, the object is assigned to;

a fifth data structure, stored in the memory, comprising definitions of relations wherein each relation comprises an identifier of the relation; and

a sixth data structure, stored in the memory, for storing definitions of relations between objects wherein each objects relation associates a relation, from the fifth data structure, to two objects from the third data structure.

11. A computer implemented method for storing ad hoc relations between previously unrelated database objects assigned to database structures in a database using an electronic computing device, the method comprising:

causing the electronic computing device to provide at least three database structures in the database defined at least as a structure A, a structure B, and a structure C,

wherein each of the at least three database structures each includes a plurality of objects,

wherein there exists a first plurality of relations between objects of structure A and objects of structure B, and

wherein there exists a second plurality of relations between objects of structure B and objects of structure C;

filtering data of structure A;

accessing structure B by selecting any of the first plurality of relations between structure A and structure B;

storing information about filtering of structure A and information on a first selected path corresponding with the first plurality of relations between structure A and structure B;

filtering results obtained from structure B;

accessing structure C by selecting any of the second plurality of relations between structure B and structure C; and

storing information about filtering of structure B and information on a second selected path corresponding with the second plurality of relations between structure B and structure C,

wherein an ad hoc relation between structure A and structure C is created.

12. The method according to claim 11, further comprising storing the ad relation.

13. The method according to claim 11 wherein the information stored is kept in a form of an XML file.

14. The method according to claim 13 wherein the XML file includes information related to selected structures, selected relations and selected filters.

15. The method according to claim 11 wherein the steps of filtering, accessing and storing are executed with respect to at least one additional structure related to structure A.

16. The method according to claim 11 wherein the steps of filtering, accessing and storing are executed with respect to at least one additional structure related to structure B.

17. The method according to claim 11 wherein the steps of filtering, accessing and storing are executed with respect to at least one additional structure related to structure C.

18. The method according to claim 11, wherein the at least three database structures are different database structures.