Real time data warehousing
First Claim
1. A method for processing data in a database, the method comprising the steps of:
- receiving data comprising at least one record having at least one identifier, each record representing at least one of a plurality of entities;
comparing the received data with at least one record stored in a database to determine an existence of a relationship therebetween;
creating a relationship record for each record stored in the database determined to reflect the existence of a relationship with at least a portion of the received data, wherein the relationship record includes a relationship type and a confidence indicator for the relationship; and
storing the relationship record in the database.
2 Assignments
0 Petitions
Accused Products
Abstract
A method and system for processing data into and in a database and for retrieving the processed data is disclosed. The data comprises identifiers of a plurality of entities. The method and system comprises: (a) processing data into and in a database, (b) enhancing received data prior to storage in a database, (c) determining and matching records based upon relationships between the records in the received data and existing data without any loss of data, (d) enabling alerts based upon user-defined alert rules and relationships, (e) automatically stopping additional matches and separating previously matched records when identifiers used to match records are later determined to be common across entities and not generally distinctive of an entity, (f) receiving data queries for retrieving the processed data stored in the database, (g) utilizing the same algorithm to process the queries and (h) transferring the processed data to another database that uses the same algorithm.
118 Citations
36 Claims
-
1. A method for processing data in a database, the method comprising the steps of:
-
receiving data comprising at least one record having at least one identifier, each record representing at least one of a plurality of entities; comparing the received data with at least one record stored in a database to determine an existence of a relationship therebetween; creating a relationship record for each record stored in the database determined to reflect the existence of a relationship with at least a portion of the received data, wherein the relationship record includes a relationship type and a confidence indicator for the relationship; and storing the relationship record in the database. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 33, 34)
-
-
17. A system for processing data in a database, a computer readable storage medium tangibly embodying a program of instructions execution executable by a computer for performing the method comprising the steps of:
-
receiving data comprising at least one record having at least one identifier, each record representing at least one of a plurality of entities; comparing the received data with at least one record stored in a database to determine an existence of a relationship therebetween; creating a relationship record for each record stored in the database determined to reflect the existence of a relationship with at least a portion of the received data, wherein the relationship record includes a relationship type and a confidence indicator for the relationship; and storing the relationship record in the database. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 35, 36)
-
Specification