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
- database schema
- Prior art date
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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- 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
- G06F16/213—Schema design and management with details for schema evolution support
-
- 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
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.
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 (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2018022707A1 (en) | 2016-07-27 | 2018-02-01 | Wal-Mart Stores, Inc. | Automated informix engine install |
| WO2018053117A1 (en) | 2016-09-16 | 2018-03-22 | Wal-Mart Stores, Inc. | 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 |
| 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 |
Family Cites Families (27)
| 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 |
| US8909599B2 (en) | 2006-11-16 | 2014-12-09 | Oracle International Corporation | Efficient migration of binary XML across databases |
| US7603339B2 (en) | 2006-11-16 | 2009-10-13 | Oracle International Corporation | Merging synopses to determine number of distinct values in large 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 |
| US9305070B2 (en) * | 2012-12-31 | 2016-04-05 | Sybase, Inc. | Continuous change data capture without disruption of DDL |
| CN105122243B (zh) | 2013-03-15 | 2019-02-12 | 亚马逊科技公司 | 用于半结构化数据的可扩展分析平台 |
| 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 |
| WO2018053117A1 (en) | 2016-09-16 | 2018-03-22 | Wal-Mart Stores, Inc. | Auto top off tool |
| US10929384B2 (en) | 2017-08-16 | 2021-02-23 | Walmart Apollo, Llc | Systems and methods for distributed data validation |
-
2017
- 2017-10-04 US US15/724,333 patent/US10540371B2/en active Active
- 2017-10-04 WO PCT/US2017/055017 patent/WO2018067624A1/en active Application Filing
- 2017-10-04 MX MX2019004025A patent/MX2019004025A/es unknown
Also Published As
| Publication number | Publication date |
|---|---|
| US20180096043A1 (en) | 2018-04-05 |
| WO2018067624A1 (en) | 2018-04-12 |
| US10540371B2 (en) | 2020-01-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| MX2019004025A (es) | Sistemas y metodos para sincronizar un esquema de base de datos. | |
| MX2018008104A (es) | Identificacion de entidades utilizando un modelo de aprendizaje profundo. | |
| MX2017003189A (es) | Metodos de gestion de salud y bienestar y sistemas utiles para la practica de los mismos. | |
| EP3545435A4 (en) | DATABASE SYSTEM AND METHOD FOR COMPILING SERIAL AND PARALLEL DATABASE INSPECTION PLANS | |
| SG10201903485WA (en) | Querying a data source on a network | |
| MX2022004253A (es) | Procesamiento coordinado de datos por medio de recursos de computacion interconectados. | |
| MY179952A (en) | Graph generating device, graph generating method and graph generating program | |
| IN2013CH05115A (es) | ||
| EP3398091A4 (en) | System, method, and device for unified access control on federated database | |
| SG10201610585WA (en) | Passsword management system and process | |
| GB2542053A (en) | Automatically generating a semantic mapping for a relational database | |
| GB2571841A (en) | Automated mutual improvement of oilfield models | |
| GB2541616A (en) | Data processing system and method for financial or non-financial data | |
| GB2538370A (en) | Designing wellbore completion intervals | |
| EP3341865A4 (en) | System and method for database query | |
| GB201309785D0 (en) | Methods and systems for providing real-time information regarding objects in a network | |
| TW201614480A (en) | Dynamical operation environment adjustment system based on operational tasks and method therefor | |
| EP3408765A4 (en) | METHOD AND SYSTEM FOR GENERATING A SYNTHETIC DATABASE FROM POSES AND GESTURES | |
| CA2912019C (en) | Systems and methods for generating issue networks | |
| TW201614439A (en) | Touch system, stylus, touch apparatus and control method thereof | |
| GB2527230A (en) | Processing seismic attributes using mathematical morphology | |
| MX2015008936A (es) | Metodos y sistemas informaticos para la colaboracion petrotecnica y de geociencia. | |
| IL230969B (en) | A network-based system and method for influence | |
| MX2018001020A (es) | Plataforma para calificar y compartir datos especificos de rutas. | |
| TW201614530A (en) | Method for modeling a photoresist profile |