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

Systeme et methode de transformation des interrogations Download PDF

Info

Publication number
CA2468614A1
CA2468614A1 CA002468614A CA2468614A CA2468614A1 CA 2468614 A1 CA2468614 A1 CA 2468614A1 CA 002468614 A CA002468614 A CA 002468614A CA 2468614 A CA2468614 A CA 2468614A CA 2468614 A1 CA2468614 A1 CA 2468614A1
Authority
CA
Canada
Prior art keywords
filter
sno
analysing
transformation
group
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
Application number
CA002468614A
Other languages
English (en)
Inventor
Michael E. Styles
Marius Cosma
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 CA002468614A priority Critical patent/CA2468614A1/fr
Publication of CA2468614A1 publication Critical patent/CA2468614A1/fr
Abandoned 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/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)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CA002468614A 2003-05-27 2004-05-27 Systeme et methode de transformation des interrogations Abandoned CA2468614A1 (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA002468614A CA2468614A1 (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
CA002468614A CA2468614A1 (fr) 2003-05-27 2004-05-27 Systeme et methode de transformation des interrogations

Publications (1)

Publication Number Publication Date
CA2468614A1 true CA2468614A1 (fr) 2004-11-27

Family

ID=33453247

Family Applications (1)

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

Country Status (1)

Country Link
CA (1) CA2468614A1 (fr)

Similar Documents

Publication Publication Date Title
US8676821B2 (en) Summary filter transformation
CA2484009C (fr) Gestion d'expressions dans un systeme de base de donnees
US8935273B2 (en) Method of processing and decomposing a multidimensional query against a relational data source
CA2562281C (fr) Mise en antememoire partielle de requete
US7567952B2 (en) Optimizing a computer database query that fetches n rows
Wang et al. ATLAS: A small but complete SQL extension for data mining and data streams
US20040243555A1 (en) Methods and systems for optimizing queries through dynamic and autonomous database schema analysis
US7711704B2 (en) System and method of providing date, arithmetic and other relational functions for OLAP sources
US8032514B2 (en) SQL distinct optimization in a computer database system
Marx et al. Torpedo: Improving the state-of-the-art rdf dataset slicing
Liu et al. PAIRPQ: an efficient path index for regular path queries on knowledge graphs
CA2468614A1 (fr) Systeme et methode de transformation des interrogations
CA2468398C (fr) Systeme et methode de transformation d'interrogations
Savinov DataCommandr: Column-Oriented Data Integration, Transformation and Analysis
Mittra Database performance tuning and optimization: using Oracle
CA2468617C (fr) Systeme et methode de transformation des interrogations
CA2510508C (fr) Systeme et methode de traitement et de decomposition d'une interrogation multidimensionnelle relativement a une source de donnees relationnelle
CA2468404A1 (fr) Systeme et methode de transformation d'agregats client/serveur
CA2468624A1 (fr) Systeme et methode de traitement des interrogations
CA2468403A1 (fr) Systeme et methode de transformation d'interrogations
Mehan et al. International Journal of Modern Trends in Engineering and Research
CA2545108A1 (fr) Systeme et methode pour fournir des fonctions de date, des fonctions arithmetiques et d'autres fonctions relationnelles pour des sources olap

Legal Events

Date Code Title Description
EEER Examination request
FZDE Dead