ES2612260T3 - Mecanismo para actualizaciones en un motor de base de datos - Google Patents

Mecanismo para actualizaciones en un motor de base de datos Download PDF

Info

Publication number
ES2612260T3
ES2612260T3 ES12834563.4T ES12834563T ES2612260T3 ES 2612260 T3 ES2612260 T3 ES 2612260T3 ES 12834563 T ES12834563 T ES 12834563T ES 2612260 T3 ES2612260 T3 ES 2612260T3
Authority
ES
Spain
Prior art keywords
data structure
database
primary data
phase
tertiary
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
ES12834563.4T
Other languages
English (en)
Inventor
Marko NIKULA
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.)
RETAIL LOGISTICS EXCELLENCE - RELEX Oy
Original Assignee
RETAIL LOGISTICS EXCELLENCE - RELEX Oy
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
Application filed by RETAIL LOGISTICS EXCELLENCE - RELEX Oy filed Critical RETAIL LOGISTICS EXCELLENCE - RELEX Oy
Application granted granted Critical
Publication of ES2612260T3 publication Critical patent/ES2612260T3/es
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/21—Design, administration or maintenance of databases
    • G06F16/211—Schema design and 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/221—Column-oriented storage; Management thereof
    • 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

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)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Un método para manejar una base de datos electrónica, el método comprende las siguientes etapas realizadas por un ordenador servidor (200) para cada una de una o más columnas en cada una de una o más tablas: en una fase de preparación de base de datos: - asignar al menos una estructura primaria de datos (110), al menos una estructura secundaria de datos (120), y al menos una estructura terciaria de datos (130); en una fase de escritura de base de datos: - escribir contenido en columnas en un formato comprimido en la al menos una estructura primaria de datos (110); en una fase de actualización de base de datos: - escribir un valor actualizado para cada columna de cada fila actualizada en la al menos una estructura terciaria de datos (130) de la columna respectiva, junto con una clave de almacenamiento que indica una fila correspondiente en la al menos una estructura primaria de datos (110); en una fase de consulta de base de datos: - leer los valores actualizados y las claves de almacenamiento de la al menos una estructura terciaria de datos (130), clasificar los valores actualizados por sus claves de almacenamiento y almacenar los valores clasificados y las claves de almacenamiento en el orden clasificado en la al menos una estructura secundaria de datos (120), y limpiar la al menos una estructura terciaria de datos (130); - responder a una consulta de base de datos preguntando a la al menos una estructura primaria de datos (110) y a la al menos una estructura secundaria de datos (120); en una fase de confirmación de base de datos: - producir una versión nueva (110D) de la al menos una estructura primaria de datos (110) combinando la al menos una estructura secundaria de datos (120) y una versión antigua (110C) de la al menos una estructura primaria de datos; en donde la pregunta y la combinación comprenden leer un valor para una clave de almacenamiento de la al menos una estructura secundaria de datos (120) si el valor existe o de lo contrario de la al menos una estructura primaria de datos (110)

Description

imagen1
imagen2
imagen3
imagen4
imagen5

Claims (1)

  1. imagen1
    imagen2
    imagen3
ES12834563.4T 2011-09-22 2012-09-21 Mecanismo para actualizaciones en un motor de base de datos Active ES2612260T3 (es)

Applications Claiming Priority (3)

Application Number Priority Date Filing Date Title
FI20115932 2011-09-22
FI20115932A FI20115932A0 (fi) 2011-09-22 2011-09-22 Mekanismi päivityksiä varten tietokantamoottorissa
PCT/FI2012/050911 WO2013041774A2 (en) 2011-09-22 2012-09-21 Mechanism for updates in a database engine

Publications (1)

Publication Number Publication Date
ES2612260T3 true ES2612260T3 (es) 2017-05-16

Family

ID=44718837

Family Applications (1)

Application Number Title Priority Date Filing Date
ES12834563.4T Active ES2612260T3 (es) 2011-09-22 2012-09-21 Mecanismo para actualizaciones en un motor de base de datos

Country Status (5)

Country Link
US (1) US9171023B2 (es)
EP (1) EP2758901B1 (es)
ES (1) ES2612260T3 (es)
FI (1) FI20115932A0 (es)
WO (1) WO2013041774A2 (es)

Families Citing this family (26)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9805108B2 (en) 2010-12-23 2017-10-31 Mongodb, Inc. Large distributed database clustering systems and methods
US10346430B2 (en) 2010-12-23 2019-07-09 Mongodb, Inc. System and method for determining consensus within a distributed database
US10614098B2 (en) 2010-12-23 2020-04-07 Mongodb, Inc. System and method for determining consensus within a distributed database
US8996463B2 (en) 2012-07-26 2015-03-31 Mongodb, Inc. Aggregation framework system architecture and method
US10262050B2 (en) 2015-09-25 2019-04-16 Mongodb, Inc. Distributed database systems and methods with pluggable storage engines
US11615115B2 (en) 2010-12-23 2023-03-28 Mongodb, Inc. Systems and methods for managing distributed database deployments
US8572031B2 (en) 2010-12-23 2013-10-29 Mongodb, Inc. Method and apparatus for maintaining replica sets
US10713280B2 (en) 2010-12-23 2020-07-14 Mongodb, Inc. Systems and methods for managing distributed database deployments
US10977277B2 (en) 2010-12-23 2021-04-13 Mongodb, Inc. Systems and methods for database zone sharding and API integration
US11544288B2 (en) 2010-12-23 2023-01-03 Mongodb, Inc. Systems and methods for managing distributed database deployments
US10740353B2 (en) 2010-12-23 2020-08-11 Mongodb, Inc. Systems and methods for managing distributed database deployments
US9740762B2 (en) 2011-04-01 2017-08-22 Mongodb, Inc. System and method for optimizing data migration in a partitioned database
US10997211B2 (en) 2010-12-23 2021-05-04 Mongodb, Inc. Systems and methods for database zone sharding and API integration
US11544284B2 (en) 2012-07-26 2023-01-03 Mongodb, Inc. Aggregation framework system architecture and method
US10872095B2 (en) 2012-07-26 2020-12-22 Mongodb, Inc. Aggregation framework system architecture and method
US11403317B2 (en) 2012-07-26 2022-08-02 Mongodb, Inc. Aggregation framework system architecture and method
US9501516B2 (en) * 2014-12-19 2016-11-22 Sap Se Zero downtime upgrade of database applications using triggers and calculated fields
US9898494B2 (en) 2015-02-23 2018-02-20 Sap Se Zero downtime upgrade for database applications using tables with sequences
US10496669B2 (en) 2015-07-02 2019-12-03 Mongodb, Inc. System and method for augmenting consensus election in a distributed database
US10846411B2 (en) * 2015-09-25 2020-11-24 Mongodb, Inc. Distributed database systems and methods with encrypted storage engines
US10673623B2 (en) * 2015-09-25 2020-06-02 Mongodb, Inc. Systems and methods for hierarchical key management in encrypted distributed databases
US10671496B2 (en) 2016-05-31 2020-06-02 Mongodb, Inc. Method and apparatus for reading and writing committed data
US10621050B2 (en) 2016-06-27 2020-04-14 Mongodb, Inc. Method and apparatus for restoring data from snapshots
US10866868B2 (en) 2017-06-20 2020-12-15 Mongodb, Inc. Systems and methods for optimization of database operations
EP3547166B1 (en) * 2018-03-26 2020-12-02 Hasso-Plattner-Institut für Digital Engineering gGmbH Data placement in hybrid data layouts for tiered htap databases
CN109213817B (zh) * 2018-08-10 2019-09-06 杭州数梦工场科技有限公司 增量数据抽取方法、装置及服务器

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6718349B2 (en) 2000-12-14 2004-04-06 Borland Software Corporation Intelligent, optimistic concurrency database access scheme
US7251650B2 (en) * 2003-08-25 2007-07-31 International Business Machines Corporation Method, system, and article of manufacture for processing updates to insert operations
US20080059492A1 (en) * 2006-08-31 2008-03-06 Tarin Stephen A Systems, methods, and storage structures for cached databases
US20080120304A1 (en) 2006-11-21 2008-05-22 Calio Robert J Method and system for providing high performance data modification of relational database tables
US20090006399A1 (en) * 2007-06-29 2009-01-01 International Business Machines Corporation Compression method for relational tables based on combined column and row coding
US8108411B2 (en) * 2007-09-14 2012-01-31 Yahoo! Inc. Methods and systems for merging data sets
US8108356B2 (en) 2007-12-24 2012-01-31 Korea Advanced Institute Of Science And Technology Method for recovering data in a storage system
US8156084B2 (en) 2008-01-17 2012-04-10 International Business Machines Corporation Transfer of data from positional data sources to partitioned databases in restartable environments
US10152504B2 (en) 2009-03-11 2018-12-11 Actian Netherlands B.V. Column-store database architecture utilizing positional delta tree update system and methods
US8935223B2 (en) * 2009-04-30 2015-01-13 Oracle International Corporation Structure of hierarchical compressed data structure for tabular data
US9195657B2 (en) * 2010-03-08 2015-11-24 Microsoft Technology Licensing, Llc Columnar storage of a database index
US8868512B2 (en) * 2011-01-14 2014-10-21 Sap Se Logging scheme for column-oriented in-memory databases

Also Published As

Publication number Publication date
EP2758901B1 (en) 2016-11-02
WO2013041774A3 (en) 2013-05-23
US9171023B2 (en) 2015-10-27
EP2758901A4 (en) 2015-07-29
US20140258343A1 (en) 2014-09-11
EP2758901A2 (en) 2014-07-30
FI20115932A0 (fi) 2011-09-22
WO2013041774A2 (en) 2013-03-28

Similar Documents

Publication Publication Date Title
ES2612260T3 (es) Mecanismo para actualizaciones en un motor de base de datos
ES2612691T3 (es) Método y aparato portátil para buscar elementos de diferentes tipos
ATE536590T1 (de) Entitätsanzeigepriorität in einem verteilten geographischen informationssystem
CL2014000565A1 (es) Metodo para lectura de numeros de placa de matriculas por ocr que comprende grabar una imagen de un numero de placa en una primera y una segunda ubicacion, leer mediante ocr una cadena de caracteres de la placa y almacenar un conjunto de datos que incluye la imagen, la cadena de caracteres y al menos una medida de confianza en una base de datos, y si al menos una medida de confianza es menor a un valor minimo, utilizar un conjunto seleccionado para mejorar la cadena de caracteres actual
CO5730015A1 (es) Sistemas, metodos e interfaces que ofrecen la posibilidad de busquedas personalizadas y acceso a la informacion
WO2014035879A3 (en) Operating a distributed database with foreign tables
GB201318442D0 (en) A method for determining rules by providing data records in columnar data stru ctures
WO2006101633A3 (en) Apparatus and method for identifying asynchronous data in redundant data stores and for re-synchronizing same
JP2011510379A5 (es)
WO2007084791A3 (en) System and method for managing context-rich database
WO2012129152A3 (en) Annotating schema elements based associating data instances with knowledge base entities
BR112015012250A2 (pt) método e sistema para identificar defeitos em vidro
GB2509023A (en) Replication of data objects from a source server to a target server
EP2549233A3 (en) Method of operating a navigation system to provide geographic location information
WO2007009074A3 (en) Identifying locations
HK1133712A1 (en) Image updating method, server and system in an image data base
FR2943814B1 (fr) Procede de gestion d'une base de donnees relationnelle de type sql
JP2015011460A5 (ja) 電子機器、プログラム、および、検索システム、検索方法
Li et al. Inbound tourism–a bibliometric review of SSCI articles (1993–2021)
GB2463221A (en) Biological database index and query searching
CA2733961A1 (en) Apparatus for providing combination module data
JP2006164288A5 (es)
Nanba et al. Automatic extraction of event information from newspaper articles and web pages
JP2014059890A5 (es)
Keyvan Ara et al. Typology of plagiarism using the experiences of experts in Isfahan University of Medical Sciences, Iran