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, system and program product for modeling data as an undirected graph is disclosed. A set of entities and a set of attributes are defined. A set of relationships is defined to represent semantic associations with each association connecting at least two entities. Attributes are associated with entities rather than with relationships. A hierarchical query language with a set of atomic operations on modeled data is employed. The modeled data is displayed on a display unit.
Abstract:
The invention discloses a DCS/WCDMA dual frequency multiplexer. On one hand, the multiplexer utilizes distributed parameter type capacitors in place of conventionally used capacitors. On the other hand, within the multiplexer, a direct circuit and a RF circuit are isolated from each other physically. All components including capacitors co-exist together physically. Similarly, the invention further discloses a dual frequency multiplexer with large application range. It also utilizes the distributed parameter type capacitors like the DCS/WCDMA dual frequency multiplexer. Because the invention has redesigned the entire construction of the multiplexer, it results good effects such as small size, less differential loss, large power capacity, as well as high isolation degree between circuits.
Abstract:
A method of data loading for large information warehouses includes performing checkpointing concurrently with data loading into an information warehouse, the checkpointing ensuring consistency among multiple tables; and recovering from a failure in the data loading using the checkpointing. A method is also disclosed for performing versioning concurrently with data loading into an information warehouse. The versioning method enables processing undo and redo operations of the data loading between a later version and a previous version. Data load failure recovery is performed without starting a data load from the beginning but rather from a latest checkpoint for data loading at an information warehouse level using a checkpoint process characterized by a state transition diagram having a multiplicity of states; and tracking state transitions among the states using a system state table.
Abstract:
Techniques for reducing a number of computations in a data storage process are provided. One or more computational elements are identified in the data storage process. An ordered structure of one or more nodes is generated using the one or more computational elements. Each of the one or more nodes represents one or more computational elements. Further, a weight is assigned to each of the one or more nodes. An ordered structure of one or more reusable nodes is generated by deleting one or more nodes in accordance with the assigned weights. The ordered structure of one or more reusable nodes is utilized to reduce the number of computations in the data storage process. The data storage process converts data from a first format into a second format, and stores the data in the second format on a computer readable medium for data analysis purposes.
Abstract:
The present invention discloses a control technology for brushless DC motor, in which firstly it is to build or import a motor running parameters' database, then detect the signals always running and the signals closely relevant to the rotor's rotating state such as the voltage and the current, and process these signals and figure out the signals about the rotor's position. Wherein these detected signals should be filtered before being used, and the best filter is the low-pass filter to cut out the high frequency components, and the cut-off frequency of the low-pass filter are determined by the motor running voltage U and PWM signal width when the motor is running at no load, finally determine if the motor is working properly by means of the motor running parameters stored in the database in advance, that is to determine if the detected value is identical with the one predicted from the database. Depending on the results from the detecting and comparison above, the control signal is generated to adjust the motor running state. With the technical method in this invention, the position sensor is not needed. This reduces the motor's external wiring amounts and the wiring complexity. Also the motor's seal is improved. Meanwhile, it is possible to measure the rotor's position accurately in any state according to this invention technology. Thus the motor running state can be controlled properly.
Abstract:
An instrument and method for measuring, analyzing and visualizing 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 and for time-domain pre-processing, a positioning device for determining positions of the sensors, an estimator for determining surface differentials of the collected signals, a spatial pre-filter for reducing measurement noise in the collected signals, a spatial threshold filter for reducing volume conduction distortion, and a unit for displaying the processed signals in one of the time domain and space domain, together with the collected signals and the surface differentials of the collected signals. The collected biosignals over the scalp are also deconvolved to estimate the electrical activity over the brain surface.
Abstract:
Systems and methods for producing an image of the electrical properties of an object using magnetic resonance imaging (“MRI”) are provided. The electrical properties are determined based on estimated gradient values of the electrical properties of the object. For instance, electrical property maps are reconstructed using a spatial integration on gradient values that are estimated from the magnitude and relative phase values derived from measurements of multiple transmit and receive B1fields. Specific absorption rate (“SAR”) maps can also be produced based on the estimated electrical properties.