WO1999006925A1 - Method and apparatus for implementing software connectivity for client/server applications - Google Patents

Method and apparatus for implementing software connectivity for client/server applications Download PDF

Info

Publication number
WO1999006925A1
WO1999006925A1 PCT/US1998/015867 US9815867W WO9906925A1 WO 1999006925 A1 WO1999006925 A1 WO 1999006925A1 US 9815867 W US9815867 W US 9815867W WO 9906925 A1 WO9906925 A1 WO 9906925A1
Authority
WO
WIPO (PCT)
Prior art keywords
message
data collection
relational database
management system
database management
Prior art date
Application number
PCT/US1998/015867
Other languages
French (fr)
Inventor
John J. Hession
Charles J. Salvo
Steven E. Bradbery
Original Assignee
Data Net Corporation
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Data Net Corporation filed Critical Data Net Corporation
Priority to AU86740/98A priority Critical patent/AU8674098A/en
Publication of WO1999006925A1 publication Critical patent/WO1999006925A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application

Definitions

  • This invention relates to the field of computer middleware and related equipment for enhanced connectivity between data collection systems and Client/Server software applications.
  • data collection systems for use in many different fields ranging from health care, to warehousing and manufacturing operations.
  • such systems have been implemented using one or more remote data collection terminals and a host computer upon which a relational database software application has been installed.
  • the remote data collection terminals were typically provided with a communication link to the host computer.
  • the remote data collection terminal would provide updated information and data to the host computer for tracking particular physical data such as inventory at a warehouse or manufacturing facility information.
  • the data collection terminals could be configured to automatically sense particular physical occurrences of interest or the information could be manually entered by an operator.
  • the database software application would typically analyze the data to ensure its validity as to format and/or content.
  • any new information communicated to the host by the remote data collection terminals would be used by the database application program to update the present content of the database.
  • One problem concerned the integration of the remote data collection terminals with the relational database application installed on the host computer.
  • the host computer and application program were not necessarily provided by the same manufacturer as the remote data collection terminals, it was typically necessary to install customized software on the host computer to facilitate the interface between the host computer and the remote data collection terminals. This resulted in substantial expense as it required the use of a skilled programmer in each instance to prepare new computer code.
  • client/server software software or “middleware”.
  • client/server software by interposing a software application on an independent computer platform between the host computer and the remote data collection terminals, means were provided for permitting the relational database application to be updated without requiring an independent programmer to customize the software comprising the computer database.
  • Communications between the host computer, remote data collection terminals and the client/server software were typically implemented with external network wiring or cables.
  • Communications between the middleware product and the database application were facilitated by use of Open Database Connectivity (OBDC) standards in the industry which were employed in the design of the database application.
  • OBDC software drivers have been designed and are called upon by the middleware product to update the database and validate data.
  • these OBDC drivers are typically provided by software vendors not associated with manufacturer of the database application software. Thus, while use of such drivers is satisfactory for the less critical purpose of data validation, it remains a weak link in such systems as concerns updating the relational database.
  • a method and apparatus in accordance with inventive arrangements disclosed herein facilitates the interfacing of a data collection terminal with a database application.
  • the system is interposed between one or more data collection terminals and a host application server provided for executing such database application.
  • the data collection terminals preferably are arranged to communicate with the system via a data collection terminal LAN which may include wireless communication links from remote or mobile data collection terminal units.
  • communications between the host application server and the system are preferably effected by a computer LAN.
  • the invention is advantageously designed to operate with database software applications which: (1 ) include a relational database management system (RDBMS); (2) comply with Open Database Connectivity (ODBC) standards and (3) make use of Stored Procedures, as that term shall hereinafter be defined.
  • RDBMS relational database management system
  • ODBC Open Database Connectivity
  • the system receives input messages from the data collection terminal and, based upon the message content, will retrieve a pre-determined action message corresponding to the particular input message.
  • the action message will be communicated to the host application server, preferably to either validate a transaction parameter associated with the input message or to update the database. If an update is to be performed, the action message is advantageously configured for causing a stored procedure of the relational database management system to perform a database update in response thereto.
  • the database update is performed via a Remote Procedure Call ("RPC") to the stored procedure.
  • RPC Remote Procedure Call
  • a transaction parameter is to be validated, this is preferably accomplished directly by communicating with the database using an ODBC software driver on a read only basis.
  • the method involves the steps of receiving an input message from the data collection terminal and retrieving a pre-determined action message responsive to the input message.
  • the action message is preferably stored in a library or cross-reference table which relates a specific input message to a corresponding action message, and is configured for causing a stored procedure of the relational database management system to perform a database update in response thereto.
  • the action message is communicated to the relational database management system which, in turn, causes the stored procedure to perform the update.
  • the action message is comprised of at least one SQL statement.
  • the method can further comprise the steps of receiving a validation result message and communicating the validation result message to the data collection terminal.
  • the method can be implemented in a computer programmed with a routine of instructions stored in a physical medium, the computer comprising: data receiving means for receiving an input message from the data collection terminal; action retrieving means for retrieving a pre-determined action message responsive to the input message; and data transmitting means for communicating the action message to said relational database management system.
  • Fig. 1 is a block diagram showing the operation of the system according to the present invention relative to a host application server and a plurality of remote data collection devices.
  • Fig. 2 is a flow chart showing the operation of the system according to the present invention.
  • FIG. 1 shows in block diagram form the interface system 10 according to the present invention for interfacing one or more data collection terminals 12 with a relational database management system 14 which has been implemented with a set of stored procedures 16.
  • the relational database management system 14 and the interface system 10 are each installed and executed on a separate computer platforms.
  • the relational database management system 14 is installed on a host application server computer 15, which preferably utilizes a UNIX or Microsoft NT type operating system. Suitable equipment for this purpose would include the HP 8000 system which is available from Hewlett Packard Corporation, the IBM RS 6000 system available from IBM Corporation, or the DEC VAX system available from Digital Equipment Corporation.
  • any other computer hardware may also be used which is capable of executing the relational database management system 14 and communicating with the interface system 10 as shall be hereinafter described.
  • any other computer hardware may also be used which is capable of executing the relational database management system 14 and communicating with the interface system 10 as shall be hereinafter described.
  • an IBM compatible personal computer with a Windows NT operating system may also be used.
  • the interface system 10 may be installed and executed on an interface platform computer 17.
  • Suitable computer equipment for the interface platform computer 17 include any one of many commercially available high speed personal computers offered by manufacturers such as Compaq, Hewlett Packard, IBM Corp or Apple Computers.
  • the operating system for the computer is one of the Windows family of operating systems, such as Windows NT or Windows 95.
  • the data collection terminals 12 may be one of any number of data collection terminals such as those which are commercially available from Data Net Corporation of Miramar, Florida for the collection of physical data in a warehousing, manufacturing or distribution operation. They can be of the fixed station type which are hard wired to a data collection local area network, or may be mobile terminals which communicate to the local area network 18 via an RF link. In either case, the data collection terminals 12 are capable of electronically transmitting and receiving messages to the interface platform 17 via local area network 18.
  • the relational database management system 14 is a computer application program which executes on the host application server computer. Such relational database management systems are well known to those who are familiar with the database management field and are commercially available from various vendors including Oracle Corporation of Redwood Shores, California, Progress Corporation of Atlanta, Georgia, and Informix Corporation of Menlo Park, California.
  • the relational database management system is typically comprised of a database engine object 20, database management object 22, and a set of stored procedures 24.
  • the stored procedures 24 are written in SQL, a high level query language which is commonly used among programmers of relational database application programs.
  • These stored procedures 24 are application objects and can be resident within the relational database engine object 20 or may be stored separately in the host computer memory. In either case, the stored procedures are designed to be called by the database management object 22 to perform various functions relative to the database, including verification of data collected by the data collection terminals 12 and database updates.
  • relational database management system 14 is capable of receiving action messages in SQL format from the interface system
  • Messages are transmitted between the interface system 10 and the relational database management system 14 via a local area network 26, which network is generally separate from local area network 18.
  • a local area network 26 between the host application server 15 and the interface platform computer are performed using a TCP/IP service, which is a commonly used communication protocol for accommodating a number of separate technology devices incorporating disparate communication protocols.
  • TCP/IP service is well known to those in the data communication field and is preferred in order to facilitate the communications between a host application computer 15 and interface platform computer.
  • the invention is not limited in this regard and other data communications protocols can also be used with the system.
  • the TCP/IP service is typically implemented as a separate software application 28 residing on the host application server 15, and an interface card 30 installed on the interface platform 17.
  • a message is transmitted to the interface system 10 via the local area network 18.
  • Local area network 18 can be any of several commonly utilized configurations such as ether net, token ring or X.25 which are well known to those familiar with such network systems.
  • the message is received by the interface platform computer, it is communicated to the LAN manager object 30.
  • the LAN manager object is configured for sending and receiving messages via local area network 18 in the required format and in conformance with network protocol.
  • the LAN manager object 30 communicates the content of the message to the dispatcher object 32.
  • the dispatcher object 32 validates the message parameters (e.g. field lengths, date fields and the like) in step 40 to ensure that the format is correct and that the information contained in the message has not been otherwise corrupted as a result of the communication process from the remote terminal 12. If the message parameters are correct, the message data is communicated to the transaction mapper object 34.
  • the message parameters e.g. field lengths, date fields and the like
  • Transaction mapper object 34 processes the message in step 42 to determine whether it concerns a request for validation of data or is of some other type, such as a database update message.
  • Validation type messages are typically those which require some type of confirmation from the database management system 14 regarding a specific data entry at a data collection terminal. For example, if a purchase order number is entered at a data collection terminal, it is desirable to verify that the number corresponds to a known purchase order. In such instances, a validation type message will be sent from the data collection terminal 12 to the interface system 10. Significantly, in the case of a validation type message, the content of the relational database maintained by the database management system 14 does not need to be altered in any way.
  • ODBC driver object 36 is stored in the memory of the interface platform computer 17. It facilitates communications with the relational database management system 14 and is specifically configured for communication with a particular manufacturer's relational database system 14. ODBC drivers are commercially available from software manufacturers such as Progress Corporation of Atlanta, Georgia, and Openlink of Canada.
  • the ODBC driver 36 is provided with the particular data or message which requires validation via an SQL action message from the transaction mapper 34.
  • the ODBC will thereafter communicate with the relational database management system 14 via local area network 26 in order to validate the information as requested and will return a result message to the dispatcher 32 as shown.
  • the result message is returned from the dispatcher 32 and LAN manager 30, to the data terminal 12 which originated the validation request, and the transaction is complete. If the operator of the terminal 12 then wishes to update the relational database management system 14, the terminal 12 will either automatically, or upon operator command, send a new message to update the database. As with the validation message, the update message is received by the transaction mapper 34 from dispatcher 32.
  • ODBC drivers are available which are designed to perform this task, they have proved to be less than satisfactory for this purpose for several reasons. Most importantly, use of ODBC drivers in conventional interface systems to modify the database content raises the possibility that the ODBC driver will not perform the update properly. Since ODBC drivers are not necessarily supplied by the manufacturer of the relational database management system 14, modifications and updates to the information contained in the database may not be performed properly. The result will be a loss of database integrity.
  • transaction mapper 34 when an update type message is received in transaction mapper 34, it is recognized as such and is processed by the transaction mapper in a distinct manner as compared to other message types which merely require data validation.
  • the transaction mapper object 34 determines the specific type of update or modification which is required based upon the content of the update message, and then cross-references the update message type to identify a specific remote procedure call for performing the necessary update action.
  • the remote procedure call when transmitted to the relational database management system 14, will trigger the execution of a specific SQL based procedure which is stored in the relational database management system.
  • the procedure thus called is a part of the relational database management system 14, and performs the specific update requested by the data terminal 12. Different procedures may be called in order to effect different types of updates or database modifications.
  • the standard format for such calls when using the C + + programming language for example, is RPCxx(AAA,BBB,CCC), where the xx identifies the specific stored SQL procedure to be called, and the AAA, BBB, and CCC are parameters or variables associated with the particular call.
  • the transaction mapper object 34 is preferably communicated to the repository object 38 in step 50.
  • the remote procedure call is queued in the repository 38 in step 52 until a suitable time when the message is transmitted to the relational database management system 14.
  • the communications between the repository and the local area network are advantageously effected by means of a socket object 40.
  • the socket object is a commercially available object which is specifically designed for receiving packets of data from the local area network.
  • the socket may be a WinSoc object which is commercially available from Microsoft Corporation of Redmond, Washington.

Abstract

A method for interfacing a data collection terminal (12) with a relational database management system (14) which has been implemented with stored procedures (16). The method involves receiving an input message from the data collection terminal (12) and retrieving a predetermined action message responsive to the input message. The action message is communicated to the relational database management system (14), and is configured for causing one of the stored procedures (16) therein to perform a database update. The method can be implemented in a computer programmed with a routine of instruction stored in a physical medium, where the computer includes a data receiver (30, 32) for receiving an input message from the data collection terminal (12), an action retriever (34) for retrieving a predetermined action message responsive to the input message, and data transmitter (36, 30) for communicating the action message to said relational database management system (14).

Description

METHOD AND APPARATUS FOR IMPLEMENTING SOFTWARE CONNECTIVITY
FOR CLIENT/SERVER APPLICATIONS
BACKGROUND OF THE INVENTION 1 . Field of the Invention
This invention relates to the field of computer middleware and related equipment for enhanced connectivity between data collection systems and Client/Server software applications. 2. Description of Related Art There currently exist a wide variety of computer implemented data collection systems for use in many different fields ranging from health care, to warehousing and manufacturing operations. In the past, such systems have been implemented using one or more remote data collection terminals and a host computer upon which a relational database software application has been installed. In such systems the remote data collection terminals were typically provided with a communication link to the host computer. The remote data collection terminal would provide updated information and data to the host computer for tracking particular physical data such as inventory at a warehouse or manufacturing facility information. The data collection terminals could be configured to automatically sense particular physical occurrences of interest or the information could be manually entered by an operator. In either case, the database software application would typically analyze the data to ensure its validity as to format and/or content. In addition, any new information communicated to the host by the remote data collection terminals would be used by the database application program to update the present content of the database.
Two basic problems were found to exist with the foregoing approach. One problem concerned the integration of the remote data collection terminals with the relational database application installed on the host computer. In particular, since the host computer and application program were not necessarily provided by the same manufacturer as the remote data collection terminals, it was typically necessary to install customized software on the host computer to facilitate the interface between the host computer and the remote data collection terminals. This resulted in substantial expense as it required the use of a skilled programmer in each instance to prepare new computer code.
Aside from the added expense, the customized computer software necessary to facilitate the interface often was prone to cause problems within the relational database application. While custom software to validate the data recorded by the remote data collection terminals presented a relatively straightforward programming problem, updating a relational database can be a complex matter. Moreover, since the programmer was essentially modifying the original relational database application, often without the guidance of the original manufacturer of such software, it was difficult to ensure that the customized software was accurately updating the relational database in all respects.
In recent years, the foregoing problems have been addressed to some extent by the use of what has become known as "client/server" software or "middleware". In particular, by interposing a software application on an independent computer platform between the host computer and the remote data collection terminals, means were provided for permitting the relational database application to be updated without requiring an independent programmer to customize the software comprising the computer database. Communications between the host computer, remote data collection terminals and the client/server software were typically implemented with external network wiring or cables. Communications between the middleware product and the database application were facilitated by use of Open Database Connectivity (OBDC) standards in the industry which were employed in the design of the database application. Specific OBDC software drivers have been designed and are called upon by the middleware product to update the database and validate data. Significantly, however, these OBDC drivers are typically provided by software vendors not associated with manufacturer of the database application software. Thus, while use of such drivers is satisfactory for the less critical purpose of data validation, it remains a weak link in such systems as concerns updating the relational database.
The foregoing problem is compounded by another concern which arises when the relational database software is updated or upgraded by its manufacturer. Specifically, in such instances, it is difficult to ascertain with certainty whether an OBDC driver supplied by a third party software manufacturer in fact will continue to perform correct updates to the relational database after such database has been upgraded or modified by the manufacturer. Once again, such problems are of particular concern in the updating of the relational database with new data. Thus, a serious problem remains with conventional methods for establishing a suitable interface system between a relational database operating on a host computer and a plurality of remote data collection terminals.
SUMMARY OF THE INVENTION A method and apparatus in accordance with inventive arrangements disclosed herein facilitates the interfacing of a data collection terminal with a database application. The system is interposed between one or more data collection terminals and a host application server provided for executing such database application. The data collection terminals preferably are arranged to communicate with the system via a data collection terminal LAN which may include wireless communication links from remote or mobile data collection terminal units. Similarly, communications between the host application server and the system are preferably effected by a computer LAN.
The invention is advantageously designed to operate with database software applications which: (1 ) include a relational database management system (RDBMS); (2) comply with Open Database Connectivity (ODBC) standards and (3) make use of Stored Procedures, as that term shall hereinafter be defined. Where these features are present, the system receives input messages from the data collection terminal and, based upon the message content, will retrieve a pre-determined action message corresponding to the particular input message. The action message will be communicated to the host application server, preferably to either validate a transaction parameter associated with the input message or to update the database. If an update is to be performed, the action message is advantageously configured for causing a stored procedure of the relational database management system to perform a database update in response thereto. In a preferred embodiment, the database update is performed via a Remote Procedure Call ("RPC") to the stored procedure. Alternatively, if a transaction parameter is to be validated, this is preferably accomplished directly by communicating with the database using an ODBC software driver on a read only basis.
Accordingly, the method involves the steps of receiving an input message from the data collection terminal and retrieving a pre-determined action message responsive to the input message. The action message is preferably stored in a library or cross-reference table which relates a specific input message to a corresponding action message, and is configured for causing a stored procedure of the relational database management system to perform a database update in response thereto. The action message is communicated to the relational database management system which, in turn, causes the stored procedure to perform the update. In a presently preferred embodiment, the action message is comprised of at least one SQL statement. The method can further comprise the steps of receiving a validation result message and communicating the validation result message to the data collection terminal. The method can be implemented in a computer programmed with a routine of instructions stored in a physical medium, the computer comprising: data receiving means for receiving an input message from the data collection terminal; action retrieving means for retrieving a pre-determined action message responsive to the input message; and data transmitting means for communicating the action message to said relational database management system.
Brief Description of the Drawings
There are shown in the drawings embodiments which are presently preferred, it being understood, however, that the invention is not limited to the precise arrangements and instrumentalities shown.
Fig. 1 is a block diagram showing the operation of the system according to the present invention relative to a host application server and a plurality of remote data collection devices.
Fig. 2 is a flow chart showing the operation of the system according to the present invention.
DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Fig. 1 shows in block diagram form the interface system 10 according to the present invention for interfacing one or more data collection terminals 12 with a relational database management system 14 which has been implemented with a set of stored procedures 16. The relational database management system 14 and the interface system 10 are each installed and executed on a separate computer platforms. In a typical installation the relational database management system 14 is installed on a host application server computer 15, which preferably utilizes a UNIX or Microsoft NT type operating system. Suitable equipment for this purpose would include the HP 8000 system which is available from Hewlett Packard Corporation, the IBM RS 6000 system available from IBM Corporation, or the DEC VAX system available from Digital Equipment Corporation. It should be noted however, that the invention is not limited in this regard and any other computer hardware may also be used which is capable of executing the relational database management system 14 and communicating with the interface system 10 as shall be hereinafter described. For example, an IBM compatible personal computer with a Windows NT operating system may also be used.
Similarly, the interface system 10 may be installed and executed on an interface platform computer 17. Suitable computer equipment for the interface platform computer 17 include any one of many commercially available high speed personal computers offered by manufacturers such as Compaq, Hewlett Packard, IBM Corp or Apple Computers. In accordance with an inventive arrangement, the operating system for the computer is one of the Windows family of operating systems, such as Windows NT or Windows 95. Once again, however, the invention is not limited in this regard and other computer hardware may also be used, provided that it is capable of performing as described herein.
The data collection terminals 12 may be one of any number of data collection terminals such as those which are commercially available from Data Net Corporation of Miramar, Florida for the collection of physical data in a warehousing, manufacturing or distribution operation. They can be of the fixed station type which are hard wired to a data collection local area network, or may be mobile terminals which communicate to the local area network 18 via an RF link. In either case, the data collection terminals 12 are capable of electronically transmitting and receiving messages to the interface platform 17 via local area network 18.
The relational database management system 14 is a computer application program which executes on the host application server computer. Such relational database management systems are well known to those who are familiar with the database management field and are commercially available from various vendors including Oracle Corporation of Redwood Shores, California, Progress Corporation of Atlanta, Georgia, and Informix Corporation of Menlo Park, California. The relational database management system is typically comprised of a database engine object 20, database management object 22, and a set of stored procedures 24. The stored procedures 24 are written in SQL, a high level query language which is commonly used among programmers of relational database application programs. These stored procedures 24 are application objects and can be resident within the relational database engine object 20 or may be stored separately in the host computer memory. In either case, the stored procedures are designed to be called by the database management object 22 to perform various functions relative to the database, including verification of data collected by the data collection terminals 12 and database updates.
As shown in Fig. 1 , relational database management system 14 is capable of receiving action messages in SQL format from the interface system
10, and then returning a result message. Messages are transmitted between the interface system 10 and the relational database management system 14 via a local area network 26, which network is generally separate from local area network 18. In a preferred embodiment, the communications on the local area network 26 between the host application server 15 and the interface platform computer are performed using a TCP/IP service, which is a commonly used communication protocol for accommodating a number of separate technology devices incorporating disparate communication protocols. TCP/IP service is well known to those in the data communication field and is preferred in order to facilitate the communications between a host application computer 15 and interface platform computer. However, the invention is not limited in this regard and other data communications protocols can also be used with the system. The TCP/IP service is typically implemented as a separate software application 28 residing on the host application server 15, and an interface card 30 installed on the interface platform 17. In a preferred embodiment according to the invention, when physical data such as warehouse or manufacturing inventory is entered at a remote data collection terminal 12, a message is transmitted to the interface system 10 via the local area network 18. Local area network 18 can be any of several commonly utilized configurations such as ether net, token ring or X.25 which are well known to those familiar with such network systems. When the message is received by the interface platform computer, it is communicated to the LAN manager object 30. The LAN manager object is configured for sending and receiving messages via local area network 18 in the required format and in conformance with network protocol. The LAN manager object 30 communicates the content of the message to the dispatcher object 32. As shown in Fig. 2(A), the dispatcher object 32 validates the message parameters (e.g. field lengths, date fields and the like) in step 40 to ensure that the format is correct and that the information contained in the message has not been otherwise corrupted as a result of the communication process from the remote terminal 12. If the message parameters are correct, the message data is communicated to the transaction mapper object 34.
Transaction mapper object 34 processes the message in step 42 to determine whether it concerns a request for validation of data or is of some other type, such as a database update message. Validation type messages are typically those which require some type of confirmation from the database management system 14 regarding a specific data entry at a data collection terminal. For example, if a purchase order number is entered at a data collection terminal, it is desirable to verify that the number corresponds to a known purchase order. In such instances, a validation type message will be sent from the data collection terminal 12 to the interface system 10. Significantly, in the case of a validation type message, the content of the relational database maintained by the database management system 14 does not need to be altered in any way. Accordingly, these types validation messages are handled differently by the interface system 10 as compared to other messages requiring an update to the database. In particular, when a validation type message is received by the transaction mapper 34 it will be immediately recognized as such, and the transaction mapper will call ODBC driver object 36 in step 44 to perform the necessary data validation. The ODBC driver object is stored in the memory of the interface platform computer 17. It facilitates communications with the relational database management system 14 and is specifically configured for communication with a particular manufacturer's relational database system 14. ODBC drivers are commercially available from software manufacturers such as Progress Corporation of Atlanta, Georgia, and Openlink of Canada.
In Fig. 1 , the ODBC driver 36 is provided with the particular data or message which requires validation via an SQL action message from the transaction mapper 34. The ODBC will thereafter communicate with the relational database management system 14 via local area network 26 in order to validate the information as requested and will return a result message to the dispatcher 32 as shown. Finally, in step 46, the result message is returned from the dispatcher 32 and LAN manager 30, to the data terminal 12 which originated the validation request, and the transaction is complete. If the operator of the terminal 12 then wishes to update the relational database management system 14, the terminal 12 will either automatically, or upon operator command, send a new message to update the database. As with the validation message, the update message is received by the transaction mapper 34 from dispatcher 32. Unlike conventional interface systems, however, the transaction mapper will not make use of an ODBC driver to perform the actual update to the database management system 14. Although ODBC drivers are available which are designed to perform this task, they have proved to be less than satisfactory for this purpose for several reasons. Most importantly, use of ODBC drivers in conventional interface systems to modify the database content raises the possibility that the ODBC driver will not perform the update properly. Since ODBC drivers are not necessarily supplied by the manufacturer of the relational database management system 14, modifications and updates to the information contained in the database may not be performed properly. The result will be a loss of database integrity. Further, in those instances where the relational database management system 14 is updated or upgraded, such modifications may result in the need for updated ODBC drivers in conventional systems; and expense which is to be avoided if at all possible. In a preferred embodiment according to the invention, when an update type message is received in transaction mapper 34, it is recognized as such and is processed by the transaction mapper in a distinct manner as compared to other message types which merely require data validation. In step 48, the transaction mapper object 34 determines the specific type of update or modification which is required based upon the content of the update message, and then cross-references the update message type to identify a specific remote procedure call for performing the necessary update action. The remote procedure call, when transmitted to the relational database management system 14, will trigger the execution of a specific SQL based procedure which is stored in the relational database management system. The procedure thus called is a part of the relational database management system 14, and performs the specific update requested by the data terminal 12. Different procedures may be called in order to effect different types of updates or database modifications. The standard format for such calls when using the C + + programming language, for example, is RPCxx(AAA,BBB,CCC), where the xx identifies the specific stored SQL procedure to be called, and the AAA, BBB, and CCC are parameters or variables associated with the particular call.
Once the transaction mapper object 34 has identified the proper remote procedure call, it is preferably communicated to the repository object 38 in step 50. The remote procedure call is queued in the repository 38 in step 52 until a suitable time when the message is transmitted to the relational database management system 14. The communications between the repository and the local area network are advantageously effected by means of a socket object 40. The socket object is a commercially available object which is specifically designed for receiving packets of data from the local area network. For example, the socket may be a WinSoc object which is commercially available from Microsoft Corporation of Redmond, Washington. Once the remote procedure call has been transmitted in step 54 via local area network 26, the relational database management system is updated by the SQL procedure. As the invention can be embodied in other specific forms without departing from the spirit or essential attributes thereof, reference should be made to the following claims, rather than to the foregoing specification, as indicating the scope of the invention.

Claims

What is claimed is:
1 . A method for interfacing a data collection terminal with a relational database management system which has been implemented with stored procedures, comprising the steps of: receiving an update input message from said data collection terminal; retrieving a pre-determined action message responsive to said update input message, said action message configured for causing a stored procedure of said relational database management system to perform a database update in response thereto; communicating said action message to said relational database management system; and wherein said database update is performed via a remote procedure call to said stored procedures.
2. The method according to claim 1 further comprising the step of: receiving a validation input message from said data collection terminal, said validation input message including at least one transaction parameter; and validating said transaction parameter by means of an ODBC software driver.
3. The method according to claim 2 further comprising the steps of receiving a validation result message and communicating said validation result message to said data collection terminal.
4. The method according to claim 3 wherein said ODBC software driver communicates with said relational database management system, and said validation result message is communicated to said data collection terminal, via a local area computer network.
5. The method according to claim 1 wherein said pre-determined action message is comprised of at least one SQL statement.
6. The method according to claim 1 wherein said action message is communicated via a local area computer network.
7. The method according to claim 1 wherein said input message is communicated via a local area network.
8. A computer programmed with a routine of instructions stored in a physical medium for interfacing a data collection terminal with a relational database management system which has been implemented with stored procedures, said computer comprising: data receiving means for receiving an update input message from said data collection terminal; action retrieving means for retrieving a pre-determined action message responsive to said update input message, said action message configured for causing a stored procedure of said relational database management system to perform a database update in response thereto; data transmitting means for communicating said action message to said relational database management system; and wherein said database update is performed via an RPC call to said stored procedures.
9. The computer according to claim 8 further comprising means for receiving and processing a validation input message having at least one transaction parameter, said means for receiving and processing comprising an ODBC software driver.
10. The computer according to claim 9 wherein said ODBC software driver is configured for receiving a validation result message and communication means are provided for communicating said validation result to said data collection terminal.
1 1 . The computer according to claim 10 wherein said communication means includes a local area computer network.
12. The computer according to claim 8 wherein said pre-determined action message is comprised of at least one SQL statement.
13. The computer according to claim 8 wherein said action message is communicated via a local area network.
14. The computer according to claim 8 wherein said input message is communicated via a local area network.
PCT/US1998/015867 1997-07-31 1998-07-30 Method and apparatus for implementing software connectivity for client/server applications WO1999006925A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU86740/98A AU8674098A (en) 1997-07-31 1998-07-30 Method and apparatus for implementing software connectivity for client/server applications

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US90417397A 1997-07-31 1997-07-31
US08/904,173 1997-07-31

Publications (1)

Publication Number Publication Date
WO1999006925A1 true WO1999006925A1 (en) 1999-02-11

Family

ID=25418710

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US1998/015867 WO1999006925A1 (en) 1997-07-31 1998-07-30 Method and apparatus for implementing software connectivity for client/server applications

Country Status (2)

Country Link
AU (1) AU8674098A (en)
WO (1) WO1999006925A1 (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2001006365A2 (en) * 1999-07-19 2001-01-25 Groove Networks, Inc. Method and apparatus for activity-based collaboration by a computer system equipped with a communications manager
EP1223517A1 (en) * 1999-10-13 2002-07-17 Kabushiki Kaisha Visual Japan Data transmission system and sale managing system

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5586175A (en) * 1993-10-15 1996-12-17 Linkusa Corporation Call-processing system and method
US5712971A (en) * 1995-12-11 1998-01-27 Ab Initio Software Corporation Methods and systems for reconstructing the state of a computation
US5734718A (en) * 1995-07-05 1998-03-31 Sun Microsystems, Inc. NIS+ password update protocol

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5586175A (en) * 1993-10-15 1996-12-17 Linkusa Corporation Call-processing system and method
US5734718A (en) * 1995-07-05 1998-03-31 Sun Microsystems, Inc. NIS+ password update protocol
US5712971A (en) * 1995-12-11 1998-01-27 Ab Initio Software Corporation Methods and systems for reconstructing the state of a computation

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2001006365A2 (en) * 1999-07-19 2001-01-25 Groove Networks, Inc. Method and apparatus for activity-based collaboration by a computer system equipped with a communications manager
WO2001006365A3 (en) * 1999-07-19 2003-05-15 Groove Networks Inc Method and apparatus for activity-based collaboration by a computer system equipped with a communications manager
US6640241B1 (en) 1999-07-19 2003-10-28 Groove Networks, Inc. Method and apparatus for activity-based collaboration by a computer system equipped with a communications manager
EP1223517A1 (en) * 1999-10-13 2002-07-17 Kabushiki Kaisha Visual Japan Data transmission system and sale managing system
EP1223517A4 (en) * 1999-10-13 2004-01-14 Visual Japan Kk Data transmission system and sale managing system
US7363654B1 (en) 1999-10-13 2008-04-22 Kabushiki Kaisha Visual Japan Data transmission system and sale managing system

Also Published As

Publication number Publication date
AU8674098A (en) 1999-02-22

Similar Documents

Publication Publication Date Title
US6629098B2 (en) Method and system for validating data submitted to a database application
US8898294B2 (en) Reporting the state of an apparatus to a remote computer
EP1280059A2 (en) Automated software driver installation
EP0756725B1 (en) Interface device and method
US20070271584A1 (en) System for submitting and processing content including content for on-line media console
JPH11231927A (en) Monitor and control system
US20070204054A1 (en) ASN.1 protocol processor and method for ASN.1 protocol processing
US7237222B1 (en) Protocol for controlling an execution process on a destination computer from a source computer
US20010020249A1 (en) System for automatically providing internet services
CN112860798A (en) Data processing method and device, electronic equipment and storage medium
CN111404889A (en) Auditing method and device and client
US6049800A (en) Mechanism and method for performing callbacks
US7328234B1 (en) Agent architecture for triggering remotely initiated data processing operations
WO1999006925A1 (en) Method and apparatus for implementing software connectivity for client/server applications
WO1998038570A1 (en) Method and apparatus for programming a device with a software package obtained over a distributed data communication network
WO2005006212A2 (en) Automating real-time data feed to a database
CN111464515A (en) Data conversion method, device, equipment and storage medium
CN115357266A (en) CAN bus-based airborne equipment upgrading method and device and storage medium
CN115454472A (en) Remote upgrading problem solving method, device, equipment and readable storage medium
CN112540995B (en) Data updating method, electronic device and storage medium
CN115357434A (en) Complete machine testing method, device to be tested, computer device and storage medium
CN114398044A (en) Vehicle control and software configuration method, device, electronic equipment and storage medium
CN111858124A (en) Method and system for automatically detecting integrity of intelligent terminal driver
CN112214437A (en) Storage device, communication method and device and computer readable storage medium
CN110995838A (en) Intelligent element remote upgrading method and system based on CAN bus

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GE GH GM HR HU ID IL IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG UZ VN YU ZW

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): GH GM KE LS MW SD SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

121 Ep: the epo has been informed by wipo that ep was designated in this application
REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

NENP Non-entry into the national phase

Ref country code: JP

Ref document number: 1999511226

Format of ref document f/p: F

NENP Non-entry into the national phase

Ref country code: CA

122 Ep: pct application non-entry in european phase