41 results about "MultiDimensional eXpressions" patented technology

A multidimensional operation provider is provided for processing a multidimensional query against a relational datasource. The multidimensional operation provider comprises a query interceptor, a query decomposer and a query replacer. The query interceptor detects and intercepts a multidimensional query that is issued against one or more relational data sources. The query decomposer decomposes expressions of the multidimensional query into one multidimensional expression and/or one or more relational expressions. The query replacer replaces the multidimensional query with a stack of operations expressed by the decomposed multidimensional expressions and/or the relational expressions.

A business intelligence (BI) system which includes the ability to extend its functionality outside of the project life cycle by means of specific content. Complex multidimensional queries are interpreted as trees of atomic sub-expressions that are combined in a parse-tree-like structure to form the overall query. Each sub tree is valid in isolation when provided with the proper context. Any sub tree can be an expression template, stored as application content, which at generation time uses simple text substitution with instance specific parameters to produce multidimensional expression syntax. The system includes a sophisticated type system and semantic layer that hides the user from the complexities inherent in working with OLAP databases. A business intelligence expert can provide type and semantic cues for each expression template, held as content. The content expression templates are then exposed in the application primarily through a context menu that is filtered for appropriateness, but also in an explorer tree, toolbars, menus and submenus. The functionality from a users perspective is integral to the application. An iterative processing capability to complement these expressions is provided by means of OLAP database stored procedures held as application content. Building on the above, workflow content allows business users to extend the application by creating expert-system-like guided analyses and processes. Of key significance to this innovation is the concept that the expression templates, stored procedures and workflows are application content, and therefore redistributable and unshackled from the classic software development lifecycle and the cost and expertise associated.

A method and program product for automatically generating reports matching user interests represented in a dynamically adjusted user interest analytic model (UIAM). A Multidimensional Expressions (MDX) query is generated based on a user visit to a business intelligence application. Based on initial user visit(s), a cube-based UIAM is constructed by including a representation of a first set of user interest(s) in a first set of UIAM item(s). The cube-based UIAM is transformed into a data warehouse-based UIAM. Based on subsequent user visit(s), UIAM items are updated to represent a second set of user interest(s) and UIAM item scores are adjusted to specify how frequently and recently user interests are indicated by the user visits. An update of data in the data warehouse is detected. Reports representative of user interest(s) represented by the updated UIAM items having the top k scores are generated.

The invention provides a relational database data processing method and device. The method includes: acquiring dimension attributes of data stored in a relational database; storing the dimension attributes into a dimension table; reading primary keys of the dimension attributes from the dimension table; searching storage region values of the dimension attributes in the relational database according to the primary keys; storing the mapping relation of the primary keys and the storage region values into the dimension table. By storage of the mapping relation of the primary keys and the storage region values, the problem of low efficiency due to the fact that each partition needs to be queried in an ROLAP (relational online analytical processing) mode in related technologies can be solved to some extent, trouble of handwriting of slices is avoided, and efficiency of MDX (multidimensional expressions) query under the ROLAP mode is improved.

The invention discloses a multi-dimensional expression language based dimension query method and device. The multi-dimensional expression language based dimension query method comprises the steps of determining query conditions and analyzing indexes meeting the query conditions in a database and dimension tables to be queried; obtaining a first dimension table in the dimension tables to be queried, wherein the member value number of the first dimension table in the dimension tables to be queried is larger than a preset threshold value; determining first indexes from the indexes meeting the query conditions; filtering member values in the first dimension table according to the first indexes to obtain a member value set; receiving a multi-dimensional expression language query instruction, wherein the multi-dimensional expression language query instruction is a query instruction obtained based on the member value set; executing query processing on the member value set according to the multi-dimensional expression language query instruction. By means of the multi-dimensional expression language based dimension query method and device, the problem of low query speed during multi-dimensional expression language based query processing in the dimension tables of an analysis database is solved.

The invention discloses an on-line analyzing and processing system of social security data on the basis of a distributed data warehouse. The on-line analyzing and processing system comprises a display layer, a dimensional layer, a star-shaped layer and a storage layer, wherein the display layers interacts with a multidimensional analysis server; the dimensional layer analyzes a MDX (Multidimensional Expressions) statement and executes query computation by the analyzed statement; the star-shaped layer manages the cache of an aggregation result; and the storage layer is in charge of receiving a SQL (Structured Query Language) statement emitted from the start-shaped layer, executing the SQL statement in the data warehouse and returning a result. The data warehouse of the system is realized through a distributed file system, and a distributed file system cluster is uniformly managed via a cloud computation platform to realize the load balancing of resources. By use of the system, through functional multilayer distribution, a uniform query interface for the distributed data warehouse which stores mass data is realized, and a multidimensional operation for a data cube is finished by a query way similar to JDBC (Java DataBase Connectivity).

The invention discloses a method and a device for database query statement generation. The method for database query statement generation comprises the steps of acquiring multi-dimensional expression statements; grouping the multi-dimensional expression statements according to the type of a query operation to acquire target groups; respectively generating a plurality of preset conversion templates according to the plurality of target groups; converting the multi-dimensional expression statements to be converted into database query statements according to the target conversion templates. The problem of higher complexity during conversion from the multi-dimensional expression statements to the database query statements is solved, and the effect of reducing the complexity of conversion from the multi-dimensional expression statements to the database query statements is further achieved by generating the plurality of preset conversion templates according to the plurality of target groups and converting the multi-dimensional expression statements to be converted into database query statements according to the target conversion templates.

This invention discloses one cross analysis process system method to process non vacuum data, which comprises the following steps: a, analyzing defined multi-dimension expression to get index axis original range; b, when only considering physical data, browsing the said original range each member combination and filtering the one dimension data to get initial two dimensional form; c, browsing the said two dimension each line or row units and filtering them to get needed two dimensional form. This invention also discloses one device to analyze process system for non-hollow data of cross machine.

The present invention relates to data processing systems and methods to facilitate debugging, development and execution of multidimensional database queries, such as MDX (Multi-Dimensional eXpressions), for a multidimensional database structure on a computer architecture running on a server, such as an OnLine Analytical Processing Server (OLAP). The expression or query can be broken down and executed incrementally and associated with contextual information which can be viewed by an end-user via an understandable user interface. The advantage is the drastic simplification of very complex computations, giving the user a perspective not available till now. This allows users to better understand multidimensional queries, find errors that occur in the execution and correct such errors.

An illustrative embodiment provides a computer-implemented process for semantic verification of multidimensional data sources that receives a trusted output from a trusted multidimensional expression engine, receives an un-trusted output from an un-trusted data source and determines whether a query produces a correct semantic result, wherein the correct semantic result is within a predetermined tolerance. Responsive to a determination that the query does not produce a semantically correct result, identifies queries having semantically incorrect results to form a local subset, notifies a query planner of semantically incorrect queries and determines whether to process queries locally. Responsive to a determination to not process queries locally, creates a set of simplified multidimensional expression queries for remote execution.

The invention relates to a multi-temporal remote sensing image spatial-temporal spectrum integrated fusion method based on coupling sparse tensor decomposition. The method comprises the following steps: preprocessing a hyperspectral image HtSe-Lsa with high temporal resolution, high spectral resolution and low spatial resolution; and representing the multi-temporal HtSe-Lsa image and the Hsa-LtSe image in a three-dimensional tensor form. The invention has the beneficial effects that a plurality of long-time-sequence images are used for expanding the third dimension, and a plurality of high-resolution images can be generated at the same time through one-time fusion, so that integrated fusion of a plurality of different time-phase images is realized; superposing target images of different time phases in a spectrum dimension by using the multidimensional expression advantage of tensor so as to realize time phase expansion; on one hand, the calculation efficiency is improved through dimensionality reduction, on the other hand, error accumulation caused by too many variables required to be solved due to too high dimensionality is reduced through dimensionality reduction, the complexity of model reconstruction is greatly reduced, and the reconstruction efficiency is improved.

The invention provides a database query method and system and electronic device.The database query method comprises the steps that an SQL statement input by a user on a user terminal and sent by the user terminal is received, a multi-dimensional expression MDX statement is obtained according to the first SQL statement, multi-dimensional data are obtained from a multi-dimensional database according to the MDX statement, and meanwhile, the multi-dimensional data are obtained according to the MDX statement; the method comprises the following steps: acquiring a first SQL statement, converting multi-dimensional data into relational data, generating a relational data table according to the relational data, acquiring a second SQL statement according to the first SQL statement and address information of the relational data table, querying in the relational data table according to the second SQL statement to obtain a data query result, and sending the data query result to a user terminal. According to the technical scheme, the data can be queried in the multi-dimensional database by using the structured query statement, and the data can be returned to the user relational data table, so that the user experience is improved.