ES2723794T3 - Sistema de base de datos que usa informática orientada a lotes - Google Patents

Sistema de base de datos que usa informática orientada a lotes Download PDF

Info

Publication number
ES2723794T3
ES2723794T3 ES12818563T ES12818563T ES2723794T3 ES 2723794 T3 ES2723794 T3 ES 2723794T3 ES 12818563 T ES12818563 T ES 12818563T ES 12818563 T ES12818563 T ES 12818563T ES 2723794 T3 ES2723794 T3 ES 2723794T3
Authority
ES
Spain
Prior art keywords
platform
calculation
recalculation
batch
results
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
ES12818563T
Other languages
English (en)
Inventor
Rudy Daniello
Benoit Janin
Luc Isnardy
Claudine Reynaud
Jean-Philippe Aubry
Damien Ciabrini
Guillaume Legrand
Rémy GOLE
Nicolas Maillot
Charles-Antoine Robelin
Luc Viguie
Sébastien GIBERGUES
Marc Patoureaux
Bénédicte ISNARDON
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 EP12368012.6A external-priority patent/EP2657893A1/en
Priority claimed from EP12368020.9A external-priority patent/EP2698729B1/en
Priority claimed from US13/585,286 external-priority patent/US9235620B2/en
Application filed by Amadeus SAS filed Critical Amadeus SAS
Application granted granted Critical
Publication of ES2723794T3 publication Critical patent/ES2723794T3/es
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions
    • 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/25—Integrating or interfacing systems involving database management systems
    • 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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Finance (AREA)
  • Human Resources & Organizations (AREA)
  • Accounting & Taxation (AREA)
  • Marketing (AREA)
  • Databases & Information Systems (AREA)
  • General Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • Educational Administration (AREA)
  • Game Theory and Decision Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Un sistema de base de datos (1) que comprende una plataforma de cálculo (2) y una plataforma de búsqueda (3), y que comprende adicionalmente una plataforma de activación de recálculo (4), en el que - la plataforma de cálculo (2) está dispuesta para - recibir órdenes de recálculo por lotes desde la plataforma de activación de recálculo (4), dando instrucciones cada orden de recálculo por lotes a la plataforma de cálculo (2) para recalcular una porción de una pluralidad de resultados de consulta de base de datos precalculados, - procesar una orden de recálculo por lotes recalculando la porción de la pluralidad de resultados de consulta de base de datos precalculados de acuerdo con una planificación de procesamiento por lotes dentro de un marco de tiempo dado, en el que el marco de tiempo se indica en la orden de recálculo por lotes o se determina de manera autónoma por la plataforma de cálculo (2) o se negocia entre la plataforma de cálculo (2) y la plataforma de activación de recálculo (4), y en el que la planificación de procesamiento por lotes se configura por la plataforma de cálculo (2) después de haber analizado la orden de cálculo por lotes y teniendo en cuenta recursos de cálculo disponibles en la plataforma de cálculo (2), - devolver los resultados de consulta de base de datos recalculados resultantes de la orden de recálculo por lotes a tanto, la plataforma de búsqueda (3) como a la plataforma de activación de recálculo (4); - la plataforma de búsqueda (3) está dispuesta para - mantener la pluralidad de resultados de consulta de base de datos precalculados en una memoria (301) y - hacer la pluralidad de resultados de consulta de base de datos precalculados disponible para clientes conectados a la plataforma de búsqueda (3); y - la plataforma de activación de recálculo (4) está dispuesta para - recibir información de los recursos de cálculo disponibles en la plataforma de cálculo (2), - mantener datos de control que comprenden atributos de la pluralidad de resultados de consulta de base de datos precalculados para determinar probabilidades de que los resultados de consulta de base de datos precalculados estén desactualizados, - emitir la orden de recálculo por lotes a la plataforma de cálculo (2) con respecto a la porción de la pluralidad de resultados de consulta de base de datos precalculados que tienen una probabilidad superior de que estén desactualizados distintos de los resultados de consulta de base de datos precalculados de la pluralidad, estando limitada la porción de la pluralidad de resultados de consulta de base de datos precalculados por los recursos de cálculo disponibles en la plataforma de cálculo (2).
ES12818563T 2012-04-26 2012-11-06 Sistema de base de datos que usa informática orientada a lotes Active ES2723794T3 (es)

Applications Claiming Priority (5)

Application Number Priority Date Filing Date Title
US201261638733P 2012-04-26 2012-04-26
EP12368012.6A EP2657893A1 (en) 2012-04-26 2012-04-26 System and method of categorizing and ranking travel option search results
EP12368020.9A EP2698729B1 (en) 2012-08-14 2012-08-14 Updating cached database query results
US13/585,286 US9235620B2 (en) 2012-08-14 2012-08-14 Updating cached database query results
PCT/IB2012/002668 WO2013160721A1 (en) 2012-04-26 2012-11-06 Database system using batch-oriented computation

Publications (1)

Publication Number Publication Date
ES2723794T3 true ES2723794T3 (es) 2019-09-02

Family

ID=49482283

Family Applications (1)

Application Number Title Priority Date Filing Date
ES12818563T Active ES2723794T3 (es) 2012-04-26 2012-11-06 Sistema de base de datos que usa informática orientada a lotes

Country Status (9)

Country Link
EP (1) EP2842085B1 (es)
JP (1) JP6138915B2 (es)
KR (1) KR101916837B1 (es)
CN (1) CN104169950B (es)
AU (1) AU2012378631A1 (es)
CA (1) CA2864042C (es)
ES (1) ES2723794T3 (es)
SG (1) SG11201404704UA (es)
WO (1) WO2013160721A1 (es)

Families Citing this family (39)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US11687842B2 (en) * 2013-12-11 2023-06-27 Skyscanner Limited Method and server for providing fare availabilities, such as air fare availabilities
WO2015120968A1 (en) * 2014-02-13 2015-08-20 Amadeus S.A.S. Increasing search result validity
EP2908255B1 (en) * 2014-02-13 2018-07-25 Amadeus S.A.S. Increasing search result validity
US9984165B2 (en) 2014-02-13 2018-05-29 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
US10395294B2 (en) 2014-11-03 2019-08-27 Amadeus S.A.S. Managing pre-computed search results
ES2990104T3 (es) * 2014-11-03 2024-11-28 Amadeus Sas Gestión de resultados de búsqueda precalculados
CN107004026B (zh) * 2014-11-03 2020-09-22 艾玛迪斯简易股份公司 管理预先计算的搜索结果
CN104616155B (zh) * 2015-01-22 2017-04-19 上海找钢网信息科技股份有限公司 钢贸行业在线询价与抢单方法及系统
CN106503007B (zh) 2015-09-08 2019-07-23 阿里巴巴集团控股有限公司 数据库操作方法及装置
KR102238694B1 (ko) * 2015-10-26 2021-04-09 에스케이텔레콤 주식회사 일괄 처리 방식의 시스템에서의 실시간 데이터 처리 장치 및 방법
WO2017182803A1 (en) * 2016-04-19 2017-10-26 Skyscanner Limited Browsing methods, computer program products, servers and systems
US10084854B2 (en) 2016-04-22 2018-09-25 Google Llc Response latency reduction in fixed allocation content selection infrastructure
JP6629157B2 (ja) 2016-09-06 2020-01-15 株式会社東芝 システム
CN106383886B (zh) * 2016-09-21 2019-08-30 深圳市博瑞得科技有限公司 一种基于大数据分布式编程框架的大数据预统系统及方法
CN106844507B (zh) * 2016-12-27 2019-07-26 星环信息科技（上海）有限公司 一种数据批处理的方法及设备
WO2018172906A1 (ja) * 2017-03-18 2018-09-27 エコエコドライブ株式会社 行動管理方法、行動管理装置、並びに決済補助コンピュータ
FR3086412B1 (fr) * 2018-09-20 2020-10-30 Amadeus Sas Recalcul des resultats de recherche precalcules
CN109785083A (zh) * 2019-03-05 2019-05-21 深圳市活力天汇科技股份有限公司 一种国际机票扩展推荐方法
CN109977284B (zh) * 2019-03-18 2023-07-14 深圳市活力天汇科技股份有限公司 一种机票购买失败原因的诊断方法
CN109782241B (zh) * 2019-03-29 2021-01-29 北京润科通用技术有限公司 一种气象雷达回波模拟方法及系统
CN110021108B (zh) * 2019-04-03 2021-04-13 西安印钞有限公司 一种钞票冠字号码记录、追溯方法及系统
CN110955681B (zh) * 2019-10-14 2021-09-03 京东数字科技控股有限公司 一种信息处理方法、装置、电子设备及存储介质
CN110874768A (zh) * 2019-11-19 2020-03-10 中国民航信息网络股份有限公司 一种打包服务信息管理方法和系统
US11455312B1 (en) 2019-11-20 2022-09-27 Sabre Glbl Inc. Data query system with improved response time
US11204922B2 (en) 2020-01-13 2021-12-21 Google Llc Optimal query scheduling for resource utilization optimization
FR3106223B1 (fr) * 2020-01-13 2022-02-25 Looker Data Sciences Inc Programmation optimale de requêtes en fonction des exigences de fraîcheur de données
FR3106224B1 (fr) * 2020-01-13 2024-09-13 Looker Data Sciences Inc Programmation optimale de requêtes pour l’optimisation de l’utilisation de ressources
CN111639117B (zh) * 2020-05-26 2023-12-01 四川三江数智科技有限公司 基于数据加工的业务处理方法及装置
US11409740B2 (en) * 2020-08-10 2022-08-09 Google Llc Anticipatory pre-execution of data queries
KR102525918B1 (ko) * 2020-11-25 2023-04-26 네이버 주식회사 기계 학습을 이용한 응답 시간 예측을 통해 검색 시스템을 운영하는 방법 및 장치
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
US11341137B1 (en) 2020-12-04 2022-05-24 Amadeus S.A.S. Processing search requests
CN112925807A (zh) * 2021-03-12 2021-06-08 广州市百果园信息技术有限公司 面向数据库的请求的批处理方法、装置、设备及存储介质
US12393587B2 (en) 2021-04-08 2025-08-19 Xero Limited Systems and methods for scheduling information retrieval
EP4099180B1 (en) 2021-06-01 2025-09-17 Amadeus S.A.S. Precomputed cache validation
CN113918771B (zh) * 2021-09-08 2025-02-14 上海跬智信息技术有限公司 批流融合的信息处理方法和装置、存储介质
EP4430545A1 (en) * 2021-11-11 2024-09-18 Grup(ease), Llc Group travel resource contracting system, methods, and apparatuses

Family Cites Families (22)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5495606A (en) 1993-11-04 1996-02-27 International Business Machines Corporation System for parallel processing of complex read-only database queries using master and slave central processor complexes
US5822747A (en) 1996-08-23 1998-10-13 Tandem Computers, Inc. System and method for optimizing database queries
US5819255A (en) 1996-08-23 1998-10-06 Tandem Computers, Inc. System and method for database query optimization
US5924090A (en) * 1997-05-01 1999-07-13 Northern Light Technology Llc Method and apparatus for searching a database of records
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
EP1234268A2 (en) 1999-11-01 2002-08-28 ITA Software, Inc. Method and apparatus for providing availability of airline seats
KR100390929B1 (ko) * 2000-06-07 2003-07-10 주식회사 마이디지털 인터넷을 이용한 여행 상품 검색 시스템 및 이를 이용한여행 상품 추천 방법
US7668740B1 (en) 2000-09-22 2010-02-23 Ita Software, Inc. Method, system, and computer program product for interfacing with information sources
EP1349082A1 (en) * 2002-03-28 2003-10-01 LION Bioscience AG Method and apparatus for querying relational databases
US7089228B2 (en) 2002-04-18 2006-08-08 International Business Machines Corporation Computer apparatus and method for caching results of a database query
US20040078251A1 (en) * 2002-10-16 2004-04-22 Demarcken Carl G. Dividing a travel query into sub-queries
US8600963B2 (en) * 2003-08-14 2013-12-03 Google Inc. System and method for presenting multiple sets of search results for a single query
US20050108069A1 (en) 2003-11-18 2005-05-19 Tomer Shiran System and a method for prefetching travel information
US20050235001A1 (en) * 2004-03-31 2005-10-20 Nitzan Peleg Method and apparatus for refreshing materialized views
US7644107B2 (en) * 2004-09-30 2010-01-05 Microsoft Corporation System and method for batched indexing of network documents
US8589195B2 (en) * 2006-01-18 2013-11-19 Google Inc. Multi-passenger multi-route travel planning
WO2008086150A2 (en) 2007-01-05 2008-07-17 Ita Software, Inc. Providing travel information using a layered cache
US20080167906A1 (en) 2007-01-05 2008-07-10 De Marcken Carl Support for flexible travel planning
US20080262878A1 (en) 2007-04-17 2008-10-23 Travelocity.Com Lp Systems, methods, and computer program products for generating and updating a cache of price and availability information for travel packages and components
US20080301122A1 (en) * 2007-05-31 2008-12-04 Amadeus S.A.S. Searching techniques
US20100094856A1 (en) * 2008-10-14 2010-04-15 Eric Rodrick System and method for using a list capable search box to batch process search terms and results from websites providing single line search boxes

Also Published As

Publication number Publication date
JP2015520445A (ja) 2015-07-16
KR101916837B1 (ko) 2019-01-24
WO2013160721A1 (en) 2013-10-31
CN104169950A (zh) 2014-11-26
CA2864042A1 (en) 2013-10-31
CN104169950B (zh) 2017-12-01
KR20150013440A (ko) 2015-02-05
CA2864042C (en) 2019-12-10
AU2012378631A1 (en) 2014-11-13
EP2842085A1 (en) 2015-03-04
SG11201404704UA (en) 2014-10-30
EP2842085B1 (en) 2019-02-06
JP6138915B2 (ja) 2017-05-31

Similar Documents

Publication Publication Date Title
ES2723794T3 (es) Sistema de base de datos que usa informática orientada a lotes
CN106537429A8 (zh) 用于针对一个或多个建筑物提供优化或改进措施的系统和方法
Redding et al. Nonseptic diseases associated with the hoof complex: keratoma, white line disease, canker, and neoplasia.
WO2014074684A3 (en) Automated sample processing system
HK1223227A1 (zh) 紧急响应通知的方法和设备
BR112017002076A2 (pt) sistema e método para processo comandado por significado e gerenciamento de informação para melhoria da eficiência, da qualidade de trabalho e da satisfação do consumidor em geral
WO2014064053A3 (en) Healthcare system and method
WO2014210137A3 (en) Method, apparatus, and computer program product for providing mobile location based sales lead identification
AR095134A1 (es) Dispositivo informático, sistema y método relacionado con gráficos y tarjetas de actividad
MX2015017587A (es) Interpretacion de un conjunto de datos.
CN104871153B8 (zh) 用于分布式大规模并行处理数据库的方法和系统
JP2018517217A5 (es)
IL262779B (en) Method, communication system and computer program for providing information indicative of concentration of allergens in the environment
Gallo et al. Ion currents involved in gamete physiology.
BR112015003997A2 (pt) sistema e método para recuperar e processar metadados
US9116886B2 (en) Document translation including pre-defined term translator and translation model
GB201206932D0 (en) Comparing event data sets
PH12016500281A1 (en) Portable information processing device, test assistance system, and test assistance method
JP2016528599A5 (es)
Akinleye et al. Knowledge of malaria and preventive measures among pregnant women attending antenatal clinics in a rural local government area in Southwestern Nigeria.
KR20180084682A (ko) 이종 클러스터 시스템에서의 계산 처리 방법 및 이를 수행하기 위한 병렬 시스템
Arndt et al. HOW TO FIX THE AIRLINES The troubled industry needs a model that works. Here's a blueprint
Sokolov et al. Methodology and technic of intelligent integrated decision support systems development for territory management
Virtanya et al. Analysis of Bank Health Levels Through Pre-Pandemic and During Pandemic at PT. Bank Central Asia, Tbk for the Period 2018-2022 With a Risk-Based Bank Rating (RBBR) Approach.
Semyonov An integrated resource-based approach to port and terminal simulation modeling