DATABASE PARALLEL EDITING METHOD

• US 20110082833A1
• Filed: 06/03/2009
• Published: 04/07/2011
• Est. Priority Date: 06/06/2007
• Status: Abandoned Application

• Current Assignee: Kunio Kamimura
• Original Assignee: Kunio Kamimura
• Inventors: Kamimura, Kunio
• Application Number:
  US12/864,872
• Publication Number:
  US 20110082833A1
• Time in Patent Office: Days
• US Class Current: 707/624
• CPC Class Codes: G06F 16/219 Managing data history or versioning querying versioned data G06F16/2474; querying temporal data G06F16/2477
• CPC Class Codes: G06F 16/2308 Concurrency control transaction processing G06F9/466

Abstract

Conventionally and generally, a plurality of computers access a database provided in a server. According to the inventions, generally-called full-fledged “parallel DB edit” using computers permanently holding duplicate DBs is presented. Computers exchange edit information on the duplicate DBs, and the duplicate DBs of the computers synchronize with one another. Each of all the relevant PCs takes out the local-edit records in the other PCs in a unique order (such as the order of arrival at the server) and updates the local original DB thereof. The edit information including the same contents is processed in the same order with the same logic, and then the local original DBs are updated. Therefore, the resultant local original DBs of the PCs also synchronize with one another. The synchronization is established not along with real time axis but along the common time axis which is the order of edit records. As a result, “substantially on-line operation” in which edit records are frequently taken in and updated and “substantially off-line operation” involving long update cycles can be mixed-ly carried out.

Claims

1. A method of editing database, comprising;

(A) holding a duplication of whole or a part of a database,

(B) a process of sending “

edit records”

of edit on said copy, to another apparatus, and

(C) a process of receiving “

edit records”

on said copy, from another apparatus, and

(D) a process of executing the following sequence of steps;

fetching a set of “

edit records”

in order of turns assigned by exterior, or specified to each set of “

edit records”

, and

updating said copy of database by said set of “

edit records”

.

2. Apparatus editing database, comprising;

(A) means of holding a duplication of whole or a part of a database, and

(B) means of sending “

edit records”

of edit on said copy, to another apparatus, and

(C) means of receiving “

edit records”

on said copy, from another apparatus, and

(D) means of executing the following sequence of steps;

fetching a set of “

edit records”

in order of turns assigned by exterior, or specified to each set of “

edit records”

, and

updating said copy of database by said set of “

edit records”

.

3. A method of editing database, comprising;

A method to edit database, comprising;

(A) holding a duplication of whole or a part of a database,

(B) a process of sending “

edit records”

of edit on said copy, to another apparatus, and

(C) a process of receiving “

edit records”

on said copy, from another apparatus, and

(D1) a process of executing the following sequence of steps;

fetching “

edit records”

in order of turns assigned by exterior, or specified to each set of “

edit records”

,

judging validity of said set of “

edit records”

, and

updating said copy of database by said valid set of “

edit records”

.

4. A method of editing database, comprising;

(B1) a process of

setting mapping between “

edit records”

of edit on said copy and “

no-change range to be confirmed”

which indicates range of information affected, and

sending said “

edit records”

to another apparatus, and

(C1) a process of receiving “

edit records”

on said copy and “

no-change range to be confirmed”

mapped to said edit records, from another apparatus, and

(D2) a process of executing the following sequence of steps;

fetching edit records in order of ordinal number assigned by exterior, or specified to the edit records,

judging validity of said edit records by “

no-change range to be confirmed”

mapped said edit records and

updating said copy of database by said valid edit records.

5. A method of editing database, comprising;

(A) holding a duplication of whole or a part of a database,

(B2) a process of

setting mapping between “

edit records”

of edit on said copy and a version which is assigned to said copy, and

sending said “

edit records”

to another apparatus, and

(C2) a process receiving a set of “

edit records”

on said copy and a version mapped to said set of “

edit records”

from another apparatus, and

(D3) a process of executing the following sequence of steps;

fetching a set of “

edit records”

in order of turns assigned by exterior, or specified to each set of “

edit records”

,

judging validity of said set of “

edit records”

by version mapped said edit records and

updating said copy of database by said valid set of “

edit records”

, and

updating its version.

6. A method of editing database, comprising;

(A) holding a duplication of whole or a part of a database,

(B3) a process of

setting mapping between “

edit records”

of edit on said duplication and a version which is assigned to a part of said information or combination of information of said copy, and

sending said “

edit records”

to another apparatus, and

(C2) a process receiving a set of “

edit records”

on said duplication and a version mapped to said set of “

edit records”

, from another apparatus, and

(D3) a process executing the following sequence of steps;

fetching a set of “

edit records”

in order of turns assigned by exterior, or specified to said set of “

edit records”

,

judging validity of said set of “

edit records”

by version mapped said set of “

edit records” and

updating said duplication of database by said valid edit records, and

updating its version.

7. A method editing database, comprising;

(A) holding a duplication of whole or a part of a database,

(B2) a process of

setting mapping between edit records of editing work on said duplication and a version which is assigned to said copy, and

sending said edit records to another apparatus, and

(C2) a process receiving edit records on said copy and a version mapped to said edit records from another apparatus, and

(D4) a process executing the following sequence of steps;

fetching edit records in order of ordinal number assigned by exterior, or specified to the edit records,

judging validity of said edit records by version mapped said edit records, and

updating version of said duplication of database, and updating said duplication of database by said valid edit records.

8. A method of editing database, comprising;

(A) holding a duplication of whole or a part of a database,

(B2) a process of

setting mapping between “

edit records”

of editing work on said duplication and a version which is assigned to said duplication, and

sending said edit records to another apparatus, and

(C3) a process of receiving a set of “

edit records”

on said duplication and date and time mapped to said “

edit records”

from another apparatus, and

(D5) a process of executing the following sequence of steps;

fetching a set of “

edit records”

in order of turns assigned by exterior, or specified to said set of “

edit records”

,

judging validity of said set of “

edit records”

by version mapped to said set of “

edit records”

, and

updating said duplication by said valid set of “

edit records”

, and.

setting date and time assigned to said set of “

edit records”

as version of said duplication.

9. A method to edit database, comprising;

(A) holding a duplication of whole or a part of a database,

(B2) a process of

setting mapping between “

edit records”

of edit on said duplication and a version which is assigned to said duplication, and

sending said “

edit records”

to another apparatus, and

(C4) a process of sequence of steps;

receiving set of “

edit records”

on said duplication and version mapped to said set of “

edit records”

from another apparatus, further

receiving date and time, and

(D3) a process of executing the following sequence of steps;

fetching a set of “

edit records”

in order of turns assigned by exterior, or specified to said set of “

edit records”

,

judging validity of said set of “

edit records”

by version mapped to said set of “

edit records”

,

updating said duplication of database by said valid set of “

edit records”

, and

setting date and time that are received by process (C4) as version of said duplication.