BR9810762A - Processo de realização em uma base de dados de uma mudança de esquema - Google Patents

Processo de realização em uma base de dados de uma mudança de esquema

Info

Publication number
BR9810762A
BR9810762A BR9810762-3A BR9810762A BR9810762A BR 9810762 A BR9810762 A BR 9810762A BR 9810762 A BR9810762 A BR 9810762A BR 9810762 A BR9810762 A BR 9810762A
Authority
BR
Brazil
Prior art keywords
schema
change
phase
schema change
database
Prior art date
Application number
BR9810762-3A
Other languages
English (en)
Inventor
Mikael Ronstr M Ulf
Original Assignee
Ericsson Telefon Ab L M
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 Ericsson Telefon Ab L M filed Critical Ericsson Telefon Ab L M
Publication of BR9810762A publication Critical patent/BR9810762A/pt

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
    • G06F16/213—Schema design and management with details for schema evolution support
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99941—Database schema or data structure
    • Y10S707/99943—Generating database or data structure, e.g. via user interface
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users
    • Y10S707/99953—Recoverability
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users
    • Y10S707/99954—Version management

Abstract

"PROCESSO DE REALIZAçãO EM UMA BASE DE DADOS DE UMA MUDANçA DE ESQUEMA". A presente invenção refere-se a um processo de realização de uma mudança de esquema dentro de uma base de dados, onde a mudança de esquema é uma mudança de esquema complicada, tal como uma mudança de esquema suave complicada, que resulta na compatibilidade de uma primeira versão de esquema, antes da mudança de esquema, com uma segunda versão de esquema, depois da mudança de esquema, ou uma mudança de esquema dura e complicada que torna uma primeira versão, de esquema, antes da mudança de esquema, incompatível com uma segunda versão de esquema depois de mudança de esquema. A execução de uma mudança de esquema é de acordo com o processo, dividida em um número de fases (1,2,3,4,5). De acordo com uma modalidade, uma mudança de esquema é dividida em três fases, uma fase preparatória (1), uma fase de varredura (2) e uma fase de encerramento (3). De acordo com outra modalidade, duas fases adicionais podem ser realizadas entre a fase de varredura (2) e a fase de encerramento (3). Essas fases adicionais são uma fase de avaliação (4) e uma fase de decisão (5).
BR9810762-3A 1997-07-21 1998-07-07 Processo de realização em uma base de dados de uma mudança de esquema BR9810762A (pt)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
SE9702763A SE521056C2 (sv) 1997-07-21 1997-07-21 Metod för genomförande av schemaförändringar i en databas
PCT/SE1998/001335 WO1999004351A2 (en) 1997-07-21 1998-07-07 Schema change within a data-base

Publications (1)

Publication Number Publication Date
BR9810762A true BR9810762A (pt) 2000-08-15

Family

ID=20407794

Family Applications (1)

Application Number Title Priority Date Filing Date
BR9810762-3A BR9810762A (pt) 1997-07-21 1998-07-07 Processo de realização em uma base de dados de uma mudança de esquema

Country Status (9)

Country Link
US (1) US6216136B1 (pt)
EP (1) EP0998713B1 (pt)
JP (1) JP4242056B2 (pt)
CN (1) CN100392643C (pt)
AU (1) AU8365398A (pt)
BR (1) BR9810762A (pt)
DE (1) DE69832386D1 (pt)
SE (1) SE521056C2 (pt)
WO (1) WO1999004351A2 (pt)

Families Citing this family (31)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7594167B1 (en) * 1998-10-16 2009-09-22 Open Invention Network, Llc System and method for schema evolution in an e-commerce network
US6460052B1 (en) * 1999-08-20 2002-10-01 Oracle Corporation Method and system for performing fine grain versioning
US7016906B1 (en) * 2000-05-04 2006-03-21 Unisys Corporation Data processing method and apparatus employing OLE DB and having dual schema and auto update features
US6993506B2 (en) 2000-12-05 2006-01-31 Jgr Acquisition, Inc. Method and device utilizing polymorphic data in e-commerce
CN1591406A (zh) * 2001-11-09 2005-03-09 无锡永中科技有限公司 集成多应用数据处理系统
US20030092438A1 (en) * 2001-11-14 2003-05-15 Moore Brian J. Method and apparatus for stabilizing calls during a system upgrade or downgrade
US7024434B2 (en) * 2002-11-01 2006-04-04 Microsoft Corporation Method and system for modifying schema definitions
US7103394B2 (en) * 2003-01-28 2006-09-05 Morphy William F Motorcycle audio system control device and method
US7844639B2 (en) * 2003-11-24 2010-11-30 Ebay Inc. Backward compatibility in database schemas
US7562357B2 (en) * 2004-03-08 2009-07-14 Microsoft Corporation Relational database schema version management
JP2005259057A (ja) * 2004-03-15 2005-09-22 Oki Electric Ind Co Ltd 更新履歴管理装置及び記録媒体
CN100461164C (zh) * 2004-03-29 2009-02-11 微软公司 用于基于版本控制的触发器的系统和方法
US20060155716A1 (en) * 2004-12-23 2006-07-13 Microsoft Corporation Schema change governance for identity store
US8037056B2 (en) 2005-02-18 2011-10-11 International Business Machines Corporation Online repair of a replicated table
US7376675B2 (en) * 2005-02-18 2008-05-20 International Business Machines Corporation Simulating multi-user activity while maintaining original linear request order for asynchronous transactional events
US8214353B2 (en) * 2005-02-18 2012-07-03 International Business Machines Corporation Support for schema evolution in a multi-node peer-to-peer replication environment
US9286346B2 (en) * 2005-02-18 2016-03-15 International Business Machines Corporation Replication-only triggers
SE529676C2 (sv) * 2006-03-02 2007-10-23 Abb Ab En metod för att utvärdera en applikation, ett automationssystem och en styrenhet
US20080059469A1 (en) * 2006-08-31 2008-03-06 International Business Machines Corporation Replication Token Based Synchronization
US8346725B2 (en) * 2006-09-15 2013-01-01 Oracle International Corporation Evolution of XML schemas involving partial data copy
US20080120323A1 (en) * 2006-11-17 2008-05-22 Lehman Brothers Inc. System and method for generating customized reports
CN105072552A (zh) * 2006-12-21 2015-11-18 Gn瑞声达A/S 具有用户接口的听力设备
US7925636B2 (en) * 2007-06-08 2011-04-12 Hewlett-Packard Development Company, L.P. Repository system and method
US8504593B2 (en) * 2007-06-29 2013-08-06 Microsoft Corporation Server directory schema comparator
US9275085B2 (en) * 2008-05-05 2016-03-01 Hewlett Packard Enterprise Development Lp Data processing system and method
EP2157517A1 (en) 2008-08-19 2010-02-24 Siemens Aktiengesellschaft A process and a system for updating a data structure in a relational database used within a manufacturing execution system
EP2336904A1 (en) * 2009-12-18 2011-06-22 Siemens Aktiengesellschaft A method for safeguarding the integrity of a relational database in case of structural transaction execution
US8244698B2 (en) * 2010-07-23 2012-08-14 Google Inc. Encoding a schema version in table names
JP5594120B2 (ja) 2010-12-17 2014-09-24 富士通株式会社 データ変換プログラム、データ変換装置およびデータ変換方法
US8832159B2 (en) 2012-05-22 2014-09-09 Google Inc. Systems and methods for asynchronous schema changes
US20230095852A1 (en) * 2021-09-29 2023-03-30 Amazon Technologies, Inc. Translating between versions of data object schemas for data producers and data consumers

Family Cites Families (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5442783A (en) * 1990-01-22 1995-08-15 Motorola, Inc. Method and apparatus for transferring data base information
TW226047B (pt) * 1990-03-27 1994-07-01 Ibm
US5873088A (en) * 1990-08-31 1999-02-16 Fujitsu Limited Derived data base processing system enabling one program to access a plurality of data basis
US5280612A (en) * 1991-11-26 1994-01-18 International Business Machines Corporation Multiple version database concurrency control system
US5410703A (en) * 1992-07-01 1995-04-25 Telefonaktiebolaget L M Ericsson System for changing software during computer operation
JP2863805B2 (ja) * 1993-11-26 1999-03-03 富士通株式会社 版数管理方式
JP3910221B2 (ja) * 1993-12-28 2007-04-25 株式会社日立製作所 オブジェクト指向データベース管理システム及び方法
JPH08202597A (ja) * 1995-01-24 1996-08-09 Nippon Telegr & Teleph Corp <Ntt> スキーマ変換機構編成方式
US5717924A (en) * 1995-07-07 1998-02-10 Wall Data Incorporated Method and apparatus for modifying existing relational database schemas to reflect changes made in a corresponding object model
US5794030A (en) * 1995-12-04 1998-08-11 Objectivity, Inc. System and method for maintenance and deferred propagation of schema changes to the affected objects in an object oriented database
US5765171A (en) * 1995-12-29 1998-06-09 Lucent Technologies Inc. Maintaining consistency of database replicas
US5850554A (en) * 1995-12-29 1998-12-15 Intel Corporation Compiler tool set for efficiently generating and easily managing multiple program versions of different types
US5950210A (en) * 1996-01-29 1999-09-07 Nelson; Paul M. Database row version differentiation process
SE509645C2 (sv) * 1996-02-08 1999-02-15 Ericsson Telefon Ab L M En metod för att samtidigt med protokollbaserad funktionsändring i en databas utföra verifiering av konverterad data
US5999947A (en) * 1997-05-27 1999-12-07 Arkona, Llc Distributing database differences corresponding to database change events made to a database table located on a server computer

Also Published As

Publication number Publication date
SE9702763D0 (sv) 1997-07-21
AU8365398A (en) 1999-02-10
SE9702763L (sv) 1999-01-22
JP2001510918A (ja) 2001-08-07
WO1999004351A2 (en) 1999-01-28
CN100392643C (zh) 2008-06-04
US6216136B1 (en) 2001-04-10
CN1271440A (zh) 2000-10-25
JP4242056B2 (ja) 2009-03-18
SE521056C2 (sv) 2003-09-23
DE69832386D1 (de) 2005-12-22
WO1999004351A3 (en) 1999-04-08
EP0998713B1 (en) 2005-11-16
EP0998713A2 (en) 2000-05-10

Similar Documents

Publication Publication Date Title
BR9810762A (pt) Processo de realização em uma base de dados de uma mudança de esquema
BR9807901A (pt) Composição cosmética e/ou dermatológica, processo de tratamento cosmético da pele e utilização de pelo menos um extrato de madeira vermelha ou de pelo menos um composto
BR0210998A (pt) Composição e processo para a tintura das fibras queratìnicas humanas, processo de tintura de oxidação das fibras queratìnicas humanas, dispositivo ou &#34;kit&#34; de tintura com vários compartimentos e compostos diazóicos dicatiÈnicos
BR9810587A (pt) Processo para produção de a-olefinas e composto
DE69516891T2 (de) Verfahren zum übersetzen von quellkode aus einer computer-hochsprache in eine andere
ATE369425T1 (de) Antikörper gegen eine lar-phosphatase untereinheit
BR0210995A (pt) Composição e processo de tintura das fibras queratìnicas, processo de tintura de oxidação das fibras queratìnicas, dispositivo ou kit de tintura com vários compartimentos e compostos diazóicos dicatiÈnicos
BR0204142A (pt) Composição para a tintura das fibras queratìnicas humanas, processo de tintura direta e processo de tintura de oxidação das fibras queratìnicas humanas, dispositivo ou &#34;kit&#34; de tintura com vários compartimentos para a tintura das fibras queratìnicas humanas, compostos monoazóicos monocatiÈnicos e seu uso
BR8905608A (pt) Processo de preparacao de um diorganopolissiloxano linear e produto
BR0306695A (pt) Processamento de tinta eletrônica
ATE228565T1 (de) Nukleinsäure, expressionsvektor und zusammensetzungen zur identifizierung und herstellung von rekombinanten sialyltransferasen
BR0007638A (pt) Processo para determinação pós-genÈmica de estruturas atÈmicas macromoleculares
BR0302227A (pt) Composição cosmética de não-lavagem, processo de tratamento das matérias queratìnicas e usos de uma composição
Mititelu Adding Morpho-semantic Relations to the Romanian Wordnet.
Clerc et al. Constrained analogs of KCVFM with improved inhibitory properties against farnesyl transferase
BR0115505A (pt) Integridade de base de dados em um ambiente de comércio eletrônico da internet
DK0570371T3 (da) Genomisk kortlægningmetode ved direkte haplotypebestemmelse ved anvendelse af intron sekvensanalyse
DE69802371D1 (de) Etikett, insbesondere für Behälter von kosmetischen Produkten
BR9806222A (pt) Composição cosmética e/ou dermatológica destinada ao tratamento das fibras queratìnicas, composição pronta para o uso, processo de tintura e de tratamento das fibras queratìnicas e dispositivos ou &#34;kit&#34; de tintura com vários compartimentos
DE69807485D1 (de) Verfahren und gerät zur konformationellen analyse von molekularfragmenten
BR9912541A (pt) Composição de tratamento de cabelo, processo de condicionamento de cabelo e produto acondicionado que compreende uma composição
Brasca Mixing methods in linguistic classification
Wilson On the existence of a nucleotide-binding regulatory site on brain hexokinase
Teresa Lollard Sources of ‘The Pore Caitif’
BR9811614A (pt) Processo para preparar um produto à base de vegetal ou fruta e produto à base de vegetal ou fruta

Legal Events

Date Code Title Description
B25A Requested transfer of rights approved

Free format text: MYSQL AB (SE)

B08F Application dismissed because of non-payment of annual fees [chapter 8.6 patent gazette]

Free format text: REFERENTE A 9A ANUIDADE.

B08K Patent lapsed as no evidence of payment of the annual fee has been furnished to inpi [chapter 8.11 patent gazette]