[go: up one dir, main page]

WO2003067391A2 - Procede et systeme de conversion de donnees patrimoniales - Google Patents

Procede et systeme de conversion de donnees patrimoniales Download PDF

Info

Publication number
WO2003067391A2
WO2003067391A2 PCT/US2003/003599 US0303599W WO03067391A2 WO 2003067391 A2 WO2003067391 A2 WO 2003067391A2 US 0303599 W US0303599 W US 0303599W WO 03067391 A2 WO03067391 A2 WO 03067391A2
Authority
WO
WIPO (PCT)
Prior art keywords
data
processing
transaction
program
embedded
Prior art date
Legal status (The legal status 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 status listed.)
Ceased
Application number
PCT/US2003/003599
Other languages
English (en)
Other versions
WO2003067391A3 (fr
Inventor
Craig Mulligan
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
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 Individual filed Critical Individual
Priority to AU2003216188A priority Critical patent/AU2003216188A1/en
Publication of WO2003067391A2 publication Critical patent/WO2003067391A2/fr
Publication of WO2003067391A3 publication Critical patent/WO2003067391A3/fr
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00—Commerce
    • G06Q30/06—Buying, selling or leasing transactions
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/02—Banking, e.g. interest calculation or account maintenance

Definitions

  • the invention relates to a process for converting data and specifically to the process of converting legacy data into a format that can be viewed via the Internet.
  • IMS Information Management System
  • IMS Information Management System
  • the IMS transaction manager includes a facility called an open transaction manager access facility or OTMS.
  • OTMA provides an easier way of enabling users that connect to a system using the TCP/IP protocol to make information requests to IMS.
  • OTMA further includes a cross-system coupling facility (XCF) that facilitates communications between OTMA and OTMA clients.
  • XCF cross-system coupling facility
  • the process of delivering data to web applications in the prior art was to first invoke a transaction (submit a transaction request) through a message queue (MQ) series, The requested transaction is then passed to OTMA, which in turn passes it to the IMS for processing by applications being managed by IMS. Once the transaction is complete, a reply is passed back through OTMA and eventually back to MQ. MQ then strips off any data that was included in the request (the MFS overhead) and the data is delivered to the middleware layer. Thereafter, either the middleware layer (or the underlying web application) receives the data and places it into a useable format.
  • MQ message queue
  • this process involves several steps resulting in both a longer lag time prior to delivery to the web application and requires multiple transaction requests that creates significant overhead (such as MFS overhead) on the overall system.
  • MFS overhead significant overhead
  • the following invention addresses the above-mentioned needs in the art by providing a method for submitting and processing data requests without requiring any extra overhead wherein the data requested by the transaction is delivered in an XML format.
  • the method begins when the IMS control region evokes one of the legacy transactions, passing the I/O area containing the message to the transaction.
  • the control region is the execution environment for the IMS system software, the control blocks and storage pools required for managing communication access and application program scheduling.
  • the transaction passes the I/O area to a program, such as E900010.
  • E900010 scans the I O area and breaks out each of the key words passed in the I/O area.
  • the transaction ends and a code indicating the no key words were present is returned. If key words were passed, control is temporarily passed to the database portion of IMS server to determine if the requested data is housed within the database. If there is no data for the request, a code indicating this fact is returned. If data is detected, the transaction continues by retrieving the driver parameters. In the preferred embodiment, the driver parameters are retrieved from the database using the E9000DBP module provided with IMS. These parameters are then placed into a data array for processing.
  • control is passed to an XML object processor.
  • the system begins processing the "object.” While processing the parameter cards, which are the XML object structure, if an embedded tag is encountered, the program passes control to a subsequent copy of itself, which then processes the embedded object.
  • the parameter cards for each object may be used to invoke further database calls to retrieve any additional data required to fulfill the object. As each process completes, the "prior" application is run until the object and all associated data have been retrieved and assembled.
  • E900UCNV may be driven by the parameter cards to clean any character strings in the data that resides on the database on internal processing area.
  • E9000LMS may be used to prefix and postfix each piece of data with the tag housed within the parameter cards. The data is subsequently processed into the L/O area, which is then returned to the requestor.
  • E9DSPLY may be used for debugging purposes.
  • Figure 1 is a block diagram illustrating a standard EvIS system including OTMA and IMS connections.
  • Figure 2 shows a schematic/block diagram of a computer system.
  • Figure 3 is a block diagram illustrating the flow of data in one embodiment of a computer system logically comiected to the system and method of the present invention.
  • Figure 4 is a flowchart illustrating how a transaction request is submitted to the IMS server.
  • Figure 5 is a flowchart illustrating the improved transaction processing and data conversion process of the present invention.
  • IMS Information Management System
  • FIG. 1 a block diagram illustrating a standard IMS system 100 that may be used in accordance with the present invention is shown.
  • IMS 100 in comprised of two primary components: a transaction management system and a hierarchical database management system (not shown).
  • the EvIS system 105 includes a facility called an open transaction manager access facility or OTMA 110.
  • OTMA 110 provides an easier way of enabling computer system 120 using a transmission control protocol/internet protocol (TCP/IP) connection 125 to make information requests to IMS server 105.
  • TCP/IP transmission control protocol/internet protocol
  • OTMA 110 further communicates with a cross-system coupling facility (XCF) 130 that facilitates communications between OTMA 110 and OTMA clients 140.
  • XCF cross-system coupling facility
  • IMS terminal 150 may also be used to communicate and otherwise submit requests to the EvIS Server 105.
  • FIG. 2 shows a basic computer system 120.
  • the computer system 120 contains a Processing Element 202.
  • the Processing Element 202 communicates to other elements of the Computer System 200 over a System Bus 204.
  • a Keyboard 206 allows a user to input information into Computer System 200, and a Graphics Display 210 allows Computer System 200 to output information to the user.
  • Graphical Input Device 208 which may be a mouse, joy stick, or other type of pointing device, is also used to input information.
  • a Storage Device 212 is used to store data and programs within Computer System 200.
  • a Memory 216 also connected to System Bus 204, contains an Operating System 218, and relevant Software 220.
  • a Communications Interface 214 is also connected to System Bus 204.
  • Communications Interface 214 may have one or more serial ports, parallel ports, infrared ports, and the like. Connectable through Communications Interface 214 may be an external printer or scanner, as well as access to a computer network (LAN or WAN), to the Internet, or to any other appropriate communication channel.
  • LAN or WAN computer network
  • the web-based applications include a web browser.
  • the web browser supports the extensible markup language or XML Using this browser, a request is submitted for data and that request is submitted via TCP/P 125 to a web server 310.
  • the web server 310 may further include various CGI programs and/or scripts 320 that receive messages from the web browser and processes the transaction.
  • the process of delivering data to web applications that are running on a computer system 120 begins by invoking a transaction through a message queue (MQ) series (not shown).
  • MQ message queue
  • the requested transaction is then passed to OTMA client 140 and OTMA 110, which in turn passes it to the IMS 105 for processing.
  • OTMA 110 passes it to the IMS 105 for processing.
  • a reply is passed back through OTMA 110 and eventually back to MQ.
  • MQ strips off any data that was included in the request (the MFS overhead) and the data is delivered the CGI program 320.
  • the CGI program 320 then delivers it back to the web server 305 that transmits the final result via TCP/IP 125 for display on the computer system 120. For example, let us assume that the requesting agent enters information into the computer system 120 and submits a request to update their address via a web server 310.
  • the requesting agent may be a physician's office, medical center, hospital etc and the relevant software 220 in the computer system 120 might be the Physician Office and Management System.
  • the Web server 310 reviews the information entered by the requesting agent in real time for embedded viruses and errors. Also, web server 310 may also verify the authority of the requesting agent to access the requested transaction. In a preferred embodiment of the invention, the formats and field sizes of all data elements of the information entered by the requesting agent are analyzed by the web server 310 and mis-keyed or erroneous data is brought to the attention of the requesting agent. In this way, any submitted request with incompatible data is halted and a notice highlighting the incompatible data is returned to the requesting agent.
  • the web server 310 in conjunction with one or more CGI programs 320, creates a string of the data submitted by the requesting agent and this string is converted through a real-time transaction into the appropriate entry format for the OTMA client 140.
  • a transaction record is created by storing one or more attributes relating to the requesting agent's transaction into a single entry having a locally unique identifier.
  • the identifier could be a database entry address, a pointer to memory location, an offset value, or other methods that can be used to establish a locally unique identifier for the stored data.
  • the attribute or attributes relating to the requested host process are stored in a database that is associated with or under the control of the IMS server 105 and given a unique identification.
  • the attributes could be assigned a unique ID by storing separate instances within the same database.
  • an identifier associated with the requesting agent or the person for whom the request is made is stored in the Database.
  • an initial tier of the IMS server (or associated programs or routines) prepares and formats the requesting agent's submitted transaction for transmission to a host (not shown). While this invention will be described with reference to managing an assortment of transactions, the invention could also be applied in such a way that only related transactions are managed by the same transaction manager.
  • the initial tier of the system may use Enterprise Java Beans ("EJB") to access the database associated with a host.
  • EJB Enterprise Java Beans
  • Java Beans is a trademark of Sun Microsystems, In.
  • a Java Bean can be used to access data or applications that create data, from a legacy host or database.
  • a host is a unit that includes at least one processor and one or more instructions associated with a process performed by the host.
  • a host may be an "update host” that updates entries to a particular database. While the word host implies singularity, the "host” unit may comprise one or more actual processing units that may be physically separated or otherwise distributed on a given network.
  • the designation of a processing unit as a "host" in one transaction does not restrict the host from serving as an initiating agent in the same or related transactions. For example, a given host may submit requests to one or more host "subprocessing" machines.
  • a single requested transaction could result in transaction entries for different layers of processing.
  • the host When the host is available, it receives and can commence processing the transaction request sent by the requesting agent via the middleware bridge (if applicable).
  • the method of the present invention begins when the IMS server 120 receives the transaction request and the control region of the IMS Server 120 evokes 405 one of the legacy transactions, passing the I/O area containing the message to the transaction.
  • the control region is the execution environment for the IMS system software, the control blocks and storage pools required for managing communication access and application program scheduling.
  • the transaction passes 410 the VO area to a program, such as E900010.
  • E900010 breaks out or otherwise identifies 415 each of the key words passed in the I/O area. Again, the specific manner in which this is performed is not relevant to the present invention provided that the program being used is capable of identifying one or more key words in the transaction request. If no key words have been passed or identified by E900010, the transaction ends and returns 420 a code indicating the no key words were present. If key words were passed, control is temporarily passed to the database portion of IMS to determine 425 if the requested data is housed within the database. If there is no data for the request, the system returns 430 a code indicating this fact.
  • the transaction continues by retrieving 435 the driver parameters.
  • the driver parameters are retrieved from the database using the E9000DBP module provided with IMS. These parameters are then stored 440 in a data array for processing. Once the data keys have been set and the driver parameters stored, control is passed 445 to an XML object processor. Referring now to FIG. 5, a flow chart illustrating the XML processing of the present invention is shown. Using pointers to the data array, the system begins processing 505 the "object" including both the data keys and parameter cards. While processing 505 the parameter cards, which are the XML object structures, the program determines if an embedded tag is present 510. If not, the program continues to process 505 the object accordingly.
  • the program creates or calls another instance of the program 515 and passes control 520 to the subsequent copy of itself.
  • This "copy" or additional instance then processes the embedded object.
  • the parameter cards for each object may be used to invoke further database calls to retrieve any additional data required to fulfill the object.
  • the "prior" application is run until the object and all associated data have been retrieved and assembled. While the flowchart only illustrates the processing of a single embedded tag, it is quite possible for the embedded tag to itself included embedded tags. In such a case, another instance of the program would be created to process this "second level" embedded tag. Again, this process can continue to call additional copies of the program until the last of the embedded links have been resolved.
  • This recursive process (or emulated recursive process) is normally not permitted by Cobol (the base language used in EVIS) but the process above avoids this restriction.
  • Additional functions may also be used, For example, a program or call, such as a call to E900UCNV, may be driven by the parameter cards to clean any character strings in the data that resides on the database on internal processing area.
  • a program or call such as E9000LMS, may be used to prefix and postfix each piece of data with the tag housed within the parameter cards.
  • a program or call such as E9DSPLY, may be used for debugging purposes. Once the data has been fully processed it is returned to the I/O area, which is then returned to the requestor.
  • the present invention provides a number of important benefits.
  • the speed of processing is increased because multiple steps are eliminated.
  • the first step that is eliminated is the work done via MQ series calls.
  • the work of stripping off the additional data sent with traditional transactions tacked on by MFS is eliminated, for example.
  • the transaction since the transaction was built from scratch meaning that MFS was not used, the transaction is allowed to directly respond back to the requester with an XML object.

Landscapes

  • Business, Economics & Management (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Engineering & Computer Science (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Development Economics (AREA)
  • Theoretical Computer Science (AREA)
  • Technology Law (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Document Processing Apparatus (AREA)

Abstract

L'invention porte sur un procédé selon lequel en réponse à une demande de transaction provenant d'une machine client, on recherche tout mot clef lié à la demande. Si on en trouve, les données associées et un ou plusieurs paramètres de pilote sont récupérés dans la base de données, puis placées dans un réseau de données en vue de leur traitement, et on passe les commandes à un processeur d'objets XML. Pendant le traitement des cartes de paramètre, qui sont les structures d'objets XML, si on rencontre un marqueur enfouis, on passe les commandes à une copie suivante du programme qui effectue le traitement de l'objet enfouis. On peut utiliser les cartes de paramètres de chaque objet et faire appel à d'autres bases de données pour récupérer toute donnée additionnelle nécessaire pour réaliser l'objet. Les différents processus étant achevés, on réexécute l'application de départ jusqu'à ce que l'objet et toutes les données associées aient été récupérées et assemblées. Lorsque toutes ces opérations sont terminées, on transmet les données traitées à la machine client en vue de leur présentation.
PCT/US2003/003599 2002-02-07 2003-02-07 Procede et systeme de conversion de donnees patrimoniales Ceased WO2003067391A2 (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
AU2003216188A AU2003216188A1 (en) 2002-02-07 2003-02-07 Method and system for converting legacy data

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US35522402P 2002-02-07 2002-02-07
US60/355,224 2002-02-07

Publications (2)

Publication Number Publication Date
WO2003067391A2 true WO2003067391A2 (fr) 2003-08-14
WO2003067391A3 WO2003067391A3 (fr) 2003-12-04

Family

ID=27734484

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2003/003599 Ceased WO2003067391A2 (fr) 2002-02-07 2003-02-07 Procede et systeme de conversion de donnees patrimoniales

Country Status (2)

Country Link
AU (1) AU2003216188A1 (fr)
WO (1) WO2003067391A2 (fr)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8397226B2 (en) 2006-08-14 2013-03-12 Microsoft Corporation Pattern matching over structured literals
US8924395B2 (en) 2010-10-06 2014-12-30 Planet Data Solutions System and method for indexing electronic discovery data

Family Cites Families (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6910216B2 (en) * 2000-08-08 2005-06-21 International Business Machines Corporation IMS transaction messages metamodel
US6912719B2 (en) * 2000-08-08 2005-06-28 International Business Machines Corporation Type descriptor metamodel
US6904598B2 (en) * 2000-08-08 2005-06-07 International Business Machines Corporation COBOL metamodel
US6775680B2 (en) * 2000-08-08 2004-08-10 International Business Machines Corporation High level assembler metamodel
US7559066B2 (en) * 2000-08-08 2009-07-07 International Business Machines Corporation CICS BMS (basic message service) meta model
US6915523B2 (en) * 2000-08-08 2005-07-05 International Business Machines Corporation PL/I metamodel
US7487110B2 (en) * 2001-01-30 2009-02-03 International Business Machines Corporation Automotive information communication exchange system, method, and program product

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8397226B2 (en) 2006-08-14 2013-03-12 Microsoft Corporation Pattern matching over structured literals
US8924395B2 (en) 2010-10-06 2014-12-30 Planet Data Solutions System and method for indexing electronic discovery data

Also Published As

Publication number Publication date
WO2003067391A3 (fr) 2003-12-04
AU2003216188A1 (en) 2003-09-02
AU2003216188A8 (en) 2003-09-02

Similar Documents

Publication Publication Date Title
US20040006739A1 (en) Method and system for converting legacy data
US6854120B1 (en) Accessing a ERP application over the internet using strongly typed declarative language files
US6105028A (en) Method and apparatus for accessing copies of documents using a web browser request interceptor
US7240125B2 (en) Apparatus and method for using a directory service for a user registry
US6738775B2 (en) Database communication system and method for communicating with a database
US7281029B2 (en) Method and system of capturing data for automating internet interactions
US6701352B1 (en) Method and apparatus for importing information from a network resource
US8533662B1 (en) Method and system for performing operations on data using XML streams
US20030093404A1 (en) Dynamic interface adapter for integration of source and target applications
US20040030991A1 (en) Systems and methods for facilitating automatic completion of an electronic form
US20020196281A1 (en) Generating a graphical user interface from a command syntax for managing multiple computer systems as one computer system
US20050114349A1 (en) Method and apparatus for serving electronic information to a user over a computer network
US20040034833A1 (en) Dynamic interaction manager for markup language graphical user interface
JP2002517823A (ja) 万能フォーム・エンジン
US8275779B2 (en) Data tranformations for applications supporting different data formats
WO2006014735A1 (fr) Tableau de bord a taches heterogenes
US8141106B2 (en) Managing elements residing on legacy systems
WO2003067400A2 (fr) Salle d'attente électronique
US20100185634A1 (en) Data tranformations for a source application and multiple target applications supporting different data formats
US20080077945A1 (en) System and method for providing a graphical user interface for disparate applications
US7225202B2 (en) Method and apparatus for generating query and response statements at runtime from generic requests
US20080172601A1 (en) Tool for configuring available functions of an application
US6836801B1 (en) System and method for tracking the use of a web tool by a web user by using broken image tracking
WO2003067391A2 (fr) Procede et systeme de conversion de donnees patrimoniales
JPH11232349A (ja) 設備のサービス要求を管理するためのシステムおよび方法、ならびに、設備のサービス要求を管理するための命令シーケンスを記憶する、コンピュータ可読な媒体

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ OM PH PL PT RO RU SD SE SG SK SL TJ TM TN TR TT TZ UA UG US UZ VN YU ZA ZM ZW

AL Designated countries for regional patents

Kind code of ref document: A2

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

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
122 Ep: pct application non-entry in european phase
NENP Non-entry into the national phase

Ref country code: JP

WWW Wipo information: withdrawn in national office

Country of ref document: JP