Patent
Automated time metadata deduction
TLDR
In this paper, a set of OLAP tools are combined with an analysis services server to deduce descriptive metadata from data contained in a column of a relational table and associated existing metadata (e.g., column data type and/or column name).Abstract:
An arrangement for deducing descriptive metadata from data contained in a column of a relational table and associated existing metadata (e.g., that which identifies column data type and/or column name) is provided by a metadata deduction engine in a set of OLAP tools which operates in conjunction with an analysis services server. The metadata deduction engine applies one or more criteria that are configured to evaluate column data in order to deduce metadata that provides additional contextual meaning to the column data beyond that given by the existing metadata. The metadata deduction engine maps the column data to a metadata tag that is passed to the analysis services server to enable it to create an OLAP cube using the deduced metadata.read more
Citations
More filters
Patent
Ranking graphical visualizations of a data set according to data attributes
Hillel Maoz,Daniel Libicki,Michael Fink,Ronald Ho,Dennis Lee,Yossi Matias,Amit Weinstein,Yoah Bar David,Itai Raz +8 more
TL;DR: A computer-implemented system, method and computer readable medium to generate graphical visualizations corresponding to a data set populated in a web-based document, such as a spreadsheet, is presented in this article.
Patent
Real time datamining
TL;DR: In this paper, the authors present a real-time datamining system for pyramid-level data, where a user requests for data mining with respect to a value from a report associated with a specific pyramid level, identifying a dataamining function to be performed for statistical analysis of lower level data pertaining to the value from the report, identifying dimensions to be used as variables for the statistical analysis, and determining criteria for selecting the lowerlevel data associated with the report.
Patent
Forests of dimension trees
TL;DR: In this paper, a method and apparatus for managing forests of dimension trees is presented, which may include receiving user input identifying a dimension tree, and presenting the dimension tree to the user.
Patent
ETL tool utilizing dimension trees
TL;DR: A method and apparatus for an ETL tool utilizing dimension trees can be found in this paper, where the method may include identifying various dimensions associated with one or more databases, and creating dimension trees based on these dimensions.
Patent
Building custom dimension trees
TL;DR: In this paper, a method and apparatus for creating custom dimension trees is described, which allows the user to create virtual dimensions, mapping elements of the available dimensions to the virtual dimensions and creating the custom dimension tree using the mapping.
References
More filters
Patent
Method, system, and program for use of metadata to create multidimensional cubes in a relational database
TL;DR: In this article, a method, system, and program for query processing is described, and a data structure stored in the computer-readable medium includes data for use by the program.
Patent
Method, system, and program for improving performance of database queries
TL;DR: In this article, a system, method, and program for improving the performance for SQL queries is presented, where multidimensional metadata associated with a cube model metadata object is obtained.
Patent
OLAP query generation engine
TL;DR: In this paper, a system and method for generating an On-Line Analytical Processing (OLAP) query is presented, where a query object is provided that supports a plurality of OLAP servers which use different structured query formats.
Patent
System and method for automatically building an OLAP model in a relational database
TL;DR: In this paper, a system automatically generates OLAP metadata objects for a multidimensional analysis program such as OLAP from SQL statements without involving the database administrator, and eliminates the need for database administrators to manually perform this analysis and design.
Patent
System and method for selecting rows from dimensional databases
John Bair,Charles M Bender +1 more
TL;DR: In this paper, a system and method selects rows from a fact table in a dimensional database containing a time dimension table and other dimension tables, each of which contains rows containing an effective time attribute for the row, and other attributes.