JP4497691B2 - データベース管理方法及び管理システム - Google Patents

データベース管理方法及び管理システム Download PDF

Info

Publication number
JP4497691B2
JP4497691B2 JP2000294551A JP2000294551A JP4497691B2 JP 4497691 B2 JP4497691 B2 JP 4497691B2 JP 2000294551 A JP2000294551 A JP 2000294551A JP 2000294551 A JP2000294551 A JP 2000294551A JP 4497691 B2 JP4497691 B2 JP 4497691B2
Authority
JP
Japan
Prior art keywords
data
master
replica
master table
join
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 - Fee Related
Application number
JP2000294551A
Other languages
English (en)
Japanese (ja)
Other versions
JP2002108681A5 (https=
JP2002108681A (ja
Inventor
弘 横内
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.)
Hitachi Ltd
Original Assignee
Hitachi Ltd
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 Hitachi Ltd filed Critical Hitachi Ltd
Priority to JP2000294551A priority Critical patent/JP4497691B2/ja
Priority to US09/809,257 priority patent/US20020038315A1/en
Priority to US10/101,065 priority patent/US20020091716A1/en
Publication of JP2002108681A publication Critical patent/JP2002108681A/ja
Priority to US10/785,990 priority patent/US7519620B2/en
Publication of JP2002108681A5 publication Critical patent/JP2002108681A5/ja
Application granted granted Critical
Publication of JP4497691B2 publication Critical patent/JP4497691B2/ja
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Images

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
    • G06F16/275—Synchronous replication
    • 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
    • G06F16/273—Asynchronous replication or reconciliation
    • 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/99931—Database or file accessing
    • Y10S707/99932—Access augmentation or optimizing
    • 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/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching
    • Y10S707/99934—Query formulation, input preparation, or translation
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Computing Systems (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)
JP2000294551A 2000-09-27 2000-09-27 データベース管理方法及び管理システム Expired - Fee Related JP4497691B2 (ja)

Priority Applications (4)

Application Number Priority Date Filing Date Title
JP2000294551A JP4497691B2 (ja) 2000-09-27 2000-09-27 データベース管理方法及び管理システム
US09/809,257 US20020038315A1 (en) 2000-09-27 2001-03-16 Replication system and program
US10/101,065 US20020091716A1 (en) 2000-09-27 2002-03-20 Replication system and program
US10/785,990 US7519620B2 (en) 2000-09-27 2004-02-26 Replication system, method and program for replicating a plurality of databases into a replica database

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2000294551A JP4497691B2 (ja) 2000-09-27 2000-09-27 データベース管理方法及び管理システム

Publications (3)

Publication Number Publication Date
JP2002108681A JP2002108681A (ja) 2002-04-12
JP2002108681A5 JP2002108681A5 (https=) 2004-08-26
JP4497691B2 true JP4497691B2 (ja) 2010-07-07

Family

ID=18777138

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2000294551A Expired - Fee Related JP4497691B2 (ja) 2000-09-27 2000-09-27 データベース管理方法及び管理システム

Country Status (2)

Country Link
US (3) US20020038315A1 (https=)
JP (1) JP4497691B2 (https=)

Families Citing this family (20)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2384174A1 (en) * 2002-04-29 2003-10-29 Ibm Canada Limited-Ibm Canada Limitee Classification of data for insertion into a database
US20030236874A1 (en) * 2002-06-04 2003-12-25 Timo Hotti Method and arrangement for providing an information management system
US8244913B1 (en) * 2004-10-13 2012-08-14 Progress Software Corporation Replication horizon determination with an independent distributed database system
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
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
US8037056B2 (en) * 2005-02-18 2011-10-11 International Business Machines Corporation Online repair of a replicated table
JP5050358B2 (ja) 2006-01-27 2012-10-17 日本電気株式会社 データ複製システムおよびデータ複製方法
US20080059469A1 (en) * 2006-08-31 2008-03-06 International Business Machines Corporation Replication Token Based Synchronization
JP5357068B2 (ja) * 2010-01-20 2013-12-04 インターナショナル・ビジネス・マシーンズ・コーポレーション 情報処理装置、情報処理システム、データ・アーカイブ方法およびデータ削除方法
US9275086B2 (en) 2012-07-20 2016-03-01 Commvault Systems, Inc. Systems and methods for database archiving
US9720787B2 (en) 2013-01-11 2017-08-01 Commvault Systems, Inc. Table level database restore in a data storage system
JP5913440B2 (ja) * 2014-06-10 2016-04-27 株式会社三菱東京Ｕｆｊ銀行 サーバおよびプログラム
US20160210306A1 (en) 2015-01-15 2016-07-21 Commvault Systems, Inc. Managing structured data in a data storage system
US10108687B2 (en) 2015-01-21 2018-10-23 Commvault Systems, Inc. Database protection using block-level mapping
US9904598B2 (en) 2015-04-21 2018-02-27 Commvault Systems, Inc. Content-independent and database management system-independent synthetic full backup of a database based on snapshot technology
US11561993B2 (en) 2018-08-08 2023-01-24 Ab Initio Technology Llc Generating real-time aggregates at scale for inclusion in one or more modified fields in a produced subset of data
US11269732B2 (en) 2019-03-12 2022-03-08 Commvault Systems, Inc. Managing structured data in a data storage system
US11514066B2 (en) * 2019-11-08 2022-11-29 Servicenow, Inc. System and methods for querying and updating databases
US20240211437A1 (en) * 2022-04-24 2024-06-27 Morgan Stanley Services Group Inc. Distributed query execution and aggregation across multiple datasets

Family Cites Families (27)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH03257529A (ja) * 1990-03-07 1991-11-18 Hitachi Ltd 推論管理システムおよび方法
US5261092A (en) * 1990-09-26 1993-11-09 Honeywell Inc. Synchronizing slave processors through eavesdrop by one on periodic sync-verify messages directed to another followed by comparison of individual status
JP3516344B2 (ja) * 1990-10-22 2004-04-05 株式会社日立製作所 分散処理システムの多重データ処理方法
JPH0798669A (ja) * 1993-08-05 1995-04-11 Hitachi Ltd 分散データベース管理システム
WO1995008809A2 (en) * 1993-09-24 1995-03-30 Oracle Corporation Method and apparatus for data replication
US5553279A (en) * 1993-10-08 1996-09-03 International Business Machines Corporation Lossless distribution of time series data in a relational data base network
GB9402935D0 (en) * 1994-02-16 1994-04-06 British Telecomm A method for controlling access to a database
US5745753A (en) * 1995-01-24 1998-04-28 Tandem Computers, Inc. Remote duplicate database facility with database replication support for online DDL operations
US5757669A (en) * 1995-05-31 1998-05-26 Netscape Communications Corporation Method and apparatus for workgroup information replication
US5937415A (en) * 1995-12-13 1999-08-10 Sybase, Inc. Data base development system with methods facilitating copying of data from one data source to another
US5884324A (en) * 1996-07-23 1999-03-16 International Business Machines Corporation Agent for replicating data based on a client defined replication period
US5758337A (en) * 1996-08-08 1998-05-26 Microsoft Corporation Database partial replica generation system
US5870765A (en) * 1996-10-09 1999-02-09 Oracle Corporation Database synchronizer
US5870761A (en) * 1996-12-19 1999-02-09 Oracle Corporation Parallel queue propagation
US5983217A (en) * 1997-03-21 1999-11-09 At&T Corp Apparatus and method for querying replicated databases
US5873074A (en) * 1997-04-18 1999-02-16 Informix Software, Inc. Applying distinct hash-join distributions of operators to both even and uneven database records
WO1999008209A1 (en) * 1997-08-08 1999-02-18 Bell Communications Research, Inc. High performance asynchronous data replication
US5924096A (en) * 1997-10-15 1999-07-13 Novell, Inc. Distributed database using indexed into tags to tracks events according to type, update cache, create virtual update log on demand
US6202070B1 (en) * 1997-12-31 2001-03-13 Compaq Computer Corporation Computer manufacturing system architecture with enhanced software distribution functions
US6532479B2 (en) * 1998-05-28 2003-03-11 Oracle Corp. Data replication for front office automation
US6112209A (en) * 1998-06-17 2000-08-29 Gusack; Mark David Associative database model for electronic-based informational assemblies
US6625593B1 (en) * 1998-06-29 2003-09-23 International Business Machines Corporation Parallel query optimization strategies for replicated and partitioned tables
JP2000020374A (ja) 1998-07-01 2000-01-21 Nec Corp レプリケーション制御システム
US6615223B1 (en) * 2000-02-29 2003-09-02 Oracle International Corporation Method and system for data replication
US6622152B1 (en) * 2000-05-09 2003-09-16 International Business Machines Corporation Remote log based replication solution
US6567823B1 (en) * 2000-08-07 2003-05-20 Corigin Ltd. Change propagation method using DBMS log files
US6745209B2 (en) * 2001-08-15 2004-06-01 Iti, Inc. Synchronization of plural databases in a database replication system

Also Published As

Publication number Publication date
JP2002108681A (ja) 2002-04-12
US7519620B2 (en) 2009-04-14
US20020091716A1 (en) 2002-07-11
US20040167936A1 (en) 2004-08-26
US20020038315A1 (en) 2002-03-28

Similar Documents

Publication Publication Date Title
JP4497691B2 (ja) データベース管理方法及び管理システム
US8880542B2 (en) Simply querying across time
JP3992263B2 (ja) データベース−ファイル連携方法
US8280840B2 (en) Data integration apparatus, data integration method, and computer product
US6557012B1 (en) System and method of refreshing and posting data between versions of a database table
US8117167B2 (en) Method and data processing system with data replication
US20120330890A1 (en) Propagating tables while preserving cyclic foreign key relationships
CN101765831A (zh) 数据库不一致的处理方法
US20080005189A1 (en) Computer readable recording medium having stored therein database synchronizing process program, and apparatus for and method of performing database synchronizing process
EP1480130B1 (en) Method and apparatus for moving data between storage devices
JP2002108681A5 (https=)
US7698319B2 (en) Database system management method, database system, database device, and backup program
US7194486B2 (en) Method and system for data processing with data replication for the same
JP2001034518A (ja) 分散データベースシステムにおける主従関係情報同期方式
JPH1063557A (ja) 分散ファイルの同期方式
JP2003281118A (ja) 文書管理装置、文書編集装置、文書管理方法、文書編集方法及びプログラム
JP2000047919A (ja) 仮想データベースレプリケーションシステム
JP2000132435A (ja) 異種データベース管理システム間のデータ整合処理装置
KR20020062309A (ko) 데이타베이스 내용 수정 방법
JPH11327988A (ja) 複数計算機間のデータベースレプリケーション制御方法
JPH08106473A (ja) データベース管理システム
JPH11250092A (ja) 共用データベース装置、共用データベースシステム、共用データベース装置のデータ抽出方法および共用データベース装置のデータ抽出プログラムを記録した記録媒体
JPH09265424A (ja) 分散ファイルの同期システムと方法
JP2004303117A (ja) 名寄せデータベース設計支援方法およびシステム
JP3330006B2 (ja) 情報記憶システムを備えるネットワークシステム、該システムの入力システムならびに

Legal Events

Date Code Title Description
A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20070410

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20070611

A02 Decision of refusal

Free format text: JAPANESE INTERMEDIATE CODE: A02

Effective date: 20070703

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20070831

A911 Transfer to examiner for re-examination before appeal (zenchi)

Free format text: JAPANESE INTERMEDIATE CODE: A911

Effective date: 20070913

A912 Re-examination (zenchi) completed and case transferred to appeal board

Free format text: JAPANESE INTERMEDIATE CODE: A912

Effective date: 20071012

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20100308

A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20100413

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20130423

Year of fee payment: 3

R150 Certificate of patent or registration of utility model

Free format text: JAPANESE INTERMEDIATE CODE: R150

Ref document number: 4497691

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20130423

Year of fee payment: 3

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20140423

Year of fee payment: 4

LAPS Cancellation because of no payment of annual fees