Xbase transaction processing system

• US 6,006,229 A
• Filed: 08/19/1996
• Issued: 12/21/1999
• Est. Priority Date: 08/19/1996
• Status: Expired due to Term

• Current Assignee: Extended Systems Inc. (SAP SE)
• Original Assignee: Extended Systems Inc. (SAP SE)
• Inventors: Schmidt, Bradley E., Lokken, Robert C.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): RONES, CHARLES
• Application Number:
  US08/699,380
• Time in Patent Office: 1,219 Days
• Field of Search: 707/1, 707/2, 707/104, 707/10, 707/203
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

An Xbase transaction processing system that allows Xbase and SQL clients to operate against an Xbase file set on a server computer with commit/rollback transaction behavior that protects the data integrity of the Xbase file set against corruption due to the failure of one or more client computers. The system includes a server network communication means, an Xbase transaction protocol interpreter, an Xbase transaction management means, and an Xbase data file execution means. The communication means is configured to receive Xbase transactional commands from the network and to present server responses to the network. Software interfaces attach the network communication means to the protocol interpreter, the protocol interpreter to the transaction manager and the transaction manager to the file execution means.

Claims

1. An Xbase transaction processing system for interpreting Xbase transactional commands encoded in an Xbase transaction protocol and enforcing commit/rollback transaction behavior on an Xbase file set on a server computer system attached to a network comprising:

a server network communication means,

an Xbase transaction protocol interpreter,

an Xbase transaction management means, and

an Xbase data file execution means,

the server network communication means is configured to receive Xbase transactional commands from the network and to present server responses to the network, the server network communication means is attached to the Xbase transaction protocol interpreter by a software interface means, the Xbase transaction protocol is attached to the Xbase transaction management means by a software interface means, and the Xbase transaction management means is attached to the Xbase data file execution means by a software interface means,

whereby Xbase transactional commands encoded in the Xbase transaction protocol are received by the server network communication means, and are presented to the Xbase transaction protocol interpreter, which causes the Xbase transaction management means to maintain a list of candidate Xbase data file changes associated with a transaction to be maintained, which at the end of the transaction either causes a commit to occur whereby all the candidate changes identified by the list are committed to the Xbase file set by causing the Xbase data file execution means to make the specified changes to the Xbase file set or causes a rollback to occur whereby none of the changes identified by the candidate list are executed against the Xbase file set.

3. The Xbase transaction processing system of claim 1 further comprising:

at least one Xbase client software means for encoding Xbase transactional commands in the Xbase transaction protocol on a client computer comprising;

one or more Xbase application programs,

an Xbase language environment, and

a client network communication means,

the Xbase language environment further comprising;

an Xbase transaction command recognition means and

an Xbase transaction protocol encoding means,

each application program is attached to the Xbase language environment by a software interface means,

the Xbase language environment is attached to the client network communication means by a software interface means,

whereby the Xbase language environment uses the Xbase command recognition means to identify Xbase transactional commands and uses the Xbase transaction protocol encoding means to encode transactional commands in the Xbase transaction protocol and present encoded Xbase transaction commands to the client network communication means, whereby the client network communication means presents the encoded command to the network

whereby the transaction commit/rollback logic specified by each application program on the client is correctly applied to the Xbase file set on the server.

4. The Xbase transaction processing system of claim 3 further comprising an SQL to Xbase translation means, the translation means is attached to the Xbase language environment by a software interface means,

whereby SQL client application programs can operate against the Xbase file set with proper commit/rollback behavior.

5. The Xbase transaction processing system of claim 3 wherein the server computer system operates Novell NetWare, and the server network communication means is based on IPX networking protocol.

6. The Xbase transaction processing system of claim 3 wherein the server computer system operates Novell NetWare, the server network communication means is based on the IPX networking protocol, and the Xbase Language environment is Clipper.

7. The Xbase transaction processing system of claim 3 wherein the server computer system operates Novell NetWare, the server network communication means is based on the IPX networking protocol, and the Xbase Language environment is Delphi.

8. The Xbase transaction processing system of claim 3 wherein the server computer system operates Microsoft Windows NT, and the Xbase Language environment is Microsoft Access.

2. An Xbase client software system for encoding Xbase transactional commands in the Xbase transaction protocol on a client computer comprising:

one or more Xbase application programs,

an Xbase language environment, and

a client network communication means,

the Xbase language environment further comprising;

an Xbase transaction command recognition means and

an Xbase transaction protocol encoding means,

each application program is attached to the Xbase language environment by a software interface means,

the Xbase language environment is attached to the client network communication means by a software interface means,

whereby the Xbase language environment uses the Xbase command recognition means to identify Xbase transactional commands and uses the Xbase transaction protocol encoding means to encode transactional commands in the Xbase transaction protocol and present encoded Xbase transaction commands to the client network communication means, whereby the client network communication means presents the encoded command to the network.