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

Systeme et methode de transformation d'interrogations 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
English (en)
Other versions
CA2468398C (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
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/fr
Application filed by Cognos Inc filed Critical Cognos Inc
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
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
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 true CA2468398A1 (fr) 2004-11-27
CA2468398C 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)

Also Published As

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

Similar Documents

Publication Publication Date Title
EP1482426A3 (fr) Système et procédé de transformation d'une requête
WO2007073515A3 (fr) Systeme et procede pour l'analyse de problemes
MXPA02012379A (es) Sistema y metodo para igualar color.
WO2004017158A3 (fr) Systeme, procede et appareil pour effectuer une recherche de termes-cles
WO2007021448A3 (fr) Traduction syntaxique de langage de programmation
IL142482A0 (en) Accessing a hierarchical data store through an sql input
CA2298181A1 (fr) Analyse d'echantillons complexes non-cibles
WO2004036365A3 (fr) Division de demande de voyage en sous-demandes
SE0101127D0 (sv) Method of finding answers to questions
EP1596313A3 (fr) Procédé et système pour mise en correspondance de schémas d'une base de données web
WO2001009754A3 (fr) Procede et systeme modulaire d'interrogation de bases de donnees
EP1276059A3 (fr) Système de traitement de données
ATE450011T1 (de) System und verfahren zur datenverarbeitung
WO2004059439A3 (fr) Appareil et procede de creation de nouveaux rapports a partir de rapports discrets
WO2008022150A3 (fr) Procédé et appareil de classification et de classement des intentions d'interrogation
TW200517870A (en) System and method for carrying out legacy application transitions
DK1353280T3 (da) Fremgangsmåde til behandling af flersproglige forespörgsler
CA2534573A1 (fr) Evolution en place de schemas xml dans des bases de donnees
TW200517887A (en) Methods and apparatus for query rewrite with auxiliary attributes in query processing operations
WO2000043916A3 (fr) Gestion par versions d'items de base de donnees
CN108268612A (zh) 一种基于olap预计算模型的预校验方法及预校验系统
CA2468398A1 (fr) Systeme et methode de transformation d'interrogations
WO2007121105A3 (fr) Systemes et procedes pour predire si une demande est un nom
WO2003085552A3 (fr) Comparaison de fichiers source
WO2003058499A1 (fr) Appareil et procede de recherche de connaissance, programme et support d'enregistrement associes

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed