SE521056C2 - Metod för genomförande av schemaförändringar i en databas - Google Patents
Metod för genomförande av schemaförändringar i en databasInfo
- Publication number
- SE521056C2 SE521056C2 SE9702763A SE9702763A SE521056C2 SE 521056 C2 SE521056 C2 SE 521056C2 SE 9702763 A SE9702763 A SE 9702763A SE 9702763 A SE9702763 A SE 9702763A SE 521056 C2 SE521056 C2 SE 521056C2
- Authority
- SE
- Sweden
- Prior art keywords
- schedule
- version
- change
- phase
- transactions
- 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/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)
Priority Applications (9)
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 |
DE69832386T DE69832386D1 (de) | 1997-07-21 | 1998-07-07 | Verfahren zum ändern von schemata für eine datenbank |
AU83653/98A AU8365398A (en) | 1997-07-21 | 1998-07-07 | Schema change method for a data-base |
PCT/SE1998/001335 WO1999004351A2 (en) | 1997-07-21 | 1998-07-07 | Schema change within a data-base |
EP98934049A EP0998713B1 (de) | 1997-07-21 | 1998-07-07 | Verfahren zum ändern von schemata für eine datenbank |
CNB988093413A CN100392643C (zh) | 1997-07-21 | 1998-07-07 | 数据库的模式改变方法 |
JP2000503496A JP4242056B2 (ja) | 1997-07-21 | 1998-07-07 | データベース用スキーマ変更方法 |
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 |
US09/115,905 US6216136B1 (en) | 1997-07-21 | 1998-07-15 | Method for performing complicated schema changes within a database |
Applications Claiming Priority (1)
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 |
Publications (3)
Publication Number | Publication Date |
---|---|
SE9702763D0 SE9702763D0 (sv) | 1997-07-21 |
SE9702763L SE9702763L (sv) | 1999-01-22 |
SE521056C2 true SE521056C2 (sv) | 2003-09-23 |
Family
ID=20407794
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
SE9702763A SE521056C2 (sv) | 1997-07-21 | 1997-07-21 | Metod för genomförande av schemaförändringar i en databas |
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)
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 |
US7325160B2 (en) * | 2001-11-09 | 2008-01-29 | Wuxi Evermore Software, Inc. | Data processing system with data recovery |
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 |
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 |
US9286346B2 (en) * | 2005-02-18 | 2016-03-15 | International Business Machines Corporation | Replication-only triggers |
US8037056B2 (en) * | 2005-02-18 | 2011-10-11 | International Business Machines Corporation | Online repair of a replicated table |
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)
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 |
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 |
US5765171A (en) * | 1995-12-29 | 1998-06-09 | Lucent Technologies Inc. | Maintaining consistency of database replicas |
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 |
-
1997
- 1997-07-21 SE SE9702763A patent/SE521056C2/sv unknown
-
1998
- 1998-07-07 BR BR9810762-3A patent/BR9810762A/pt not_active IP Right Cessation
- 1998-07-07 JP JP2000503496A patent/JP4242056B2/ja not_active Expired - Lifetime
- 1998-07-07 CN CNB988093413A patent/CN100392643C/zh not_active Expired - Lifetime
- 1998-07-07 AU AU83653/98A patent/AU8365398A/en not_active Abandoned
- 1998-07-07 DE DE69832386T patent/DE69832386D1/de not_active Expired - Lifetime
- 1998-07-07 EP EP98934049A patent/EP0998713B1/de not_active Expired - Lifetime
- 1998-07-07 WO PCT/SE1998/001335 patent/WO1999004351A2/en active IP Right Grant
- 1998-07-15 US US09/115,905 patent/US6216136B1/en not_active Expired - Lifetime
Also Published As
Publication number | Publication date |
---|---|
US6216136B1 (en) | 2001-04-10 |
DE69832386D1 (de) | 2005-12-22 |
WO1999004351A2 (en) | 1999-01-28 |
BR9810762A (pt) | 2000-08-15 |
JP4242056B2 (ja) | 2009-03-18 |
AU8365398A (en) | 1999-02-10 |
CN1271440A (zh) | 2000-10-25 |
EP0998713B1 (de) | 2005-11-16 |
SE9702763D0 (sv) | 1997-07-21 |
WO1999004351A3 (en) | 1999-04-08 |
SE9702763L (sv) | 1999-01-22 |
CN100392643C (zh) | 2008-06-04 |
EP0998713A2 (de) | 2000-05-10 |
JP2001510918A (ja) | 2001-08-07 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
SE521056C2 (sv) | Metod för genomförande av schemaförändringar i en databas | |
US8301589B2 (en) | System and method for assignment of unique identifiers in a distributed environment | |
CN100576208C (zh) | 用于提供对关系数据库表的高性能数据修改的方法和系统 | |
US5806075A (en) | Method and apparatus for peer-to-peer data replication | |
JP4414381B2 (ja) | ファイル管理プログラム、ファイル管理装置、ファイル管理方法 | |
AU770289B2 (en) | Method and apparatus for concurrent DBMS table operations | |
US6341308B1 (en) | Input/output device information management system for multi-computer system | |
US7117229B2 (en) | Method and system for online reorganization of databases | |
US6535869B1 (en) | Increasing efficiency of indexing random-access files composed of fixed-length data blocks by embedding a file index therein | |
US20060041598A1 (en) | Method and system of database management for replica database | |
US20070118547A1 (en) | Efficient index versioning in multi-version databases | |
CN102024015A (zh) | 用于批量删除数据库系统的数据记录的方法 | |
Jajodia | Managing replicated files in partitioned distributed database systems | |
CN101178724A (zh) | 临时表管理方法 | |
JP4311059B2 (ja) | トランザクション制御方法 | |
CN101763283A (zh) | 网格环境下的补偿事务自动产生方法 | |
Meyer | Basic infobase change | |
Dutcher | DOCLINE: a national automated interlibrary loan request routing and referral system | |
Dion | Reliable storage in a local network | |
CN101118501A (zh) | 基于网格的补偿事务自动产生方法 | |
JP4604666B2 (ja) | 入出力対象変更制御方法 | |
JPH04191934A (ja) | 機能別プログラム管理方法および装置 | |
Pillai et al. | Design issues and an architecture for a heterogenous multidatabase system | |
Nett | Supporting action management in heterogeneous distributed systems | |
JP2000222410A (ja) | シソーラス検索装置及びシソーラス検索システム |