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

Verfahren und systeme um olap hierarchien zusammenfassbar zu machen

Info

Publication number
ATE246824T1
ATE246824T1 AT00940226T AT00940226T ATE246824T1 AT E246824 T1 ATE246824 T1 AT E246824T1 AT 00940226 T AT00940226 T AT 00940226T AT 00940226 T AT00940226 T AT 00940226T AT E246824 T1 ATE246824 T1 AT E246824T1
Authority
AT
Austria
Prior art keywords
aggregation
hierarchies
aggregates
olap
dimension
Prior art date
Application number
AT00940226T
Other languages
English (en)
Inventor
Torben Bach Pedersen
Christian S Jensen
Curtis E S Dyreson
Original Assignee
Torben Bach Pedersen
Christian S Jensen
Curtis E S Dyreson
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 Torben Bach Pedersen, Christian S Jensen, Curtis E S Dyreson filed Critical Torben Bach Pedersen
Application granted granted Critical
Publication of ATE246824T1 publication Critical patent/ATE246824T1/de

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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 OR CALCULATING; 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 OR CALCULATING; 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)
  • Hardware Redundancy (AREA)
  • Lubricants (AREA)
  • Paper (AREA)
AT00940226T 1999-07-21 2000-06-30 Verfahren und systeme um olap hierarchien zusammenfassbar zu machen ATE246824T1 (de)

Applications Claiming Priority (2)

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

Publications (1)

Publication Number Publication Date
ATE246824T1 true ATE246824T1 (de) 2003-08-15

Family

ID=8100367

Family Applications (1)

Application Number Title Priority Date Filing Date
AT00940226T ATE246824T1 (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
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
US7529726B2 (en) * 2005-08-22 2009-05-05 International Business Machines Corporation XML sub-document versioning method in XML databases using record storages
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
EP2111593A2 (de) * 2007-01-26 2009-10-28 Information Resources, Inc. Analyseplattform
US20090006309A1 (en) 2007-01-26 2009-01-01 Herbert Dennis Hunt Cluster processing of an aggregated dataset
US8160984B2 (en) 2007-01-26 2012-04-17 Symphonyiri Group, Inc. Similarity matching of a competitor's products
US9262503B2 (en) 2007-01-26 2016-02-16 Information Resources, Inc. Similarity matching of products based on multiple classification schemes
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
EP1222569A1 (de) 2002-07-17
DE60004385D1 (de) 2003-09-11
WO2001008041A1 (en) 2001-02-01
DE60004385T2 (de) 2004-06-24
AU5522800A (en) 2001-02-13
US7133865B1 (en) 2006-11-07
EP1222569B1 (de) 2003-08-06

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
WO2001067379A3 (en) Registry emulation
WO2001009754A3 (en) Modular method and system for performing database queries
ATE373272T1 (de) Durchführung von kalkulationen des tabellenkalkulationstyps in einem datenbanksystem
EP0790562A3 (de) Dateneingangs/-ausgangsvorrichtung durch Referenzierung zwischen zentralen Verarbeitungseinheiten und Ein-/Ausgabevorrichtungen
EP1267258A3 (de) Herstellung von Prädikaten in einem Mehrfachdatenpfadprozessor
IL147283A0 (en) Relation path viability prediction
Wilcox Object databases
Lyrintzis et al. Development and comparative evaluation of high-order traffic flow models
Dowling Use of default parameters for estimating signalized intersection level of service
Sanders Driver performance in countermeasure development at railroad-highway grade crossings
EP0877328A3 (de) Datenbanksuchsystem und -verfahren
Virkler et al. Capacity for right turn on red
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)
Cottini Strategies and Patterns for Softboard-Based System Database Modeling
WO1999009489A3 (de) Verfahren und anordnung zur durchführung von überwachungs- und managementfunktionen
WO2002082196A3 (de) Verfahren, datenbanksystem sowie computerprogrammprodukt zur projektierung einer technischen anlage
ELAND Language-based access control mechanisms for shared databases[Ph. D. Thesis]
EP0398641A3 (de) Fernausführung von Datenbanktransaktionen
Billheimer et al. Review and assessment of paratransit models
Jenik Computerized mapping and record systems for utilities

Legal Events

Date Code Title Description
RER Ceased as to paragraph 5 lit. 3 law introducing patent treaties