摘要:
The present invention relates to a system and method of translating stored data. In particular the present invention facilitates multilingual interaction with a data store by providing a translation component between data stored in one language and users that prefer to interact in one or more different languages. Queries or commands can be executed on a database and results presented in any one of a plurality of languages selected by a user. Furthermore, a mechanism is also provided to allow users to enter queries in their preferred language rather than the language of the underlying system.
摘要:
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.
摘要:
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.
摘要:
Computer-readable media, systems, and methods for building a multidimensional data cube having one or more high-cardinality attributes are described. In embodiments, data is extracted from one or more databases. It is determined that one or more instances of the data are fact data and one or more instances of the data are dimension data. Each member of the fact data is one instance of a dimension and each instance of the dimension data includes an attribute for grouping the fact data. Moreover, in embodiments it is determined that one or more instances of the dimension data are high-cardinality attributes. The one or more high-cardinality attributes are processed with fact data and stored in fact tables on a computer storage medium.
摘要:
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 that facilitates one or more of querying and updating a multi-dimensional structure comprises a component that receives a statement in a declarative language relating to a typed object associated with a multi-dimensional structure. A conversion component analyzes context associated with the statement and automatically converts the object to a disparate type as a function of the analysis. For example, an execution engine can comprise the conversion component, and the execution engine can be an Online Analytical Processing (OLAP) engine.
摘要:
A system and method for analytically modeling data from different measure groups onto a single cube are disclosed. The single cube preferably includes a first measure associated with a first measure group with a first set of corresponding dimensions. The single cube preferably also includes a second measure associated with a second measure group with a second set of corresponding dimensions. The single cube preferably also includes each dimension in both the first and second set of dimensions. Each measure is preferably tied to each corresponding dimension according to data in an underlying relational data table. Each measure is preferably tied to each non-corresponding dimension according to an approximation.
摘要:
A system that facilitates one or more of querying and updating a multi-dimensional structure comprises a component that receives a statement in a declarative language relating to a typed object associated with a multi-dimensional structure. A conversion component analyzes context associated with the statement and automatically converts the object to a disparate type as a function of the analysis. For example, an execution engine can comprise the conversion component, and the execution engine can be an Online Analytical Processing (OLAP) engine.
摘要:
Creating and maintaining cell data records in a multidimensional database is disclosed using flexible dimension paths is disclosed. The systems and methods of the invention define an efficient mechanism to specify a cell's location within the multidimensional database where there are hierarchies of levels within a dimension. The flexible dimension path does not change when a member is moved from a first point to a second point on a dimension thereby avoiding the need to rebuild the OLAP database. The format used lends itself well to indexing, and also to creating aggregations of the cell data.
摘要:
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.