CA2468398C - Systeme et methode de transformation d'interrogations - Google Patents

Systeme et methode de transformation d'interrogations Download PDF

Info

Publication number
CA2468398C
CA2468398C CA002468398A CA2468398A CA2468398C CA 2468398 C CA2468398 C CA 2468398C CA 002468398 A CA002468398 A CA 002468398A CA 2468398 A CA2468398 A CA 2468398A CA 2468398 C CA2468398 C CA 2468398C
Authority
CA
Canada
Prior art keywords
group
query
sql
aggregates
transformation
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 - Fee Related
Application number
CA002468398A
Other languages
English (en)
Other versions
CA2468398A1 (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.)
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 CA002429910A external-priority patent/CA2429910A1/fr
Application filed by International Business Machines Corp filed Critical International Business Machines Corp
Priority to CA002468398A priority Critical patent/CA2468398C/fr
Publication of CA2468398A1 publication Critical patent/CA2468398A1/fr
Application granted granted Critical
Publication of CA2468398C publication Critical patent/CA2468398C/fr
Anticipated expiration legal-status Critical
Expired - Fee Related 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)
CA002468398A 2003-05-27 2004-05-27 Systeme et methode de transformation d'interrogations Expired - Fee Related CA2468398C (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA002468398A CA2468398C (fr) 2003-05-27 2004-05-27 Systeme et methode de transformation d'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
CA002468398A CA2468398C (fr) 2003-05-27 2004-05-27 Systeme et methode de transformation d'interrogations

Publications (2)

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

Family

ID=33453244

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002468398A Expired - Fee Related CA2468398C (fr) 2003-05-27 2004-05-27 Systeme et methode de transformation d'interrogations

Country Status (1)

Country Link
CA (1) CA2468398C (fr)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117493654A (zh) * 2023-10-30 2024-02-02 山东浪潮数据库技术有限公司 一种时序数据库加速聚合查询的方法

Also Published As

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

Similar Documents

Publication Publication Date Title
EP1482426A2 (fr) Système et procédé de transformation d'une requête
CA2562281C (fr) Mise en antememoire partielle de requete
US8620888B2 (en) Partitioning in virtual columns
CA2484009C (fr) Gestion d'expressions dans un systeme de base de donnees
US6609131B1 (en) Parallel partition-wise joins
AU2002312104B2 (en) Method and system for improving response time of a query for a partitioned database object
US7730055B2 (en) Efficient hash based full-outer join
US6957210B1 (en) Optimizing an exclusion join operation using a bitmap index structure
US7213011B1 (en) Efficient processing of multi-column and function-based in-list predicates
WO2018107942A1 (fr) Système et procédé de division adaptative des données afin d'accélérer des interrogations de jointure sur des systèmes de base de données parallèles et distribuées
CA2468398C (fr) Systeme et methode de transformation d'interrogations
CA2468617C (fr) Systeme et methode de transformation des interrogations
CA2468404A1 (fr) Systeme et methode de transformation d'agregats client/serveur
CA2468614A1 (fr) Systeme et methode de transformation des interrogations
US7177856B1 (en) Method for correlating data from external databases
CA2468624A1 (fr) Systeme et methode de traitement des interrogations
Ruberg et al. A Cost Model for the Evaluation of Path Expressions in Distributed Object Databases
HK1094470B (en) Partial query caching
Mazumdar STREAMING DATA: STORAGE, QUERYING & ANALYSIS
CA2468403A1 (fr) Systeme et methode de transformation d'interrogations

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed