KR101972199B1 - 캐시처리된 데이터베이스 질의 결과의 업데이트 - Google Patents

캐시처리된 데이터베이스 질의 결과의 업데이트 Download PDF

Info

Publication number
KR101972199B1
KR101972199B1 KR1020157004168A KR20157004168A KR101972199B1 KR 101972199 B1 KR101972199 B1 KR 101972199B1 KR 1020157004168 A KR1020157004168 A KR 1020157004168A KR 20157004168 A KR20157004168 A KR 20157004168A KR 101972199 B1 KR101972199 B1 KR 101972199B1
Authority
KR
South Korea
Prior art keywords
cache
query results
recalculation
probability
platform
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
KR1020157004168A
Other languages
English (en)
Korean (ko)
Other versions
KR20150043338A (ko
Inventor
다미앙 씨아브리니
귀욤 르그랑
브누와 쟈냥
뤽 이스나르디
니꼴라 마이욧
샤를르-앙뚜완느 로블랭
뤼디 다니엘로
Original Assignee
아마데우스 에스.에이.에스.
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 US13/585,286 external-priority patent/US9235620B2/en
Priority claimed from EP12368020.9A external-priority patent/EP2698729B1/en
Application filed by 아마데우스 에스.에이.에스. filed Critical 아마데우스 에스.에이.에스.
Publication of KR20150043338A publication Critical patent/KR20150043338A/ko
Application granted granted Critical
Publication of KR101972199B1 publication Critical patent/KR101972199B1/ko
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

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/24539—Query rewriting; Transformation using cached or materialised query results
    • 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
    • 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/02—Reservations, e.g. for tickets, services or events
    • 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
    • G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/10—Services
    • G06Q50/14—Travel agencies

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Tourism & Hospitality (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Economics (AREA)
  • Strategic Management (AREA)
  • Operations Research (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Quality & Reliability (AREA)
  • Development Economics (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Information Transfer Between Computers (AREA)
KR1020157004168A 2012-08-14 2013-08-09 캐시처리된 데이터베이스 질의 결과의 업데이트 Active KR101972199B1 (ko)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
EP12368020.9 2012-08-14
US13/585,286 2012-08-14
US13/585,286 US9235620B2 (en) 2012-08-14 2012-08-14 Updating cached database query results
EP12368020.9A EP2698729B1 (en) 2012-08-14 2012-08-14 Updating cached database query results
PCT/EP2013/002390 WO2014026753A1 (en) 2012-08-14 2013-08-09 Updating cached database query results

Publications (2)

Publication Number Publication Date
KR20150043338A KR20150043338A (ko) 2015-04-22
KR101972199B1 true KR101972199B1 (ko) 2019-04-24

Family

ID=49003740

Family Applications (1)

Application Number Title Priority Date Filing Date
KR1020157004168A Active KR101972199B1 (ko) 2012-08-14 2013-08-09 캐시처리된 데이터베이스 질의 결과의 업데이트

Country Status (11)

Country Link
EP (1) EP2885725B1 (enExample)
JP (1) JP6162240B2 (enExample)
KR (1) KR101972199B1 (enExample)
CN (1) CN104471573B (enExample)
AU (1) AU2013304366B2 (enExample)
BR (1) BR112014031390A2 (enExample)
CA (1) CA2875735C (enExample)
ES (1) ES2714676T3 (enExample)
IN (1) IN2014DN10461A (enExample)
SG (1) SG11201408814XA (enExample)
WO (1) WO2014026753A1 (enExample)

Families Citing this family (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
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
WO2015120968A1 (en) * 2014-02-13 2015-08-20 Amadeus S.A.S. Increasing search result validity
US9582536B2 (en) 2014-02-19 2017-02-28 Amadeus S.A.S. Long-term validity of pre-computed request results
EP3016000B1 (en) 2014-11-03 2024-07-31 Amadeus S.A.S. Managing pre-computed search results
US10395294B2 (en) 2014-11-03 2019-08-27 Amadeus S.A.S. Managing pre-computed search results
WO2016070964A1 (en) 2014-11-03 2016-05-12 Amadeus S.A.S. Managing pre-computed search results
ES2991404T3 (es) 2015-08-03 2024-12-03 Amadeus Sas Manejo de peticiones de datos
US12169806B2 (en) * 2016-09-15 2024-12-17 U.S. Bank National Association Network-based real-time enterprise travel management apparatus, methods, and systems
US11741091B2 (en) * 2016-12-01 2023-08-29 Ab Initio Technology Llc Generating, accessing, and displaying lineage metadata
CA3038199A1 (en) * 2018-04-03 2019-10-03 Amadeus S.A.S. Updating cache data
CN110858204B (zh) * 2018-08-16 2023-09-19 中国移动通信集团重庆有限公司 查询请求的处理方法、设备和介质
FR3086412B1 (fr) 2018-09-20 2020-10-30 Amadeus Sas Recalcul des resultats de recherche precalcules
CN109788305B (zh) * 2018-12-10 2021-03-02 北京爱奇艺科技有限公司 一种缓存数据的刷新方法及装置
FR3092920B1 (fr) 2019-02-14 2022-04-01 Amadeus Traitement d’interrogations de base de données complexes
FR3093575B1 (fr) 2019-03-04 2021-12-03 Amadeus Traitement de données distribuées
FR3093574B1 (fr) * 2019-03-04 2021-10-01 Amadeus Traitement de données distribuées
CN110795457B (zh) * 2019-09-24 2023-05-05 苏宁云计算有限公司 数据缓存处理方法、装置、计算机设备和存储介质
US20210182214A1 (en) * 2019-12-17 2021-06-17 Advanced Micro Devices, Inc. Prefetch level demotion
US11409740B2 (en) * 2020-08-10 2022-08-09 Google Llc Anticipatory pre-execution of data queries
US11593356B2 (en) * 2020-09-11 2023-02-28 ForgeRock, Inc. Never stale caching of effective properties
US11341137B1 (en) 2020-12-04 2022-05-24 Amadeus S.A.S. Processing search requests
CA3200431A1 (en) 2020-12-04 2022-06-09 Guillaume Lecourt Processing search requests
EP4009188A1 (en) 2020-12-04 2022-06-08 Amadeus S.A.S. Processing search requests
US12405820B2 (en) 2022-03-30 2025-09-02 International Business Machines Corporation Central randomized scheduler for hypothesis-based workloads
CN120448525B (zh) * 2025-07-14 2025-09-09 深圳市信润富联数字科技有限公司 数据的检索方法及装置、终端

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090234682A1 (en) 1999-11-01 2009-09-17 Ita Software, Inc., A Delaware Corporation Method and apparatus for providing availability of airline seats

Family Cites Families (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6128701A (en) * 1997-10-28 2000-10-03 Cache Flow, Inc. Adaptive and predictive cache refresh policy
US6725333B1 (en) * 1999-04-22 2004-04-20 International Business Machines Corporation System and method for managing cachable entities
WO2002007364A2 (en) * 2000-07-17 2002-01-24 Eplication Networks Ltd. BANDWIDTH SAVINGS AND QoS IMPROVEMENT FOR WWW SITES BY CATCHING STATIC AND DYNAMIC CONTENT ON A DISTRIBUTED NETWORK OF CACHES
US7085747B2 (en) * 2001-09-26 2006-08-01 J Koninklijke Philips Electronics, Nv. Real-time event recommender for media programming using “Fuzzy-Now” and “Personal Scheduler”
WO2006046486A1 (ja) * 2004-10-27 2006-05-04 Nec Corporation 資源管理システム、資源情報提供方法、及び、プログラム
JP5387457B2 (ja) * 2010-03-10 2014-01-15 富士電機株式会社 遠隔監視装置および該装置におけるデータアクセス方法

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090234682A1 (en) 1999-11-01 2009-09-17 Ita Software, Inc., A Delaware Corporation Method and apparatus for providing availability of airline seats

Also Published As

Publication number Publication date
ES2714676T3 (es) 2019-05-29
CA2875735A1 (en) 2014-02-20
AU2013304366B2 (en) 2016-05-12
KR20150043338A (ko) 2015-04-22
WO2014026753A1 (en) 2014-02-20
BR112014031390A2 (pt) 2017-06-27
EP2885725B1 (en) 2018-12-12
JP6162240B2 (ja) 2017-07-12
SG11201408814XA (en) 2015-01-29
CA2875735C (en) 2020-09-15
CN104471573A (zh) 2015-03-25
EP2885725A1 (en) 2015-06-24
IN2014DN10461A (enExample) 2015-08-21
CN104471573B (zh) 2017-07-18
AU2013304366A1 (en) 2015-02-26
JP2015531129A (ja) 2015-10-29

Similar Documents

Publication Publication Date Title
KR101972199B1 (ko) 캐시처리된 데이터베이스 질의 결과의 업데이트
US9235620B2 (en) Updating cached database query results
CN104169950B (zh) 利用面向批处理的计算的数据库系统
US20160171008A1 (en) Updating cached database query results
US20130073586A1 (en) Database system using batch-oriented computation
US20200057918A1 (en) Systems and methods for training artificial intelligence to predict utilization of resources
US20040249682A1 (en) Filling a query cache for travel planning
EP2911070B1 (en) Long-term validity of pre-computed request results
EP3128441B1 (en) Handling data requests
US10956955B2 (en) Managing pre-computed search results
EP2698729B1 (en) Updating cached database query results
US20230108482A1 (en) System and method for large-scale accelerated parallel predictive modelling and control
EP3016000B1 (en) Managing pre-computed search results
CN107004026B (zh) 管理预先计算的搜索结果
CN119862988A (zh) 一种基于历史数据的民航客运运营指标预测方法与装置

Legal Events

Date Code Title Description
PA0105 International application

Patent event date: 20150216

Patent event code: PA01051R01D

Comment text: International Patent Application

PG1501 Laying open of application
A201 Request for examination
PA0201 Request for examination

Patent event code: PA02012R01D

Patent event date: 20150619

Comment text: Request for Examination of Application

E902 Notification of reason for refusal
PE0902 Notice of grounds for rejection

Comment text: Notification of reason for refusal

Patent event date: 20181015

Patent event code: PE09021S01D

E701 Decision to grant or registration of patent right
PE0701 Decision of registration

Patent event code: PE07011S01D

Comment text: Decision to Grant Registration

Patent event date: 20190404

GRNT Written decision to grant
PR0701 Registration of establishment

Comment text: Registration of Establishment

Patent event date: 20190418

Patent event code: PR07011E01D

PR1002 Payment of registration fee

Payment date: 20190418

End annual number: 3

Start annual number: 1

PG1601 Publication of registration
PR1001 Payment of annual fee

Payment date: 20220408

Start annual number: 4

End annual number: 4