CA2468372C - Systeme et methode de traitement des resultats d'interrogations multidimensionnelles - Google Patents

Systeme et methode de traitement des resultats d'interrogations multidimensionnelles Download PDF

Info

Publication number
CA2468372C
CA2468372C CA2468372A CA2468372A CA2468372C CA 2468372 C CA2468372 C CA 2468372C CA 2468372 A CA2468372 A CA 2468372A CA 2468372 A CA2468372 A CA 2468372A CA 2468372 C CA2468372 C CA 2468372C
Authority
CA
Canada
Prior art keywords
data
report
check
row
header
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 - Lifetime
Application number
CA2468372A
Other languages
English (en)
Other versions
CA2468372A1 (fr
Inventor
David Cushing
Marius Cosma
Neil Warner
Helmut Beffert
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
Priority claimed from CA002429909A external-priority patent/CA2429909A1/fr
Application filed by International Business Machines Corp filed Critical International Business Machines Corp
Priority to CA2468372A priority Critical patent/CA2468372C/fr
Publication of CA2468372A1 publication Critical patent/CA2468372A1/fr
Application granted granted Critical
Publication of CA2468372C publication Critical patent/CA2468372C/fr
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/283Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

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)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Document Processing Apparatus (AREA)

Abstract

L'invention porte sur un système de traitement des résultats d'interrogations multidimensionnelles permettant la sortie de traduction d'une exécution d'une interrogation multidimensionnelle dans une série de résultats de données qui traduisent la sémantique d'une spécification de rapport de schéma d'entité/relation. Le système comprend un module de génération de description de série de résultats pour produire une description de série de résultats qui traduisent la sémantique de la spécification du rapport, un module de génération de rangées tabulaires pour convertir les résultats de l'unique interrogation multidimensionnelle en une collection de rangées de données, un module de calcul de niveau de sommaire tabulaire pour calculer un niveau de résumage d'une rangée de données, un module de génération de rangée d'en-tête tabulaire pour produire une rangée d'en-tête à inclure dans la rangée de données, et un module de génération de résultats de tableau de contingence pour convertir les résultats d'une unique interrogation multidimensionnelle en une série de résultats qui correspond à la sémantique de la spécification du rapport.
CA2468372A 2003-05-27 2004-05-26 Systeme et methode de traitement des resultats d'interrogations multidimensionnelles Expired - Lifetime CA2468372C (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA2468372A CA2468372C (fr) 2003-05-27 2004-05-26 Systeme et methode de traitement des resultats d'interrogations multidimensionnelles

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
CA002429909A CA2429909A1 (fr) 2003-05-27 2003-05-27 Transformation d'interrogations tabulaires et croisees basees sur un diagramme e/r en interrogations d'expression multidimensionnelle
CA2,429,909 2003-05-27
CA2468372A CA2468372C (fr) 2003-05-27 2004-05-26 Systeme et methode de traitement des resultats d'interrogations multidimensionnelles

Publications (2)

Publication Number Publication Date
CA2468372A1 CA2468372A1 (fr) 2004-11-27
CA2468372C true CA2468372C (fr) 2011-05-17

Family

ID=33453242

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2468372A Expired - Lifetime CA2468372C (fr) 2003-05-27 2004-05-26 Systeme et methode de traitement des resultats d'interrogations multidimensionnelles

Country Status (1)

Country Link
CA (1) CA2468372C (fr)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111241147B (zh) * 2018-11-29 2023-10-31 中国石油天然气股份有限公司 一种数据采集方法、装置、电子设备及存储介质
CN110109654A (zh) * 2019-05-15 2019-08-09 中山大学 一种多维数据分析系统界面的交互设计方法及系统
CN112418802B (zh) * 2020-11-25 2024-02-09 珠海市呼呼网络科技有限责任公司 一种实现工程项目基础数据四维翻转的数据架构方法

Also Published As

Publication number Publication date
CA2468372A1 (fr) 2004-11-27

Similar Documents

Publication Publication Date Title
US9081849B2 (en) System and method of multidimensional query results processing
US7353222B2 (en) System and method for the storage, indexing and retrieval of XML documents using relational databases
US8484208B1 (en) Displaying results of keyword search over enterprise data
US8935267B2 (en) Apparatus and method for executing different query language queries on tree structured data using pre-computed indices of selective document paths
Goldman et al. Dataguides: Enabling query formulation and optimization in semistructured databases
US8682932B2 (en) Mechanisms for searching enterprise data graphs
US6934712B2 (en) Tagging XML query results over relational DBMSs
US9798772B2 (en) Using persistent data samples and query-time statistics for query optimization
US8892599B2 (en) Apparatus and method for securing preliminary information about database fragments for utilization in mapreduce processing
US7444330B2 (en) Methods and systems for model matching
US8886617B2 (en) Query-based searching using a virtual table
Lee et al. Nesting-Based Relational-to-XML Schema Translation.
US20050010550A1 (en) System and method of modelling of a multi-dimensional data source in an entity-relationship model
US8825621B2 (en) Transformation of complex data source result sets to normalized sets for manipulation and presentation
US20060161525A1 (en) Method and system for supporting structured aggregation operations on semi-structured data
US20060242169A1 (en) Storing and indexing hierarchical data spatially
CA2468372C (fr) Systeme et methode de traitement des resultats d'interrogations multidimensionnelles
US20180060404A1 (en) Schema abstraction in data ecosystems
Pluempitiwiriyawej et al. Element matching across data-oriented XML sources using a multi-strategy clustering model
CA2468373A1 (fr) Systeme et methode de transformation d'interrogations basees sur le schema entite-relation en interrogations multidimensionnelles
Tung et al. An improved indexing method for Xpath queries
Mahboubi XML warehousing and OLAP
Lee et al. Spatial metadata and its management
Tankoano Providing in RDBMSs the Flexibility to Work with Various Non-Relational Data Models
Pluempitiwiriyawej A new hierarchical clustering model for speeding up the reconciliation of XML-based, semistructured data in mediation systems

Legal Events

Date Code Title Description
EEER Examination request