CN1688998A - 用于联机分析处理的方法和系统 - Google Patents

用于联机分析处理的方法和系统 Download PDF

Info

Publication number
CN1688998A
CN1688998A CNA038242834A CN03824283A CN1688998A CN 1688998 A CN1688998 A CN 1688998A CN A038242834 A CNA038242834 A CN A038242834A CN 03824283 A CN03824283 A CN 03824283A CN 1688998 A CN1688998 A CN 1688998A
Authority
CN
China
Prior art keywords
data
dimension
sequence
vector
database
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.)
Pending
Application number
CNA038242834A
Other languages
English (en)
Chinese (zh)
Inventor
帕特里克·阿尔拉斯
阿尔冯·斯坦因霍夫
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
International Business Machines Corp
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 International Business Machines Corp filed Critical International Business Machines Corp
Publication of CN1688998A publication Critical patent/CN1688998A/zh
Pending legal-status Critical Current

Links

Images

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/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/953—Organization of data
    • Y10S707/957—Multidimensional
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
CNA038242834A 2002-10-18 2003-09-11 用于联机分析处理的方法和系统 Pending CN1688998A (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
EP02023362.3 2002-10-18
EP02023362 2002-10-18

Publications (1)

Publication Number Publication Date
CN1688998A true CN1688998A (zh) 2005-10-26

Family

ID=32103886

Family Applications (1)

Application Number Title Priority Date Filing Date
CNA038242834A Pending CN1688998A (zh) 2002-10-18 2003-09-11 用于联机分析处理的方法和系统

Country Status (6)

Country Link
US (3) US7340476B2 (enExample)
JP (1) JP4609995B2 (enExample)
CN (1) CN1688998A (enExample)
AU (1) AU2003286187A1 (enExample)
TW (1) TWI230344B (enExample)
WO (1) WO2004036456A2 (enExample)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103019951A (zh) * 2011-09-20 2013-04-03 阿里巴巴集团控股有限公司 有序数据的记录方法和装置、有序数据的访问方法和装置
CN103235793A (zh) * 2013-04-01 2013-08-07 华为技术有限公司 联机处理数据的方法、设备及系统
CN103678420A (zh) * 2012-09-25 2014-03-26 北大方正集团有限公司 一种建立多维数据集的方法和多维数据集处理装置
CN106775742A (zh) * 2016-12-27 2017-05-31 中国建设银行股份有限公司 一种用户定制信息的扩展方法及系统
CN108140024A (zh) * 2015-07-07 2018-06-08 华为技术有限公司 Molap中合并索引结构并保持查询一致性的机制

Families Citing this family (21)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7263520B2 (en) * 2004-02-27 2007-08-28 Sap Ag Fast aggregation of compressed data using full table scans
US7774298B2 (en) * 2004-06-30 2010-08-10 Sap Ag Method and system for data extraction from a transaction system to an analytics system
CA2593999C (en) * 2005-01-12 2015-12-08 West Services, Inc. Systems, methods, and interfaces for aggregating and providing information regarding legal professionals
US8270612B2 (en) * 2006-12-18 2012-09-18 Sap Ag Mapping compound keys
US20090063458A1 (en) * 2007-08-31 2009-03-05 International Business Machines Corporation method and system for minimizing sorting
US8495007B2 (en) * 2008-08-28 2013-07-23 Red Hat, Inc. Systems and methods for hierarchical aggregation of multi-dimensional data sources
US20100076935A1 (en) * 2008-09-09 2010-03-25 Ahmir Hussain Method, system, and computer for analytical reporting and archiving of data
US9959330B2 (en) 2011-09-20 2018-05-01 Oracle International Corporation Mechanism for updating OLAP system structure and OLTP system structure
US8549045B2 (en) * 2010-12-30 2013-10-01 International Business Machines Corporation Test data generation and scale up for database testing using unique common factor sequencing
US8751564B2 (en) * 2011-04-19 2014-06-10 Echostar Technologies L.L.C. Reducing latency for served applications by anticipatory preprocessing
US8635229B2 (en) 2011-10-18 2014-01-21 International Business Machines Corporation Sequenced query processing in data processing system
US8938416B1 (en) 2012-01-13 2015-01-20 Amazon Technologies, Inc. Distributed storage of aggregated data
US8660985B2 (en) * 2012-04-11 2014-02-25 Renmin University Of China Multi-dimensional OLAP query processing method oriented to column store data warehouse
US9721321B1 (en) * 2012-04-12 2017-08-01 Farshad Nayeri Automated interactive dynamic audio/visual performance with integrated data assembly system and methods
US9646072B2 (en) * 2013-03-03 2017-05-09 Panorama Software Inc. Multidimensional dataset query processing
US9965512B2 (en) 2013-06-25 2018-05-08 Sap Se Operators for constants in aggregated formulas
EP3678033A1 (en) 2019-01-07 2020-07-08 QlikTech International AB A computer implemented method for indexlet based aggregation
GB201916800D0 (en) 2019-11-19 2020-01-01 Ibm Detecting errors in spreadsheets
GB201916804D0 (en) 2019-11-19 2020-01-01 Ibm Generating an OLAP model from a spreadsheet
GB201916803D0 (en) 2019-11-19 2020-01-01 Ibm Identifying content and structure of olap dimensions from a spreadsheet
GB201916801D0 (en) 2019-11-19 2020-01-01 Ibm Identifying data relationships from a spreadsheet

Family Cites Families (21)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5875108A (en) * 1991-12-23 1999-02-23 Hoffberg; Steven M. Ergonomic man-machine interface incorporating adaptive pattern recognition based control system
US6850252B1 (en) * 1999-10-05 2005-02-01 Steven M. Hoffberg Intelligent electronic appliance system and method
US5727197A (en) * 1995-11-01 1998-03-10 Filetek, Inc. Method and apparatus for segmenting a database
US5787279A (en) * 1995-12-22 1998-07-28 International Business Machines Corporation System and method for conformationally-flexible molecular recognition
US5767854A (en) * 1996-09-27 1998-06-16 Anwar; Mohammed S. Multidimensional data display and manipulation system and methods for using same
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
US6003036A (en) * 1998-02-12 1999-12-14 Martin; Michael W. Interval-partitioning method for multidimensional data
US6957341B2 (en) * 1998-05-14 2005-10-18 Purdue Research Foundation Method and system for secure computational outsourcing and disguise
US6334125B1 (en) * 1998-11-17 2001-12-25 At&T Corp. Method and apparatus for loading data into a cube forest data structure
US7272593B1 (en) * 1999-01-26 2007-09-18 International Business Machines Corporation Method and apparatus for similarity retrieval from iterative refinement
US6427123B1 (en) * 1999-02-18 2002-07-30 Oracle Corporation Hierarchical indexing for accessing hierarchically organized information in a relational system
US6560594B2 (en) * 1999-05-13 2003-05-06 International Business Machines Corporation Cube indices for relational database management systems
US20030171876A1 (en) * 2002-03-05 2003-09-11 Victor Markowitz System and method for managing gene expression data
EP1217540A1 (en) * 2000-11-29 2002-06-26 Lafayette Software Inc. Methods of organizing data and processing queries in a database system, and database system and software product for implementing such method
EP1211611A1 (en) * 2000-11-29 2002-06-05 Lafayette Software Inc. Methods of encoding and combining integer lists
EP1211610A1 (en) * 2000-11-29 2002-06-05 Lafayette Software Inc. Methods of organising data and processing queries in a database system
US20020138316A1 (en) * 2001-03-23 2002-09-26 Katz Steven Bruce Value chain intelligence system and methods
US20030033179A1 (en) * 2001-08-09 2003-02-13 Katz Steven Bruce Method for generating customized alerts related to the procurement, sourcing, strategic sourcing and/or sale of one or more items by an enterprise
US8090730B2 (en) * 2001-12-04 2012-01-03 University Of Southern California Methods for fast progressive evaluation of polynomial range-sum queries on real-time datacubes
US7076505B2 (en) * 2002-07-11 2006-07-11 Metrobot Llc Method, apparatus, and computer program product for providing a graphical user interface with a linear map component
WO2004029828A2 (en) * 2002-09-24 2004-04-08 Ismartsoft, Inc. Method and apparatus for data analysis

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103019951A (zh) * 2011-09-20 2013-04-03 阿里巴巴集团控股有限公司 有序数据的记录方法和装置、有序数据的访问方法和装置
CN103019951B (zh) * 2011-09-20 2016-12-07 阿里巴巴集团控股有限公司 有序数据的记录方法和装置、有序数据的访问方法和装置
CN103678420A (zh) * 2012-09-25 2014-03-26 北大方正集团有限公司 一种建立多维数据集的方法和多维数据集处理装置
CN103678420B (zh) * 2012-09-25 2017-02-01 北大方正集团有限公司 一种建立多维数据集的方法和多维数据集处理装置
CN103235793A (zh) * 2013-04-01 2013-08-07 华为技术有限公司 联机处理数据的方法、设备及系统
WO2014161281A1 (zh) * 2013-04-01 2014-10-09 华为技术有限公司 联机处理数据的方法、设备及系统
RU2612570C2 (ru) * 2013-04-01 2017-03-09 Хуавей Текнолоджиз Ко., Лтд. Способ, устройство и система обработки данных в режиме реального времени
CN108140024A (zh) * 2015-07-07 2018-06-08 华为技术有限公司 Molap中合并索引结构并保持查询一致性的机制
CN108140024B (zh) * 2015-07-07 2021-01-29 华为技术有限公司 Molap中合并索引结构并保持查询一致性的机制
CN106775742A (zh) * 2016-12-27 2017-05-31 中国建设银行股份有限公司 一种用户定制信息的扩展方法及系统

Also Published As

Publication number Publication date
US7774302B2 (en) 2010-08-10
WO2004036456A2 (en) 2004-04-29
TWI230344B (en) 2005-04-01
JP2006503357A (ja) 2006-01-26
TW200413969A (en) 2004-08-01
US20080082563A1 (en) 2008-04-03
US20080183740A1 (en) 2008-07-31
US20060010147A1 (en) 2006-01-12
AU2003286187A1 (en) 2004-05-04
WO2004036456A3 (en) 2004-09-30
US7340476B2 (en) 2008-03-04
JP4609995B2 (ja) 2011-01-12
US7856458B2 (en) 2010-12-21

Similar Documents

Publication Publication Date Title
CN1688998A (zh) 用于联机分析处理的方法和系统
US8037059B2 (en) Implementing aggregation combination using aggregate depth lists and cube aggregation conversion to rollup aggregation for optimizing query processing
US7024431B1 (en) Data transformation to maintain detailed user information in a data warehouse
Hellerstein et al. On a model of indexability and its bounds for range queries
JP2006503357A5 (enExample)
US5850547A (en) Method and apparatus for parallel processing aggregates using intermediate aggregate values
Goil et al. A parallel scalable infrastructure for OLAP and data mining
US20030229639A1 (en) Runtime query optimization for dynamically selecting from multiple plans in a query based upon runtime-evaluated performance criterion
US6430565B1 (en) Path compression for records of multidimensional database
JP2003526159A (ja) 多次元データベースおよび統合集約サーバ
ZA200100187B (en) Value-instance-connectivity computer-implemented database.
US20110082855A1 (en) Multi-dimensional access to data
Dehne et al. The cgmCUBE project: Optimizing parallel data cube generation for ROLAP
US20100235344A1 (en) Mechanism for utilizing partitioning pruning techniques for xml indexes
Su et al. Taming massive distributed datasets: data sampling using bitmap indices
US20040059724A1 (en) Extensions for adding and removing calculated members in a multidimensional database
Weng et al. An approach for automatic data virtualization
US6456998B1 (en) Efficient processing of parent-child relationships in a relational database management system
Sheng et al. Dynamic top-k range reporting in external memory
US20050102271A1 (en) Indexes with embedded data
US11086864B2 (en) Optimizing search for data
Mittra Database performance tuning and optimization: using Oracle
Bellatreche Dimension table selection strategies to referential partition a fact table of relational data warehouses
Eavis et al. Towards a scalable, performance-oriented OLAP storage engine
Eavis et al. Query optimization and execution in a parallel analytics DBMS

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Open date: 20051026