41 results about "MultiDimensional eXpressions" patented technology

A system for transforming queries based upon entity/relationship schema into multi-dimensional expression queries is provided. The system comprises a binding module for matching an object reference in a report specification to a corresponding entity/relationship schema object and adding associated multi-dimensional metadata information from the entity/relationship schema to a corresponding report specification object, and a query translation module for translating the report specification into a single multi-dimensional query.

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 multidimensional modeling system which comprises an interface generating unit, a model selecting unit, an information definition unit and a statement generating unit, wherein the interface generating unit is used for generating a visualization operation interface and displaying computer icons corresponding to selectable service operations and corresponding operation function menu options in the visualization operation interface. The model selecting unit is used for selecting from the visualization operation interface according to selecting operation of a user so as to determine a multidimensional cubic model. The information definition unit is used for defining a line dimensionality and/ or a column dimensionality and an index in the multidimensional cubic model in the visualization operation interface, and the statement generating unit is used for generating corresponding inquire statements by utilizing type information of the multidimensional cubic model, the line dimensionality and/ or the column dimensionality and the index. The invention further provides a multidimensional modeling method. By means of the technical scheme, parts of a multidimensional expression (MDX) can be separated independently to enable a graphical interface to independently generate each part, and then all parts are combined to a complete MDX statement.

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

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).

A computer readable medium stores executable instructions to receive a Multidimensional Expressions (MDX) query. The MDX query is recursively rationalized to form a rationalized query. The rationalized query is applied to a multidimensional data source to produce query results. The query results are returned.

The invention discloses a method and a device for multidimensional analysis of a relational database. The method includes: creating a fact table and a dimension table in the relational database, and establishing a multidimensional analysis model; translating MDX (multidimensional expressions) statements in the multidimensional analysis model to SQL (structured query language) statements; compiling the SQL statements so as to determine an SQL execution step, and outputting and displaying the MDX statements, the SQL statements and the corresponding SQL execution step; adopting the SQL statements to execute SQL inquiry on the fact table and the dimension table, and returning inquiry results. By output and display of the MDX statements in the multidimensional analysis model, the SQL statements translated from the MDX statements and the SQL execution step, developers can discover possible performance problems in time beneficially, efficiency of multidimensional analysis is improved, convenience is brought to developers to monitor generation of the MDX statements into the SQL statements, and operation of multidirectional analysis and optimization is facilitated.

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 discloses a method for querying hierarchical node data. By using the method, MDX (multidimensional expressions) statements, BWETL (band width extract transform and load) data extracting and RFC (request for comment) remote functions are invoked integrally, the hierarchical node data are queried, hierarchical nodes are inputted, and queried nodes are inputted on a data retrieval platform. The method for querying hierarchical node data comprises the following steps of examination on authorization: verifying authorization of inputted nodes and personnel using the method; parameter transmitting: transmitting parameters to a function if verification passes and performing specific data extracting operation; executing on a node report: invoking a BWQUERY node report according to the parameters after the parameters are received by the function; invoking of the MDX statements: invoking the MDX statements if data of the inputted nodes exist, transmitting the running result of the report to an inner table of the function and maintaining the running result as a queried parameter; and returning of the result: reading data from a DSO (digital storage oscilloscope) model according to the node parameters and limiting conditions of the function, and returning the result to the data retrieval platform to obtain the hierarchical node data. By using the method, the data acquisition efficiency is improved, and data uploading is stable.

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.