IP Library › Granted Patent US 10,296,542
Granted Patent B2
US 10,296,542 · App. 14/785,949 · Granted May 21, 2019

Integration database framework

Inventor: Jan Söderberg (Göteborg, SE)
Assignee: SYSTEMITE AB
G06F16/9024G06F16/211G06F16/23G06F16/25G06F16/27
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,296,542
App. No.
14/785,949
Granted
May 21, 2019
Kind
B2
Abstract

A database system comprising a first database including a database manager and a schema with set of rules enabling the database manager to store and access data items in the first database, and a second database storing a plurality of data items. The schema further including rules to enable the database manager to access at least a subset of the data items in the second database. The first database further includes a first link pointing from the primary item to a replica of the secondary item stored in the first database, and a second link pointing from the replica to the secondary item in the second database.

Claims (23)

1. A method for creating a link between a first database and a second database,

said first database comprising a database manager and a schema including set of rules enabling said database manager to store and access primary data items in said first database,

said second database storing a plurality of secondary data items,

said method comprising:

extending said schema to include rules to enable said database manager to access at least a subset of said items in said second database, wherein said schema includes a plurality of data item types, said data item types each includes a marker field indicating if a data item is a replica of a secondary item in the second database,

receiving a request to establish a link from a primary item in the first database to a secondary item in the second database,

verifying that said schema includes access rules to enable said database manager to access said secondary item,

accessing, by said database manager, said secondary item and storing, in said first database, a replica of said secondary item,

creating a link from said replica to said secondary item, and

creating a link from said primary item to said replica.

2. The method according to claim 1 , wherein the first database is used as an integration database, providing access to all information required by a user to work with several different computer tools.

3. The method according to claim 2 , wherein the schema extended so as to enable the database manager to access data items in any database used by an organization.

4. The method according to claim 1 , wherein the second database stores additional content which is not covered by rules of the schema.

5. The method according to claim 1 , wherein the replica is not a complete copy of the secondary data item.

6. The method according to claim 1 , further comprising a step of performing, at scheduled points in time, an update of said replica, to reflect any changes made to the secondary data item.

7. The method according to claim 1 , wherein the step of extending said schema includes automatically examining schemas of specific databases and extracting rules required to access data items in said specific databases.

8. The method according to claim 1 , wherein the schema is defined according to one of object database principles and relational databases principles.

9. A database system comprising:

at least one processor;

a first database including a database manager and a schema with set of rules enabling said database manager to store and access data items in said first database,

a second database storing a plurality of data items, said schema further including rules to enable said database manager to access at least a subset of said data items in said second database, wherein said schema includes a plurality of data item types, said data item types each includes a marker field indicating if a data item is a replica of a secondary item in the second database,

said first database further including a link between a primary item in said first database and a secondary item in said second database, said link comprising a first link and a second link,

said first link pointing from said primary item to a replica of said secondary item stored in said first database, and said second link pointing from said replica to said secondary item in said second database.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 21, 2015
From: SÖDERBERG, JAN
To: SYSTEMITE AB
Reel/Frame 036845/0240 →
Priority Claims (1)
EP 13002292 · Apr 30, 2013 · regional
Continuity (1)
Related Publication 20160070819A1 · Mar 10, 2016