DATABASE SYSTEM

• US 20080120270A1
• Filed: 11/19/2007
• Published: 05/22/2008
• Est. Priority Date: 11/17/2006
• Status: Abandoned Application

• Current Assignee: Llinxx
• Original Assignee: Llinxx
• Inventors: LAMBERTS, Johan Hugo
• Application Number:
  US11/941,991
• Publication Number:
  US 20080120270A1
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 16/2477 Temporal data queries

Abstract

A database system includes receiving, storing and retrieving data using the following database elements: an item element comprising database data; a link element comprising a link between the item element and a further item element; an item type element comprising type information of the item element; and a link type element comprising type information of the link element. The item element has a type field for connecting to an item type element, and the link element comprising a type field for connecting to a link type element. In each database element an actual timestamp is included. For retrieving an actual version of the database element, the timestamps are evaluated and the most recent database element is retrieved. Using the above four basic database elements and the timestamp advantageously allows entering data without prior design of a database structure, and modifying both data and links on the fly using the time stamps for keeping consistency.

Claims

1. Method of managing data in a database in a database system, the method comprising

receiving database data to be stored,

generating at least one database element out of the following database elements:

an item element comprising database data;

a link element comprising a link between the item element and a further item element;

an item type element comprising type information of the item element;

a link type element comprising type information of the link element;

the item element comprising a type field for connecting to an item type element, the link element comprising a type field for connecting to a link type element,

including an actual timestamp in the database element and subsequently storing the database element, and

retrieving an actual version of the database element in dependence of the timestamp.

2. Method as claimed in claim 1, wherein generating the database element comprises including an identifier that identifies the database element and enables further database elements to connect to the respective database element,

the identifier in combination with the timestamp constituting a unique key for the database element.

3. Method as claimed in claim 2, wherein said retrieving of the actual version of the database element involves

selecting a most recent one of all database elements having a same identifier.

4. Method as claimed in claim 1, the method comprising

retrieving an item element,

retrieving at least one link element coupled via the link to the retrieved item element, and

retrieving at least one further item element via the link of the retrieved link element.

5. Method as claimed in claim 1, the method comprising

retrieving an item element,

detecting a type field in the retrieved item element,

retrieving a corresponding item type element in dependence of the type field in the retrieved item element,

processing the item element according to the retrieved item type element,

and, in the event that the database has no corresponding type element, processing the item element according to no-type criteria.

6. Method as claimed in claim 1, wherein said processing comprises

retrieving an item type element,

retrieving at least one link type element comprising a link between the item type element and a further item type element, and

receiving database data for generating, coupled to an item element according to the item type element, at least one further link element based on the link type element or at least one further item element based on the further item type element.

7. Method as claimed in claim 1, wherein said database elements further comprise at least one higher hierarchical level, including:

a higher level item element comprising higher level information of a lower level item element;

a higher level link element comprising higher level information of a lower level link element;

the higher level item element comprising a type field for connecting to the lower level item element,

the higher level link element comprising a type field for connecting to a lower level link element.

8. Method as claimed in claim 1, wherein

generating said link element comprises including a position field indicating a position with respect to further link elements of a same link type, and/or

generating said link type element comprises including a position field indicating a position with respect to further link type elements,

and the method comprises ordering item elements and/or item type elements according to the position.

9. Method as claimed in claim 1, wherein the method comprises

providing a copy of the database in a further database system,

operating for a period the database and the copy of the database simultaneously and independently,

synchronizing, after said period of operating, the database and the copy of the database in dependence of the timestamps.

10. Method as claimed in claim 1, wherein the method comprises

providing at least one of the elements of the database system with a concept marker for indicating a concept status.

13. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 1.

14. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 2.

15. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 4.

16. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 5.

17. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 6.

18. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 7.

19. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 8.

20. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 9.

21. Computer program product for managing data in a database in a database system, the product comprising a program of instructions, wherein the program is operative to cause a processor to perform the method as claimed in claim 10.

11. Database system for managing data in a database, the system comprising

input means for receiving database data to be stored,

processing means for

generating at least one database element out of the following database elements:

an item element comprising database data;

a link element comprising a link between the item element and a further item element;

an item type element comprising type information of the item element;

a link type element comprising type information of the link element;

the item element comprising a type field for connecting to an item type element, the link element comprising a type field for connecting to a link type element, and

including an actual timestamp in the database element, and

storage means for, subsequent to including said actual timestamp, storing the database element and for retrieving database elements, the processing means being arranged for selecting an actual version of the database element in dependence of the timestamp.

12. System as claimed in claim 11, wherein the storage means comprise a write once storage unit for storing of the database element.