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.

Data integrity between multiple databases with redundant data fields is enhanced by a synchronization method which adapts to unspecified database formats by a flexible format definition, identification of a data origin and identification of data targets to significantly improve data integrity and update efficiency in legacy database systems.

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 processing a service request via a legacy data base management system to produce a response. The response is converted from the internal format of the legacy data base management system into an XML document which is transferred via the Internet to a user.

Disclosed is a method of and a system for establishing a logical-model based understanding of a legacy application. The method comprises the steps of providing a physical data model of the legacy application, said physical data model having a plurality of physical elements; establishing a logical data model for the legacy application, said logical data model having a plurality of logical model elements; and establishing links between said logical model elements and said physical elements. One of said physical or logical elements is selected, and said links are used to identify all of the physical or logical elements that are linked to said selected one of said elements. The preferred system may include a component for browsing and navigating the physical data model, logical data model, or the links between them, a component to answer queries about the application expressed using the logical data model, and a component to create a relational data model to support the migration of data stored in legacy databases (including flat files) to relational databases.

A computer-readable medium is encoded with a method of externalizing legacy data from a legacy database on a data resource into an Extensible Markup Language (“XML”)-compliant format where the format is specified by an automatically generated XML meta-description, thus enabling access and processing of legacy data by XML-compliant applications.

An information and reporting system is used in conjunction with a plurality of incompatible legacy system databases. The legacy system applications and databases continue to operate in a normal manner. The information and reporting system operates as an overlay to each of the existing legacy systems. Each local system includes a unique entity transfer that reads specified files from a legacy system database. The data within the legacy system database is mapped into a group of predefined XML documents which are transmitted to an XML service. The XML service provides a quality control examination and forwards the XML documents to a set of domain entity controllers. The controllers receive the XML documents and selectively extract data from these documents and store the data on a common format database, which is standardized for use in all of the local systems. A user accesses the system through a communication medium and is provided with a user interface which allows the user to select any one of a group of entities, reports and file management. Each of the entities is associated with one or more modules which provides specific processing to produce information and reports. The modules can access the common format database for extracting the required information to produce the results corresponding to the module functionality. Previously produced reports can be accessed from a file repository. The system allows users to access any legacy system and process management and information modules independent of the type of local legacy database 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.

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.

An apparatus for and method of processing a call to native script in a service built by a Component Builder for a legacy data base management system. The service built by the Component Builder consists of a series of steps. One or more of these steps may be a call to a native script subroutine contained in a repository in the legacy data base management system.

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 method and apparatus for adding information to a graph database. A computer system receives initial records from a legacy database. The computer system converts the initial records from a source format for the legacy database into nodes and relationships for the graph database. The computer system also stores the nodes and the relationships in the graph database. The graph database stores the information about employees in an organization. Further, the computer system receives a group of records after the initial records have been converted into the nodes and the relationships for the graph database. Still further, the computer system changes at least one of a group of nodes or a group of relationships in the graph database based on the group of records. A synchronization between the legacy database and the graph database occurs.

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.

Disclosed is a method of and a system for establishing a logical-model based understanding of a legacy application. The method comprises the steps of providing a physical data model of the legacy application, said physical data model having a plurality of physical elements; establishing a logical data model for the legacy application, said logical data model having a plurality of logical model elements; and establishing links between said logical model elements and said physical elements. One of said physical or logical elements is selected, and said links are used to identify all of the physical or logical elements that are linked to said selected one of said elements. The preferred system may include a component for browsing and navigating the physical data model, logical data model, or the links between them, a component to answer queries about the application expressed using the logical data model, and a component to create a relational data model to support the migration of data stored in legacy databases (including flat files) to relational 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.

An apparatus for and method of processing a service request in XML document format via a legacy data base management system to produce a response. The service is defined by a component definition which is presented to the legacy data base management system as a combination of tables, variables, and script defining various components. The inputs are defined in accordance with a combination of components from a variety of sources. The legacy data base management system honors the service and returns results as appropriate.