Method and apparatus for synchronizing cache with target tables in a data warehousing system
Granted: May 17, 2005
Patent Number:
6895471
A method and apparatus for processing (transporting) data, such as in a data warehouse system. In one embodiment, the data are received from a source and compared to data in a lookup cache comprising a subset of data from a first data set (e.g., a dimension table). Instances of the data not present in a lookup cache (that is, new data) are identified. Information corresponding to these instances are generated (e.g., a unique identifier is associated with each of these instances), and the…
Transponder having high phase stability, particularly for synthetic aperture radar, or sar, systems
Granted: March 1, 2005
Patent Number:
6861971
A transceiver or transponder particularly for synthetic aperture radar, or SAR, systems, operating in a frequency band having a central frequency, the transponder comprising a receiver (1) and a transmitter (2) both thermally stable and made by microstrip technology, the receiver (1) and the transmitter (2) being adapted to receive and to transmit, respectively, an electromagnetic wave provided with at least one linear polarisation, the receiver (1) being connected to the transmitter (2)…
Method and apparatus with data partitioning and parallel processing for transporting data for data warehousing applications
Granted: February 1, 2005
Patent Number:
6850947
A method and apparatus for transporting data for a data warehouse application is described. The data from an operational data store (the source database) is organized in non-overlapping data partitions. Separate execution threads read the data from the operational data store concurrently. This is followed by concurrent transformation of the data in multiple execution threads. Finally, the data is loaded into the target data warehouse concurrently using multiple execution threads. By…
System and method for coupling remote data stores and mobile devices via an internet based server
Granted: November 23, 2004
Patent Number:
6823373
The present invention provides a mobile data communication system which couples application specific remote data sources and mobile devices via an internet based server. An interface is provided by the server for extracting data from the application specific remote data sources. The extracted data is then generalized into generic objects and presented on the mobile devices by device specific application templates.
Method and system for navigating a large amount of data
Granted: November 16, 2004
Patent Number:
6820077
Methods for navigating a large amount of data are disclosed. In one embodiment, the present invention accesses a source of formatted warehoused data. The present invention then displays a grid on a display device. In one embodiment, the grid is an iconic representation of the formatted warehoused data. The grid is comprised of elements, each element corresponding to some portion of the formatted warehoused data. The present invention displays a portion of the formatted warehoused data on…
Real time sessions in an analytic application
Granted: September 7, 2004
Patent Number:
6789096
A method and system thereof for performing real time transformations of dynamically increasing databases is described. A session, identified as a real time session, is initialized. The real time session repeatedly executes a persistent (e.g., continually running) data transport pipeline of the analytic application. The data transport pipeline extracts data from a changing database, transforms the data, and writes the transformed data to storage (e.g., a data warehouse or data mart). The…
Ranking query optimization in analytic applications
Granted: October 28, 2003
Patent Number:
6640226
A method of optimizing ranking queries in analytic applications. The method involves dividing a ranking query constructed by a user into multiple sub-commands. These sub-commands are based on the relationship between the foreign key and ranking attributes of a table of data and are run as a batch of commands. As usable data is extracted from each sub-command, it is stored and the foreign key is used as a filter for the next query in the batch. This eliminates accessing irrelevant data…
Apparatus and method for performing data transformations in data warehousing
Granted: January 15, 2002
Patent Number:
6339775
A transformation description language (TDL) for specifying how data is to be manipulated in a data warehousing application. The TDL is comprised of a source for storing raw data, one or more transformation objects for processing the raw data according to predefined instructions, and a target for storing the processed data. A mapping is used for directing the data flow between the I/O ports corresponding to the source, the plurality of transformation objects, and the target. The mapping…
Method and architecture for automated optimization of ETL throughput in data warehousing applications
Granted: March 27, 2001
Patent Number:
6208990
A computer software architecture to automatically optimize the throughput of the data extraction/transformation/loading (ETL) process in data warehousing applications. This architecture has a componentized aspect and a pipeline-based aspect. The componentized aspect refers to the fact that every transformation used in this architecture is built up with transformation components selected from an extensible set of transformation components. Besides simplifying source code maintenance and…
Method and apparatus for sharing metadata between multiple data marts through object references
Granted: March 28, 2000
Patent Number:
6044374
A method and system for accessing and sharing metadata amongst a number of data marts through the use of object referencing. A global repository is created. Shared folders containing metadata is contained in the global repository. Any number of data marts can be linked to the global repository. Stored within the folders of the linked data marts are references pointing to certain metadata stored in the shared folders of the global repository. Multiple data marts can reference the same…
Apparatus and method for capturing and propagating changes from an operational database to data marts
Granted: February 29, 2000
Patent Number:
6032158
A method for updating a target table of a data mart in response to changes made by a transaction to data stored in a source table of an operational database. Data that was changed in the source table by the transaction is stored in a dynamic image table of a change capture database. Data that was not changed in the source table by the transaction, but which is nevertheless required to be mapped to the target table, is stored in a static image table of the change capture database. The…
Apparatus and method for performing data transformations in data warehousing
Granted: January 11, 2000
Patent Number:
6014670
A transformation description language (TDL) for specifying how data is to be manipulated in a data warehousing application. The TDL is comprised of a source for storing raw data, one or more transformation objects for processing the raw data according to predefined instructions, and a target for storing the processed data. A mapping is used for directing the data flow between the I/O ports corresponding to the source, the plurality of transformation objects, and the target. The mapping…
Method for incremental aggregation of dynamically increasing database data sets
Granted: August 11, 1998
Patent Number:
5794246
A method of performing incremental aggregation of dynamically increasing database data sets. An embodiment of the present invention operates within a data mart or data warehouse to aggregate data stored within an operational database corresponding to newly received data to provide current information. Initially, a computer server creates an intermediate file which is initialized by the server with an aggregate data set. The aggregate data set consists of data values and count values that…
