CA2882498A1 - Methode et systeme de stockage et de recuperation de donnees - Google Patents

Methode et systeme de stockage et de recuperation de donnees Download PDF

Info

Publication number
CA2882498A1
CA2882498A1 CA2882498A CA2882498A CA2882498A1 CA 2882498 A1 CA2882498 A1 CA 2882498A1 CA 2882498 A CA2882498 A CA 2882498A CA 2882498 A CA2882498 A CA 2882498A CA 2882498 A1 CA2882498 A1 CA 2882498A1
Authority
CA
Canada
Prior art keywords
data
cache
database
software application
database systems
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.)
Granted
Application number
CA2882498A
Other languages
English (en)
Other versions
CA2882498C (fr
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/fr
Application filed by Amadeus SAS filed Critical Amadeus SAS
Publication of CA2882498A1 publication Critical patent/CA2882498A1/fr
Application granted granted Critical
Publication of CA2882498C publication Critical patent/CA2882498C/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/23—Updating
    • G06F16/2379—Updates performed during online database operations; commit processing
    • 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
    • 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/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)

Abstract

L'invention concerne une méthode et un système de stockage de données par une application logicielle. Dans un système de stockage de données comprenant un ou plusieurs systèmes de base de données et au moins un nud cache, l'application logicielle interface indépendamment le ou les systèmes de base de données sur une première interface dédiée et ledit nud cache sur une deuxième interface dédiée. La méthode et le système sont caractérisés en ce que : chaque requête de lecture du système de stockage de données par l'application logicielle est d'abord envoyée uniquement à la pluralité de nuds caches qui renvoie les données demandées si elles sont disponibles. Si elles ne sont pas disponibles, l'application logicielle reçoit une recherche infructueuse qui déclenche une extraction des données demandées dans le ou les systèmes de base de données. Lorsque les données demandées sont récupérées, l'application logicielle ajoute les données demandées à au moins un nud cache. La méthode et le système sont de plus caractérisés en ce que chaque écriture du ou des systèmes de base de données par l'application logicielle est aussi effectuée simultanément dans ledit nud cache. Ainsi, le peuplement dudit nud cache est effectué rapidement à chaque requête de lecture infructueuse dudit nud cache et à chaque requête d'écriture du système de stockage de données.
CA2882498A 2012-09-27 2013-09-04 Methode et systeme de stockage et de recuperation de donnees Active CA2882498C (fr)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
EP12368027.4 2012-09-27
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.4A EP2713284B1 (fr) 2012-09-27 2012-09-27 Procédé et système de stockage et de récupération de données
PCT/EP2013/002655 WO2014048540A1 (fr) 2012-09-27 2013-09-04 Méthode et système de stockage et de récupération de données

Publications (2)

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

Family

ID=49150900

Family Applications (1)

Application Number Title Priority Date Filing Date
CA2882498A Active CA2882498C (fr) 2012-09-27 2013-09-04 Methode et systeme de stockage et de recuperation de donnees

Country Status (8)

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

Families Citing this family (6)

* 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
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
US20090204583A1 (en) * 2006-06-08 2009-08-13 International Business Machines Corporation Method for providing access to data stored in a database to an application
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
IN2015DN01332A (fr) 2015-07-03
WO2014048540A1 (fr) 2014-04-03
SG11201501650WA (en) 2015-04-29
CA2882498C (fr) 2020-11-17
KR20150075407A (ko) 2015-07-03
AU2013324689B2 (en) 2016-07-07
KR101690288B1 (ko) 2016-12-28
CN104662539A (zh) 2015-05-27
JP6511394B2 (ja) 2019-05-15
CN104662539B (zh) 2018-02-23
JP2015535995A (ja) 2015-12-17
AU2013324689A1 (en) 2015-04-09

Similar Documents

Publication Publication Date Title
US9037801B2 (en) Method and system of storing and retrieving data
CA2882498C (fr) Methode et systeme de stockage et de recuperation de donnees
US11520770B2 (en) System and method for providing high availability data
KR101623663B1 (ko) 클라이언트/서버 시스템에서 분산된 복제 콘텐츠들의 강한 일관성을 유지하는 방법 및 시스템
US20230267131A1 (en) Managing database failover based on transaction request time
US20200081879A1 (en) Persistent data storage techniques
US7587428B2 (en) Maintaining a relationship between two different items of data
EP2169909B1 (fr) Système et procédé pour conserver la cohérence de contenus de cache
Rys Scalable sql: How do large-scale sites and applications remain sql-based?
US20130074083A1 (en) System and method for handling storage events in a distributed data grid
US20190354407A1 (en) Optimized Database Resource Handling
EP2713284B1 (fr) Procédé et système de stockage et de récupération de données
US20020152103A1 (en) High availability planning and scheduling architecture
Forsythe et al. A Four-Tier Model of A Web-Based Book-Buying System

Legal Events

Date Code Title Description
EEER Examination request

Effective date: 20180830