Abstract: A system and method for managing a database is provided. The system and method includes logic that supports an atomic synchronization operation initiated by execution of a single synchronization statement. This operation utilizes a single call to a database management system to transform a database table from a first unknown state to a known state that contains a specified target record containing one or more specified data values. The first unknown state may be a state that already contains the target record, or may instead be a state that does not contain the record. In the former instance, a record containing one or more of the data values is created, and in the latter instance, the existing record is updated. A one-step locking mechanism is performed in conjunction with the operation to prevent the occurrence of deadlock and to minimize the number of required lock requests.

Abstract: An apparatus for and method of utilizing an Internet terminal coupled to the world wide web to interface with an existing proprietary data base management system through a user interface which permits access to an application service using a combination of proprietary language syntax and SGML-derived syntax. A specific code within the proprietary language is redefined to indicate that the immediately following script is in SGML-derived syntax.