[go: up one dir, main page]

MX2019004025A - Sistemas y metodos para sincronizar un esquema de base de datos. - Google Patents

Sistemas y metodos para sincronizar un esquema de base de datos.

Info

Publication number
MX2019004025A
MX2019004025A MX2019004025A MX2019004025A MX2019004025A MX 2019004025 A MX2019004025 A MX 2019004025A MX 2019004025 A MX2019004025 A MX 2019004025A MX 2019004025 A MX2019004025 A MX 2019004025A MX 2019004025 A MX2019004025 A MX 2019004025A
Authority
MX
Mexico
Prior art keywords
database
systems
methods
source
generated
Prior art date
Application number
MX2019004025A
Other languages
English (en)
Inventor
Ledbetter Joshua
Bryan AUSTIN Daniel
Original Assignee
Walmart Apollo Llc
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 Walmart Apollo Llc filed Critical Walmart Apollo Llc
Publication of MX2019004025A publication Critical patent/MX2019004025A/es

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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • 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/21—Design, administration or maintenance of databases
    • G06F16/211—Schema design and management
    • G06F16/213—Schema design and management with details for schema evolution support
    • 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

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

Abstract

Se describen los métodos y sistemas para sincronizar el esquema de base de datos (o estructura de datos) de una base de datos fuente hacia una base de datos objetivo. Se genera una definición de estructura de datos fuente, lo que incluye definiciones de cada objeto en la estructura de base de datos fuente. Se genera una estructura de base de datos objetivo, lo que incluye definiciones de cada objeto en la estructura de base de datos fuente. Las definiciones objeto se comparan entre la estructura de base de datos fuente y la estructura de base de datos objeto. Se genera una secuencia de instrucción de cambio de lenguaje de definición de datos que, cuando se ejecuta, modificará la estructura de la base de datos objetivo para que corresponda con la definición de la estructura de datos. La secuencia de instrucción de cambio se ejecuta en la base de datos objetivo.
MX2019004025A 2016-10-05 2017-10-04 Sistemas y metodos para sincronizar un esquema de base de datos. MX2019004025A (es)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US201662404349P 2016-10-05 2016-10-05
PCT/US2017/055017 WO2018067624A1 (en) 2016-10-05 2017-10-04 Systems and methods for synchronizing database schema

Publications (1)

Publication Number Publication Date
MX2019004025A true MX2019004025A (es) 2019-08-05

Family

ID=61758146

Family Applications (1)

Application Number Title Priority Date Filing Date
MX2019004025A MX2019004025A (es) 2016-10-05 2017-10-04 Sistemas y metodos para sincronizar un esquema de base de datos.

Country Status (3)

Country Link
US (1) US10540371B2 (es)
MX (1) MX2019004025A (es)
WO (1) WO2018067624A1 (es)

Families Citing this family (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
MX2019001175A (es) 2016-07-27 2019-11-18 Walmart Apollo Llc Instalacion de motor informix automatizado.
US11182357B2 (en) 2016-09-16 2021-11-23 Walmart Apollo, Llc Auto top off tool
US10824968B2 (en) * 2017-02-24 2020-11-03 Sap Se Transformation of logical data object instances and updates to same between hierarchical node schemas
CA2999581A1 (en) 2017-03-28 2018-09-28 Walmart Apollo, Llc Systems and methods for computer assisted database change documentation
US10929384B2 (en) 2017-08-16 2021-02-23 Walmart Apollo, Llc Systems and methods for distributed data validation
US10732948B2 (en) * 2017-12-01 2020-08-04 Jpmorgan Chase Bank, N.A. System and method for implementing automated deployment
US11120047B1 (en) * 2018-08-22 2021-09-14 Gravic, Inc. Method and apparatus for continuously comparing two databases which are actively being kept synchronized
US11204940B2 (en) * 2018-11-16 2021-12-21 International Business Machines Corporation Data replication conflict processing after structural changes to a database
US11599644B2 (en) 2019-05-17 2023-03-07 Walmart Apollo, Llc Blocking insecure code with locking
CN112925849A (zh) * 2021-02-25 2021-06-08 北京金风慧能技术有限公司 数据库同步的方法、装置、电子设备及计算机存储介质
US12298993B2 (en) * 2021-06-25 2025-05-13 Sap Se Metadata synchronization for cross system data curation
US12248459B2 (en) * 2021-11-11 2025-03-11 Sigma Computing, Inc. Versioning in editable tables
US12197458B1 (en) 2021-11-11 2025-01-14 Sigma Computing, Inc. Generating edited input tables for low-latency presentation
US12481671B2 (en) 2021-11-11 2025-11-25 Sigma Computing, Inc. Editing data-warehouse tables using managed input tables

Family Cites Families (27)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5684990A (en) 1995-01-11 1997-11-04 Puma Technology, Inc. Synchronization of disparate databases
US5745753A (en) 1995-01-24 1998-04-28 Tandem Computers, Inc. Remote duplicate database facility with database replication support for online DDL operations
US6212530B1 (en) 1998-05-12 2001-04-03 Compaq Computer Corporation Method and apparatus based on relational database design techniques supporting modeling, analysis and automatic hypertext generation for structured document collections
US6453322B1 (en) * 1999-07-19 2002-09-17 International Business Machines Corporation Extension of data definition language (DDL) capabilities for relational databases for applications issuing multiple units of work
US6490590B1 (en) 2000-02-14 2002-12-03 Ncr Corporation Method of generating a logical data model, physical data model, extraction routines and load routines
US6681383B1 (en) 2000-04-04 2004-01-20 Sosy, Inc. Automatic software production system
US8589346B2 (en) 2011-04-26 2013-11-19 Oracle International Corporation Techniques for combining statement level, procedural, and row level replication
US20050149582A1 (en) 2003-12-29 2005-07-07 Wissmann Joseph T. Method and system for synchronization of copies of a database
US20050197807A1 (en) 2004-03-04 2005-09-08 Jerimy Nelson System and method for maintaining homogeneity between a model in a computer-aided modeling system and corresponding model documentation
US7809763B2 (en) * 2004-10-15 2010-10-05 Oracle International Corporation Method(s) for updating database object metadata
FR2888018A1 (fr) 2005-07-01 2007-01-05 Medience Sa Procede et systeme de realisation d'une base de donnees virtuelle a partir de sources de donnees presentant des schemas heterogenes
US7730028B2 (en) 2006-09-22 2010-06-01 Research In Motion Limited Schema updating for synchronizing databases connected by wireless interface
US8176475B2 (en) * 2006-10-31 2012-05-08 Oracle America, Inc. Method and apparatus for identifying instructions associated with execution events in a data space profiler
US7603339B2 (en) 2006-11-16 2009-10-13 Oracle International Corporation Merging synopses to determine number of distinct values in large databases
US8909599B2 (en) 2006-11-16 2014-12-09 Oracle International Corporation Efficient migration of binary XML across databases
US20080168081A1 (en) 2007-01-09 2008-07-10 Microsoft Corporation Extensible schemas and party configurations for edi document generation or validation
US7953744B2 (en) 2009-01-28 2011-05-31 International Business Machines Corporation Database change verifier
US20110185136A1 (en) 2010-01-22 2011-07-28 Microsoft Corporation Moving large dynamic datasets via incremental change synchronization
US8924398B2 (en) * 2011-03-23 2014-12-30 Bmc Software, Inc. Log-based DDL generation
US9430505B2 (en) 2011-04-18 2016-08-30 Infosys Limited Automated data warehouse migration
US20130117232A1 (en) 2011-11-09 2013-05-09 Microsoft Corporation Snapshots of database models
WO2014101207A1 (en) 2012-12-31 2014-07-03 Sybase, Inc. Continuous change data capture without disruption of ddl
WO2014144889A2 (en) 2013-03-15 2014-09-18 Amazon Technologies, Inc. Scalable analysis platform for semi-structured data
US9171051B2 (en) 2013-07-24 2015-10-27 Oracle International Corporation Data definition language (DDL) expression annotation
US9367597B2 (en) 2013-11-18 2016-06-14 International Business Machines Corporation Automatically managing mapping and transform rules when synchronizing systems
US11182357B2 (en) 2016-09-16 2021-11-23 Walmart Apollo, Llc Auto top off tool
US10929384B2 (en) 2017-08-16 2021-02-23 Walmart Apollo, Llc Systems and methods for distributed data validation

Also Published As

Publication number Publication date
WO2018067624A1 (en) 2018-04-12
US10540371B2 (en) 2020-01-21
US20180096043A1 (en) 2018-04-05

Similar Documents

Publication Publication Date Title
MX2019004025A (es) Sistemas y metodos para sincronizar un esquema de base de datos.
BR112017026670A2 (pt) sistema e método para fornecer informações contextuais para uma localização
MX392418B (es) Poda parcial/total cuando se añade un candidato a hmvp para fusión/amvp.
IN2013CH05115A (es)
CO2017007032A2 (es) Actualización de modelos de clasificador de entendimiento de lenguaje para un asistente digital personal basándose en externalización masiva
MX2018004690A (es) Expansion de respuestas de recursos.
MX2017007035A (es) Metodo para reconocimiento de texto y producto de programa de computadora.
CL2018000799A1 (es) Método y sistema para asignar tareas a equipos mineros y/o de contrucción
CO2017011544A2 (es) Sistema y método para extraer y compartir datos de usuario relacionados con la aplicación
MX395127B (es) Ensamble de retencion.
MX361586B (es) Un sistema y método para la personalización de diálogo.
BR112018014237A2 (pt) interface do usuário para pesquisa multivariada
MX2016009297A (es) Plantillas de busqueda por el cliente para redes sociales en linea.
AR103725A1 (es) Terminaciones integradas de pozos
MX2017012016A (es) Comunicaciones de usuario con un comerciante a traves de un sistema de red social.
CR20150552A (es) Entorno de aprendizaje de idiomas
GT201600202A (es) Métodos y aparato para la coordinación de la selección del sistema entre un conjunto de nodos
MX2016004097A (es) Metodos, dispositivos y sistemas para manejar datos de calendario.
MX364426B (es) Sistema y procedimiento de enmascaramiento basado en preservación de formatos.
MX2020007346A (es) Metodo de configuracion de la seccion de red, primer elemento de red y segundo elemento de red.
AR101678A1 (es) Dispositivo de procesamiento de información, método de procesamiento de información y medio de almacenamiento legible por computadora no transitorio de almacenamiento de programa
AR100543A1 (es) Mejora del desempeño de levantamiento de pozos
CO2019011941A2 (es) Sistemas y métodos para optimización de consulta e índice para recuperar datos en casos de una estructura de datos de formulación desde una base de datos
AR095134A1 (es) Dispositivo informático, sistema y método relacionado con gráficos y tarjetas de actividad
AR098046A1 (es) Orientación de las herramientas de fondo de pozo