KNOWLEDGE COMPUTING CORPORATION Patent applications |
Patent application number | Title | Published |
20110231358 | Method and apparatus for loading data files into a data-warehouse system - Date-warehouse systems are populated using an enhanced Extraction-Load-Transform (ETL) process and system by employing three ideas: Out-of-order-fill ETL, relative-ordering index (ROI), and dependent queries. Out-of-order-fill ETL allows a data warehouse to accept the loading of data files in any order, and does not require the loading of any previous backup data files in order to provide some functionality to end users under the view that some functionality or data access is better than none at all. Dependent queries are processes that use defined data structures for use in constructing, extracting, and validating each record to be written in said data-warehouse system in order to ensure that referential integrity is maintained and that no orphaned data is pushed into the data warehouse. Finally, ROI is a process wherein a value is determined, based on the constraints of the source data, which indicates the relative newness of the data. | 09-22-2011 |
20100030750 | Methods and Apparatus for Performing Multi-Data-Source, Non-ETL Queries and Entity Resolution - The application discloses a new system for performing queries and entity resolution on two or more data sources without having to ETL all the documents, entities, and descriptions of entities. Also disclosed, is a method to perform advanced entity resolution without divulging personally sensitive information to end-users and intermediate systems. | 02-04-2010 |
20090177647 | Method and Apparatus for Conducting Data Queries Using Consolidation Strings and Inter-Node Consolidation - Query inefficiencies are improved and entity-interrelational blindness is overcome by employing two ideas: Consolidation Strings and Inter-Node Consolidation. These ideas can be typically employed in law-enforcement records systems (such as COPLINK systems), but is certainly not limited to such an application. Consolidation Strings represent key pieces of information that are in a text/character format, and may be encrypted/hashed. A system's hierarchy of consolidation rules automatically determine if two different rows in a database actually refer to the same real-world object. These rules are NOT statistical or probabilistic in nature, thus enhancing the confidence and reliability in the results. Three general classifications of Consolidation Strings are encompassed: Those based on positive identifiers, those based on demographic information, and those based on associative information that spans multiple-entity types. Inter-Node Consolidation provides a means to facilitate the communication of updated consolidation information between data-source nodes in order to leverage the advantages of Consolidation Strings. | 07-09-2009 |
20090172047 | Method and Apparatus for Loading Data Files into a Data-Warehouse System - Date-warehouse systems are populated using an enhanced Extraction-Load-Transform (ETL) process and system by employing three ideas: Out-of-order-fill ETL, relative-ordering index (ROI), and dependent queries. Out-of-order-fill ETL allows a data warehouse to accept the loading of data files in any order, and does not require the loading of any previous backup data files in order to provide some functionality to end users under the view that some functionality or data access is better than none at all. Dependent queries are processes that use defined data structures for use in constructing, extracting, and validating each record to be written in said data-warehouse system in order to ensure that referential integrity is maintained and that no orphaned data is pushed into the data warehouse. Finally, ROI is a process wherein a value is determined, based on the constraints of the source data, which indicates the relative newness of the data. | 07-02-2009 |