FR3092920B1 - Traitement d’interrogations de base de données complexes - Google Patents

Traitement d’interrogations de base de données complexes Download PDF

Info

Publication number
FR3092920B1
FR3092920B1 FR1901483A FR1901483A FR3092920B1 FR 3092920 B1 FR3092920 B1 FR 3092920B1 FR 1901483 A FR1901483 A FR 1901483A FR 1901483 A FR1901483 A FR 1901483A FR 3092920 B1 FR3092920 B1 FR 3092920B1
Authority
FR
France
Prior art keywords
query
database
response
database queries
processing complex
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.)
Active
Application number
FR1901483A
Other languages
English (en)
Other versions
FR3092920A1 (fr
Inventor
Nuno Miguel Pires Gaspar
Stéphane Rodrigues
Francois-Joseph Mytych
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.)
Amadeus SAS
Original Assignee
Amadeus SAS
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 to FR1901483A priority Critical patent/FR3092920B1/fr
Application filed by Amadeus SAS filed Critical Amadeus SAS
Priority to CA3129634A priority patent/CA3129634A1/fr
Priority to US17/428,835 priority patent/US11748348B2/en
Priority to AU2020220394A priority patent/AU2020220394A1/en
Priority to PCT/EP2020/053680 priority patent/WO2020165304A1/fr
Priority to EP20703488.5A priority patent/EP3924838B1/fr
Priority to CN202080017149.4A priority patent/CN113490931A/zh
Publication of FR3092920A1 publication Critical patent/FR3092920A1/fr
Application granted granted Critical
Publication of FR3092920B1 publication Critical patent/FR3092920B1/fr
Active 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/24539—Query rewriting; Transformation using cached or materialised query results
    • 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/21—Design, administration or maintenance of databases
    • G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
    • 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/24542—Plan optimisation
    • 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/2455—Query execution
    • G06F16/24552—Database cache management

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

De multiples interrogations de bases de données formant une requête de base de données complexe sont traitées. Une première interrogation et une deuxième interrogation sont résolues par une première réponse et une deuxième réponse qui sont basées sur une mémoire cache stockant des données en cache ; une troisième interrogation qui est liée à la deuxième interrogation est résolue en se basant sur une base de données qui stocke des données actuelles correspondant aux données en cache. Un sous-ensemble sélectionné des données en cache renvoyé avec la deuxième réponse est validé par des données actuelles correspondantes stockées dans la base de données. Figure pour abrégé : Fig. 2
FR1901483A 2019-02-14 2019-02-14 Traitement d’interrogations de base de données complexes Active FR3092920B1 (fr)

Priority Applications (7)

Application Number Priority Date Filing Date Title
FR1901483A FR3092920B1 (fr) 2019-02-14 2019-02-14 Traitement d’interrogations de base de données complexes
US17/428,835 US11748348B2 (en) 2019-02-14 2020-02-13 Processing complex database querys
AU2020220394A AU2020220394A1 (en) 2019-02-14 2020-02-13 Processing complex database querys
PCT/EP2020/053680 WO2020165304A1 (fr) 2019-02-14 2020-02-13 Traitement de requêtes de base de données complexes
CA3129634A CA3129634A1 (fr) 2019-02-14 2020-02-13 Traitement de requetes de base de donnees complexes
EP20703488.5A EP3924838B1 (fr) 2019-02-14 2020-02-13 Traitement de requêtes de base de données complexes
CN202080017149.4A CN113490931A (zh) 2019-02-14 2020-02-13 处理复杂数据库查询

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
FR1901483A FR3092920B1 (fr) 2019-02-14 2019-02-14 Traitement d’interrogations de base de données complexes
FR1901483 2019-02-14

Publications (2)

Publication Number Publication Date
FR3092920A1 FR3092920A1 (fr) 2020-08-21
FR3092920B1 true FR3092920B1 (fr) 2022-04-01

Family

ID=68424929

Family Applications (1)

Application Number Title Priority Date Filing Date
FR1901483A Active FR3092920B1 (fr) 2019-02-14 2019-02-14 Traitement d’interrogations de base de données complexes

Country Status (7)

Country Link
US (1) US11748348B2 (fr)
EP (1) EP3924838B1 (fr)
CN (1) CN113490931A (fr)
AU (1) AU2020220394A1 (fr)
CA (1) CA3129634A1 (fr)
FR (1) FR3092920B1 (fr)
WO (1) WO2020165304A1 (fr)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116303730B (zh) * 2023-05-18 2023-08-01 安徽泛联信息科技有限公司 一种数据可视化平台用异步数据源连接系统

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
AU3638401A (en) * 1999-11-01 2001-05-14 Ita Software, Inc. Method and apparatus for providing availability of airline seats
EP2146292B8 (fr) * 2008-07-18 2019-03-20 QlikTech International AB Procédé et appareil pour extraire les informations d'une base de données
US9235620B2 (en) * 2012-08-14 2016-01-12 Amadeus S.A.S. Updating cached database query results
SG11201408814XA (en) * 2012-08-14 2015-01-29 Amadeus Sas Updating cached database query results
JP6511394B2 (ja) * 2012-09-27 2019-05-15 アマデウス エス．アー．エス．Ａｍａｄｅｕｓ Ｓ．Ａ．Ｓ． データの保存および取得の方法およびシステム
US9826051B2 (en) 2014-01-21 2017-11-21 Amadeus S.A.S. Content integration framework
WO2015110133A1 (fr) 2014-01-21 2015-07-30 Amadeus S.A.S. Cadre d'intégration de contenu
ES2689305T3 (es) 2014-02-13 2018-11-13 Amadeus S.A.S. Aumentar la validez del resultado de búsqueda
US9984165B2 (en) * 2014-02-13 2018-05-29 Amadeus S.A.S. Increasing search result validity
WO2015124274A1 (fr) 2014-02-19 2015-08-27 Amadeus S.A.S. Recalcul de résultats de recherche précalculés
US9582536B2 (en) 2014-02-19 2017-02-28 Amadeus S.A.S. Long-term validity of pre-computed request results
US10061808B2 (en) * 2014-06-03 2018-08-28 Sap Se Cached views

Also Published As

Publication number Publication date
FR3092920A1 (fr) 2020-08-21
WO2020165304A1 (fr) 2020-08-20
EP3924838B1 (fr) 2024-04-24
US20210382894A1 (en) 2021-12-09
CA3129634A1 (fr) 2020-08-20
EP3924838A1 (fr) 2021-12-22
CN113490931A (zh) 2021-10-08
AU2020220394A1 (en) 2021-08-26
US11748348B2 (en) 2023-09-05

Similar Documents

Publication Publication Date Title
CN106202548B (zh) 数据存储方法、查找方法及装置
US9529848B2 (en) Predictive query result computation
US20170161323A1 (en) Automatic generation of sub-queries
US8533181B2 (en) Partition pruning via query rewrite
US20190095850A1 (en) Data trend analysis
JP7100422B2 (ja) データプロパティ認識のための装置、プログラム、及び方法
Stebbing A modern elementary logic
Sweetser Factor structure as ecological structure in Helsinki and Boston
US20220253484A1 (en) Dynamically-qualified aggregate relationship system in genealogical databases
FR3092920B1 (fr) Traitement d’interrogations de base de données complexes
US9454557B2 (en) Unit of work based incremental data processing
Dopp Notions de logique formelle
Heginbotham et al. The dating of French gilt bronzes with ED-XRF analysis and machine learning
Speelman et al. The role of concept characteristics in lexical dialectometry
US20180341709A1 (en) Unstructured search query generation from a set of structured data terms
US20140280050A1 (en) Term searching based on context
Lavrentiev et al. Systematization of Tabular and Graphical Resources in Quantitative Spectroscopy.
CN108415914B (zh) 一种可视化对象中查询信息的方法、装置及设备
US9824076B2 (en) Big file editor
Uskenbayeva et al. Technology of integration of diverse databases on the example of medical records
Peralta et al. The greed line: tool for a just economy
CN115221249B (zh) 跨库数据查询方法、装置、计算机设备和存储介质
US20240160649A1 (en) Indication of trends in a document set
Kudaiarova et al. The Concept of “Developmental State” in the Context of Eurasian Integration
JP2018194903A (ja) 検索システム、端末装置、情報処理装置、検索方法、およびプログラム

Legal Events

Date Code Title Description
PLFP Fee payment

Year of fee payment: 2

PLSC Publication of the preliminary search report

Effective date: 20200821

PLFP Fee payment

Year of fee payment: 3

PLFP Fee payment

Year of fee payment: 4

PLFP Fee payment

Year of fee payment: 5

PLFP Fee payment

Year of fee payment: 6