摘要:
The subject invention pertains to systems and methods for interacting with fact dimensions. In particular, systems and methods are disclosed that optimize performance and scalability with respect to processing queries that involve fact dimensions. Furthermore, queries involving fact dimensions can be evaluated in distinct manners. For instance, queries can be processed such that regular dimensions restrict the scope of the data and only fact dimension members that are relevant to that scope are exposed.
摘要:
Systems and methodologies are provided for synchronizing a state of a target serve with that of a source server. During such synchronization process users that interact with the target server can still query data therefrom, with no interruption of service, and are switched to a new state of database upon completion of the synchronization process. Additionally, a transaction consistency is maintained and system administrators are enabled to change location of the data caches, and distribute data and/or applications among a plurality of server configurations by the synchronization process.
摘要:
In a centrifugal oil separator in an internal combustion engine including a centrifuge housing which is placed in a rotationally fixed manner onto a rotating centrifuge shaft, the centrifuge housing is manufactured from plastic and a metal bushing is integrated into the centrifuge housing and is slipped onto the centrifuge shaft.
摘要:
A fiber optic sensor for sensing the presence of an analyte has a plurality of optical fibers each of which has at least one analyte sensing segment and one or more low loss lead portion, where the optical fibers are disposed on the periphery of a fiber carrier. The analyte sensing segments may be disposed in an offset relationship to provide continuous detection over a desired distance or they may be spaced apart to provide detection at selected locations. More than one set of optical fibers with sensing segments may be combined to provide detection of multiple analytes. Multiple fiber carriers allow each segment or the grouped sets of segments to be coupled together over a distance either in offset relationship or in spaced apart relationship.
摘要:
Compressing system paths in a database is disclosed. The systems and methods of the invention define an efficient mechanism to specify a cell's location within the database where there are hierarchies of levels within a dimension. The compressed system paths allow random access of the data without decompressing the data. The format used lends itself well to indexing, and also to creating aggregations of the cell data.
摘要:
A system, method, and related techniques are disclosed for processing data across a distributed network to a plurality of machines. The method may include receiving a first user-supplied transform and generating a first package based on the first user-supplied transform. The method may further include receiving a designated key and generating a second package based on the key. Furthermore, the method may include receiving a second user-supplied transform and generating a third package based on the second user-supplied transform. Moreover, the method may include distributing the first, second, and third packages to a plurality of machines using a cluster API.
摘要:
Systems and methods for storing and retrieving data items in multidimensional databases are provided. Data partition templates are generated for grouping data partitions that are similar to one another, that is, that contain information specified according to particular common characteristics (for instance, time, product, geography, etc.). The data partition template includes one or more rules concerning how the data stored in partitions associated with the data partition template should be processed. A template object having the rule(s) associated therewith is generated for the data partition template. Once a data partition template is generated, a plurality of partitions are generated in accordance therewith. Each of the plurality of partitions utilizes the template object associated with the data partition template. In this way, the overhead associated with managing the partitions is significantly decreased.
摘要:
A data model for accessing data in a relational database in an OLAP system utilizes a multiple-hierarchy dimension. The dimension includes a set of attributes. Each attribute is bound to a column in the relational database. A logical structure is defined, indicating the relationships between the attributes. Hierarchies are defined. Each hierarchy includes a sequence of attributes. A hierarchy provides a common drill-down path that a database user can utilize to access the database. A hierarchy can include a single attribute or a combination of attributes. Both the relationships between the attributes and the sequence of attributes in a hierarchy are defined independent of any restrictions associated with the database.
摘要:
A system and method for analytically modeling data with related attributes is disclosed. A single dimension is used to provide data according to each of the related attributes, and, thus, may be said to play the role of each related attribute depending on a received query. The measure of the analytical data model is tied to the dimension according to both data attributes to allow the measure to be analyzed by the dimension according to both attributes.
摘要:
A system and method for analytically modeling data organized according to non-referred attributes is disclosed. Data stored in a first and a second relational data table is analytically modeled in a data cube. The first table organizes a first type according to a first attribute. The second table organizes a second type according to the first attribute and a second attribute. A first measure is modeled according to the first type of the first table. A first dimension is modeled according to the first attribute of the first and second tables. A second dimension is modeled according to the second attribute of the second table. The first measure is tied to the first dimension according to the first attribute of the first table to allow the first measure to be analyzed by the first dimension according to the first attribute. The first measure is tied to the second dimension by, for each entry of the first dimension, allocating the entry to each entry of the second dimension in a predetermined manner.