CA2510747A1 - Specifying multidimensional calculations for a relational olap engine - Google Patents

Specifying multidimensional calculations for a relational olap engine Download PDF

Info

Publication number
CA2510747A1
CA2510747A1 CA002510747A CA2510747A CA2510747A1 CA 2510747 A1 CA2510747 A1 CA 2510747A1 CA 002510747 A CA002510747 A CA 002510747A CA 2510747 A CA2510747 A CA 2510747A CA 2510747 A1 CA2510747 A1 CA 2510747A1
Authority
CA
Canada
Prior art keywords
metadata
measures
query language
structured query
symmetric
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CA002510747A
Other languages
French (fr)
Other versions
CA2510747C (en
Inventor
Nathan Gevaerd Colossi
William Earl Malloy
Mir Hamid Pirahesh
Craig Reginald Tomlyn
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
International Business Machines Corp
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Publication of CA2510747A1 publication Critical patent/CA2510747A1/en
Application granted granted Critical
Publication of CA2510747C publication Critical patent/CA2510747C/en
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Disclosed is a system, method, and program for specifying multidimensional calculations. Selection of a subset of a cube model metadata object that is generated from a facts metadata object and one or more dimension metadata objects is received. The facts metadata object references one or more measure metadata objects. A statement is generated for retrieving multidimensional information using metadata in the cube model metadata object and the measure metadata objects, wherein each of the measure metadata objects specifies one or more aggregations.

Claims (4)

1. A computer implemented method for automatically generating a single structured query language statement specifying multidimensional calculations involving symmetric or asymmetric measures sets, wherein aggregation order, and asymmetric measures have multiple aggregation operators, the method comprising the steps of:
receiving selection of a subset of a cube model metadata object that is generated from a facts metadata object and one or more dimension metadata objects, wherein the facts metadata object references one or more measure metadata objects;
generating a statement for retrieving multidimensional information using metadata in the cube model metadata object and the one or more measure metadata objects, wherein each of the measure metadata objects specifies one or more aggregations;
separating symmetric measures and asymmetric measures defined in the one or more measure metadata objects;
generating structured query language statements for the asymmetric measures; and combining the structured query language statements for the symmetric and asymmetric measures into a single structured query language statement.
2. The method of claim 2 wherein the combining comprises use of a join.
3. Apparatus for automatically generating a single structured query language statement specifying multidimensional calculations involving symmetric or asymmetric measures sets, wherein symmetric measures have a single aggregation operator and no specific aggregation order, and asymmetric measures have multiple aggregation operators, the apparatus comprising:
means for receiving selection of a subset of a cube model metadata object that is generated from a facts metadata object and one or more dimension metadata objects, wherein the facts metadata object references one or more measure metadata objects;
means for generating a statement for retrieving multidimensional information using metadata in the cube model metadata object and the one or more measure metadata objects, wherein each of the measure metadata objects specifies one or more aggregations;
means for separating symmetric measures and asymmetric measures defined in the one or more measure metadata objects;
means for generating structured query language statements for the symmetric measures;
means for generating structured query language statements for the asymmetric measures; and means for combining the structured query language statements for the symmetric and asymmetric measures into a single structured query language statement.
4. A computer program comprising computer program code for when loaded into a computer system and executed thereon, cause the computer system to perform all the steps of a method as claimed in any of claims 1 or 2.
CA2510747A 2003-01-13 2003-12-17 Specifying multidimensional calculations for a relational olap engine Expired - Lifetime CA2510747C (en)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
US10/341,763 2003-01-13
US10/341,763 US7953694B2 (en) 2003-01-13 2003-01-13 Method, system, and program for specifying multidimensional calculations for a relational OLAP engine
PCT/GB2003/005490 WO2004063942A1 (en) 2003-01-13 2003-12-17 Specifying multidimensional calculations for a relational olap engine

Publications (2)

Publication Number Publication Date
CA2510747A1 true CA2510747A1 (en) 2004-07-29
CA2510747C CA2510747C (en) 2011-12-13

Family

ID=32711577

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2510747A Expired - Lifetime CA2510747C (en) 2003-01-13 2003-12-17 Specifying multidimensional calculations for a relational olap engine

Country Status (6)

Country Link
US (1) US7953694B2 (en)
JP (1) JP2006513474A (en)
CN (1) CN100424686C (en)
AU (1) AU2003288564A1 (en)
CA (1) CA2510747C (en)
WO (1) WO2004063942A1 (en)

Families Citing this family (140)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7447687B2 (en) * 2002-05-10 2008-11-04 International Business Machines Corporation Methods to browse database query information
US7181450B2 (en) * 2002-12-18 2007-02-20 International Business Machines Corporation Method, system, and program for use of metadata to create multidimensional cubes in a relational database
US7716167B2 (en) 2002-12-18 2010-05-11 International Business Machines Corporation System and method for automatically building an OLAP model in a relational database
CA2419502A1 (en) * 2003-02-21 2004-08-21 Cognos Incorporated Time-based partitioned cube
US7895191B2 (en) * 2003-04-09 2011-02-22 International Business Machines Corporation Improving performance of database queries
EP1644849A1 (en) * 2003-07-11 2006-04-12 Computer Associates Think, Inc. System and method for generating sql using templates
US8315972B2 (en) * 2003-09-26 2012-11-20 Microsoft Corporation Method for maintaining databases information about multiple instances of an activity generating, updating virtual OLAP cube based on modified star-schema
US8548170B2 (en) 2003-12-10 2013-10-01 Mcafee, Inc. Document de-registration
US7756739B2 (en) * 2004-02-12 2010-07-13 Microsoft Corporation System and method for aggregating a measure over a non-additive account dimension
US20050216451A1 (en) * 2004-02-19 2005-09-29 Urs Enzler Generation of database queries from predefined query strings
US7707143B2 (en) * 2004-06-14 2010-04-27 International Business Machines Corporation Systems, methods, and computer program products that automatically discover metadata objects and generate multidimensional models
US20050283494A1 (en) * 2004-06-22 2005-12-22 International Business Machines Corporation Visualizing and manipulating multidimensional OLAP models graphically
US7480663B2 (en) * 2004-06-22 2009-01-20 International Business Machines Corporation Model based optimization with focus regions
US20060010058A1 (en) * 2004-07-09 2006-01-12 Microsoft Corporation Multidimensional database currency conversion systems and methods
US7490106B2 (en) * 2004-07-09 2009-02-10 Microsoft Corporation Multidimensional database subcubes
US20060020608A1 (en) * 2004-07-09 2006-01-26 Microsoft Corporation Cube update tool
US7694278B2 (en) * 2004-07-09 2010-04-06 Microsoft Corporation Data cube script development and debugging systems and methodologies
US7483918B2 (en) 2004-08-10 2009-01-27 Microsoft Corporation Dynamic physical database design
US20090300037A1 (en) * 2004-08-12 2009-12-03 Amdocs (Israel) Ltd. Enhanced database structure configuration
US7567962B2 (en) * 2004-08-13 2009-07-28 Microsoft Corporation Generating a labeled hierarchy of mutually disjoint categories from a set of query results
US7516149B2 (en) * 2004-08-30 2009-04-07 Microsoft Corporation Robust detector of fuzzy duplicates
US7505888B2 (en) * 2004-11-30 2009-03-17 International Business Machines Corporation Reporting model generation within a multidimensional enterprise software system
US7610300B2 (en) * 2004-11-30 2009-10-27 International Business Machines Corporation Automated relational schema generation within a multidimensional enterprise software system
US7418438B2 (en) * 2004-11-30 2008-08-26 International Business Machines Corporation Automated default dimension selection within a multidimensional enterprise software system
US7593955B2 (en) * 2004-11-30 2009-09-22 International Business Machines Corporation Generation of aggregatable dimension information within a multidimensional enterprise software system
US7444331B1 (en) * 2005-03-02 2008-10-28 Symantec Corporation Detecting code injection attacks against databases
US7584205B2 (en) * 2005-06-27 2009-09-01 Ab Initio Technology Llc Aggregating data with complex operations
US8099674B2 (en) 2005-09-09 2012-01-17 Tableau Software Llc Computer systems and methods for automatically viewing multidimensional databases
US7415454B2 (en) * 2005-11-18 2008-08-19 Microsoft Corporation Allocation performance by query optimization
US7765224B2 (en) * 2005-11-18 2010-07-27 Microsoft Corporation Using multi-dimensional expression (MDX) and relational methods for allocation
CN101093495B (en) * 2006-06-22 2011-08-17 国际商业机器公司 Data processing method and system based on network relation dimension
US7809735B2 (en) * 2006-10-11 2010-10-05 Yahoo! Inc. Infrastructure for more efficient processing to generate of ad-hoc reports
US8020144B2 (en) * 2007-06-29 2011-09-13 Microsoft Corporation Metadata-based application deployment
US7702622B2 (en) * 2007-06-29 2010-04-20 Microsoft Corporation Advanced techniques for SQL generation of performancepoint business rules
US8200604B2 (en) * 2007-06-29 2012-06-12 Microsoft Corporation Multi-platform business calculation rule language and execution environment
US9177079B1 (en) 2009-01-22 2015-11-03 Joviandata, Inc. Apparatus and method for processing multi-dimensional queries in a shared nothing system through tree reduction
US9477702B1 (en) * 2009-01-22 2016-10-25 Joviandata, Inc. Apparatus and method for accessing materialized and non-materialized values in a shared nothing system
US8041740B1 (en) 2008-03-04 2011-10-18 Amdocs Software Systems Limited Database system, method, and computer program product for recording entity state and type information for use during subsequent processing of data
US9692856B2 (en) * 2008-07-25 2017-06-27 Ca, Inc. System and method for filtering and alteration of digital data packets
US8401990B2 (en) * 2008-07-25 2013-03-19 Ca, Inc. System and method for aggregating raw data into a star schema
US20100030728A1 (en) * 2008-07-29 2010-02-04 Oracle International Corporation Computing selectivities for group of columns and expressions
US9253154B2 (en) 2008-08-12 2016-02-02 Mcafee, Inc. Configuration management for a capture/registration system
US8495007B2 (en) * 2008-08-28 2013-07-23 Red Hat, Inc. Systems and methods for hierarchical aggregation of multi-dimensional data sources
US8463739B2 (en) * 2008-08-28 2013-06-11 Red Hat, Inc. Systems and methods for generating multi-population statistical measures using middleware
US8214408B2 (en) * 2008-09-29 2012-07-03 Teradata Us, Inc. Method, database system and computer program for joining temporal database tables
CN102171648A (en) * 2008-10-07 2011-08-31 渣普控股有限公司 Synchronization of relational databases with OLAP cubes
US9020882B2 (en) 2008-11-26 2015-04-28 Red Hat, Inc. Database hosting middleware dimensional transforms
US8473442B1 (en) 2009-02-25 2013-06-25 Mcafee, Inc. System and method for intelligent state management
US8447722B1 (en) 2009-03-25 2013-05-21 Mcafee, Inc. System and method for data mining and security policy management
US9105006B2 (en) 2009-05-29 2015-08-11 Red Hat, Inc. Generating floating desktop representation of extracted model object
US8606827B2 (en) * 2009-05-29 2013-12-10 Red Hat, Inc. Systems and methods for extracting database dimensions as data modeling object
US8930487B2 (en) * 2009-05-29 2015-01-06 Red Hat, Inc. Object-based modeling using model objects exportable to external modeling tools
US8417739B2 (en) * 2009-05-29 2013-04-09 Red Hat, Inc. Systems and methods for object-based modeling using hierarchical model objects
US9009006B2 (en) 2009-05-29 2015-04-14 Red Hat, Inc. Generating active links between model objects
US9292592B2 (en) * 2009-05-29 2016-03-22 Red Hat, Inc. Object-based modeling using composite model object having independently updatable component objects
US9292485B2 (en) 2009-05-29 2016-03-22 Red Hat, Inc. Extracting data cell transformable to model object
US20100318537A1 (en) * 2009-06-12 2010-12-16 Microsoft Corporation Providing knowledge content to users
CA2708911C (en) 2009-07-09 2016-06-28 Accenture Global Services Gmbh Marketing model determination system
US9152944B2 (en) 2009-08-31 2015-10-06 Red Hat, Inc. Generating rapidly rotatable dimensional view of data objects
US20110054854A1 (en) * 2009-08-31 2011-03-03 Eric Williamson Systems and methods for generating dimensionally altered model objects
JP5175903B2 (en) * 2009-08-31 2013-04-03 アクセンチュア グローバル サービスィズ ゲーエムベーハー Adaptive analysis multidimensional processing system
CA2713039C (en) * 2009-08-31 2014-06-10 Accenture Global Services Gmbh Flexible cube data warehousing
US8365195B2 (en) * 2009-08-31 2013-01-29 Red Hat, Inc. Systems and methods for generating sets of model objects having data messaging pipes
US8417734B2 (en) * 2009-08-31 2013-04-09 Red Hat, Inc. Systems and methods for managing sets of model objects via unified management interface
US9152435B2 (en) * 2009-08-31 2015-10-06 Red Hat, Inc. Generating a set of linked rotational views of model objects
EP2483812A4 (en) * 2009-09-29 2016-10-05 Zap Holdings Ltd A content based approach to extending the form and function of a business intelligence system
US8447755B1 (en) * 2009-09-29 2013-05-21 Aquire Solutions, Inc. Systems and methods of analyzing changes and data between hierarchies
US8909678B2 (en) * 2009-09-30 2014-12-09 Red Hat, Inc. Conditioned distribution of data in a lattice-based database using spreading rules
US8984013B2 (en) * 2009-09-30 2015-03-17 Red Hat, Inc. Conditioning the distribution of data in a hierarchical database
US9031987B2 (en) * 2009-09-30 2015-05-12 Red Hat, Inc. Propagation of data changes in distribution operations in hierarchical database
US8996453B2 (en) * 2009-09-30 2015-03-31 Red Hat, Inc. Distribution of data in a lattice-based database via placeholder nodes
US20110078199A1 (en) * 2009-09-30 2011-03-31 Eric Williamson Systems and methods for the distribution of data in a hierarchical database via placeholder nodes
US8396880B2 (en) * 2009-11-30 2013-03-12 Red Hat, Inc. Systems and methods for generating an optimized output range for a data distribution in a hierarchical database
US8589344B2 (en) * 2009-11-30 2013-11-19 Red Hat, Inc. Systems and methods for generating iterated distributions of data in a hierarchical database
US9189535B2 (en) * 2009-12-01 2015-11-17 International Business Machines Corporation Compensating for unbalanced hierarchies when generating OLAP queries from report specifications
US9990416B2 (en) * 2009-12-02 2018-06-05 Business Objects Software Limited Analysis groups for semantic layer
US8315174B2 (en) * 2009-12-31 2012-11-20 Red Hat, Inc. Systems and methods for generating a push-up alert of fault conditions in the distribution of data in a hierarchical database
US8543535B2 (en) * 2010-02-24 2013-09-24 Oracle International Corporation Generation of star schemas from snowflake schemas containing a large number of dimensions
US8433673B2 (en) 2010-05-28 2013-04-30 Oracle International Corporation System and method for supporting data warehouse metadata extension using an extender
US9342793B2 (en) 2010-08-31 2016-05-17 Red Hat, Inc. Training a self-learning network using interpolated input sets based on a target output
US10353891B2 (en) 2010-08-31 2019-07-16 Red Hat, Inc. Interpolating conformal input sets based on a target output
US8806615B2 (en) 2010-11-04 2014-08-12 Mcafee, Inc. System and method for protecting specified data combinations
US9355383B2 (en) 2010-11-22 2016-05-31 Red Hat, Inc. Tracking differential changes in conformal data input sets
US10366464B2 (en) 2010-11-29 2019-07-30 Red Hat, Inc. Generating interpolated input data sets using reduced input source objects
US8346817B2 (en) 2010-11-29 2013-01-01 Red Hat, Inc. Systems and methods for embedding interpolated data object in application data file
US8364687B2 (en) 2010-11-29 2013-01-29 Red Hat, Inc. Systems and methods for binding multiple interpolated data objects
US8862638B2 (en) 2011-02-28 2014-10-14 Red Hat, Inc. Interpolation data template to normalize analytic runs
US8768942B2 (en) 2011-02-28 2014-07-01 Red Hat, Inc. Systems and methods for generating interpolated data sets converging to optimized results using iterative overlapping inputs
US9489439B2 (en) 2011-02-28 2016-11-08 Red Hat, Inc. Generating portable interpolated data using object-based encoding of interpolation results
US8290969B2 (en) 2011-02-28 2012-10-16 Red Hat, Inc. Systems and methods for validating interpolation results using monte carlo simulations on interpolated data inputs
US10102236B2 (en) * 2011-11-15 2018-10-16 Pvelocity Inc. Method and system for providing business intelligence data
US8666968B2 (en) * 2011-12-23 2014-03-04 Sap Ag Executing runtime callback functions
US9348874B2 (en) * 2011-12-23 2016-05-24 Sap Se Dynamic recreation of multidimensional analytical data
US9069373B2 (en) * 2011-12-23 2015-06-30 Sap Se Generating a runtime framework
US20130246431A1 (en) * 2011-12-27 2013-09-19 Mcafee, Inc. System and method for providing data protection workflows in a network environment
CN102663114B (en) * 2012-04-17 2013-09-11 中国人民大学 Database inquiry processing method facing concurrency OLAP (On Line Analytical Processing)
US10235441B1 (en) * 2012-06-29 2019-03-19 Open Text Corporation Methods and systems for multi-dimensional aggregation using composition
US10169442B1 (en) 2012-06-29 2019-01-01 Open Text Corporation Methods and systems for multi-dimensional aggregation using composition
US9892187B2 (en) 2012-09-14 2018-02-13 Hitachi, Ltd. Data analysis method, data analysis device, and storage medium storing processing program for same
US9633076B1 (en) 2012-10-15 2017-04-25 Tableau Software Inc. Blending and visualizing data from multiple data sources
CN103793422B (en) 2012-10-31 2017-05-17 国际商业机器公司 Methods for generating cube metadata and query statements on basis of enhanced star schema
US10860526B2 (en) * 2012-12-01 2020-12-08 The Regents Of The University Of California System and method of managing large data files
US9747313B2 (en) * 2012-12-19 2017-08-29 Sap Se Timeline index for managing temporal data
US9430453B1 (en) 2012-12-19 2016-08-30 Emc Corporation Multi-page document recognition in document capture
CN103164222A (en) * 2013-02-25 2013-06-19 用友软件股份有限公司 Multidimensional modeling system and multidimensional modeling method
US20140365519A1 (en) * 2013-06-10 2014-12-11 Targit A/S Intelligent processing of user input to a business intelligence software application
US10223401B2 (en) * 2013-08-15 2019-03-05 International Business Machines Corporation Incrementally retrieving data for objects to provide a desired level of detail
JP6045706B2 (en) * 2013-08-21 2016-12-14 株式会社日立製作所 Data processing system, data processing method, and data processing apparatus
US20150134676A1 (en) * 2013-11-11 2015-05-14 International Business Machines Corporation Amorphous data query formulation
CN104657370B (en) * 2013-11-19 2018-09-04 中国移动通信集团天津有限公司 A kind of associated method and apparatus of realization multi-dimension data cube
US9489386B2 (en) 2014-03-19 2016-11-08 International Business Machines Corporation Inferred operations for data analysis
US10255336B2 (en) 2015-05-07 2019-04-09 Datometry, Inc. Method and system for transparent interoperability between applications and data management systems
US10268745B2 (en) * 2015-05-29 2019-04-23 Oracle International Corporation Inherited dimensions
US11294924B1 (en) * 2015-07-16 2022-04-05 Tableau Software, Inc. Systems and methods for using multiple aggregation levels in a single data visualization
US10594779B2 (en) 2015-08-27 2020-03-17 Datometry, Inc. Method and system for workload management for data management systems
US10353879B2 (en) * 2015-11-18 2019-07-16 Sap Se Database catalog with metadata extensions
US10133778B2 (en) * 2015-11-20 2018-11-20 Sap Se Query optimization using join cardinality
US10289665B2 (en) * 2016-10-27 2019-05-14 Sap Portals Israel Ltd. Creating and consuming multi-dimensional representations
CN108572963A (en) * 2017-03-09 2018-09-25 北京京东尚科信息技术有限公司 Information acquisition method and device
US11086895B2 (en) 2017-05-09 2021-08-10 Oracle International Corporation System and method for providing a hybrid set-based extract, load, and transformation of data
US11048725B2 (en) * 2017-07-25 2021-06-29 Sap Se Methods and systems for unified data sources
US11620315B2 (en) 2017-10-09 2023-04-04 Tableau Software, Inc. Using an object model of heterogeneous data to facilitate building data visualizations
CN108304505B (en) * 2018-01-18 2020-09-11 上海达梦数据库有限公司 SQL statement processing method and device, server and storage medium
US11537276B2 (en) 2018-10-22 2022-12-27 Tableau Software, Inc. Generating data visualizations according to an object model of selected data sources
US10996835B1 (en) 2018-12-14 2021-05-04 Tableau Software, Inc. Data preparation user interface with coordinated pivots
US11436213B1 (en) 2018-12-19 2022-09-06 Datometry, Inc. Analysis of database query logs
US11294869B1 (en) 2018-12-19 2022-04-05 Datometry, Inc. Expressing complexity of migration to a database candidate
US11403282B1 (en) 2018-12-20 2022-08-02 Datometry, Inc. Unbatching database queries for migration to a different database
US10990612B2 (en) * 2018-12-28 2021-04-27 Microsoft Technology Licensing, Llc Metric-centric transformations of multidimensional database data
US11030256B2 (en) 2019-11-05 2021-06-08 Tableau Software, Inc. Methods and user interfaces for visually analyzing data visualizations with multi-row calculations
US10997217B1 (en) 2019-11-10 2021-05-04 Tableau Software, Inc. Systems and methods for visualizing object models of database tables
US11366858B2 (en) 2019-11-10 2022-06-21 Tableau Software, Inc. Data preparation using semantic roles
USD959447S1 (en) 2019-12-20 2022-08-02 Sap Se Display system or portion thereof with a virtual three-dimensional animated graphical user interface
US11205296B2 (en) * 2019-12-20 2021-12-21 Sap Se 3D data exploration using interactive cuboids
USD959477S1 (en) 2019-12-20 2022-08-02 Sap Se Display system or portion thereof with a virtual three-dimensional animated graphical user interface
USD959476S1 (en) 2019-12-20 2022-08-02 Sap Se Display system or portion thereof with a virtual three-dimensional animated graphical user interface
US11281668B1 (en) 2020-06-18 2022-03-22 Tableau Software, LLC Optimizing complex database queries using query fusion
US11461328B2 (en) 2020-09-21 2022-10-04 Oracle International Corporation Method for using a sematic model to transform SQL against a relational table to enable performance improvements
US11556533B2 (en) * 2020-11-12 2023-01-17 Oracle International Corporation Method for generating views based on a semantic model, that allows for autonomous performance improvements and complex calculations
US11537594B2 (en) 2021-02-05 2022-12-27 Oracle International Corporation Approximate estimation of number of distinct keys in a multiset using a sample

Family Cites Families (159)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6115547A (en) * 1993-03-29 2000-09-05 Trilogy Development Group, Inc. Flash configuration cache
US5594897A (en) * 1993-09-01 1997-01-14 Gwg Associates Method for retrieving high relevance, high quality objects from an overall source
AU6702594A (en) * 1993-12-17 1995-07-03 Taligent, Inc. Object-oriented distributed communications directory service
US5586311A (en) * 1994-02-14 1996-12-17 American Airlines, Inc. Object oriented data access and analysis system
US5692107A (en) * 1994-03-15 1997-11-25 Lockheed Missiles & Space Company, Inc. Method for generating predictive models in a computer system
US5537524A (en) * 1994-04-25 1996-07-16 Hypercubic Tunneling Industries, Inc. Process for converting two dimensional data into a multidimensional flow model
US5706494A (en) * 1995-02-10 1998-01-06 International Business Machines Corporation System and method for constraint checking bulk data in a database
US5926815A (en) * 1995-07-27 1999-07-20 James, Iii; J. Colin Binary sort access method and apparatus
US5832496A (en) * 1995-10-12 1998-11-03 Ncr Corporation System and method for performing intelligent analysis of a computer database
US5870746A (en) * 1995-10-12 1999-02-09 Ncr Corporation System and method for segmenting a database based upon data attributes
US5748188A (en) * 1995-10-12 1998-05-05 Ncr Corporation Hypertext markup language (HTML) extensions for graphical reporting over an internet
US5832475A (en) * 1996-03-29 1998-11-03 International Business Machines Corporation Database system and method employing data cube operator for group-by operations
US5767854A (en) * 1996-09-27 1998-06-16 Anwar; Mohammed S. Multidimensional data display and manipulation system and methods for using same
US6144962A (en) * 1996-10-15 2000-11-07 Mercury Interactive Corporation Visualization of web sites and hierarchical data structures
US5978788A (en) * 1997-04-14 1999-11-02 International Business Machines Corporation System and method for generating multi-representations of a data cube
JP4155363B2 (en) * 1997-06-19 2008-09-24 富士通株式会社 Data display device, data display method, and recording medium on which data display program is recorded
US5943668A (en) * 1997-06-30 1999-08-24 International Business Machines Corporation Relational emulation of a multi-dimensional database
US5926818A (en) * 1997-06-30 1999-07-20 International Business Machines Corporation Relational database implementation of a multi-dimensional database
US5905985A (en) * 1997-06-30 1999-05-18 International Business Machines Corporation Relational database modifications based on multi-dimensional database modifications
US6205447B1 (en) * 1997-06-30 2001-03-20 International Business Machines Corporation Relational database management of multi-dimensional data
US6292797B1 (en) * 1997-08-07 2001-09-18 New York University Method for determining actionable patterns in a database
US5960423A (en) * 1997-08-15 1999-09-28 Microsoft Corporation Database system index selection using candidate index selection for a workload
GB2330221B (en) * 1997-10-09 2002-07-03 Ibm Optimisation of relational database queries
US6539371B1 (en) * 1997-10-14 2003-03-25 International Business Machines Corporation System and method for filtering query statements according to user-defined filters of query explain data
US6023695A (en) 1997-10-31 2000-02-08 Oracle Corporation Summary table management in a computer system
US6092064A (en) * 1997-11-04 2000-07-18 International Business Machines Corporation On-line mining of quantitative association rules
US6134532A (en) * 1997-11-14 2000-10-17 Aptex Software, Inc. System and method for optimal adaptive matching of users to most relevant entity and information in real-time
US5918232A (en) * 1997-11-26 1999-06-29 Whitelight Systems, Inc. Multidimensional domain modeling method and system
US6628312B1 (en) * 1997-12-02 2003-09-30 Inxight Software, Inc. Interactive interface for visualizing and manipulating multi-dimensional data
US6362823B1 (en) * 1998-01-05 2002-03-26 N-Dimensional Visualization Intellectual structure for single-point visual representation of n-dimensional points using broken-line parallel coordinates
US6003036A (en) * 1998-02-12 1999-12-14 Martin; Michael W. Interval-partitioning method for multidimensional data
AU761900B2 (en) * 1998-03-27 2003-06-12 International Business Machines Corporation Processing precomputed views
US6385609B1 (en) * 1998-04-23 2002-05-07 Lucent Technologies Inc. System and method for analyzing and displaying telecommunications switch report output
US6324533B1 (en) * 1998-05-29 2001-11-27 International Business Machines Corporation Integrated database and data-mining system
US6289352B1 (en) 1998-05-29 2001-09-11 Crystal Decisions, Inc. Apparatus and method for compound on-line analytical processing in databases
US6327574B1 (en) * 1998-07-07 2001-12-04 Encirq Corporation Hierarchical models of consumer attributes for targeting content in a privacy-preserving manner
US6226647B1 (en) * 1998-07-24 2001-05-01 Oracle Corporation Method, article of manufacture, and apparatus for constructing a multi-dimensional view containing two-pass value measure results
US7162464B1 (en) 1998-10-02 2007-01-09 Ncr Corporation Data mining assists in a relational database management system
AU6412099A (en) * 1998-10-02 2000-04-26 Ncr Corporation Data mining assists in a relational database management system
US6317750B1 (en) * 1998-10-26 2001-11-13 Hyperion Solutions Corporation Method and apparatus for accessing multidimensional data
US6546381B1 (en) * 1998-11-02 2003-04-08 International Business Machines Corporation Query optimization system and method
US6449609B1 (en) 1998-12-28 2002-09-10 Oracle Corporation Using materialized view to process a related query containing a one to many lossless join
US5991754A (en) * 1998-12-28 1999-11-23 Oracle Corporation Rewriting a query in terms of a summary based on aggregate computability and canonical format, and when a dimension table is on the child side of an outer join
WO2000042530A1 (en) * 1999-01-15 2000-07-20 Metaedge Corporation Method for visualizing information in a data warehousing environment
US6574791B1 (en) * 1999-01-15 2003-06-03 International Business Machines Corporation Component based designer for modifying and specializing wizards
US6308168B1 (en) * 1999-02-09 2001-10-23 Knowledge Discovery One, Inc. Metadata-driven data presentation module for database system
US6567796B1 (en) * 1999-03-23 2003-05-20 Microstrategy, Incorporated System and method for management of an automatic OLAP report broadcast system
US8607138B2 (en) 1999-05-28 2013-12-10 Microstrategy, Incorporated System and method for OLAP report generation with spreadsheet report within the network user interface
US6711585B1 (en) 1999-06-15 2004-03-23 Kanisa Inc. System and method for implementing a knowledge management system
US6374234B1 (en) * 1999-06-22 2002-04-16 Microsoft Corporation Aggregations performance estimation in database systems
US6477536B1 (en) 1999-06-22 2002-11-05 Microsoft Corporation Virtual cubes
US6438537B1 (en) 1999-06-22 2002-08-20 Microsoft Corporation Usage based aggregation optimization
US6707454B1 (en) 1999-07-01 2004-03-16 Lucent Technologies Inc. Systems and methods for visualizing multi-dimensional data in spreadsheets and other data structures
US6665682B1 (en) 1999-07-19 2003-12-16 International Business Machines Corporation Performance of table insertion by using multiple tables or multiple threads
US6581054B1 (en) * 1999-07-30 2003-06-17 Computer Associates Think, Inc. Dynamic query model and method
US6842758B1 (en) 1999-07-30 2005-01-11 Computer Associates Think, Inc. Modular method and system for performing database queries
US6408292B1 (en) * 1999-08-04 2002-06-18 Hyperroll, Israel, Ltd. Method of and system for managing multi-dimensional databases using modular-arithmetic based address data mapping processes on integer-encoded business dimensions
US6385604B1 (en) 1999-08-04 2002-05-07 Hyperroll, Israel Limited Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements
US6546395B1 (en) * 1999-08-30 2003-04-08 International Business Machines Corporation Multi-dimensional restructure performance by selecting a technique to modify a relational database based on a type of restructure
US6542895B1 (en) * 1999-08-30 2003-04-01 International Business Machines Corporation Multi-dimensional restructure performance when adding or removing dimensions and dimensions members
US6636853B1 (en) * 1999-08-30 2003-10-21 Morphism, Llc Method and apparatus for representing and navigating search results
CA2281331A1 (en) 1999-09-03 2001-03-03 Cognos Incorporated Database management system
US6339776B2 (en) * 1999-10-04 2002-01-15 International Business Machines Corporation Dynamic semi-structured repository for mining software and software-related information
US6898603B1 (en) 1999-10-15 2005-05-24 Microsoft Corporation Multi-dimensional data structure caching
US6484179B1 (en) * 1999-10-25 2002-11-19 Oracle Corporation Storing multidimensional data in a relational database management system
FR2806183B1 (en) * 1999-12-01 2006-09-01 Cartesis S A DEVICE AND METHOD FOR INSTANT CONSOLIDATION, ENRICHMENT AND "REPORTING" OR BACKGROUND OF INFORMATION IN A MULTIDIMENSIONAL DATABASE
US6721727B2 (en) * 1999-12-02 2004-04-13 International Business Machines Corporation XML documents stored as column data
US6356900B1 (en) * 1999-12-30 2002-03-12 Decode Genetics Ehf Online modifications of relations in multidimensional processing
US6633885B1 (en) * 2000-01-04 2003-10-14 International Business Machines Corporation System and method for web-based querying
US6871140B1 (en) * 2000-02-25 2005-03-22 Costar Group, Inc. System and method for collection, distribution, and use of information in connection with commercial real estate
JP2001243242A (en) 2000-02-25 2001-09-07 Hitachi Ltd Inquiry processing method, database management system to execute the same and recording medium storing processing program
US20020029207A1 (en) 2000-02-28 2002-03-07 Hyperroll, Inc. Data aggregation server for managing a multi-dimensional database and database management system having data aggregation server integrated therein
JP2001243244A (en) 2000-02-28 2001-09-07 Hitachi Ltd Retrieving method of multi-dimensional database, retrieving device and computer readable recording medium storing multi-dimensional database retrieval program
CA2407974A1 (en) * 2000-03-16 2001-09-20 Poly Vista, Inc. A system and method for analyzing a query and generating results and related questions
US20010026276A1 (en) * 2000-03-17 2001-10-04 Kiyomi Sakamoto Map display device and navigation device
US6574619B1 (en) * 2000-03-24 2003-06-03 I2 Technologies Us, Inc. System and method for providing cross-dimensional computation and data access in an on-line analytical processing (OLAP) environment
US20020091681A1 (en) 2000-04-03 2002-07-11 Jean-Yves Cras Report then query capability for a multidimensional database model
US6768986B2 (en) * 2000-04-03 2004-07-27 Business Objects, S.A. Mapping of an RDBMS schema onto a multidimensional data model
US6831668B2 (en) 2000-04-03 2004-12-14 Business Objects, S.A. Analytical reporting on top of multidimensional data model
US6366903B1 (en) 2000-04-20 2002-04-02 Microsoft Corporation Index and materialized view selection for a given workload
US6615201B1 (en) * 2000-04-25 2003-09-02 Lucent Technologies Computer network management
WO2001081829A1 (en) * 2000-04-27 2001-11-01 Brio Technology, Inc. Method and apparatus for processing jobs on an enterprise-wide computer system
CA2306928C (en) * 2000-04-28 2004-05-25 Ibm Canada Limited-Ibm Canada Limitee Selectivity estimation for processing sql queries containing having clauses
US20010037228A1 (en) * 2000-05-05 2001-11-01 Iaf Consulting, Inc. System and method for using metadata to flexibly analyze data
JP3659318B2 (en) * 2000-05-09 2005-06-15 インターナショナル・ビジネス・マシーンズ・コーポレーション Spatial data mining equipment
US6995768B2 (en) * 2000-05-10 2006-02-07 Cognos Incorporated Interactive business data visualization system
JP2002007435A (en) 2000-06-20 2002-01-11 Nec Corp Interactive analysis data base system and recording medium recoded with interactive analysis program
US20020002469A1 (en) * 2000-06-21 2002-01-03 Scott Hillstrom System and method for hiring lawyers and managing the process entailed in the pursuit of clients' legal claims
US6633882B1 (en) * 2000-06-29 2003-10-14 Microsoft Corporation Multi-dimensional database record compression utilizing optimized cluster models
US6694322B2 (en) 2000-06-29 2004-02-17 Alphablox Corporation Caching scheme for multi-dimensional data
US6681223B1 (en) * 2000-07-27 2004-01-20 International Business Machines Corporation System and method of performing profile matching with a structured document
US6684207B1 (en) 2000-08-01 2004-01-27 Oracle International Corp. System and method for online analytical processing
US6604110B1 (en) 2000-08-31 2003-08-05 Ascential Software, Inc. Automated software code generation from a metadata-based repository
AU2001287044A1 (en) * 2000-09-05 2002-03-22 Big Think Llc System and method for personalization implemented on multiple networks and multiple interfaces
JP2002123530A (en) 2000-10-12 2002-04-26 Hitachi Ltd Method and device for visualizing multidimensional data
EP1346503A4 (en) * 2000-12-07 2006-05-31 Newsgrade Corp System and method for organizing, navigating and analyzing data
US6687693B2 (en) 2000-12-18 2004-02-03 Ncr Corporation Architecture for distributed relational data mining systems
US20020091679A1 (en) * 2001-01-09 2002-07-11 Wright James E. System for searching collections of linked objects
US6671689B2 (en) 2001-01-19 2003-12-30 Ncr Corporation Data warehouse portal
WO2002065249A2 (en) 2001-02-13 2002-08-22 Candera, Inc. Storage virtualization and storage management to provide higher level storage services
US6643646B2 (en) * 2001-03-01 2003-11-04 Hitachi, Ltd. Analysis of massive data accumulations using patient rule induction method and on-line analytical processing
US6651055B1 (en) 2001-03-01 2003-11-18 Lawson Software, Inc. OLAP query generation engine
US6741981B2 (en) * 2001-03-02 2004-05-25 The United States Of America As Represented By The Administrator Of The National Aeronautics And Space Administration (Nasa) System, method and apparatus for conducting a phrase search
US6721728B2 (en) * 2001-03-02 2004-04-13 The United States Of America As Represented By The Administrator Of The National Aeronautics And Space Administration System, method and apparatus for discovering phrases in a database
US6697793B2 (en) * 2001-03-02 2004-02-24 The United States Of America As Represented By The Administrator Of The National Aeronautics And Space Administration System, method and apparatus for generating phrases from a database
US6823333B2 (en) * 2001-03-02 2004-11-23 The United States Of America As Represented By The Administrator Of The National Aeronautics And Space Administration System, method and apparatus for conducting a keyterm search
CA2364645A1 (en) * 2001-03-07 2002-09-07 Spektor Leonid Query filter for querying a multitude of databases
US20020138316A1 (en) * 2001-03-23 2002-09-26 Katz Steven Bruce Value chain intelligence system and methods
US6931418B1 (en) 2001-03-26 2005-08-16 Steven M. Barnes Method and system for partial-order analysis of multi-dimensional data
US6711579B2 (en) 2001-04-20 2004-03-23 Sree Ayyanar Spinning And Weaving Mills Limited Data storage schema independent programming for data retrieval using semantic bridge
US6636860B2 (en) 2001-04-26 2003-10-21 International Business Machines Corporation Method and system for data mining automation in domain-specific analytic applications
US6850925B2 (en) * 2001-05-15 2005-02-01 Microsoft Corporation Query optimization by sub-plan memoization
US6775662B1 (en) * 2001-05-21 2004-08-10 Oracle International Corporation Group pruning from cube, rollup, and grouping sets
US7007039B2 (en) 2001-06-14 2006-02-28 Microsoft Corporation Method of building multidimensional workload-aware histograms
US7430562B1 (en) 2001-06-19 2008-09-30 Microstrategy, Incorporated System and method for efficient date retrieval and processing
US6697808B1 (en) 2001-06-19 2004-02-24 Microstrategy, Inc. Method and system for performing advanced object searching of a metadata repository used by a decision support system
GB2377046A (en) * 2001-06-29 2002-12-31 Ibm Metadata generation
US6968344B2 (en) * 2001-07-26 2005-11-22 Tata Consultancy Services Limited Method and apparatus for object-oriented access to a relational database management system (RDBMS) based on any arbitrary predicate
US6865573B1 (en) 2001-07-27 2005-03-08 Oracle International Corporation Data mining application programming interface
WO2003014977A1 (en) * 2001-08-10 2003-02-20 Datavine Research Services Method and apparatus for access, integration and analysis of heterogeneous data sources via the manipulation of metadata objects
KR100656528B1 (en) * 2001-09-10 2006-12-12 한국과학기술원 Dynamic Update Cube and Hybrid Queries Search Method for Range-Sum Queries
US20030115207A1 (en) * 2001-09-25 2003-06-19 Bowman David M. Hierarchical hybrid OLAP analytics generators
US7487111B2 (en) * 2001-10-19 2009-02-03 U-Haul International, Inc. Online marketplace for moving and relocation services
US20030081002A1 (en) * 2001-10-30 2003-05-01 Microsoft Corporation Method and system for chaining and extending wizards
US6654764B2 (en) * 2001-11-15 2003-11-25 International Business Machines Corporation Systems, methods, and computer program products to interpret, explain, and manipulate exceptions in multidimensional data
US6714940B2 (en) * 2001-11-15 2004-03-30 International Business Machines Corporation Systems, methods, and computer program products to rank and explain dimensions associated with exceptions in multidimensional data
US8140568B2 (en) * 2001-12-13 2012-03-20 International Business Machines Corporation Estimation and use of access plan statistics
US6823334B2 (en) 2002-03-07 2004-11-23 International Business Machines Corporation Metadata system for managing data mining environments
US7284204B2 (en) * 2002-03-29 2007-10-16 International Business Machines Corporation System, method, and visual user interface for evaluating and selecting suppliers for enterprise procurement
US7171427B2 (en) 2002-04-26 2007-01-30 Oracle International Corporation Methods of navigating a cube that is implemented as a relational object
US20030206201A1 (en) 2002-05-03 2003-11-06 Ly Eric Thichvi Method for graphical classification of unstructured data
US6957225B1 (en) 2002-05-07 2005-10-18 Oracle International Corporation Automatic discovery and use of column correlations in tables
US7149983B1 (en) 2002-05-08 2006-12-12 Microsoft Corporation User interface and method to facilitate hierarchical specification of queries using an information taxonomy
US7447687B2 (en) 2002-05-10 2008-11-04 International Business Machines Corporation Methods to browse database query information
US6947929B2 (en) 2002-05-10 2005-09-20 International Business Machines Corporation Systems, methods and computer program products to determine useful relationships and dimensions of a database
US7191169B1 (en) 2002-05-21 2007-03-13 Oracle International Corporation System and method for selection of materialized views
US7346601B2 (en) 2002-06-03 2008-03-18 Microsoft Corporation Efficient evaluation of queries with mining predicates
US7281013B2 (en) 2002-06-03 2007-10-09 Microsoft Corporation Workload analysis tool for relational databases
US7051038B1 (en) 2002-06-28 2006-05-23 Microsoft Corporation Method and system for a reporting information services architecture
US7610329B2 (en) 2002-07-30 2009-10-27 Storediq, Inc. Method and apparatus for managing file systems and file-based data storage
US6996556B2 (en) 2002-08-20 2006-02-07 International Business Machines Corporation Metadata manager for database query optimizer
US7668885B2 (en) * 2002-09-25 2010-02-23 MindAgent, LLC System for timely delivery of personalized aggregations of, including currently-generated, knowledge
US7716167B2 (en) 2002-12-18 2010-05-11 International Business Machines Corporation System and method for automatically building an OLAP model in a relational database
US7472127B2 (en) 2002-12-18 2008-12-30 International Business Machines Corporation Methods to identify related data in a multidimensional database
US7181450B2 (en) 2002-12-18 2007-02-20 International Business Machines Corporation Method, system, and program for use of metadata to create multidimensional cubes in a relational database
US7136850B2 (en) 2002-12-20 2006-11-14 International Business Machines Corporation Self tuning database retrieval optimization using regression functions
US7472109B2 (en) 2002-12-30 2008-12-30 International Business Machines Corporation Method for optimization of temporal and spatial data processing
US7203671B1 (en) 2003-02-11 2007-04-10 Federal Home Loan Mortgage Corporation System and method for validating the technical correctness of an OLAP reporting project
US8122044B2 (en) 2003-03-12 2012-02-21 Microsoft Corporation Generation of business intelligence entities from a dimensional model
US7275024B2 (en) 2003-03-12 2007-09-25 Microsoft Corporation Automatic generation of a dimensional model for business analytics from an object model for online transaction processing
US7895191B2 (en) 2003-04-09 2011-02-22 International Business Machines Corporation Improving performance of database queries
US7139764B2 (en) 2003-06-25 2006-11-21 Lee Shih-Jong J Dynamic learning and knowledge representation for data mining
US7610306B2 (en) 2003-06-30 2009-10-27 International Business Machines Corporation Multi-modal fusion in content-based retrieval
US7188090B2 (en) 2003-06-30 2007-03-06 Microsoft Corporation Drill-through queries from data mining model content
US7130863B2 (en) 2003-09-24 2006-10-31 Tablecode Software Corporation Method for enhancing object-oriented programming through extending metadata associated with class-body class-head by adding additional metadata to the database
US7246116B2 (en) 2004-04-22 2007-07-17 International Business Machines Corporation Method, system and article of manufacturing for converting data values quantified using a first measurement unit into equivalent data values when quantified using a second measurement unit in order to receive query results including data values measured using at least one of the first and second measurement units
US7707143B2 (en) 2004-06-14 2010-04-27 International Business Machines Corporation Systems, methods, and computer program products that automatically discover metadata objects and generate multidimensional models
US20050283494A1 (en) 2004-06-22 2005-12-22 International Business Machines Corporation Visualizing and manipulating multidimensional OLAP models graphically
US7480663B2 (en) 2004-06-22 2009-01-20 International Business Machines Corporation Model based optimization with focus regions

Also Published As

Publication number Publication date
CN100424686C (en) 2008-10-08
CN1726495A (en) 2006-01-25
WO2004063942A1 (en) 2004-07-29
JP2006513474A (en) 2006-04-20
CA2510747C (en) 2011-12-13
AU2003288564A1 (en) 2004-08-10
US7953694B2 (en) 2011-05-31
US20040139061A1 (en) 2004-07-15

Similar Documents

Publication Publication Date Title
CA2510747A1 (en) Specifying multidimensional calculations for a relational olap engine
WO2003069554A3 (en) Method and system for interactive ground-truthing of document images
DE60130475D1 (en) IMPLEMENTATION OF CALCULATIONS OF THE TABLE CALCULATION TYPE IN A DATABASE SYSTEM
US5598559A (en) Method and apparatus for optimizing queries having group-by operators
CA2484009A1 (en) Managing expressions in a database system
CA2534788A1 (en) Dml statements for densifying data in a relational database system
Cuzzocrea Retrieving accurate estimates to olap queries over uncertain and imprecise multidimensional data streams
MXPA05005536A (en) Combining multidimensional expressions and data mining extensions to mine olap cubes.
WO2005028627A3 (en) Performing sequence analysis as a relational join
WO2008063974A3 (en) Method and system for high performance integration, processing and searching of structured and unstructured data using coprocessors
CN104794221B (en) A kind of multi-Dimensional Data Analytical System based on business object
WO2003075176A3 (en) Support for multiple content-management data models
TW200508911A (en) Multidimensional data object searching using bit vector indices
AU3092099A (en) Perspective transformations on relational database tables
WO2003100666A3 (en) High-performance change capture for data warehousing
WO2010039898A3 (en) Efficient large-scale filtering and/or sorting for querying of column based data encoded structures
WO2007038229A3 (en) Non-indexed in-memory data storage and retrieval
EP1298543A3 (en) Providing a join plan using group-by operator
CN110399395B (en) Pre-calculation-based accelerated query method and storage medium
WO2005045569A3 (en) System and method for generating aggregated data views in a computer network
CN110750599B (en) Associated information extraction and display method based on entity modeling
WO2017062987A8 (en) Systems and methods for multi-dimensional computer-aided searching
CN104715076B (en) A kind of data processing of multithread and device
WO2021203918A8 (en) Method for processing model parameters, and apparatus
EP1492030A3 (en) System and method for online analytical processing using dimension attributes and multiple hierarchies per dimension

Legal Events

Date Code Title Description
EEER Examination request
MKEX Expiry

Effective date: 20231218