CA2550818C - Systeme et methode permettant d'executer des operations sur des ensembles relationnels pour des sources de donnees olap - Google Patents

Systeme et methode permettant d'executer des operations sur des ensembles relationnels pour des sources de donnees olap Download PDF

Info

Publication number
CA2550818C
CA2550818C CA2550818A CA2550818A CA2550818C CA 2550818 C CA2550818 C CA 2550818C CA 2550818 A CA2550818 A CA 2550818A CA 2550818 A CA2550818 A CA 2550818A CA 2550818 C CA2550818 C CA 2550818C
Authority
CA
Canada
Prior art keywords
query
olap
data
relational
provider
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
CA2550818A
Other languages
English (en)
Other versions
CA2550818A1 (fr
Inventor
Soufiane Azizi
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 CA002519015A external-priority patent/CA2519015A1/fr
Application filed by International Business Machines Corp filed Critical International Business Machines Corp
Priority to CA2550818A priority Critical patent/CA2550818C/fr
Publication of CA2550818A1 publication Critical patent/CA2550818A1/fr
Application granted granted Critical
Publication of CA2550818C publication Critical patent/CA2550818C/fr
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/10—Office automation; Time management
    • 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
    • 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)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • General Engineering & Computer Science (AREA)
  • Operations Research (AREA)
  • General Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
CA2550818A 2005-09-13 2006-06-22 Systeme et methode permettant d'executer des operations sur des ensembles relationnels pour des sources de donnees olap Expired - Fee Related CA2550818C (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA2550818A CA2550818C (fr) 2005-09-13 2006-06-22 Systeme et methode permettant d'executer des operations sur des ensembles relationnels pour des sources de donnees olap

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
CA2,519,015 2005-09-13
CA002519015A CA2519015A1 (fr) 2005-09-13 2005-09-13 Systeme et methode permettant d'executer des operations sur des ensembles relationnels pour des sources de donnees olap
CA2550818A CA2550818C (fr) 2005-09-13 2006-06-22 Systeme et methode permettant d'executer des operations sur des ensembles relationnels pour des sources de donnees olap

Publications (2)

Publication Number Publication Date
CA2550818A1 CA2550818A1 (fr) 2007-03-13
CA2550818C true CA2550818C (fr) 2012-06-26

Family

ID=37872092

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2550818A Expired - Fee Related CA2550818C (fr) 2005-09-13 2006-06-22 Systeme et methode permettant d'executer des operations sur des ensembles relationnels pour des sources de donnees olap

Country Status (1)

Country Link
CA (1) CA2550818C (fr)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7853603B2 (en) 2007-05-23 2010-12-14 Microsoft Corporation User-defined relevance ranking for search

Also Published As

Publication number Publication date
CA2550818A1 (fr) 2007-03-13

Similar Documents

Publication Publication Date Title
US8935273B2 (en) Method of processing and decomposing a multidimensional query against a relational data source
US7647315B2 (en) System and method of providing relational set operations for multidimensional data sources
US7711704B2 (en) System and method of providing date, arithmetic and other relational functions for OLAP sources
JP7273045B2 (ja) Ｓｑｌクエリプランを最適化するための次元コンテキスト伝搬技術
US10984042B2 (en) Publishing RDF quads as relational views
US10515094B2 (en) System and method for analyzing and reporting extensible data from multiple sources in multiple formats
US7756822B2 (en) Operational reporting architecture
EP3259686B1 (fr) Interrogation d'une source de données sur un réseau
US20130166552A1 (en) Systems and methods for merging source records in accordance with survivorship rules
US20060294098A1 (en) Universal drill-down system for coordinated presentation of items in different databases
US20070094236A1 (en) Combining multi-dimensional data sources using database operations
HK1246425A1 (en) Querying a data source on a network
US12436948B2 (en) Systems and methods for extracting data views from heterogeneous sources
CN106503912A (zh) 一种数据服务系统
US7640238B2 (en) Query planning for execution using conditional operators
CN104317936A (zh) 一种基于星型模型的rolap解析引擎设计方法及装置
US8527552B2 (en) Database consistent sample data extraction
US20080133492A1 (en) Efficient execution of aggregation queries
CA2510508C (fr) Systeme et methode de traitement et de decomposition d'une interrogation multidimensionnelle relativement a une source de donnees relationnelle
CA2545108A1 (fr) Systeme et methode pour fournir des fonctions de date, des fonctions arithmetiques et d'autres fonctions relationnelles pour des sources olap
Schneider et al. Reading Sample
CN120705002A (zh) Pos收银系统操作日志收集与智能分析方法
Tocci A comparison of leading database storage engines in support of online analytical processing in an open source environment
HK40016211A (en) Querying a data source on a network

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed

Effective date: 20150622