Abstract:
A system and method for ensuring large and frequent updates to a data warehouse. The process leverages a set of temporary staging tables to track the updates. A set of intermediate steps are performed to accomplish bulk deletions of the outdated changed records, and perform modifications to the map tables for models such as snowflake. Finally, bulk load operations load the updates and insert them into the final dimension tables. The process ensures performance comparable to insertion-only schemes with at most only slight performance degradation. Furthermore, a modified process is applied on the newfact data warehouse dimension model. The process can be readily adapted to handle star schema and other hierarchical data warehouse models.
Abstract:
A method and system for coping with slice and dice operations in data warehouses is disclosed. An external approach may be utilized, creating queries using structured query language on a computer. An algorithm may be used to rewrite the queries. The resulting predicates may be joined to dimension tables corresponding to fact tables. An internal approach may be utilized, using aggregation functions with early aggregation for creating the queries. The results of the slice and dice operations may be outputted to a user on a computer monitor.
Abstract:
A method and system for coping with slice and dice operations in data warehouses is disclosed. An external approach may be utilized, creating queries using structured query language on a computer. An algorithm may be used to rewrite the queries. The resulting predicates may be joined to dimension tables corresponding to fact tables. An internal approach may be utilized, using aggregation functions with early aggregation for creating the queries. The results of the slice and dice operations may be outputted to a user on a computer monitor.
Abstract:
Exemplary embodiments include an iceberg query method, including processing the iceberg query using a bitmap index having a plurality of bitmap vectors in a database, eliminating any of the plurality of bitmap vectors in the bitmap index that fails to meet a given condition thereby forming a subset of the plurality of bitmap vectors and aligning the vectors in the subset of the plurality of bitmap vectors in the bitmap index according to respective positions of the bitmap vectors in the subset of the plurality of bitmap vectors.
Abstract:
Described herein is a non-invasive determination of locations of neural activity in a brain. In particular, methods and systems have been developed that utilize a FINES algorithm for use in three-dimensional (3-D) dipole source localization to locate neural activity in a brain.
Abstract:
Methods and apparatus are presented for implementing a uniform platform for data/voice service, in which a base station controller and a Multi-BSSFast Packet Server are integrated into one rack, and a base station controller is connected to the Multi-BSSFast Packet Server via a link based on E1 over Ethernet (E1oE).
Abstract:
A system and method for ensuring large and frequent updates to a data warehouse. The process leverages a set of temporary staging tables to track the updates. A set of intermediate steps are performed to accomplish bulk deletions of the outdated changed records, and perform modifications to the map tables for models such as snowflake. Finally, bulk load operations load the updates and insert them into the final dimension tables. The process ensures performance comparable to insertion-only schemes with at most only slight performance degradation. Furthermore, a modified process is applied on the newfact data warehouse dimension model. The process can be readily adapted to handle star schema and other hierarchical data warehouse models.
Abstract:
A computer program product being embodied on a computer readable medium for extracting semantic information about a plurality of documents being accessible via a computer network, the computer program product including computer-executable instructions for: generating a plurality of tokens from at least one of the documents, each token being indicative of a displayed item and a corresponding position; and, constructing at least one parse tree indicative of a semantic structure of the at least one document from the tokens dependently upon a grammar being indicative of presentation conventions.
Abstract:
An apparatus and method of controlling an engine by determining the state of an ignition command device and the speed of an engine and operating a fuel pump during a predetermined period in response to the ignition command device being in a predetermined state and the speed being substantially zero.
Abstract:
An instrument and method for imaging and localizing of electrical activities in a biological system, comprising a plurality of sensors for detecting signals over a part of a surface of the biological system, a data acquisition unit for collecting the signals, a positioning device for determining positions of the sensors, a procedure for determining geometry information of the biological system, an electrical source model incorporating physical and physiological properties of the biological system, an estimator for determining the parameters of the electrical source model, and a unit for displaying the reconstructed excitation sequence and/or electrical source distribution in the three dimension space of the biological system and over time.