CA2468373A1 - Systeme et methode de transformation d'interrogations basees sur le schema entite-relation en interrogations multidimensionnelles - Google Patents
Systeme et methode de transformation d'interrogations basees sur le schema entite-relation en interrogations multidimensionnelles Download PDFInfo
- Publication number
- CA2468373A1 CA2468373A1 CA002468373A CA2468373A CA2468373A1 CA 2468373 A1 CA2468373 A1 CA 2468373A1 CA 002468373 A CA002468373 A CA 002468373A CA 2468373 A CA2468373 A CA 2468373A CA 2468373 A1 CA2468373 A1 CA 2468373A1
- Authority
- CA
- Canada
- Prior art keywords
- dimensional
- query
- level
- report
- entity
- 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.)
- Abandoned
Links
- 230000014509 gene expression Effects 0.000 title claims abstract description 51
- 230000001131 transforming effect Effects 0.000 title claims abstract description 16
- 238000000034 method Methods 0.000 title claims description 71
- 238000013519 translation Methods 0.000 claims abstract description 52
- 230000014616 translation Effects 0.000 claims description 51
- 238000012545 processing Methods 0.000 claims description 44
- 238000004220 aggregation Methods 0.000 claims description 29
- 230000002776 aggregation Effects 0.000 claims description 28
- 238000004364 calculation method Methods 0.000 claims description 13
- 238000001514 detection method Methods 0.000 claims description 6
- 230000003993 interaction Effects 0.000 claims description 4
- 238000004590 computer program Methods 0.000 claims 2
- 238000012805 post-processing Methods 0.000 description 20
- 230000000875 corresponding effect Effects 0.000 description 14
- 239000000945 filler Substances 0.000 description 10
- 210000004027 cell Anatomy 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 230000009466 transformation Effects 0.000 description 8
- 238000006243 chemical reaction Methods 0.000 description 7
- 238000013507 mapping Methods 0.000 description 5
- 210000001901 basal epithelial cell of bronchioalveolar duct junction Anatomy 0.000 description 4
- 238000000844 transformation Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000013499 data model Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 230000007246 mechanism Effects 0.000 description 3
- 238000011045 prefiltration Methods 0.000 description 3
- 238000013459 approach Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 101710125089 Bindin Proteins 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000001174 ascending effect Effects 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000002596 correlated effect Effects 0.000 description 1
- 238000007429 general method Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000002265 prevention Effects 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 230000001629 suppression Effects 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/242—Query formulation
- G06F16/2423—Interactive query statement specification based on a database schema
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CA002468373A CA2468373A1 (fr) | 2003-05-27 | 2004-05-26 | Systeme et methode de transformation d'interrogations basees sur le schema entite-relation en 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 | ||
| CA002468373A CA2468373A1 (fr) | 2003-05-27 | 2004-05-26 | Systeme et methode de transformation d'interrogations basees sur le schema entite-relation en interrogations multidimensionnelles |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CA2468373A1 true CA2468373A1 (fr) | 2004-11-27 |
Family
ID=33453243
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CA002468373A Abandoned CA2468373A1 (fr) | 2003-05-27 | 2004-05-26 | Systeme et methode de transformation d'interrogations basees sur le schema entite-relation en interrogations multidimensionnelles |
Country Status (1)
| Country | Link |
|---|---|
| CA (1) | CA2468373A1 (fr) |
-
2004
- 2004-05-26 CA CA002468373A patent/CA2468373A1/fr not_active Abandoned
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7945575B2 (en) | Method of transforming queries based upon E/R schema into multi-dimensional expression queries | |
| Bourret et al. | A generic load/extract utility for data transfer between XML documents and relational databases | |
| Moody et al. | From enterprise models to dimensional models: a methodology for data warehouse and data mart design. | |
| US10515094B2 (en) | System and method for analyzing and reporting extensible data from multiple sources in multiple formats | |
| US5870739A (en) | Hybrid query apparatus and method | |
| US6167393A (en) | Heterogeneous record search apparatus and method | |
| US5884304A (en) | Alternate key index query apparatus and method | |
| US7243098B2 (en) | Method, system, and program for optimizing aggregate processing | |
| US20070061318A1 (en) | System and method of data source agnostic querying | |
| EP1918827A1 (fr) | Système et méthode de traitement de données | |
| CA2386168A1 (fr) | Systeme et procede permettant la transformation d'une base de donnees relationnelle en une base de donnees hierarchique | |
| CN102314647A (zh) | 一种利用xbrl进行的企业数据存储的方法 | |
| US20060161525A1 (en) | Method and system for supporting structured aggregation operations on semi-structured data | |
| Lin et al. | A method of extracting the semi-structured data implication rules | |
| Abramowicz et al. | Filtering the Web to feed data warehouses | |
| Koupil et al. | A universal approach for multi-model schema inference | |
| US20180060404A1 (en) | Schema abstraction in data ecosystems | |
| Ramanujam et al. | R2D: A bridge between the semantic web and relational visualization tools | |
| US20060167867A1 (en) | Enhancing node-based query languages to support common relational mapping patterns | |
| CA2468372C (fr) | Systeme et methode de traitement des resultats d'interrogations multidimensionnelles | |
| CA2468373A1 (fr) | Systeme et methode de transformation d'interrogations basees sur le schema entite-relation en interrogations multidimensionnelles | |
| Gulić | Transformation of OWL ontology sources into data warehouse | |
| EP1965313A1 (fr) | Traitement de données | |
| Sarkar et al. | Conceptual Level Design of Object Oriented Data Warehouse: Graph Semantic Based Model | |
| Mangisengi et al. | Multidimensional modeling approaches for OLAP based on extended relational concepts |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| EEER | Examination request | ||
| FZDE | Discontinued | ||
| FZDE | Discontinued |
Effective date: 20110302 |