DE69832386D1 - Verfahren zum ändern von schemata für eine datenbank - Google Patents

Verfahren zum ändern von schemata für eine datenbank

Info

Publication number
DE69832386D1
DE69832386D1 DE69832386T DE69832386T DE69832386D1 DE 69832386 D1 DE69832386 D1 DE 69832386D1 DE 69832386 T DE69832386 T DE 69832386T DE 69832386 T DE69832386 T DE 69832386T DE 69832386 D1 DE69832386 D1 DE 69832386D1
Authority
DE
Germany
Prior art keywords
database
schemes
modifying
modifying schemes
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.)
Expired - Lifetime
Application number
DE69832386T
Other languages
English (en)
Inventor
Mikael Ronstroem
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.)
MySQL AB
Original Assignee
MySQL AB
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 MySQL AB filed Critical MySQL AB
Application granted granted Critical
Publication of DE69832386D1 publication Critical patent/DE69832386D1/de
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

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

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)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
DE69832386T 1997-07-21 1998-07-07 Verfahren zum ändern von schemata für eine datenbank Expired - Lifetime DE69832386D1 (de)

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
DE69832386D1 true DE69832386D1 (de) 2005-12-22

Family

ID=20407794

Family Applications (1)

Application Number Title Priority Date Filing Date
DE69832386T Expired - Lifetime DE69832386D1 (de) 1997-07-21 1998-07-07 Verfahren zum ändern von schemata für eine datenbank

Country Status (9)

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

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
CN100461158C (zh) * 2001-11-09 2009-02-11 无锡永中科技有限公司 一种使用应用程序处理数据的方法
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 更新履歴管理装置及び記録媒体
JP4647653B2 (ja) * 2004-03-29 2011-03-09 マイクロソフト コーポレーション バージョニングをベースとするトリガのためのシステムおよび方法
US20060155716A1 (en) * 2004-12-23 2006-07-13 Microsoft Corporation Schema change governance for identity store
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
US8037056B2 (en) * 2005-02-18 2011-10-11 International Business Machines Corporation Online repair of a replicated table
US9286346B2 (en) * 2005-02-18 2016-03-15 International Business Machines Corporation Replication-only triggers
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
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 (de) * 2008-08-19 2010-02-24 Siemens Aktiengesellschaft Verfahren und System zur Aktualisierung einer Datenstruktur in einer Bezugsdatenbank in einem Herstellungsausführungssystem
EP2336904A1 (de) 2009-12-18 2011-06-22 Siemens Aktiengesellschaft Verfahren zum Schützen der Integrität einer Bezugsdatenbank im Fall einer strukturellen Transaktionsausführung
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 (de) * 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
WO1999004351A3 (en) 1999-04-08
EP0998713A2 (de) 2000-05-10
SE521056C2 (sv) 2003-09-23
EP0998713B1 (de) 2005-11-16
AU8365398A (en) 1999-02-10
WO1999004351A2 (en) 1999-01-28
SE9702763L (sv) 1999-01-22
BR9810762A (pt) 2000-08-15
CN1271440A (zh) 2000-10-25
CN100392643C (zh) 2008-06-04
US6216136B1 (en) 2001-04-10
JP2001510918A (ja) 2001-08-07
SE9702763D0 (sv) 1997-07-21
JP4242056B2 (ja) 2009-03-18

Similar Documents

Publication Publication Date Title
DE69832386D1 (de) Verfahren zum ändern von schemata für eine datenbank
DE69517526D1 (de) Verfahren zum zusammenfügen von elastischen teilen
DE69422406T2 (de) Verfahren zum Durchführen eines Vergleichs von Datenketten
DE69621670D1 (de) Verfahren zum Datenzugriff in einer Datenbasis
DE69719805D1 (de) Verfahren zum erzeugen von elastischen höckern
DE69826283D1 (de) Verfahren zum bewahren von elementen in einer datenbank
DE69421206D1 (de) Verfahren zum installieren von Klammern
DE69738832D1 (de) Verfahren zum Planen von periodischen Prozessabläufen
DE69514809D1 (de) Verfahren zum reparieren von substraten
DE19780228T1 (de) Verfahren zum Aktualisieren von Programm-Code in einem Kommunikationssystem
DE69839604D1 (de) Verfahren und system zum durchsuchen einer datenbank
DE69739969D1 (de) Verfahren zum verstecken von daten
DE69508921D1 (de) Verfahren zum nachweis von staphylokokken
DE69430367T2 (de) Verfahren zum formen von heftklammern
DE69519733D1 (de) Verfahren zum zerkleinern von hydroxypropylmethylcellulose
DE69702016T2 (de) Verfahren zum Ersetzen von Datenblöcken
DE69733300D1 (de) Verfahren zum Lesen eines Strichkodes
DE59706527D1 (de) Verfahren zum sortieren von sendungen
DE69730979D1 (de) Verfahren zum entwerfen von luftreifen
DE59812633D1 (de) Verfahren zum Verbinden von Bauteilen
DE69522828D1 (de) Verfahren zum entmetallieren von raffinerieeizätzen
ATE230667T1 (de) Verfahren zum verschweissen von kunststoffteilen
DE59604614D1 (de) Verfahren zum ausbessern von beschichtungsfehlern
DE59902804D1 (de) Verfahren zum vergleichen von punktmengen
DE69615578T2 (de) Verfahren zum schweissverbinden von zwei elementen

Legal Events

Date Code Title Description
8332 No legal effect for de