DE60004385D1 - Verfahren und systeme um olap hierarchien zusammenfassbar zu machen - Google Patents

Verfahren und systeme um olap hierarchien zusammenfassbar zu machen

Info

Publication number
DE60004385D1
DE60004385D1 DE60004385T DE60004385T DE60004385D1 DE 60004385 D1 DE60004385 D1 DE 60004385D1 DE 60004385 T DE60004385 T DE 60004385T DE 60004385 T DE60004385 T DE 60004385T DE 60004385 D1 DE60004385 D1 DE 60004385D1
Authority
DE
Germany
Prior art keywords
aggregation
hierarchies
aggregates
dimension
olap
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.)
Expired - Fee Related
Application number
DE60004385T
Other languages
English (en)
Other versions
DE60004385T2 (de
Inventor
Torben Bach Pedersen
Christian S Jensen
Curtis E S Dyreson
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.)
Individual
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 DE60004385D1 publication Critical patent/DE60004385D1/de
Application granted granted Critical
Publication of DE60004385T2 publication Critical patent/DE60004385T2/de
Anticipated expiration legal-status Critical
Expired - Fee Related 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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24539—Query rewriting; Transformation using cached or materialised query results
    • 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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24553—Query execution of query operations
    • G06F16/24554—Unary operations; Data partitioning operations
    • G06F16/24556—Aggregation; Duplicate elimination
    • 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
    • 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
    • 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/99934—Query formulation, input preparation, or translation

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Lubricants (AREA)
  • Paper (AREA)
  • Hardware Redundancy (AREA)
DE60004385T 1999-07-21 2000-06-30 Verfahren und systeme um olap hierarchien zusammenfassbar zu machen Expired - Fee Related DE60004385T2 (de)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
DKPA199901045 1999-07-21
DK104599 1999-07-21
PCT/DK2000/000354 WO2001008041A1 (en) 1999-07-21 2000-06-30 Method and systems for making olap hierarchies summarisable

Publications (2)

Publication Number Publication Date
DE60004385D1 true DE60004385D1 (de) 2003-09-11
DE60004385T2 DE60004385T2 (de) 2004-06-24

Family

ID=8100367

Family Applications (1)

Application Number Title Priority Date Filing Date
DE60004385T Expired - Fee Related DE60004385T2 (de) 1999-07-21 2000-06-30 Verfahren und systeme um olap hierarchien zusammenfassbar zu machen

Country Status (6)

Country Link
US (1) US7133865B1 (de)
EP (1) EP1222569B1 (de)
AT (1) ATE246824T1 (de)
AU (1) AU5522800A (de)
DE (1) DE60004385T2 (de)
WO (1) WO2001008041A1 (de)

Families Citing this family (46)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6700590B1 (en) * 1999-11-01 2004-03-02 Indx Software Corporation System and method for retrieving and presenting data using class-based component and view model
US6842904B1 (en) * 2000-11-21 2005-01-11 Microsoft Corporation Extensible architecture for versioning APIs
CA2429910A1 (en) * 2003-05-27 2004-11-27 Cognos Incorporated System and method of query transformation
US20050027690A1 (en) * 2003-07-29 2005-02-03 International Business Machines Corporation Dynamic selection of optimal grouping sequence at runtime for grouping sets, rollup and cube operations in SQL query processing
US7698292B2 (en) * 2003-12-03 2010-04-13 Siemens Aktiengesellschaft Tag management within a decision, support, and reporting environment
US7949639B2 (en) * 2004-02-20 2011-05-24 Symphonyiri Group, Inc. Attribute segments and data table bias reduction
US10325272B2 (en) * 2004-02-20 2019-06-18 Information Resources, Inc. Bias reduction using data fusion of household panel data and transaction data
US7840607B2 (en) * 2004-08-06 2010-11-23 Siemens Aktiengesellschaft Data mart generation and use in association with an operations intelligence platform
US8700671B2 (en) 2004-08-18 2014-04-15 Siemens Aktiengesellschaft System and methods for dynamic generation of point / tag configurations
US7814123B2 (en) * 2004-12-02 2010-10-12 Siemens Aktiengesellschaft Management of component members using tag attributes
US8442938B2 (en) 2005-01-14 2013-05-14 Siemens Aktiengesellschaft Child data structure update in data management system
US20060218116A1 (en) * 2005-03-28 2006-09-28 O'hearn James E Pass-through interface queries to populate a class-based model
US7587388B2 (en) * 2005-07-28 2009-09-08 Microsoft Corporation Separating uploads into aggregate and raw data storage
US7529726B2 (en) * 2005-08-22 2009-05-05 International Business Machines Corporation XML sub-document versioning method in XML databases using record storages
US8543614B2 (en) * 2005-08-22 2013-09-24 International Business Machines Corporation Packing nodes into records to store XML XQuery data model and other hierarchically structured data
US8572125B2 (en) * 2005-08-22 2013-10-29 International Business Machines Corporation Scalable storage schemes for native XML column data of relational tables
US7698257B2 (en) * 2006-05-16 2010-04-13 Business Objects Software Ltd. Apparatus and method for recursively rationalizing data source queries
CN101093495B (zh) * 2006-06-22 2011-08-17 国际商业机器公司 基于网状关系维的数据处理方法和系统
US8204914B2 (en) * 2006-12-05 2012-06-19 Sap Ag Method and system to process multi-dimensional data
US9262503B2 (en) 2007-01-26 2016-02-16 Information Resources, Inc. Similarity matching of products based on multiple classification schemes
WO2008092147A2 (en) * 2007-01-26 2008-07-31 Information Resources, Inc. Analytic platform
US8160984B2 (en) 2007-01-26 2012-04-17 Symphonyiri Group, Inc. Similarity matching of a competitor's products
US20090006309A1 (en) 2007-01-26 2009-01-01 Herbert Dennis Hunt Cluster processing of an aggregated dataset
US8504598B2 (en) * 2007-01-26 2013-08-06 Information Resources, Inc. Data perturbation of non-unique values
US20080294996A1 (en) * 2007-01-31 2008-11-27 Herbert Dennis Hunt Customized retailer portal within an analytic platform
US8260783B2 (en) 2007-02-27 2012-09-04 Siemens Aktiengesellschaft Storage of multiple, related time-series data streams
US20080222189A1 (en) * 2007-03-06 2008-09-11 Microsoft Corporation Associating multidimensional data models
US9715710B2 (en) * 2007-03-30 2017-07-25 International Business Machines Corporation Method and system for forecasting using an online analytical processing database
US10255583B2 (en) * 2007-05-01 2019-04-09 Oracle International Corporation Nested hierarchical rollups by level using a normalized table
US7917462B1 (en) * 2007-11-09 2011-03-29 Teradata Us, Inc. Materializing subsets of a multi-dimensional table
US20090248715A1 (en) * 2008-03-31 2009-10-01 Microsoft Corporation Optimizing hierarchical attributes for olap navigation
US20090271327A1 (en) * 2008-04-23 2009-10-29 Raghav Lal Payment portfolio optimization
US20090299955A1 (en) * 2008-05-29 2009-12-03 Microsoft Corporation Model Based Data Warehousing and Analytics
US9110970B2 (en) * 2008-07-25 2015-08-18 International Business Machines Corporation Destructuring and restructuring relational data
US8972463B2 (en) * 2008-07-25 2015-03-03 International Business Machines Corporation Method and apparatus for functional integration of metadata
US8943087B2 (en) * 2008-07-25 2015-01-27 International Business Machines Corporation Processing data from diverse databases
US7916295B2 (en) * 2008-09-03 2011-03-29 Macronix International Co., Ltd. Alignment mark and method of getting position reference for wafer
US8504513B2 (en) 2009-11-25 2013-08-06 Microsoft Corporation Auto-generation of code for performing a transform in an extract, transform, and load process
US8375056B2 (en) * 2010-02-26 2013-02-12 International Business Machines Corporation Optimizing data cache when applying user-based security
US9223847B2 (en) * 2012-03-07 2015-12-29 Microsoft Technology Licensing, Llc Using dimension substitutions in OLAP cubes
US10223421B2 (en) * 2015-12-30 2019-03-05 Sap Se Virtual Aggregation
CN106095859B (zh) * 2016-06-02 2020-04-07 成都淞幸科技有限责任公司 基于olam的多维度中医针灸关联规则挖掘方法
US11036735B2 (en) * 2018-01-16 2021-06-15 Oracle International Corporation Dimension context propagation techniques for optimizing SQL query plans
US11036479B2 (en) * 2018-08-27 2021-06-15 Georgia Tech Research Corporation Devices, systems, and methods of program identification, isolation, and profile attachment
US20220147503A1 (en) * 2020-08-11 2022-05-12 Massachusetts Mutual Life Insurance Company Systems and methods to generate a database structure with a low-latency key architecture
US11954085B1 (en) 2022-09-22 2024-04-09 International Business Machines Corporation Hierarchical data skipping using data sketches

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5918232A (en) * 1997-11-26 1999-06-29 Whitelight Systems, Inc. Multidimensional domain modeling method and system
CA2326513C (en) * 1998-03-27 2009-06-16 Informix Software, Inc. Processing precomputed views
US20020099691A1 (en) * 1998-06-24 2002-07-25 Michael Dean Lore Method and apparatus for aggregation of data in a database management system
US6535872B1 (en) * 1999-04-08 2003-03-18 International Business Machines Corporation Method and apparatus for dynamically representing aggregated and segmented data views using view element sets
US6665682B1 (en) * 1999-07-19 2003-12-16 International Business Machines Corporation Performance of table insertion by using multiple tables or multiple threads

Also Published As

Publication number Publication date
WO2001008041A1 (en) 2001-02-01
AU5522800A (en) 2001-02-13
ATE246824T1 (de) 2003-08-15
EP1222569A1 (de) 2002-07-17
US7133865B1 (en) 2006-11-07
EP1222569B1 (de) 2003-08-06
DE60004385T2 (de) 2004-06-24

Similar Documents

Publication Publication Date Title
DE60004385D1 (de) Verfahren und systeme um olap hierarchien zusammenfassbar zu machen
WO2000051027A3 (en) System and method for enhanced performance of a relational database management system
WO2001009754A3 (en) Modular method and system for performing database queries
WO2001067379A3 (en) Registry emulation
ATE373272T1 (de) Durchführung von kalkulationen des tabellenkalkulationstyps in einem datenbanksystem
WO2004104764A3 (en) Graphics model referencing method and apparatus
EP1160694A3 (de) Vefahren und System zum Erstellen einer Datenbank von Schlüsselwörtern als Referenz zu physischen Orten
EP1267258A3 (de) Herstellung von Prädikaten in einem Mehrfachdatenpfadprozessor
CA2377581A1 (en) Relation path viability prediction
ES2140241T3 (es) Procedimiento para la sincronizacion de programas en diferentes ordenadores de un sistema integrado.
WO2004104890A8 (en) System and method for project tracking and reporting
Wilcox Object databases
Cronje Optimization model for isolated signalized traffic intersections
WO2002029518A3 (en) Construction information and management system
Sanders Driver performance in countermeasure development at railroad-highway grade crossings
Dowling Use of default parameters for estimating signalized intersection level of service
EP0789306A3 (de) Dateneingangs-/-ausgangsvorrichtung durch Referenzierung zwischen mehreren zentralen Verarbeitungseinheiten
WO2004079475A3 (en) A method and a computer system for data assignment
Dean Highway guide signs: a framework for design and evaluation
RESNIK Access to multiple underlying systems in Janus(Interim Technical Report)
WO2002082196A3 (de) Verfahren, datenbanksystem sowie computerprogrammprodukt zur projektierung einer technischen anlage
WO1999009489A3 (de) Verfahren und anordnung zur durchführung von überwachungs- und managementfunktionen
Cottini Strategies and Patterns for Softboard-Based System Database Modeling
Perrizo et al. KB-HYDRO: a heterogeneous distributed system integrating data and knowledge bases
Billheimer et al. Review and assessment of paratransit models

Legal Events

Date Code Title Description
8364 No opposition during term of opposition
8339 Ceased/non-payment of the annual fee