CA2882498C - Method and system of storing and retrieving data - Google Patents

Method and system of storing and retrieving data Download PDF

Info

Publication number
CA2882498C
CA2882498C CA2882498A CA2882498A CA2882498C CA 2882498 C CA2882498 C CA 2882498C CA 2882498 A CA2882498 A CA 2882498A CA 2882498 A CA2882498 A CA 2882498A CA 2882498 C CA2882498 C CA 2882498C
Authority
CA
Canada
Prior art keywords
data
cache
database
database systems
cache nodes
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
CA2882498A
Other languages
English (en)
French (fr)
Other versions
CA2882498A1 (en
Inventor
Jean-Charles Redoutey
Joel Singer
Florent Balard
Florian Prud'Homme
Romain Bouteloup
Colin Pitrat
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 claimed from US13/628,517 external-priority patent/US9037801B2/en
Priority claimed from EP12368027.4A external-priority patent/EP2713284B1/en
Application filed by Amadeus SAS filed Critical Amadeus SAS
Publication of CA2882498A1 publication Critical patent/CA2882498A1/en
Application granted granted Critical
Publication of CA2882498C publication Critical patent/CA2882498C/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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/23—Updating
    • G06F16/2379—Updates performed during online database operations; commit processing
    • 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/2455—Query execution
    • G06F16/24552—Database cache 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G06F16/275—Synchronous replication

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)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Memory System Of A Hierarchy Structure (AREA)
CA2882498A 2012-09-27 2013-09-04 Method and system of storing and retrieving data Active CA2882498C (en)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US13/628,517 2012-09-27
US13/628,517 US9037801B2 (en) 2012-09-27 2012-09-27 Method and system of storing and retrieving data
EP12368027.4 2012-09-27
EP12368027.4A EP2713284B1 (en) 2012-09-27 2012-09-27 Method and system of storing and retrieving data
PCT/EP2013/002655 WO2014048540A1 (en) 2012-09-27 2013-09-04 Method and system of storing and retrieving data

Publications (2)

Publication Number Publication Date
CA2882498A1 CA2882498A1 (en) 2014-04-03
CA2882498C true CA2882498C (en) 2020-11-17

Family

ID=49150900

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2882498A Active CA2882498C (en) 2012-09-27 2013-09-04 Method and system of storing and retrieving data

Country Status (8)

Country Link
JP (1) JP6511394B2 (enExample)
KR (1) KR101690288B1 (enExample)
CN (1) CN104662539B (enExample)
AU (1) AU2013324689B2 (enExample)
CA (1) CA2882498C (enExample)
IN (1) IN2015DN01332A (enExample)
SG (1) SG11201501650WA (enExample)
WO (1) WO2014048540A1 (enExample)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106846802B (zh) * 2017-02-09 2021-01-05 陕西公路交通科技开发咨询公司 一种高速路数据处理方法及装置
KR102415155B1 (ko) 2018-05-11 2022-06-29 삼성에스디에스 주식회사 데이터 검색 장치 및 방법
FR3081238A1 (fr) * 2018-05-17 2019-11-22 Amadeus S.A.S. Mise en memoire cache de base de donnees
FR3092920B1 (fr) * 2019-02-14 2022-04-01 Amadeus Traitement d’interrogations de base de données complexes
CN111125138B (zh) * 2019-12-26 2023-08-25 深圳前海环融联易信息科技服务有限公司 一种轮询查询数据的方法、装置、计算机设备及存储介质
SG10202008564PA (en) * 2020-09-03 2021-12-30 Grabtaxi Holdings Pte Ltd Data Base System and Method for Maintaining a Data Base
CN116521969B (zh) * 2023-02-28 2023-12-29 华为云计算技术有限公司 一种数据检索方法、服务端、系统及相关设备

Family Cites Families (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH08147201A (ja) * 1994-11-18 1996-06-07 Nippon Telegr & Teleph Corp <Ntt> トラヒックデータキャッシュ方法
US6256710B1 (en) * 1995-04-28 2001-07-03 Apple Computer, Inc. Cache management during cache inhibited transactions for increasing cache efficiency
US6067550A (en) * 1997-03-10 2000-05-23 Microsoft Corporation Database computer system with application recovery and dependency handling write cache
US6609126B1 (en) * 2000-11-15 2003-08-19 Appfluent Technology, Inc. System and method for routing database requests to a database and a cache
US7434000B1 (en) * 2004-06-30 2008-10-07 Sun Microsystems, Inc. Handling duplicate cache misses in a multithreaded/multi-core processor
US7415487B2 (en) * 2004-12-17 2008-08-19 Amazon Technologies, Inc. Apparatus and method for data warehousing
US8417680B2 (en) * 2005-12-02 2013-04-09 International Business Machines Corporation System for improving access efficiency in database and method thereof
CN101410836B (zh) * 2006-06-08 2012-05-30 国际商业机器公司 向应用提供对存储在数据库中的数据的访问的方法
US7711657B1 (en) * 2006-06-26 2010-05-04 Hewlett-Packard Development Company, L.P. Resource-reservation pricing structures based on expected ability to deliver
US8095618B2 (en) * 2007-03-30 2012-01-10 Microsoft Corporation In-memory caching of shared customizable multi-tenant data
JP5163171B2 (ja) * 2008-02-15 2013-03-13 日本電気株式会社 キャッシュシステムおよびサーバ
US8799409B2 (en) * 2009-01-15 2014-08-05 Ebay Inc. Server side data cache system
CN102103523A (zh) * 2009-12-22 2011-06-22 国际商业机器公司 锁分配控制的方法和装置

Also Published As

Publication number Publication date
JP6511394B2 (ja) 2019-05-15
CN104662539B (zh) 2018-02-23
WO2014048540A1 (en) 2014-04-03
AU2013324689A1 (en) 2015-04-09
IN2015DN01332A (enExample) 2015-07-03
AU2013324689B2 (en) 2016-07-07
SG11201501650WA (en) 2015-04-29
KR20150075407A (ko) 2015-07-03
CN104662539A (zh) 2015-05-27
CA2882498A1 (en) 2014-04-03
KR101690288B1 (ko) 2016-12-28
JP2015535995A (ja) 2015-12-17

Similar Documents

Publication Publication Date Title
US9037801B2 (en) Method and system of storing and retrieving data
CA2882498C (en) Method and system of storing and retrieving data
US12461939B2 (en) Directing requests to databases based on client account association
CN101278540B (zh) 用于保持旨在与大型数据库对接的多层软件系统中的缓存内容的一致性的系统和方法
KR101623663B1 (ko) 클라이언트/서버 시스템에서 분산된 복제 콘텐츠들의 강한 일관성을 유지하는 방법 및 시스템
US7587428B2 (en) Maintaining a relationship between two different items of data
US11520770B2 (en) System and method for providing high availability data
US20200081879A1 (en) Persistent data storage techniques
US20130074083A1 (en) System and method for handling storage events in a distributed data grid
US10776165B2 (en) Optimized database resource handling
Rys Scalable sql: How do large-scale sites and applications remain sql-based?
EP2713284B1 (en) Method and system of storing and retrieving data

Legal Events

Date Code Title Description
EEER Examination request

Effective date: 20180830