Patent US5513112A successfully refreshed from Google Patents.
← Back to Patent Explorer
US5513112A Expired / Lapsed US ⏱️ 0.0 years remaining

Database system

Assignee: Neopost Ltd
•
Filing: 1993-10-06
•
Granted: 1996-04-30
•
Expires: 2013-10-06
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A database system for maintaining accounting records in relation to usage of postage meters is disclosed. The database system is provided with two computers, both of which provide access to the system from remote postage meters via a telephone network, and each computer maintains a separate database. One computer acts as primary and handles all transactions, received either direct or via the other secondary computer, and maintains a primary database. For each transaction, the primary computer creates an archived record in a buffer and periodically when the buffer is full sends an archive record to the secondary computer for use by the secondary computer to update the secondary database. In addition for critical transactions such as a postage meter recredit transaction, the primary computer also creates a transaction log and sends it to the secondary computer for storing in a FILO buffer. The primary computer lastly authorises credit to the postage meter. In the event the archived record is not sent to the secondary computer due to a fault in the primary computer, the secondary computer utilises the transaction log to update the secondary database with critical accounting data.

Inventors

  • 👤 William J. Herring
  • 👤 MacKenny L. Trim

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-11-01 20:05
CPC Classifications
G; G07; G07B; G07B17/00; G07B17/00016; G07B17/0008; G06; G06F; G06F11/00; G06F11/07; G06F11/14; G06F11/1471; G07B17/00185; G07B17/00435; G07B2017/00088; G07B2017/00096; G07B2017/00137; G07B2017/00153; G07B2017/00161; G07B17/00362; G07B2017/00427

Claims Analysis

Total Claims: 10
Claim 1
Independent Claim 237 words
A dual database system including first means for processing transactions and for writing transaction records in respect of said transactions in a first database; second means for entering and storing records in a second database to correspond to said first database; said first means being operative to create an archived record from a group of said transaction records and to send said archived record to said second means; said first means being operative to create a transaction log record in respect of each transaction relating to critical information and to transmit each said transaction log record to said second means; said second means including transaction log storage means and being operative to store received transaction log records in said transaction log storage means; said second means being operative to update said second database from said archived record sent by said first means and received by said second means; and said second means being operable in response to failure of said first means to send an archived record in respect of new transactions processed by said first means immediately prior to said failure of said first means to utilise said transaction log records stored in said transaction log storage means to update said second database in respect of each transaction record relating to critical data of said new transactions so that the second database contains records of all transactions relating to critical information processed by said first means.
Claim 2
Dependent Claim 237 words
A dual database system including first means for processing transactions and for writing transaction records in respect of said transactions in a first database; second means for entering and storing records in a second database to correspond to said first database; said first means being operative to create an archived record from a group of said transaction records and to send said archived record to said second means; said first means being operative to create a transaction log record in respect of each transaction relating to critical information and to transmit each said transaction log record to said second means; said second means including transaction log storage means and being operative to store received transaction log records in said transaction log storage means; said second means being operative to update said second database from said archived record sent by said first means and received by said second means; and said second means being operable in response to failure of said first means to send an archived record in respect of new transactions processed by said first means immediately prior to said failure of said first means to utilise said transaction log records stored in said transaction log storage means to update said second database in respect of each transaction record relating to critical data of said new transactions so that the second database contains records of all transactions relating to critical information processed by said first means.
Claim 3
Dependent Claim 19 words
A system as claimed in claim 1 wherein the operations performable by the first and second means are interchangeable.
Claim 4
Dependent Claim 31 words
A system as claimed in claim 1 wherein in the event of a failure of said first means the second means is operative to enter transaction records into the second database.
Claim 5
Dependent Claim 38 words
A dual database system as claimed in claim 1 wherein said first means is operable to recredit selected postage meters of a plurality of postage meters and in each recrediting operation the transaction relates to the critical information.
Claim 6
Dependent Claim 77 words
A dual database system as claimed in claim 1 wherein said first means and said second means are operable to recredit selected postage meters of a plurality of postage meters and to create transaction records of recrediting operations; and wherein said second means is operative in a recrediting operation to transmit the transaction record created by said second means to said first means to enable said first means to enter said transaction record in said first database.
Claim 7
Dependent Claim 36 words
A dual database system as claimed in claim 1 wherein said first means is operative to send said transaction log record to said second means prior to entry of said transaction record into the first database.
Claim 8
Dependent Claim 19 words
A system as claimed in claim 6 wherein the operations performable by the first and second means are interchangeable.
Claim 9
Dependent Claim 96 words
A system as claimed in claim 1 including a plurality of remote devices; communication means to provide communication between said remote devices and the first and second means said first and second means being operative selectively to generate a new first transaction record relating to communication with a respective one of said remote devices; said second means being operative to send the transaction records to said first means and said first means being operative to create the archived record of transaction records generated by the first means and of transaction records generated by the second means.
Claim 10
Dependent Claim 16 words
A dual database system as claimed in claim 8, wherein the remote devices comprise postage meters.

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 1999-04-30 1999-10-30 2000-04-30 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2003-04-30 2003-10-30 2004-04-30 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2007-04-30 2007-10-30 2008-04-30 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag