CA2468398A1 - System and method of query transformation - Google Patents

System and method of query transformation Download PDF

Info

Publication number
CA2468398A1
CA2468398A1 CA002468398A CA2468398A CA2468398A1 CA 2468398 A1 CA2468398 A1 CA 2468398A1 CA 002468398 A CA002468398 A CA 002468398A CA 2468398 A CA2468398 A CA 2468398A CA 2468398 A1 CA2468398 A1 CA 2468398A1
Authority
CA
Canada
Prior art keywords
query
group query
group
olap
sql
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.)
Granted
Application number
CA002468398A
Other languages
French (fr)
Other versions
CA2468398C (en
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.)
International Business Machines Corp
Original Assignee
Cognos Inc
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/en
Application filed by Cognos Inc filed Critical Cognos Inc
Priority to CA002468398A priority Critical patent/CA2468398C/en
Publication of CA2468398A1 publication Critical patent/CA2468398A1/en
Application granted granted Critical
Publication of CA2468398C publication Critical patent/CA2468398C/en
Expired - Fee Related legal-status Critical Current
Anticipated expiration legal-status Critical

Links

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/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24537—Query rewriting; Transformation of operators
    • 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/2433—Query languages
    • G06F16/244—Grouping and aggregation
    • 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

Abstract

A group query transformation system for transforming structured query langua ge group query windowed aggregates is provided. The group query transformation system comprises a group query analysis module for analyzing one or more structured query language (SQL)/ on-line analytical programming (OLAP) windowed aggregates th at are not supported by a target database system, and a group query transformation module for transforming the one or more SQL/OLAP windowed aggregates into semantically equivalent standard aggregate functions that are supported by the target database system.
CA002468398A 2003-05-27 2004-05-27 System and method of query transformation Expired - Fee Related CA2468398C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA002468398A CA2468398C (en) 2003-05-27 2004-05-27 System and method of query transformation

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
CA002429910A CA2429910A1 (en) 2003-05-27 2003-05-27 System and method of query transformation
CA2,429,910 2003-05-27
CA002468398A CA2468398C (en) 2003-05-27 2004-05-27 System and method of query transformation

Publications (2)

Publication Number Publication Date
CA2468398A1 true CA2468398A1 (en) 2004-11-27
CA2468398C CA2468398C (en) 2009-07-14

Family

ID=33453244

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002468398A Expired - Fee Related CA2468398C (en) 2003-05-27 2004-05-27 System and method of query transformation

Country Status (1)

Country Link
CA (1) CA2468398C (en)

Also Published As

Publication number Publication date
CA2468398C (en) 2009-07-14

Similar Documents

Publication Publication Date Title
EP1482426A3 (en) System and method of query transformation
WO2007073515A3 (en) System and method for problem analysis
AU2002368176A1 (en) System, method and apparatus for conducting a keyterm search
MXPA02012379A (en) Color matching system and method.
WO2007021448A3 (en) Syntactic program language translation
IL142482A0 (en) Accessing a hierarchical data store through an sql input
CA2298181A1 (en) Non-targeted complex sample analysis
WO2004036365A3 (en) Dividing a travel query into sub-queries
WO2001009754A3 (en) Modular method and system for performing database queries
EP1482430A3 (en) System and method of transforming queries based upon e/r schema into multi-dimensional expression queries
EP1276059A3 (en) Data processing system
WO2007018826A3 (en) Intelligent sql generation for persistent object retrieval
ATE450011T1 (en) SYSTEM AND METHOD FOR DATA PROCESSING
WO2004059439A3 (en) Apparatus and method for creating new reports from discrete reports
WO2008022150A3 (en) Method and apparatus for identifying and classifying query intent
TW200517870A (en) System and method for carrying out legacy application transitions
DK1353280T3 (en) Process for processing multilingual queries
TW200517887A (en) Methods and apparatus for query rewrite with auxiliary attributes in query processing operations
WO2000043916A3 (en) Database item versioning
CN108268612A (en) A kind of pre- method of calibration based on OLAP precomputation models and pre- check system
CA2468398A1 (en) System and method of query transformation
WO2007121105A3 (en) Systems and methods for predicting if a query is a name
WO2003085552A3 (en) Comparison of source files
WO2003058499A1 (en) Knowledge search apparatus, knowledge search method, program, and recording medium
WO2001059613A3 (en) System for data management

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed