WO2006059243A3 - Aggregatable dimension information fn multidimensional enterprise software system - Google Patents

Aggregatable dimension information fn multidimensional enterprise software system Download PDF

Info

Publication number
WO2006059243A3
WO2006059243A3 PCT/IB2005/004112 IB2005004112W WO2006059243A3 WO 2006059243 A3 WO2006059243 A3 WO 2006059243A3 IB 2005004112 W IB2005004112 W IB 2005004112W WO 2006059243 A3 WO2006059243 A3 WO 2006059243A3
Authority
WO
WIPO (PCT)
Prior art keywords
data
aggregatable
dimension information
hierarchy
software system
Prior art date
Application number
PCT/IB2005/004112
Other languages
French (fr)
Other versions
WO2006059243A2 (en
Inventor
Thomas Legault
Dominique Roy
John Baker
Original Assignee
Cognos Inc
Thomas Legault
Dominique Roy
John Baker
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 Cognos Inc, Thomas Legault, Dominique Roy, John Baker filed Critical Cognos Inc
Priority to EP05850796A priority Critical patent/EP1854028A4/en
Priority to AU2005310977A priority patent/AU2005310977B2/en
Priority to CA002588363A priority patent/CA2588363A1/en
Priority to CN2005800469761A priority patent/CN101167048B/en
Publication of WO2006059243A2 publication Critical patent/WO2006059243A2/en
Publication of WO2006059243A3 publication Critical patent/WO2006059243A3/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • 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
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y10S707/99935—Query augmenting and refining, e.g. inexact access
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99943—Generating database or data structure, e.g. via user interface

Abstract

Techniques are described for generating dimension information in hierarchical form. A computer-implemented system, for example, includes a data store having multidimensional data. The multidimensional data includes a data cube having a dimension. The system further includes an executable software module that accesses the data store and generates hierarchy data describing a hierarchy of the dimension of the data cube. The software module generates the hierarchy data so that the hierarchy data is guaranteed to aggregate to totals represented within the data cube.
PCT/IB2005/004112 2004-11-30 2005-11-16 Aggregatable dimension information fn multidimensional enterprise software system WO2006059243A2 (en)

Priority Applications (4)

Application Number Priority Date Filing Date Title
EP05850796A EP1854028A4 (en) 2004-11-30 2005-11-16 Generation of aggregatable dimension information within a multidimensional enterprise software system
AU2005310977A AU2005310977B2 (en) 2004-11-30 2005-11-16 Aggregatable dimension information FN multidimensional enterprise software system
CA002588363A CA2588363A1 (en) 2004-11-30 2005-11-16 Generation of aggregatable dimension information within a multidimensional enterprise software system
CN2005800469761A CN101167048B (en) 2004-11-30 2005-11-16 Generation of aggregatable dimension information within a multidimensional enterprise software system

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US11/000,352 2004-11-30
US11/000,352 US7593955B2 (en) 2004-11-30 2004-11-30 Generation of aggregatable dimension information within a multidimensional enterprise software system

Publications (2)

Publication Number Publication Date
WO2006059243A2 WO2006059243A2 (en) 2006-06-08
WO2006059243A3 true WO2006059243A3 (en) 2007-11-22

Family

ID=36565413

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/IB2005/004112 WO2006059243A2 (en) 2004-11-30 2005-11-16 Aggregatable dimension information fn multidimensional enterprise software system

Country Status (6)

Country Link
US (1) US7593955B2 (en)
EP (1) EP1854028A4 (en)
CN (1) CN101167048B (en)
AU (1) AU2005310977B2 (en)
CA (1) CA2588363A1 (en)
WO (1) WO2006059243A2 (en)

Families Citing this family (35)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7529728B2 (en) 2003-09-23 2009-05-05 Salesforce.Com, Inc. Query optimization in a multi-tenant database system
US8543566B2 (en) 2003-09-23 2013-09-24 Salesforce.Com, Inc. System and methods of improving a multi-tenant database query using contextual knowledge about non-homogeneously distributed tenant data
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
US20080016023A1 (en) * 2006-07-17 2008-01-17 The Mathworks, Inc. Storing and loading data in an array-based computing environment
US8095531B2 (en) 2006-10-03 2012-01-10 Salesforce.Com, Inc. Methods and systems for controlling access to custom objects in a database
US9715710B2 (en) * 2007-03-30 2017-07-25 International Business Machines Corporation Method and system for forecasting using an online analytical processing database
US20080294673A1 (en) * 2007-05-25 2008-11-27 Microsoft Corporation Data transfer and storage based on meta-data
US8463739B2 (en) * 2008-08-28 2013-06-11 Red Hat, Inc. Systems and methods for generating multi-population statistical measures using middleware
US8495007B2 (en) * 2008-08-28 2013-07-23 Red Hat, Inc. Systems and methods for hierarchical aggregation of multi-dimensional data sources
CA2713039C (en) * 2009-08-31 2014-06-10 Accenture Global Services Gmbh Flexible cube data warehousing
CN102207940B (en) * 2010-03-31 2014-11-05 国际商业机器公司 Method and system for checking data
US9218408B2 (en) * 2010-05-27 2015-12-22 Oracle International Corporation Method for automatically creating a data mart by aggregated data extracted from a business intelligence server
US9430550B2 (en) 2012-09-28 2016-08-30 Oracle International Corporation Clustering a table in a relational database management system
US9514187B2 (en) 2012-09-28 2016-12-06 Oracle International Corporation Techniques for using zone map information for post index access pruning
US8996544B2 (en) 2012-09-28 2015-03-31 Oracle International Corporation Pruning disk blocks of a clustered table in a relational database management system
US9519701B2 (en) * 2012-12-26 2016-12-13 Sap Se Generating information models in an in-memory database system
CN103942197B (en) * 2013-01-17 2018-06-26 阿里巴巴集团控股有限公司 Data monitoring processing method and equipment
US10642837B2 (en) 2013-03-15 2020-05-05 Oracle International Corporation Relocating derived cache during data rebalance to maintain application performance
US10235649B1 (en) * 2014-03-14 2019-03-19 Walmart Apollo, Llc Customer analytics data model
WO2014193470A1 (en) * 2013-05-28 2014-12-04 Dynasim Technical Services, Inc. Method of managing relational data in a single matrix representation
CN104657370B (en) * 2013-11-19 2018-09-04 中国移动通信集团天津有限公司 A kind of associated method and apparatus of realization multi-dimension data cube
US10565538B1 (en) 2014-03-14 2020-02-18 Walmart Apollo, Llc Customer attribute exemption
US10733555B1 (en) 2014-03-14 2020-08-04 Walmart Apollo, Llc Workflow coordinator
US10235687B1 (en) 2014-03-14 2019-03-19 Walmart Apollo, Llc Shortest distance to store
US10346769B1 (en) 2014-03-14 2019-07-09 Walmart Apollo, Llc System and method for dynamic attribute table
US10430438B2 (en) * 2014-06-20 2019-10-01 Amazon Technologies, Inc. Dynamic n-dimensional cubes for hosted analytics
CN105488043B (en) * 2014-09-15 2019-03-26 南京理工大学 Data query method and system based on Key-Value data block
CN105404634B (en) * 2014-09-15 2019-02-22 南京理工大学 Data managing method and system based on Key-Value data block
WO2017070533A1 (en) 2015-10-23 2017-04-27 Oracle International Corporation System and method for automatic inference of a cube schema from a tabular data for use in a multidimensional database environment
US10733155B2 (en) 2015-10-23 2020-08-04 Oracle International Corporation System and method for extracting a star schema from tabular data for use in a multidimensional database environment
CN105335514B (en) * 2015-10-30 2018-09-18 北京奇虎科技有限公司 It is a kind of game forum in user data treating method and apparatus
EP3296936A1 (en) * 2016-09-20 2018-03-21 Tata Consultancy Services Limited Method and system for providing consultative analytics in a multi-tenant software environment
US11042569B2 (en) * 2017-09-29 2021-06-22 Oracle International Corporation System and method for load, aggregate and batch calculation in one scan in a multidimensional database environment
US11086876B2 (en) 2017-09-29 2021-08-10 Oracle International Corporation Storing derived summaries on persistent memory of a storage device

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6510420B1 (en) * 1999-09-30 2003-01-21 International Business Machines Corporation Framework for dynamic hierarchical grouping and calculation based on multidimensional member characteristics
US20040059724A1 (en) * 1999-10-15 2004-03-25 Cristian Petculescu Extensions for adding and removing calculated members in a multidimensional database
US20040181519A1 (en) * 2002-07-09 2004-09-16 Mohammed Shahbaz Anwar Method for generating multidimensional summary reports from multidimensional summary reports from multidimensional data
US20040236738A1 (en) * 2002-09-30 2004-11-25 Adaytum, Inc. Real-time aggregation of data within an enterprise planning environment

Family Cites Families (48)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5379419A (en) * 1990-12-07 1995-01-03 Digital Equipment Corporation Methods and apparatus for accesssing non-relational data files using relational queries
US5734887A (en) * 1995-09-29 1998-03-31 International Business Machines Corporation Method and apparatus for logical data access to a physical relational database
US5692181A (en) * 1995-10-12 1997-11-25 Ncr Corporation System and method for generating reports from a computer database
US5870746A (en) * 1995-10-12 1999-02-09 Ncr Corporation System and method for segmenting a database based upon data attributes
JP3952518B2 (en) * 1996-03-29 2007-08-01 株式会社日立製作所 Multidimensional data processing method
US5721910A (en) 1996-06-04 1998-02-24 Exxon Research And Engineering Company Relational database system containing a multidimensional hierachical model of interrelated subject categories with recognition capabilities
US5978788A (en) * 1997-04-14 1999-11-02 International Business Machines Corporation System and method for generating multi-representations of a data cube
US6205447B1 (en) * 1997-06-30 2001-03-20 International Business Machines Corporation Relational database management of multi-dimensional data
US5978796A (en) * 1997-06-30 1999-11-02 International Business Machines Corporation Accessing multi-dimensional data by mapping dense data blocks to rows in a relational database
US6134541A (en) * 1997-10-31 2000-10-17 International Business Machines Corporation Searching multidimensional indexes using associated clustering and dimension reduction information
US5918232A (en) * 1997-11-26 1999-06-29 Whitelight Systems, Inc. Multidimensional domain modeling method and system
WO2000019340A1 (en) * 1998-09-30 2000-04-06 I2 Technologies, Inc. Multi-dimensional data management system
US6282544B1 (en) * 1999-05-24 2001-08-28 Computer Associates Think, Inc. Method and apparatus for populating multiple data marts in a single aggregation process
US6477536B1 (en) * 1999-06-22 2002-11-05 Microsoft Corporation Virtual cubes
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
CA2281331A1 (en) * 1999-09-03 2001-03-03 Cognos Incorporated Database management system
GB9924523D0 (en) * 1999-10-15 1999-12-15 Univ Strathclyde Database processor
US6484179B1 (en) * 1999-10-25 2002-11-19 Oracle Corporation Storing multidimensional data in a relational database management system
US6418427B1 (en) * 1999-12-30 2002-07-09 Decode Genetics Ehf Online modifications of dimension structures in multidimensional processing
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
US6768986B2 (en) * 2000-04-03 2004-07-27 Business Objects, S.A. Mapping of an RDBMS schema onto a multidimensional data model
US6594672B1 (en) * 2000-06-01 2003-07-15 Hyperion Solutions Corporation Generating multidimensional output using meta-models and meta-outlines
CA2311884A1 (en) * 2000-06-16 2001-12-16 Cognos Incorporated Method of managing slowly changing dimensions
US7788212B2 (en) * 2000-09-05 2010-08-31 Big Think Llc System and method for personalization implemented on multiple networks and multiple interfaces
US6801921B2 (en) * 2000-09-08 2004-10-05 Hitachi, Ltd. Method and system for managing multiple database storage units
US6829621B2 (en) * 2000-10-06 2004-12-07 International Business Machines Corporation Automatic determination of OLAP cube dimensions
US7287218B1 (en) * 2000-10-25 2007-10-23 Bea Systems, Inc. Dynamic publication of information from a database
US7039871B2 (en) * 2000-10-27 2006-05-02 Swiftknowledge, Inc. Secure data access in a multidimensional data environment
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
US7028046B2 (en) * 2002-03-19 2006-04-11 Hyperion Solutions Corporation Method of splitting a multi-dimensional cube between a multi-dimensional and a relational database
US6691102B2 (en) * 2002-03-26 2004-02-10 International Business Machines Corporation Query processing method of name-value pairs in relational databases
US8868544B2 (en) * 2002-04-26 2014-10-21 Oracle International Corporation Using relational structures to create and support a cube within a relational database system
US7171427B2 (en) * 2002-04-26 2007-01-30 Oracle International Corporation Methods of navigating a cube that is implemented as a relational object
US6965903B1 (en) * 2002-05-07 2005-11-15 Oracle International Corporation Techniques for managing hierarchical data with link attributes in a relational database
JP2004094425A (en) * 2002-08-30 2004-03-25 Hitachi Ltd Database construction processing modification method
US7072822B2 (en) * 2002-09-30 2006-07-04 Cognos Incorporated Deploying multiple enterprise planning models across clusters of application servers
US7467125B2 (en) * 2002-12-12 2008-12-16 International Business Machines Corporation Methods to manage the display of data entities and relational database structures
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
US7953694B2 (en) * 2003-01-13 2011-05-31 International Business Machines Corporation Method, system, and program for specifying multidimensional calculations for a relational OLAP engine
US20040193633A1 (en) * 2003-03-28 2004-09-30 Cristian Petculescu Systems, methods, and apparatus for automated dimensional model definitions and builds utilizing simplified analysis heuristics
US7089266B2 (en) * 2003-06-02 2006-08-08 The Board Of Trustees Of The Leland Stanford Jr. University Computer systems and methods for the query and visualization of multidimensional databases
US7756907B2 (en) * 2003-09-16 2010-07-13 The Board Of Trustees Of The Leland Stanford Jr. University Computer systems and methods for visualizing data
JP4419519B2 (en) * 2003-10-31 2010-02-24 セイコーエプソン株式会社 Printer driver program
US7593969B2 (en) 2003-12-31 2009-09-22 Microsoft Corporation Linked dimension and measure groups
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
US7505888B2 (en) * 2004-11-30 2009-03-17 International Business Machines Corporation Reporting model generation within a multidimensional enterprise software system

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6510420B1 (en) * 1999-09-30 2003-01-21 International Business Machines Corporation Framework for dynamic hierarchical grouping and calculation based on multidimensional member characteristics
US20040059724A1 (en) * 1999-10-15 2004-03-25 Cristian Petculescu Extensions for adding and removing calculated members in a multidimensional database
US20040181519A1 (en) * 2002-07-09 2004-09-16 Mohammed Shahbaz Anwar Method for generating multidimensional summary reports from multidimensional summary reports from multidimensional data
US20040236738A1 (en) * 2002-09-30 2004-11-25 Adaytum, Inc. Real-time aggregation of data within an enterprise planning environment

Also Published As

Publication number Publication date
US7593955B2 (en) 2009-09-22
CA2588363A1 (en) 2006-06-08
AU2005310977B2 (en) 2009-11-12
EP1854028A4 (en) 2010-01-06
AU2005310977A1 (en) 2006-06-08
WO2006059243A2 (en) 2006-06-08
CN101167048B (en) 2011-01-19
EP1854028A2 (en) 2007-11-14
US20060116976A1 (en) 2006-06-01
CN101167048A (en) 2008-04-23

Similar Documents

Publication Publication Date Title
WO2006059243A3 (en) Aggregatable dimension information fn multidimensional enterprise software system
WO2005015378A3 (en) Generating end-user presentations from structured data
WO2005111780A3 (en) Property metadata navigation and assigment
WO2001093111A3 (en) Generating multidimensional output using meta-models and meta-outline
WO2005076780A3 (en) Methods apparatuses, systems, and articles for determining and implementing and efficient computer network architecture
WO2006089092A3 (en) Hierarchal data management
WO2007064887A3 (en) Methods and systems for optimizing text searches over structured data in a multi-tenant environment
WO2008009018A3 (en) Spreadsheet-based relational database interface
WO2004010319A3 (en) Dynamic object- driven database manipulation and mapping system
WO2005109212A3 (en) Hierarchical systems providing unified of storage information
WO2007014274A3 (en) Caching and modifying portions of a multi-dimensional database on a user device
JP2004280823A5 (en)
WO2006026636A3 (en) Metadata management
WO2003003243A3 (en) Geographic information system having dynamic data model
WO2005099381A3 (en) Expression and time-based data creation and creator-controlled organization
WO2008033415A3 (en) Dynamic accessible reporting tool (dart)
EP1698991A3 (en) Method and computer-readable medium for generating usage rights for an item based upon access rights
WO2002021327A3 (en) Method and computer program for generating files for a database system for a business management user program
TW200634848A (en) Method for generating latch clock and memory subsystem
WO2004097630A3 (en) Managing access to objects of a computing environment
WO2004077274A3 (en) Multi-tier business layer architecture for information systems
WO2002023333A3 (en) Construction of virtual objects based on run-time type information
WO2002021314A3 (en) Integrated design environment for a commerce server system
CA2317194A1 (en) Query engine and method for querying data using metadata model
WO2003058408A3 (en) Information security awareness system

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BW BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE EG ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KM KN KP KR KZ LC LK LR LS LT LU LV LY MA MD MG MK MN MW MX MZ NA NG NI NO NZ OM PG PH PL PT RO RU SC SD SE SG SK SL SM SY TJ TM TN TR TT TZ UA UG US UZ VC VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): GM KE LS MW MZ NA SD SL SZ TZ UG ZM ZW AM AZ BY KG KZ MD RU TJ TM AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HU IE IS IT LT LU LV MC NL PL PT RO SE SI SK TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG

WWE Wipo information: entry into national phase

Ref document number: 2005850796

Country of ref document: EP

WWE Wipo information: entry into national phase

Ref document number: 2588363

Country of ref document: CA

WWE Wipo information: entry into national phase

Ref document number: 2005310977

Country of ref document: AU

NENP Non-entry into the national phase

Ref country code: DE

ENP Entry into the national phase

Ref document number: 2005310977

Country of ref document: AU

Date of ref document: 20051116

Kind code of ref document: A

WWP Wipo information: published in national office

Ref document number: 2005310977

Country of ref document: AU

WWE Wipo information: entry into national phase

Ref document number: 200580046976.1

Country of ref document: CN

WWP Wipo information: published in national office

Ref document number: 2005850796

Country of ref document: EP