43 results about "Legacy database" patented technology

Techniques for concurrent access to a resource object, such as a database, include generating a lock data structure for a particular resource object. The lock data structure includes data values for a resource object identification, a lock type, and a version number. The version number is related to a number of changes to the resource object since the lock data structure was generated. A request is received from a requesting process. The request is for a requested lock type for access to the particular resource object. It is determined whether to grant the request based on the requested lock type and the lock type in the lock data structure. By carrying a lock version number in a lock data structure managed by a lock manager, improved optimistic locking is provided in a database. In particular, the approach enables introduction of optimistic locking to a legacy database without requiring burdensome changes to a database table schema.

A database integrator is provided to an application program that utilizes the ODBC interface so as to enable the application program to access the data in a legacy DBMS. The application program ("the client program") is located on a workstation, and the legacy DBMS is located on a host computer. The legacy DBMS is used primarily by an application program ("the server program"). The database integrator receives ODBC commands from the client program, and unlike database drivers interacting with non-legacy DBMSs that send SQL statements to the DBMS, the database integrator instead converts these commands into server program-specific commands to manipulate the user interface of the server program, establishes a connection with the server program over a terminal emulation session, and issues the server program-specific commands to the server program by using the terminal emulator. These server program-specific commands manipulate the server program's user interface to display the appropriate data so that the database integrator can then access it. In this manner, the database integrator accesses the data in the legacy DBMS indirectly by issuing user interface commands to the server program, because the database integrator cannot typically access the legacy DBMS directly. This indirect access enables the client program to gain access to the data in a database that it would not otherwise be able to access.

The present invention provides a method, system, and computer program product for enabling a user to provide a single system sign-on for accessing one or more legacy host applications and/or one or more systems which provide legacy host data (such as legacy database systems) during a secure host access session which is authenticated using a digital certificate and is protected by a host-based security system, such as RACF (Resource Access Control Facility, a product offered by the IBM Corporation), where the same set of credentials must be provided more than once during the secure session. The subsequent provision of the credentials may be transparent to the user, and does not require change to existing legacy applications or systems.

Computer processes for carrying out almost any process may be defined as a series of steps using a plurality of standardized user-interface screens. These standardized interface screens may be linked together in predetermined orders to implement on a client computer activities for which the standardized screens are appropriate to accomplish a pre-defined process. Any number of computer processes may be developed and deployed using the standard interfaces. The computer process automatically takes a user from screen to screen, prompting the user to review or provide information or take appropriate action. Processes may be represented using metadata. Metadata may provide data to a screen rendering process running on a user's workstation with details on how to render one of a plurality of standard screens in a manner which is specific to a particular process. Metadata may be provided to define the steps of the process for enabling navigational capabilities. Metadata may stored in a database and communicated by a process server to a client computer, which acts as a user's workstation. This client-server system architecture allows maintenance of the computer processes in a central location and remote management of their use within a network. Furthermore, any number of application-specific computer processes may be made available and distributed to users without detailed programs for those processes having to be stored at each user workstation. Furthermore, basic interface functions with legacy databases and back-end systems may be provided to each user workstation in a network through the server system.

A medical check-in and data communication kiosk for efficiently checking-in patients at a medical facility and/or exchanging relevant data with the patient. A patient automatically provides initial identification information by swiping, scanning, etc., an I.D. card and the kiosk then accesses various legacy database systems to gather all relevant medical data corresponding to the particular patient. The patient is requested to verify and/or update any third party payer information, such as insurance information, and is also informed of suggested preventive healthcare actions.

A method for migrating data from a legacy system is provided. The method comprises providing a legacy database having metadata describing one or more legacy data fields in the legacy database and creating a legacy value table in the legacy database that corresponds to a recipient value table in the recipient database. Further, the method comprises updating a translation table in the legacy database that defines one or more recipient data elements in the recipient database based upon the metadata of the legacy database, and translating legacy data elements in the legacy database to correspond to the one or more recipient data elements in the recipient database by utilizing the translation table. Furthermore, the method comprises populating a legacy interface table using the translation table and remotely extracting the data from the legacy interface table to the recipient database.

An apparatus for and method of utilizing service requests to a legacy data base management system to efficiently access external data types. To accomplish this, the external data types are dynamically mapped into data types compatible with the legacy data base management system.

A system and method of connecting legacy database applications and new database systems. The method includes parsing SQL scripts by a connector program. In this manner, the legacy application system does not have to be replaced to work with the new database system.

A data mapping tool facilitates database engineer interaction with a data mapping document design system that facilitates creating the technical specification for migrating legacy databases. The data mapping tool provides a flexible selection of mapping modes, including a fully automated mode that resolves conflicts that may occur during the creation of the technical specification. The available modes also allow the database engineer to fully specify the intermediate staging tables used in the technical specification, and to request an partially automatic and partially interactive role over the execution of the data mapping document design system.

An apparatus for and method of utilizing an Internet terminal coupled to the world wide web to access a legacy data base management system having a dialog-based request format using a standardized object-based command language, such as JavaScript, rather than the proprietary command language native to the legacy data base management system to perform a bulk update operation. This approach leverages the power of the legacy data base management without the need for the user to become familiar with the proprietary command language of the legacy data base management system. The approach is particularly efficient in that the user can provide parameters to the legacy data base management system as a parameter object.

A data mapping document design system provides a market differentiator that facilitates creating the technical specification for migrating legacy databases. The system addresses the significant technical problems associated with the immensely labor intensive, complex, and error prone endeavor of manually creating the technical specification. The system not only achieves cost and time savings in clearly measurable aspects of data migration such as migration project cost and completion timelines, but also achieves improvements in other harder to measure and track areas, such as data quality, and achieves reductions in subsequently discovered data errors.

An apparatus for and method of utilizing JavaScript to request a complex combining across multiple datasets from a legacy data base management system. The user is thus able to evoke the powerful dataset combination tools of the legacy data base management system without the need to understand and use the command language of the legacy data base management system.

The present invention provides a method and system for determining and creating an extended ID file for a consumer located in a database containing a large record of consumers. The system and method utilizes existing historical records located in legacy databases, and through a scoring program to match consumer records, creates an extended identification file that represents a higher probability of a combination of name, address and social security number for a given consumer. The extended identification file may now be utilized by credit bureaus to locate credit history for the given consumer.

An apparatus for and method of temporarily, or permanently, saving the current computational data as a table within a legacy data base management system for later use within the current computational service or for use in a following computational service. In particular, the apparatus enables the generation of XML output documents with computational data from more than one source. The DTD, IDT, and other key conversion components may be stored within a repository of the legacy data base management system.

An apparatus, system, and method are disclosed for directly accessing a database management system (“DBMS”). A client communication module is included to transmit a data call between a client and a client interface wherein the client interface resides within a database network. A DBMS communication module is included to transmit the data call between the client interface and a hierarchical DBMS on a host within the database network. The client interface and hierarchical DBMS are free of user-defined code.

A depository monitoring system for use in a semiconductor factory comprises a plurality of carriers, each holding at least one semiconductor object; a depository monitoring host for monitoring a depository of each carrier; and a plurality of RFID tags and a plurality of RFID readers. It is characterized in that the RFID tags are disposed on the carriers and/or semiconductor objects, respectively, wherein each RFID tag has a tag information; the RFID readers read/write the tag information from/to the RFID tags; and the depository monitoring host comprises: a legacy database to store information related to the depository monitoring system; an RFID middleware for processing operations between the RFID readers and the RFID tags; a web interface for processing commands and query results through a B2B internet; an input/output interface for processing commands and query results through an intranet; and a depository controller for performing a sequence of processes in depository monitoring.

A blockchain gateway device and associated method of use for reconciling and insuring the consistency of integrated blockchain networks and legacy database-based systems. The blockchain gateway device and associated blockchain scheme harmonizes and reconciles the data elements from multiple independent blockchain databases.

The invention discloses an asynchronous uplink method. The method comprises the following steps: receiving a transaction request triggered by an electronic wallet application of an issuing bank by a user; receiving a transaction request triggered by an electronic wallet application of the issuing bank; generating a corresponding transaction record according to the received transaction request, andcaching the transaction record into a legacy database, wherein the transaction record includes transaction information when the transaction request is assumed to be successful; the cached transactionrecords in the traditional database are read according to a preset period, and the read transaction records are uploaded. The invention also discloses an asynchronous uplink device and a computer-readable storage medium. The invention can reduce the time consumption of the transaction uplink, thereby reducing the time consumption of the whole transaction process and improving the experience of the wallet user.