CA2468372C - Systeme et methode de traitement des resultats d'interrogations multidimensionnelles - Google Patents
Systeme et methode de traitement des resultats d'interrogations multidimensionnelles Download PDFInfo
- 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
Links
- 238000012545 processing Methods 0.000 title claims abstract description 43
- 238000000034 method Methods 0.000 title claims description 37
- 238000004364 calculation method Methods 0.000 claims abstract description 9
- 239000000945 filler Substances 0.000 claims description 13
- 238000013519 translation Methods 0.000 claims description 12
- 238000013507 mapping Methods 0.000 claims description 6
- 238000012805 post-processing Methods 0.000 description 17
- 230000002776 aggregation Effects 0.000 description 8
- 238000004220 aggregation Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 6
- 230000009466 transformation Effects 0.000 description 6
- 230000014509 gene expression Effects 0.000 description 5
- 238000006243 chemical reaction Methods 0.000 description 4
- 230000007246 mechanism Effects 0.000 description 4
- 238000004422 calculation algorithm Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 3
- 238000000844 transformation Methods 0.000 description 3
- 230000001131 transforming effect Effects 0.000 description 3
- 238000004590 computer program Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000001174 ascending effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
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/248—Presentation of 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/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
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.
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)
| 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 | 珠海市呼呼网络科技有限责任公司 | 一种实现工程项目基础数据四维翻转的数据架构方法 |
-
2004
- 2004-05-26 CA CA2468372A patent/CA2468372C/fr not_active Expired - Lifetime
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 |