CA2468617C - Systeme et methode de transformation des interrogations - Google Patents

Systeme et methode de transformation des interrogations Download PDF

Info

Publication number
CA2468617C
CA2468617C CA2468617A CA2468617A CA2468617C CA 2468617 C CA2468617 C CA 2468617C CA 2468617 A CA2468617 A CA 2468617A CA 2468617 A CA2468617 A CA 2468617A CA 2468617 C CA2468617 C CA 2468617C
Authority
CA
Canada
Prior art keywords
query
nested
aggregate
transformation
aggregates
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
CA2468617A
Other languages
English (en)
Other versions
CA2468617A1 (fr
Inventor
Michael E. Styles
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.)
SAP SE
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 CA002429910A external-priority patent/CA2429910A1/fr
Application filed by International Business Machines Corp filed Critical International Business Machines Corp
Priority to CA2468617A priority Critical patent/CA2468617C/fr
Publication of CA2468617A1 publication Critical patent/CA2468617A1/fr
Application granted granted Critical
Publication of CA2468617C publication Critical patent/CA2468617C/fr
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

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/24537—Query rewriting; Transformation of operators
    • 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/242—Query formulation
    • G06F16/2433—Query languages
    • G06F16/244—Grouping and aggregation
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Ce brevet décrit un système visant la transformation des agrégats imbriqués en requête. Le système de transformation de requête comporte un module d'analyse des agrégats imbriqués pour l'analyse de la requête non prise en charge par le système de base de données ciblé ainsi qu'un module de transformation des agrégats imbriqués pour la transformation de la requête en une demande sémantique équivalente compatible avec le système de base de données ciblé.
CA2468617A 2003-05-27 2004-05-27 Systeme et methode de transformation des interrogations Expired - Lifetime CA2468617C (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA2468617A CA2468617C (fr) 2003-05-27 2004-05-27 Systeme et methode de transformation des interrogations

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
CA002429910A CA2429910A1 (fr) 2003-05-27 2003-05-27 Systeme et methode de transformation d'interrogations
CA2,429,910 2003-05-27
CA2468617A CA2468617C (fr) 2003-05-27 2004-05-27 Systeme et methode de transformation des interrogations

Publications (2)

Publication Number Publication Date
CA2468617A1 CA2468617A1 (fr) 2004-11-27
CA2468617C true CA2468617C (fr) 2010-06-29

Family

ID=33453248

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2468617A Expired - Lifetime CA2468617C (fr) 2003-05-27 2004-05-27 Systeme et methode de transformation des interrogations

Country Status (1)

Country Link
CA (1) CA2468617C (fr)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9275121B2 (en) 2013-01-03 2016-03-01 Sap Se Interoperable shared query based on heterogeneous data sources

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9275121B2 (en) 2013-01-03 2016-03-01 Sap Se Interoperable shared query based on heterogeneous data sources

Also Published As

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

Similar Documents

Publication Publication Date Title
US20050010570A1 (en) System and method of query transformation
Souibgui et al. Data quality in ETL process: A preliminary study
US6253200B1 (en) Structured query language to IMS transaction mapper
JP5721818B2 (ja) 検索におけるモデル情報群の使用
US7505985B2 (en) System and method of generating string-based search expressions using templates
US8086593B2 (en) Dynamic filters for relational query processing
US20030084035A1 (en) Integrated search and information discovery system
US20120246154A1 (en) Aggregating search results based on associating data instances with knowledge base entities
US8527502B2 (en) Method, system and computer-readable media for software object relationship traversal for object-relational query binding
US20060053095A1 (en) Computer-implemented system and method for analyzing search queries
US20060195420A1 (en) System and method of joining data obtained from horizontally and vertically partitioned heterogeneous data stores using string-based location transparent search expressions
US7853604B2 (en) Inline view query rewrite using a materialized view
CN115391142A (zh) 一种数据库审计日志生成方法及系统
US7085760B2 (en) Data query differential analysis
EP4062292A1 (fr) Index de données universel pour exploration rapide de données
US20070239799A1 (en) Analyzing log files
US20160371329A1 (en) Prepared execution plans for joins with partitioned tables
CN117076742A (zh) 数据血缘追踪方法、装置及电子设备
US8312030B2 (en) Efficient evaluation of XQuery and XPath full text extension
US7181454B1 (en) Asset locator
CA2468617C (fr) Systeme et methode de transformation des interrogations
Hassanzadeh et al. Helix: Online enterprise data analytics
US7685103B2 (en) Method, system, and program for predicate processing by iterator functions
CA2468398C (fr) Systeme et methode de transformation d'interrogations
Schwab et al. A Framework for DSL-Based Query Classification Using Relational and Graph-Based Data Models

Legal Events

Date Code Title Description
EEER Examination request
H11 Ip right ceased following rejected request for revival

Free format text: ST27 STATUS EVENT CODE: T-6-6-H10-H11-H101 (AS PROVIDED BY THE NATIONAL OFFICE); EVENT TEXT: TIME LIMIT FOR REVERSAL EXPIRED

Effective date: 20241129