AU2001242008A1 - Method and system for reporting XML data from a legacy computer system - Google Patents
Method and system for reporting XML data from a legacy computer systemInfo
- Publication number
- AU2001242008A1 AU2001242008A1 AU2001242008A AU2001242008A AU2001242008A1 AU 2001242008 A1 AU2001242008 A1 AU 2001242008A1 AU 2001242008 A AU2001242008 A AU 2001242008A AU 2001242008 A AU2001242008 A AU 2001242008A AU 2001242008 A1 AU2001242008 A1 AU 2001242008A1
- Authority
- AU
- Australia
- Prior art keywords
- data
- computer system
- legacy computer
- xml
- legacy
- 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.)
- Granted
Links
Description
METHOD AND SYSTEM FOR REPORTING XML DATA FROM A LEGACY COMPUTER SYSTEM
TECHNICAL FIELD
This invention relates in general to the field of computer systems, and more particularly a method and system for reporting XML data from a computer system.
CROSS REFERENCE TO RELATED APPLICATIONS
This application relates to U. S. Patent Application
Serial Number , entitled METHOD AND SYSTEM FOR
MODELING LEGACY COMPUTER SYSTEM, by Ballantyne, et al . , filed concurrently with this application.
This application relates to U. S. Patent Application
Serial Number , entitled METHOD AND SYSTEM FOR
APPLYING XML SCHEMA, by Ballantyne, et al . , filed concurrently with this application.
BACKGROUND OF THE INVENTION
The Internet and e-commerce are rapidly reshaping the way that the world does business. In addition to direct purchases made through the Internet , consumers increasingly depend upon information available through the Internet to make purchasing decisions. Businesses have responded by allowing greater access of information
through the Internet both directly to consumers and to other businesses such as suppliers. One result of the increased access to electronic information through the Internet is a decreased dependency and desire for printed "hard copy" information.
Extensible Mark-up Language ("XML") provides an excellent tool for business-to-business electronic commerce and publication of data via the Internet. XML specifies a format that is easily adapted for data transmission over the Internet, direct transfer as an object between different applications, or the direct display and manipulation of data via browser technology. Currently, complex transformations are performed on data output in legacy computer system formats in order to put the data in XML format.
One example of the transformation from written reports typically output by legacy computer systems to electronic reports is the telephone bill. Historically, telephone companies have relied on mainframe or legacy computer systems running COBOL code to track and report telephone call billing information. Typically, these legacy computer system reports are printed, copied and distributed to those who need the information. However, conventional legacy computer system report formats are difficult to transmit or manipulate electronically. Yet, the electronic distribution of bills, such as through e- mail, a biller's web site or at a bill consolidator chosen by the consumer, enhances flexibility and control of bill payment, especially with complex business invoices.
Generally, in order to make conventional legacy reports available in different formats, a complex transformation of the data is performed based on a report print stream. One transformation technique is to write a "wrapper" around the legacy computer system. The wrapper includes parsers and generators that transform legacy computer system reports into XML formatted output . Parsers apply a variety of rules to identify and tag data output in a legacy report. For example, a parser might determine that a data field of a telephone bill represents a dollar amount based on the presence of a dollar sign or the location of a decimal point in the data field, or that a data field represents a customer name due to absence of numbers . Once the parser deciphers the legacy report, a generator transforms the legacy computer system data into appropriately tagged XML format .
Although the end result of the parsing and transforming process is data in an XML format, the process itself is difficult and expensive to implement and cumbersome to maintain. Without careful study of underlying program logic, it is generally not possible to reliably determine all potential outputs from the legacy computer system. In particular, even a fairly large output sample is almost certain to be incomplete in that some program logic is only rarely exercised. Another difficulty with the parsing and transforming process is that , as changes are made to the underlying program applications of the legacy computer system, the parsing and transforming systems generally require updates that mirror the underlying changes . These downstream changes
increase the time and expense associated with maintaining the legacy computer system, and also increase the likelihood of errors being introduced into the XML formatted output. Another difficulty associated with the use of XML is that, although XML dramatically improves the utility of output data, the generation of XML output depends upon underlying programs that adhere to an exacting data structure. For instance, the generation of syntactically correct XML requires adherence to a rigid labeled tree structure so that output data is identified by "tags" and "end tags" associated with the XML data structure as defined by an XML schema. When writing a deeply embedded element of an XML tree, such as a subschema within a defined XML schema, tags corresponding to all of that element's ancestor elements must also be written. When writing another element, not part of a current XML subschema, the current subschema must be closed off to an appropriate level with balancing closing end tags for the ancestor elements. XML schema also specify type and cardinality constraints on their elements. Thus, substantial and exacting bookkeeping of programs that output XML is necessary with respect to the XML schema in order to minimize errors on the part of programmers.
SUMMARY OF THE INVENTION
Therefore, a need has arisen for a method and system which rapidly and automatically modifies legacy computer systems to produce output in an XML format . A further need exists for a method and system which modifies legacy computer systems to produce output in XML
format without altering the underlying legacy computer system program logic or business rules.
A further need exists for a method and system which determines write operations of a legacy computer system to allow modification of those nodes so that the legacy computer system outputs data in XML format.
A further need exists for a method and system which generates syntactically correct XML output* with automated bookkeeping to minimize programming errors. In accordance with the present invention, a method and system is provided that substantially eliminates or reduces disadvantages and problems associated with previously developed methods and systems that transform the output from legacy computer systems into an XML format. The present invention provides XML output by modifying the underlying legacy computer system program applications to report data in XML format instead of transforming the output from the legacy computer system after the data is reported in the format of the legacy computer system.
More specifically, a code generation engine automatically modifies legacy computer system program applications to create modified legacy program applications. The modified legacy program applications are run on the legacy computer system so that the data output from the legacy computer system is in XML format. The modified legacy program applications are written in the computer language of the legacy computer system so that the legacy computer system directly produces an XML version of its output without the need to alter the logic
or business rules embodied in the unmodified program applications of the legacy computer system.
The code generation engine creates the modified program applications in accordance with a modification specification created by a mapping engine. The mapping engine generates the modification specification and context table by mapping a model of write operations of the legacy computer system to an XML schema. The mapping engine provides the modification specification to the code generation engine. The code generation engine creates modified legacy computer system program applications for use on the legacy computer system. A writer engine is an application program loaded on the legacy computer system and written in the language of the legacy computer system. The writer engine is called by the modified program applications to write XML output in the format of the XML schema encoded by the context table.
The model used by the mapping engine is generated by a modeling engine which analyzes the legacy computer system to identify and model the write operations, such as with a report data model. The modeling engine determines a list of legacy computer system program applications that report data. The program applications that report data are further analyzed to determine the incidents within each program application at which a write operation exists. A report data model is then compiled with a value and/or type for the data fields of each incident. The report data model is augmented by a formal grammar that simplifies the process of relating
write operations to execution paths of legacy computer system program applications.
Once the modified program application is loaded on the legacy computer system, the legacy computer system continues to perform its functional operations without change to the underlying business or program logic. When a legacy computer system program application commands the reporting of data, modified instructions provided in the modified program application call the writer engine to output syntactically correct XML data. The writer engine determines the current context of XML output and opens appropriate schema element data structures in conjunction with the context table. The writer engine then analyzes the current schema element data structure and the called schema element to determine the relationship of the called schema element with the current schema -element . If the called schema element is a descendant of the current schema element, the writer engine opens the schema element ID tags down through the called schema element and outputs the data from the schema element in syntactically correct XML format. If the schema element is not a descendant of the current schema element, the writer engine finds a mutual ancestor having consistent cardinality, closes the schema element ID tags up to the ancestor schema element and proceeds to open the schema element ID tags down through the called schema element to output data in syntactically correct XML format. In addition, the writer engine supports delayed printing of tags and attributes until such time as a complete syntactic unit is available.
The present invention provides a number of important technical advantages . One important technical advantage is the ability to rapidly and automatically modify legacy computer system program applications to enable them to directly produce an XML version of their data output. By modifying the underlying legacy computer system program applications, XML output is made available directly from the legacy computer system without a transformation of the "data itself from a legacy computer system format. Further, the underlying program logic and business rules remain unaltered so that the substantive functions of the legacy computer system need not change. Thus, a business enterprise using a legacy computer system is provided with the greater accessibility to data provided by output in XML format without affecting computed values.
Another important technical advantage of the present invention is that modification of the underlying legacy computer program applications is operationally less expensive, complex and time-consuming than transformation of legacy computer system output to an XML format. For instance, once modified program applications are running on the legacy computer system, XML formatted output is available without further action to the data. By comparison, transformation of output to an XML format after the data is reported by the legacy computer system requires action with each data report. Thus, if any changes are made to the underlying legacy program applications, changes must also generally be made to transformation applications that mirror the underlying changes. This further complicates the maintenance of the legacy computer system.
Another important technical advantage of the present invention is that, whether or not used with a legacy computer system, the writer engine and context table aid in the generation of syntactically correct XML output. For instance, the writer engine ensures that a command to write an embedded XML element will include tags corresponding to all of the embedded element's ancestor elements. Also, when an XML element is written that is not part of the current XML subschema, the writer engine will close off the current XML subschema to an appropriate level of an ancestor schema element. Automation of the bookkeeping involved with the XML schema eliminates the risk of syntactic errors associated with XML reports . The delayed printing feature provides a mechanism whereby a program can generate correct XML data even when the sequence of print commands in the original legacy system application program does not map directly onto the order of XML elements prescribed by the XML schema. Another important advantage of the present invention is that tool support manages the complexity of modeling the underlying program logic, resulting in substantially reduced time and expense for modification of a legacy computer system to output XML formatted data. Tools aid in: the determination of the control flow graph of legacy applications; the abstraction out of this graph of a subgraph specifically related to the writing of report lines; the identification of constants and data items that flow into print lines so that the elements that need to be written as tagged XML can be readily identified; and the identification of domain specific information
such as locations of headers and footers. Automation through tool support greatly enhances management of program complexity.
BRIEF DESCRIPTION OF THE DRAWINGS
A more complete understanding of the present invention and advantages thereof may be acquired by referring to the following description taken in conjunction with the accompanying drawings, in which like reference numbers indicate like features, and wherein: Figure 1 depicts a block diagram of a code generation system in communication with a legacy computer system;
Figure 2 depicts a flow diagram of the generation of modified legacy program applications to output XML data; Figure 3 depicts a flow diagram of the generation of a model of the write operations of a legacy program application;
Figure 4 depicts a sample output of a legacy computer system report for a telephone bill;
Figure 5 depicts XML formatted data corresponding to the legacy computer system report depicted by Figure 4 ;
Figure 5A depicts an XML schema for the output depicted in Figure 5; Figure 6 depicts a graphical user interface for mapping legacy computer system code to an Extensible Markup Language schema and report data model ;
Figure 6A depicts underlying COBOL code modeled by the report data model of Figure 6 ; Figure 7 depicts a sample Extensible Markup Language schema for outputting address data;
Figure 7A depicts a tree structure for the schema of Figure 7 ;
Figure 7B depicts a computed data context table for the schema depicted by Figure 7; and Figure 8 depicts a flow diagram of an XML print operation that ensures generation of syntactically correct Extensible Markup Language data output.
DETAILED DESCRIPTION OF THE INVENTION Preferred embodiments of the present invention are illustrated in the figures, like numeral being used to refer to like and corresponding parts of the various drawings .
In order to take advantage of the opportunities provided by the use of XML as a medium for e-commerce, businesses will eventually have to either replace existing legacy computer systems or re-write the applications on the legacy computer systems. However, businesses have substantial investments in their existing legacy computer systems and related applications so that wholesale replacement of these systems and applications is not practical in the short term. Legacy computer systems perform essential functions such as billing, inventory control, and scheduling that need massive on- line and batch transaction processing. Legacy computer system applications written in languages such as COBOL remain a vital part of the enterprise applications of many large organizations for the foreseeable future. In fact, this installed base of existing software represents the principal embodiment of many organizations' business rules. Although, in principle, these applications could
be hand-modified to output data in XML format, in reality the underlying logic of even a simple report application can be difficult to understand and decipher.
Therefore, a tremendous challenge facing many businesses is the rapid and inexpensive adaptation of existing computer systems to take advantage of the opportunities presented by electronic commerce. Even when installing new and updated computer systems, the ever-evolving nature of electronic commerce demands that businesses incorporate flexibility as a key component for new computer systems . XML has become a popular choice for reporting data due to the ease with which XML adapts to essential e-commerce functions, such as transmission over the Internet, direct transfer as an object between different applications and display and manipulation via browser technology. XML's flexibility results from its inclusion of named tags bracketing data that identify the data's relationship within an XML schema. However, implementation of XML data reports relies on accurate use of tags to define the output data within the XML schema. Thus, computer systems that implement XML adhere to the XML schema and use exact bookkeeping to obtain accurate reports .
The present invention aids in the implementation of XML for reports, both by the modification of legacy computer system program applications to output XML data and by the tracking of XML output within an XML schema to ensure an accurate output, whether or not the XML data originates with a legacy computer system. Referring now to Figure 1, a block diagram depicts a computer system 10 that modifies a legacy computer system 12 to output data
in XML format. A code generation system 14 interfaces with legacy computer system 12 to allow the analysis of one or more legacy program applications 16 and the generation of one or more modified legacy program applications 18. Code generation system 14 also provides a writer engine 20 and context table 22 to legacy computer system 12. Legacy computer system 12 is then able to directly output XML formatted data when modified legacy program applications 18 call writer engine 20 in cooperation with context table 22 to output syntactically correct XML data.
Code generation system 14 includes a code generation engine 24, a mapping engine 26 and a modeling engine 28. Modeling engine 28 interfaces with legacy computer system 12 to obtain a copy of legacy program applications 16 for automated review and modeling. Modeling engine 28 generates a list of incidents for points in the program at which data is written. For instance, modeling engine 28 may search the source code of the legacy program applications for reporting or writing commands for selected output streams. The list of report incidents are used to model the report functions of the legacy computer system such as by a report data model that lists the values and types of written data fields from the legacy program applications 16. The list of report incidents is then augmented by a formal grammar that is used to relate the XML schema to the output reported by the legacy program applications. The list of report incidents and the formal grammar are two components of the report data model for the legacy system application program. Intuitively, an incident describes a line in a
report, and the formal grammar describes how the application program sequences those lines to form a report .
Modeling engine 28 provides the report data model identifying report incidents in the legacy program applications 16 to mapping engine 26 and modeling/mapping graphical user interface 30. Mapping engine 26 maps the report incidents from the report data model to the XML schema 32 and this relationship between the report data model and XML schema 32 is displayed on modeling/mapping graphical user interface 30. By establishing the relationship between the report incidents of legacy program application 16 and the XML schema 32, mapping engine 26 defines a specification for modification of the legacy program applications 16 to output XML data.
Modeling/mapping graphical user interface 30 provides information to programmers of the modification specification. Modeling/mapping graphical user interface 30 produces a modification specification and a context table 22. Optionally, the modeling/mapping graphical user interface 30 allows programmers to create or modify an XML schema.
Code generation engine 24 accepts the modification specification, a copy of the legacy program applications 16, and context table 22 to generate modified legacy program applications 18. Based on the modification specification, code generation engine 24 generates source code in the computer language of the legacy computer system that is inserted in legacy program applications 16 to command output of XML data and saves the modified source code as modified legacy program applications 18.
The modified legacy program applications 18 may continue to maintain the legacy computer system report instructions so that the modified program applications 18 continue to report data in the legacy computer system format in addition to the XML format. The outputting of both formats aids in quality control by allowing a direct comparison of data from modified and unmodified code. Alternatively, the modified instructions provided by code generation engine 24 may replace report instructions of legacy program applications 16 so that modified legacy program applications 18 report data exclusively in XML format. Writer engine 20 is written in a computer language of legacy computer system 12 and references context table 22 to determine the appropriate XML schema elements for output of data from legacy system 12. The modified code in modified legacy program applications 18 calls writer engine 20 when outputting data in XML format .
Referring now to Figure 2, a simplified flow diagram depicts the process of generation of modified legacy program applications that output data in XML format. The process begins at step 34 in which the legacy code of the legacy program applications 16 is made available to code generation system 14. For example, a mainframe legacy computer system running COBOL source code downloads a copy of the source code to code generation system 14 for analysis and generation of modified code.
At step 36, code generation system 14 models the legacy program applications to provide a report data model of the write incidents and their underlying grammar from the legacy program applications' code. For
instance, a report data model identifies the incidents within the code of legacy program applications 16 at which data to selected output devices are written, including the values and types of the data. At step 38, the report data model is used to generate a modification specification. The modification specification is generated in conjunction with an XML schema provided at step 40 that defines the data structure for write instructions of the modified legacy program applications 18 to output XML data.
At step 42, the modification specification is used to automatically generate modified legacy code to be run on the legacy computer system 12. The modified legacy code is run at step 44 so that the modified legacy program applications emit output from legacy system 12 in XML format without requiring further transformation of the output data .
The process of modeling legacy computer system 12 is shown in greater detail by reference to Figure 3. Modeling engine 28 extracts a report data model of legacy program applications 16 through an automated analysis of the underlying legacy code. The automated analysis provides improved understanding of the operation of the legacy code and reduces the likelihood of errors regarding the operation and maintenance of the underlying legacy code. Essentially, modeling engine 28 parses the legacy software process into rules to graph its control flow. An abstraction of the control flow produces a report data model that allows understanding of data types and invariant data values written at each write instruction in the report data model. The report data
model, when combined with the values and typing of written data fields, provides a model of legacy program applications 16.
Referring to Figure 3, the modeling process starts at step 46 through a determination of the legacy programs' control flow graph. The control flow graph of a particular legacy program application is a directed graph (N, A) in which N contains a node for each execution point of the program application and A contains an arc <nι, n2>, where ni and n2 are elements of N, if the legacy program application is able to move immediately from τi to n2 for some possible execution state.
At step 48, the write operations of the control flow graph are determined to obtain a data file control graph. Essentially, the control flow graph is abstracted to contain only start nodes, stop nodes, and nodes writing to selected data files. This results in a data file control graph that identifies the write incidents in the legacy program applications. The data file control graph abstracted from a control flow graph (N, A) is a directed graph (NR, AR) . A node n is in the set of nodes NR if the node n starts a legacy program application, stops a legacy program application or writes to a data file. The arc <nι,_ nm> is in AR if both ni and nm are in the set of nodes NR and a sequence of arcs <nι, n2>, <n2, n3>, . . . <nm.1# nm> exists in A where, for i from 2 to ιrt-1, ni is not in the set of nodes NR.
Once the data file control graph is completed, at step 50, information about the data written at each data file write node is attached to the data file control graph. For instance, the values or the type of each data
field written by each node are statically determined via data flow in the control flow graph and are attached to the nodes of the data file control graph.
At step 52, the paths from the start nodes through the data file control graph to the stop nodes are represented in a formal grammar. This formal grammar with the attached data field information form the report data model . This model is an abstract representation of the data files that can be written by the legacy program applications and provides the basis on which a modification specification can be written.
The report data model is presented in two parts . First, each write node with its attached data field information is presented as an incident. These incidents are the most basic or leaf sub-expressions of the report data model. Second, the non-leaf sub-expressions of the report data model are presented as rules hierarchically building up from the incidents.
The generation and presentation of a report data model of legacy program applications may be illustrated by consideration of a telephone bill example. Figure 4 depicts the printed output from a COBOL program for a telephone bill. A typical COBOL program prints the telephone bill in a predetermined format that may include, for example, predetermined paper sizes and column dimensions. The printing of the "TOTAL CALLS" line in Figure 4 is the result of a computation of the total number of calls, total time of the calls and the total cost of the calls. As an example of a single node of a control flow graph, the incident derived from COBOL
code for outputting the total calls line of Figure 4 is as follows :
Incident 47 loc 414 record PRTEC from RS-LINE <LINE 2>
0 " TOTAL CALLS : " 14 RECORDS-SELECTED-EDIT loc 266 pic Z,ZZ9 size 5 19 " TOTAL TIME: " 53 RS-HH loc 270 pic 99 size 2 55 56 RS-MM loc 272 pic 99 size 2 58 II . II 59 RS-SS loc 274 pic 99 size 2 61 II II 63 RS-COST loc 276 pic $$$$$.99 size 8 71
Incident 47 describes the data written at the appropriate point in the program by the write instruction at line 414. The data include the headings of "TOTAL CALLS" and "TOTAL TIME" followed by the accumulated values for the total number of calls, the total time of calls and the total cost of calls. The constant values "TOTAL CALLS" and "TOTAL TIME" are determined by data flow analysis of the legacy application program. The report data model includes grammar rules built up from the write incidents . Once each grammar rule is defined from the appropriate incidents and sub-rules, a report grammar describing the potential output of the legacy program applications for the bill shown in Figure 4 is generated as follows:
Rule 23 [seq 3 4 5 6 7 8 9 10 ]
Rule 24 [ ? 23 ]
Rule 41 [seq 23 24 25 ]
Rule 42 [ ?41 ] Rule 45 [seq 0 1 2 42 ]
Rule 46 [ ? 45 ]
Rule 50 [seq 24 49 ]
Rule 51 [ ? 50 ]
Rule 61 [seq 24 47 48 51 23 ] Rule 62 [ ? 61]
Rule 63 [seq 62 24 25 ]
Rule 64 [* 63 ]
Rule 78 [seq 46 64 24 47 48 50 65 66 ]
Root 79 [seq 78 ]
These grammar rules show how the write incidents are combined to represent the output written by the legacy application program. For example, rule 61 consists of the sequence of sub-rules and incidents 24, 47, 48, 51, and 23. Data described by each sub-rule or incident is followed sequentially in the data file by the data described by the next sub-rule or incident. That is, in rule 61, data described by incident 47 is followed immediately by data described by incident 48. Rule 62 is a conditional rule indicating that data described by 61 may be written to the data file or skipped entirely. Rule 64 is a repeating rule indicating that there is data described by rule 63 that is repeated zero or more times. Referring now to Figure 5, data formatted according to the XML schema of Figure 5A is depicted that provides a data structure for the legacy computer output of Figure 4. The data falls within an opening tag of "<bill>" and a closing tag of "</bill>". The "bill" schema includes a "detail-list" subschema that, in turn, includes a "detail-by-phone" subschema. Within the "detail-by- phone" subschema separate tags are defined that report
the data from the TOTAL CALLS line of Figure 4. The "total-bill-by-phone" subschema, the "total-time-by- phone" subschema and the "total-calls" subschema define the data printed in the TOTAL CALLS line of the legacy computer system output .
Figure 5A depicts the XML bill schema used to output the data in Figure 5. The root element of the schema is the element type named "bill". Its subschemas are types of the subelements. The detail-by-phone subschema of the detail-list subschema of bill includes the data structure reported in the TOTAL CALLS line of Figure 4.
Referring now to Figure 6, one example of a display by the modeling/mapping graphical user interface 30 illustrates the mapping relationship between the XML schema, the report data model and the underlying legacy computer program application depicted as COBOL code in Figure 6a. A grammar window 54 lists the report data model grammar rules provided by the report data model of the legacy program applications. An XML schema window 56 depicts the XML schema depicted by Figure 5 that is representative of the legacy computer system output depicted by Figure 4. A mapping window 58 depicts the relationship between the variables of the legacy program applications and the XML tags of the XML schema. For instance, RS-TIME is a COBOL variable that is mapped to the "total-time" tag of the XML schema. Rule 79 represents the root or beginning of the grammar provided by the report data model shown above. Within the grammar window, incident 47 falls under rule 78 as an incident called to report the total cost from the legacy program application.
Once a relationship is established between the report data model and the XML schema, a modification specification is written, and the generation of modified legacy program applications is automatically performed. The modified legacy program applications are designed to report the data from the legacy computer system along with XML schema tags that describe the nature of the data. For instance, the following is incident 47 having
XML tag information and data field type and value information annotated within it:
Incident 47 loc 414 record PRTEC from RS-LINE <LINE 2> 0: " TOTAL CALLS:" size 14 14: RECORDS-SELECTED-EDIT loc 266 pic Z,ZZ9 size 5 tag total -calls-by-phone id bill\detail-list\detail-by-phone\total- calls-by-phone type TAG when P 19: "TOTAL TIME:" size 34 53: RS-TIME loc 270 pic 99 size 2 tag total-time-by-phone id bill\total-time type TAG when P
55 56 RS-MM loc* 272 pic 99 size 2 58 " : " size 1 59 RS-SS loc 274 pic 99 size 2 61 "" size 2 63 RS-COST loc 276 pic $$$$$.99 size 8 tag total-cost id bill\total-cost type TAG when P
71: "" size 2
The annotated incidents provide the basis for the modification specification which is provided by mapping engine 26 to code generation engine 24 for the creation of modified legacy program applications. For instance, the modification specification for incident 47 is:
node (414, XML-TOTAL-CALLS-ID, 'total-calls-by- phone', 'RECORDS-SELECTED-EDIT' , 266). node(414, XML-TOTAL-TIME-ID, ' total-time-by-phone ' , 'RS-TIME' , 270) . node(414, XML-TOTAL-BILL-ID, • total-bill-by-phone ' , •RS-COST', 276)
Note that the data items RS-HH, RS-MM, and RS-SS have been combined under data item RS-TIME. Code generation engine 24 applies the modification specification to determine the modifications needed for the legacy code to output appropriate tags relating data to the XML schema. For instance, the following code is added by code generation engine 24 in accordance to the modification specification in order to emit XML formatted data from the modified legacy program applications that relate to incident 47 :
MOVE RECORDS-SELECTED-EDIT TO XML-BUFFER MOVE XML-TOTAL-CALLS-ID TO XML-UID CALL 'XML' USING XML-UID
XML-BUFFER MOVE RS-TIME TO XML-BUFFER
MOVE XML-TOTAL-TIME-ID TO XML-UID CALL 'XML' USING XML-UID XML-BUFFER
MOVE RS-COST TO XML-BUFFER
MOVE XML-TOTAL-BILL-ID TO XML-UID CALL 'XML' USING XML-UID
XML-BUFFER
The modified legacy program application calls writer engine 20 to emit output with tags provided from the XML schema stored in context table 22. Once modified legacy program applications 18 are loaded onto legacy computer system 12, writer engine 20 in cooperation with context table 22 is called by modified legacy program applications 18 to output an XML data stream.
The pre-computed data necessary to control the accurate writing of embedded XML elements is generated from the XML schema. The pre-computed data consists of a map from an index to depth, start-label, stop-label, parent-index, and other information necessary to generate correct XML. For instance, the XML schema depicted by Figure 7 provides a data structure for printing a customer's name, address and identification. Figure 7A depicts the tree structure of the XML schema shown by Figure 7. Figure 7B depicts the computed data structure of the XML schema shown by Figure 7, including the depth of each element corresponding to the element's position in the tree structure and an index for each element indicating its ancestor element. For instance, the "Customer" element is the root of the XML schema and has a descendant element of "Address". The "Street" element is a descendant of the "Address" element, as indicated by the number 3 corresponding to the identification of the " ddress" element . Referring now to Figure 8, a flow diagram depicts the process implemented in the write engine to output an
XML data stream. The computed data depicted by Figure 7B is applied to the writing of the XML data stream with reference to the XML schema depicted by Figure 7. The process begins at step 100 where an XML print command is called along with identification of the schema element and the value to be printed. For instance, the commands:
MOVE '861 East Meadow' TO XML-BUFFER MOVE XML-CUSTOMER-STREET TO XML-UID CALL 'XML' USING XML-UID
XML-BUFFER
provide the identification for the "Street" element of the computed data structure .
At step 102, a test is made to see if the XML printing process has been initiated to emit data. If not, the appropriate data structure or current context is initialized and the identified data file is opened at step 104. For example, an XML print instruction relating to customer data would result in initialization of the current context that has "Customer" as the root element. At step 106, a test is performed to determine whether all data of the data structure has been emitted. If all data is emitted, the process proceeds to step 108 where the appropriate XML end tags are emitted and the data file is closed. If, however, the node ID is not at the end of the data structure, then the process proceeds to step 109. For instance, if the node ID is "City" then the process proceeds to step 109.
At step 109, a test is performed to determine whether the called node ID is a descendant of the current node. For instance, the "Street" element is a descendant of the "Address" element. Thus, if the "Address" element is the current element and the "Street" element is the called element, then the process proceeds to step 110. In contrast, if the current element is the "Name" element and the called element is the "Street" element, then the process proceeds to step 112 in order to locate the nearest mutual ancestor node ID having consistent cardinality with the called element. Thus, the mutual ancestor of the "Name" and "Street" elements, the "Customer" element, would be identified. At step 114 the end tags are closed up to the "Customer" element, and the
process proceeds to step 110. The cardinality check at step 112 ensures that, if an ancestor only permits a single occurrence of a descendant, then the descendant is only printed once. For example, if a descendant element is emitted in successive occurrences, the cardinality indicates that, between each emission of the descendant, the ancestor element is closed and a new instance of the ancestor is opened.
At step 110, tags are opened from the identified ancestor down through the called node, and attributes of the nodes along the tree structure are emitted along with appropriate values. At step 116 the process returns to step 100 to accept the next value in the XML data stream. An additional function of writer engine 20 is the delayed processing for writing of data as complete data " structures. For instance, writer engine 20 stores attributes, values and text values to a data structure without emitting the data until the all of the attributes, values and text values of the data structure are complete. This delayed processing allows the writer engine 20 to adhere to the sequencing requirements of the XML schema.
The sample output below illustrates the need for this capability.
SAMPLE OUTPUT
Send check payable to
John Doe ABC WIRELESS
111 Mizar Pi P. O. BOX 666666 Pasadena CA 93436-1204 DALLAS TX 75263-1111
Two addresses are printed side by side on the page. One is the customer address and the other is the remitter
address. Thus, a single line of output contains interleaved elements from two distinct subschemas, according to the target XML schema shown below.
TARGET XML SCHEMA
<ElementType name="name"/> <E1ementType name="address" /> <ElementType name="phone-number"/> <ElementType name="city-state-zip"/> <ElementType name="customer" > <element type="name"/> <element type="address"/> <element type="city-state-zip" /> </ElementType>
<ElementType name="remitter"> <element type="name"/> <e1ement type="address" /> <element type="city-state-zip"/> </ElementType>
<ElementType name="bill-header"> <element type="customer" /> <element type="remitter"/> </ElementType>
A complete customer address subschema must be emitted before the remitter address subschema. Due to the structure of the legacy code (shown below) it is necessary to buffer up the remitter address components while writing the XML structure for the customer. In addition to its other bookkeeping roles, the context table provides storage for this buffering operation.
The original legacy code can be seen below:
FRAGMENT OF LEGACY COBOL DATA DECLARATIONS
05 HL-BILL-HEADER-10.
10 FILLER PIC X(49) VALUE SPACES .
10 FILLER PIC X(32) VALUE "Send check payable to". 05 HL-BILL-HEADER-11.
10 FILLER PIC X VALUE SPACES,
10 HLS-CUSTOMER-NAME PIC X(40) VALUE SPACES.
10 HLS-REMITTANCE-NAME PIC X(40) VALUE SPACES. 05 HL-BILL-HEADER-12.
10 FILLER PIC X VALUE SPACES.
10 HLS-CUSTOMER-ADDRESS PIC X(40) VALUE SPACES.
10 HLS-REMITTANCE-ADDRESS PIC X(40) VALUE SPACES. 05 HL-BILL-HEADER-13.
10 FILLER PIC X VALUE SPACES.
10 HLS-CT-ST-ZIP PIC X(40) VALUE SPACES.
10 HLS-REMITTANCE-CT-ST-ZIP PIC X(40) VALUE SPACES.
FRAGMENT OF LEGACY COBOL PROCEDURAL CODE
WRITE BILL-RECORD FROM HL-BILL-HEADER-10 AFTER 2 WRITE BILL-RECORD FROM HL-BILL-HEADER-11 WRITE BILL-RECORD FROM HL-BILL-HEADER-12 WRITE BILL-RECORD FROM HL-BILL-HEADER-13
The modified code is shown below, with comments describing the successive operations.
MODIFIED LEGACY COBOL PROCEDURAL CODE
* Unchanged, since it does not emit anything
* relevant to the schema
WRITE BILL-RECORD FROM HL-BILL-HEADER-10 AFTER 2 * Emit the customer name
MOVE HLS-CUSTOMER-NAME TO XML-VALUE MOVE CUSTOMER-NAME-ID TO XML-TAG CALL "XML" USING XML-TAG XML-VALUE
* Deferred write of remitter name MOVE HLS-REMITTANCE-NAME TO XML-VALUE MOVE REMITTER-NAME-ID TO XML-TAG
CALL "XML-SET-NODE-VALUE" USING XML-TAG XML-VALUE WRITE BILL-RECORD FROM HL-BILL-HEADER-11
* Emit the customer address MOVE HLS-CUSTOMER-ADDRESS TO XML-VALUE MOVE CUSTOMER-ADDRESS-ID TO XML-TAG CALL "XML" USING XML-TAG XML-VALUE
* Deferred write of remitter address
MOVE HLS-REMITTANCE-ADDRESS TO XML-VALUE MOVE REMITTER-ADDRESS-ID TO XML-TAG
CALL "XML-SET-NODE-VALUE" USING XML-TAG XML-VALUE WRITE BILL-RECORD FROM HL-BILL-HEADER-12
* Emit customer city-state-zip
MOVE HLS-CT-ST-ZIP TO XML-VALUE MOVE CUSTOMER-CITY-STATE-ZIP-ID TO XML-TAG CALL "XML" XML-TAG XML-VALUE
* Deferred write of remitter city-state-zip
MOVE HLS-REMITTANCE-CT-ST-ZIP TO XML-VALUE MOVE* REMITTER-CITY-STATE-ZIP-ID TO XML-TAG CALL "XML-SET-NODE-VALUE" USING XML-TAG XML-VALUE WRITE BILL-RECORD FROM HL-BILL-HEADER-13
* Write of deferred remitter node with subnodes .
MOVE XML-REMITTER-ID TO XML-TAG CALL "XML-WRITE-NODE" USING XML-TAG
The resulting output for this particular example can be seen below.
XML OUTPUT
<bill-header> <customer>
<name>John Doe</name> <address>lll Mizar Pl</address>
<city-state-zip> Pasadena CA 93436-1204</city-state- zip>
</customer> <remitter> <name>ABC WIRELESS</name>
<address> P. O. BOX 666666</address>
<city-state-zip>DALLAS TX 75263-llll</city-state-zip> </remitter> </bill-header>
An XML schema may impose cardinality constraints on the component elements. For example, in the 'schema below
C, Cl and C2 may each appear only once within their respective parents. It is important to ensure this property when producing an instance of this schema.
<ElementType name="Cl"> <ElementType name="C2"> <ElementType name="C"> <element type="Cl" maxOccurs="l"/>
<element type="C2" maxOccurs="l"/> </ElementType> <ElementType name="A">
<element type="C" maxOccurs="l"/> </ElementType>
Some of the precomputed elements of the context table that represent the schema rooted at "A" are shown in the table below.
ID Label Depth Parent Cardinality
1 <A> 1 0 n
2 <C> 2 1 1
3 <C1 > 3 2 1
4 <C2 > 3 2 1
The ID column holds the unique identifier associated with each element. The Cardinality column indicates a constraint on the number of occurrences of an element within its parent. 'n' means there may be zero or more.
' 1 ' indicates that there should be exactly 1.
The table below shows how this information is used dynamically as XML-PRINT commands are executed. (Note that the COUNT column of the CONTEXT shows the change in the value of the cardinality count with respect to a particular schema element.)
CONTEXT
STATE STACK COUNT COMMAND OUTPUT
0 [ ] A =1 XML- PRINT Cl , Vll <A> 1 [A] C =1 <C> 2 [A, C] Cl = l <C1>V11</C1>
[A, C] C2 =l XML- PRINT C2 , V21 <C2 >V21</C2 >
[A, C] C1 = 0 XML -PRINT Cl , VI 2 < /C> C2 = 0
5 [A] C =0 </A> 6 [ ] A =2 <A> 7 [A] C =1 <C> 8 [A, C] Cl = l <C1>V12</C1>
The initial state, 0, includes an empty stack and no cardinality counts associated with any schema element. The command to print Vll as a schema element Cl causes a
check of the state, the output of the <A> and <C> ancestor labels, and the output of the labeled Vll element. The STACK is modified to record the current context of an open <A> and <C> and the cardinality counts for A, C and Cl are set to 1.
The command to print V21 as a schema element C2 causes a check of the state. The STACK as regards the ancestors of C2 is correct, so the only printing operation is the output of the labeled V21 element. The STACK is unchanged. The cardinality count for C2 is set to 1.
The command to print V12 labeled by schema element Cl causes a check of the state . The STACK in state 3 as regards the ancestors of Cl is correct. However, the cardinality count for Cl is equal to 1 which is the permitted cardinality of elements of this type. We therefore close C and reset the cardinality counts for its children, Cl and C2. At this point it can be seen that the cardinality count for C is equal to 1 which is the permitted cardinality of elements of this type. We therefore close A and reset the cardinality count for C to 0. At this point (state 6) the stack is empty, and we output the ancestor labels <A> and <C>, output the labeled V12 element, modify the STACK to record the current context of an open <A> and <C> and set the cardinality counts for C and Cl to 1 and A to 2.
Now, consider the case where the maximum occurrence of elements of type C has no upper bound. That is, the element definition of C within A is changed to:
<element type="C" maxOccurs="n"/>
The third print step now becomes simpler, as shown in the table below:
CONTEXT
STATE STACK COUNT COMMAND OUTPUT
0 [ ] A =1 XML- PRINT Cl , Vll <A>
1 [A] C =1 <C> 2 [A, C] Cl = l <C1 >V11< /C1 >
3 [A, C] C2 = l XML- PRINT C2 , V22 <C2 >V22 </C2 >
4 [A, C] C1 = 0 XML- PRINT Cl , V12 < /C> C2 =0
5 [A] C =2 <C> 6 [A, C] Cl = l <C1>V12</C1>
The first two XML-PRINT operations proceed as before. Because there may be an arbitrary number of C subelements of A there is no need to close the A and open a new one. We close C, setting the STACK to [A] , and reset the cardinality counts for C's descendents, Cl and C2. We open a new C and increment C's cardinality count to 2. Finally the labeled V12 element is output, and the cardinality count for Cl is set to 1.
Finally, contrast the previous examples to the case where there is no upper bound on the occurrence of any element.- That is, the element definitions of C, Cl and C2 are changed to:
<element type="Cl" maxOccurs="n"/> <element type="C2" maxOccurs="n"/> <element type="C" maxOccurs="n"/>
The state changes as seen in the table below:
CONTEXT STATE STACK COUNT COMMAND OUTPUT
1 [] A =1 XML-PRINT Cl , Vll <A>
2 [A] C =1 <C>
3 [A, C] Cl=l <C1>V11</C1>
4 [A, C] C2=l XML-PRINT C2 , V22 <C2>V22</C2>
5 [A, C] Cl=2 XML-PRINT Cl, V12 <C1>V12</C1>
The first and second calls work as before. The third call becomes even simpler. Because there may be an arbitrary number of Cl subelements of C there is no need to close the C and open a new one . The labeled V12 element is output, and the cardinality count for Cl is incremented to 2.
When modifying legacy code certain difficulties arise in deciding when to print schema data that is contained in headers and footers. Consider the example of telephone invoices. The output of an invoicing program may consist of a sequence of invoices. Each invoice may take up a single page or multiple pages. When the invoice occupies multiple pages, its header is typically repeated. As a result, sometimes the header is introducing a new invoice schema element, and at other times it is mere page decoration of the human readable output. In order to recognize the need to close the current invoice tag and open a new one, it is necessary to know that there is some unique identifier associated with each invoice instance and that when the value of this 'key' changes, the current invoice is closed and a
new one opened. To enable this computation the context table contains a boolean identifier for key elements and the current values for these elements. This check is performed at the same time as the cardinality check. The present invention has a number of important business applications that relate to e-commerce and to more efficient use of legacy computer reports by brick- and-mortar businesses . One example is that internal reports otherwise printed on paper for manual inspection are instead available for storage on a database in XML format. Once electronically stored, the reports are available as electronic information assets for review by a browser or other electronic analysis. The reports are also much simpler to store in a data warehouse. Another commercial application is as Enterprise
Application Integration (EAI) middleware for transfer of data between applications. Setting up transfer of data from structured databases, such as those using XML formats, is relatively straightforward since data definitions may be treated as semantic tags. In contrast, typical legacy computer system reports are unstructured since they represent data generated according to business logic instead of a data structure. By modifying underlying legacy applications to directly output XML formatted data, the outputted data is more easily treated as structured data files for integration in a suite of enterprise applications.
Another commercial application is Electronic Bill Presentment and Payment (EBPP) . In order to provide electronic billing from typical legacy computer systems, a parser is generally used to parse untagged invoice data
files and then tag the data files with semantically meaningful identifiers. Parsers are expensive' and difficult to set up and maintain. In contrast, modification of underlying legacy computer system code to directly output XML formatted data saves time, requires less expertise and expense, and provides data in a recognized format for e-commerce. Thus, businesses with legacy computer systems may output XML formatted reports that allow the business to take advantage of advances taking place in e-commerce, such as automatic bill payment. For instance, individual telephone customers could receive their telephone bill by e-mail containing a web link to a site that provides the individual's bill detail . Another commercial application is archival of billing statements. Banks, for example, maintain large archives of customer billing statements as reduced photographic copies on microfiche or as print streams on optical disk systems. Retrieval systems for these archives are complex and difficult to maintain. Data extraction from the print streams is a recent improvement, as disclosed in U.S. Patent No. 6,031,625 (US6031625) , but such a system still requires processing of print streams after they have been output from the legacy application. In contrast, modifying the underlying legacy computer code so it directly produces XML formatted billing statements makes archiving and retrieval of billing statements much simpler. For example, the XML statements can be stored in a relational database for easy retrieval. In addition, the retrieved statements, because they have an XML representation,
become directly viewable, for example, using browser technology.
Another commercial application is in business intelligence, which seeks to analyze electronic information assets to determine business behaviors, such as purchasing or selling behaviors. Syndicated data providers obtain data for intelligence analysis through reports that are parsed on a distributor or purchaser basis. This detailed parsing can be even more complicated than the parsing used to support EBPP function. Thus, direct generation of XML formatted data from a legacy computer system providing invoice reports is even more efficient in the business intelligence role than in electronic billing and other applications since detailed data analysis is available without applying detailed parsing systems.
Overall the direct generation of XML formatted data from a legacy computer system reduces friction in information networks by making the transfer of information simpler. This reduces the cost of tracking information, the manual effort to exchange and analyze business information, and reduces the time associated with obtaining valuable business intelligence from existing data sources. By making data available in semantically meaningful form, customers can automatically analyze their suppliers for Vendor Relationship Management, suppliers can automatically analyze their customers for Customer Relationship Management, and manufacturers can automatically analyze markets for their products for Market Intelligence.
Although the present invention has been described in detail, it should be understood that various changes, substitutions and alterations can be made hereto without departing from the spirit and scope of the invention as defined by the appended claims.
Claims (21)
1. A method for reporting data from a legacy computer system using Extensible Markup Language, the method comprising: generating a model of the legacy computer system; mapping the model of the legacy computer system to an Extensible Markup Language schema; and automatically modifying one or more applications of the legacy computer system, the modified application operable to output data from the legacy computer system in Extensible Markup Language format.
2. The method of Claim 1 wherein generating a model further comprises: listing incidents within the applications that write data; and generating a report data model.
3. The method of Claim 2 wherein the report data model comprises a statically determined value or type of the data fields written by the associated write operation.
4. The method of Claim 3 wherein the report data model further comprises a formal grammar that describes how the write operations are combined.
5. The method of Claim 1 wherein mapping the model further comprises: creating a specification that defines modifications to one or more applications of the legacy computer system, the modifications relating applications that write data to the Extensible Markup Language schema.
6. The method of Claim 5 wherein creating a specification further comprises: mapping the incidents of the report data model to the Extensible Markup Language Schema and to the application code.
7. The method of Claim 1 wherein automatically modifying one or more applications further comprises: providing the legacy computer system with an Extensible Markup Language context table having the Extensible Markup Language schema; providing the legacy computer system with a writer engine ; and calling the writer engine with the modified applications, the writer engine cooperating with the context table to output syntactically correct Extensible Markup Language data from the legacy computer system.
8. The method of Claim 7 further comprising: outputting data from the legacy computer system in both the Extensible Markup Language format and an unmodified legacy computer system format.
9. A system for reporting data from a legacy computer system in an Extensible Markup Language format, the system comprising: a modeling engine in communication with the legacy computer system, the modeling engine operable to generate a model of reported data written by an application residing on the legacy computer system; a mapping engine in communication with the modeling engine, the mapping engine operable to generate a modification specification by mapping the model to an Extensible Markup Language schema; and a code generation engine in communication with the mapping engine and the legacy computer system, the code generation engine operable to modify legacy computer system application code to directly output data in Extensible Markup Language format.
10. The system of Claim 9 wherein the model generated by the modeling engine comprises: a list of incidents within the legacy application that reports data; and a report data model having a value or type for the data fields of each of the incidents.
11. The system of Claim 10 wherein the report data model further comprises a formal grammar that describes how write operations are combined.
12. The system of Claim 9 wherein the modification specification comprises instructions for modifying legacy computer system applications.
13. The system of Claim 9 further comprising: a context table associated with the legacy computer system, the context table providing the Extensible Markup Language schema to the legacy computer system; and a writer engine loaded on the legacy computer system, the writer engine communicating with the context table and the modified legacy computer system applications to output data in Extensible Markup Language format.
14. The system of Claim 13 wherein the writer engine is coded in the computer language of the legacy computer system.
15. The system of Claim 14 wherein the computer language comprises COBOL and the context table comprises a COBOL copybook.
16. A method for updating a legacy computer system to output data in Extensible Markup Language format, the method comprising: analyzing one or more applications residing on the legacy computer system to identify incidents that report data; associating the incidents with an Extensible Markup Language schema; and modifying the applications so that the modified applications report data directly in an Extensible Markup Language format .
17. The method of Claim 16 further comprising: running the modified applications on the legacy computer system to output data in an Extensible Markup Language format .
18. The method of Claim 17 wherein analyzing the one or more applications further comprises: determining a control flow graph for the applications of the legacy computer system; determining write operations of the flow graph to obtain a report data model ; attaching value or type information for each data field written by the write operations; and writing a formal grammar for the report data model with the attached information.
19. The method of Claim 18 wherein associating the incidents comprises: mapping the incidents of the applications to the Extensible Markup Language schema with the assistance of the regular grammar and attached values and types .
20. The method of Claim 19 wherein modifying the applications comprises: applying the map to the applications to automatically generate modified applications having code that supports outputting of data from the incidents in Extensible Markup Language format .
21. The method of Claim 20 further comprising: running the modified applications on the legacy computer system; running a writer engine on the legacy computer system, the writer engine accepting data output from the modified applications and applying Extensible Markup Language tags to the data, the tags defined by the Extensible Markup Language schema; and outputting the data from the writer engine in Extensible Markup Language format.
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US09/522,056 | 2000-03-09 | ||
| US09/522,056 US6687873B1 (en) | 2000-03-09 | 2000-03-09 | Method and system for reporting XML data from a legacy computer system |
| PCT/US2001/007222 WO2001067294A2 (en) | 2000-03-09 | 2001-03-07 | Method and system for reporting xml data from a legacy computer system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| AU2001242008A1 true AU2001242008A1 (en) | 2001-11-29 |
| AU2001242008B2 AU2001242008B2 (en) | 2005-12-01 |
Family
ID=24079279
Family Applications (2)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| AU2001242008A Ceased AU2001242008B2 (en) | 2000-03-09 | 2001-03-07 | Method and system for reporting XML data from a legacy computer system |
| AU4200801A Pending AU4200801A (en) | 2000-03-09 | 2001-03-07 | Method and system for reporting xml data from a legacy computer system |
Family Applications After (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| AU4200801A Pending AU4200801A (en) | 2000-03-09 | 2001-03-07 | Method and system for reporting xml data from a legacy computer system |
Country Status (5)
| Country | Link |
|---|---|
| US (1) | US6687873B1 (en) |
| EP (1) | EP1264247A2 (en) |
| JP (1) | JP4495895B2 (en) |
| AU (2) | AU2001242008B2 (en) |
| WO (1) | WO2001067294A2 (en) |
Families Citing this family (109)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7356390B2 (en) | 1999-06-29 | 2008-04-08 | Space Data Corporation | Systems and applications of lighter-than-air (LTA) platforms |
| WO2002087112A2 (en) | 2001-04-18 | 2002-10-31 | Space Data Corporation | Unmanned lighter-than-air safe termination and recovery methods |
| US6931623B2 (en) * | 1999-08-30 | 2005-08-16 | Touchnet Information Systems, Inc. | Method of accessing data and logic on existing systems through dynamic construction of software components |
| US7000194B1 (en) | 1999-09-22 | 2006-02-14 | International Business Machines Corporation | Method and system for profiling users based on their relationships with content topics |
| US6772413B2 (en) * | 1999-12-21 | 2004-08-03 | Datapower Technology, Inc. | Method and apparatus of data exchange using runtime code generator and translator |
| US7114147B2 (en) * | 2000-03-09 | 2006-09-26 | Electronic Data Systems Corporation | Method and system for reporting XML data based on precomputed context and a document object model |
| US6993745B1 (en) | 2000-03-09 | 2006-01-31 | Electronic Data Systems Corporation | Method and system for modeling a legacy computer system |
| US7111233B1 (en) | 2000-03-09 | 2006-09-19 | Electronic Data Systems Corporation | Method and system for applying XML schema |
| WO2001077847A1 (en) * | 2000-04-07 | 2001-10-18 | Financeware.Com | Method and apparatus for rendering electronic documents |
| US8082491B1 (en) * | 2000-05-09 | 2011-12-20 | Oracle America, Inc. | Dynamic displays in a distributed computing environment |
| US7082463B1 (en) * | 2000-06-07 | 2006-07-25 | Cisco Technology, Inc. | Time-based monitoring of service level agreements |
| US7467192B1 (en) | 2000-06-07 | 2008-12-16 | Cisco Technology, Inc. | Online standardized contract configuration for service level agreement monitoring |
| AU2000264369A1 (en) * | 2000-07-22 | 2002-02-05 | Abb Research Ltd | System and method for generating an xml-based error model |
| US7117239B1 (en) | 2000-07-28 | 2006-10-03 | Axeda Corporation | Reporting the state of an apparatus to a remote computer |
| AU2001288757A1 (en) * | 2000-09-01 | 2002-03-13 | Op40, Inc. | System, method, uses, products, program products, and business methods for distributed internet and distributed network services |
| US7657833B2 (en) | 2000-09-15 | 2010-02-02 | Hartford Fire Insurance Company | Real-time single entry multiple carrier interface (SEMCI) |
| US8108543B2 (en) | 2000-09-22 | 2012-01-31 | Axeda Corporation | Retrieving data from a server |
| US7185014B1 (en) * | 2000-09-22 | 2007-02-27 | Axeda Corporation | Retrieving data from a server |
| US20100223211A1 (en) * | 2000-10-11 | 2010-09-02 | Johnson Gregory A | Decision service method and system |
| US20030105887A1 (en) * | 2001-12-03 | 2003-06-05 | Cox Burke David | Method and system for integration of software applications |
| US20020091818A1 (en) * | 2001-01-05 | 2002-07-11 | International Business Machines Corporation | Technique and tools for high-level rule-based customizable data extraction |
| US6584407B2 (en) * | 2001-01-10 | 2003-06-24 | Halliburton Energy Services, Inc. | Formation resistivity measurement method that eliminates effects of lateral tool motion |
| US20020143823A1 (en) * | 2001-01-19 | 2002-10-03 | Stevens Mark A. | Conversion system for translating structured documents into multiple target formats |
| JP2002229783A (en) * | 2001-01-31 | 2002-08-16 | Toshiba Corp | Software construction support system, its method, and software construction support program |
| US7237190B2 (en) * | 2001-03-07 | 2007-06-26 | International Business Machines Corporation | System and method for generating multiple customizable interfaces for XML documents |
| US9908608B2 (en) | 2001-04-18 | 2018-03-06 | Space Data Corporation | Systems and applications of lighter-than-air (LTA) platforms |
| US9632503B2 (en) | 2001-04-18 | 2017-04-25 | Space Data Corporation | Systems and applications of lighter-than-air (LTA) platforms |
| US9643706B2 (en) | 2001-04-18 | 2017-05-09 | Space Data Corporation | Systems and applications of lighter-than-air (LTA) platforms |
| JP3692054B2 (en) * | 2001-05-21 | 2005-09-07 | 株式会社東芝 | Document structure conversion method, document structure conversion apparatus, and program |
| US20030101170A1 (en) * | 2001-05-25 | 2003-05-29 | Joseph Edelstein | Data query and location through a central ontology model |
| US7146399B2 (en) * | 2001-05-25 | 2006-12-05 | 2006 Trident Company | Run-time architecture for enterprise integration with transformation generation |
| US8412746B2 (en) * | 2001-05-25 | 2013-04-02 | International Business Machines Corporation | Method and system for federated querying of data sources |
| US7877421B2 (en) * | 2001-05-25 | 2011-01-25 | International Business Machines Corporation | Method and system for mapping enterprise data assets to a semantic information model |
| US7099885B2 (en) * | 2001-05-25 | 2006-08-29 | Unicorn Solutions | Method and system for collaborative ontology modeling |
| US20060064666A1 (en) | 2001-05-25 | 2006-03-23 | Amaru Ruth M | Business rules for configurable metamodels and enterprise impact analysis |
| US20030014439A1 (en) * | 2001-06-20 | 2003-01-16 | International Business Machines Corporation | Defining a markup language representation for state chart data |
| US7003725B2 (en) * | 2001-07-13 | 2006-02-21 | Hewlett-Packard Development Company, L.P. | Method and system for normalizing dirty text in a document |
| US20030018661A1 (en) * | 2001-07-19 | 2003-01-23 | Darugar Parand Tony | XML smart mapping system and method |
| AU2002330242A1 (en) * | 2001-10-05 | 2003-04-22 | Vitria Technology, Inc. | System and method for vocabulary-based data transformation |
| US6993760B2 (en) * | 2001-12-05 | 2006-01-31 | Microsoft Corporation | Installing software on a mobile computing device using the rollback and security features of a configuration manager |
| US7254601B2 (en) | 2001-12-20 | 2007-08-07 | Questra Corporation | Method and apparatus for managing intelligent assets in a distributed environment |
| US7194402B2 (en) * | 2002-01-09 | 2007-03-20 | International Business Machines Corporation | Method and system for converting files to a specified markup language |
| US7124353B2 (en) * | 2002-01-14 | 2006-10-17 | International Business Machines Corporation | System and method for calculating a user affinity |
| US20040205509A1 (en) * | 2002-03-18 | 2004-10-14 | Sun Microsystems, Inc. | System and method for comparing parsed XML files |
| US7096421B2 (en) * | 2002-03-18 | 2006-08-22 | Sun Microsystems, Inc. | System and method for comparing hashed XML files |
| US20030184581A1 (en) * | 2002-04-02 | 2003-10-02 | Bawa Satvinder Singh | Application level integration in support of a distributed network management and service provisioning solution |
| US7178149B2 (en) * | 2002-04-17 | 2007-02-13 | Axeda Corporation | XML scripting of soap commands |
| EP1502196A4 (en) * | 2002-05-02 | 2008-04-02 | Sarvega Inc | System and method for transformation of xml documents using stylesheets |
| US20030229846A1 (en) * | 2002-06-07 | 2003-12-11 | Anil Sethi | System and method for capturing digital data directly from an electronic device and processing the data into XML form on a computer chip |
| US7765467B2 (en) * | 2002-06-12 | 2010-07-27 | Microsoft Corporation | Undoing pending changes applied to web pages |
| US7143344B2 (en) * | 2002-06-12 | 2006-11-28 | Microsoft Corporation | Transformation stylesheet editor |
| US7149966B2 (en) * | 2002-06-24 | 2006-12-12 | Microsoft Corporation | Word processor for freestyle editing of well-formed XML documents |
| DE10230883A1 (en) * | 2002-07-09 | 2004-02-19 | Siemens Ag | Automatic evaluation of properties of a system based on process logs |
| JP2004062600A (en) * | 2002-07-30 | 2004-02-26 | Fujitsu Ltd | Conversion method, restoration method, conversion and restoration method and program for structured document |
| CA2400590A1 (en) * | 2002-08-29 | 2004-02-29 | Ibm Canada Limited-Ibm Canada Limitee | Method and apparatus for converting legacy programming language data structures to schema definitions |
| US7103872B2 (en) | 2002-09-14 | 2006-09-05 | International Business Machines Corporation | System and method for collecting and transferring sets of related data from a mainframe to a workstation |
| US7130893B2 (en) | 2003-05-19 | 2006-10-31 | International Business Machines Corporation | System and method for representing MFS control blocks in XML for MFS-based IMS applications |
| US20040103370A1 (en) * | 2002-11-27 | 2004-05-27 | International Business Machines Corporation | System and method for rendering MFS XML documents for display |
| US7421701B2 (en) | 2002-09-16 | 2008-09-02 | International Business Machines Corporation | System for facilitating transactions between thin-clients and message format service (MFS)-based information management system (IMS) applications |
| US20040054969A1 (en) * | 2002-09-16 | 2004-03-18 | International Business Machines Corporation | System and method for generating web services definitions for MFS-based IMS applications |
| US8577795B2 (en) | 2002-10-10 | 2013-11-05 | Convergys Information Management Group, Inc. | System and method for revenue and authorization management |
| US7966418B2 (en) | 2003-02-21 | 2011-06-21 | Axeda Corporation | Establishing a virtual tunnel between two computer programs |
| JP2007525047A (en) * | 2003-03-18 | 2007-08-30 | レネシス コーポレーション | Method and system for monitoring network routing |
| US9137033B2 (en) | 2003-03-18 | 2015-09-15 | Dynamic Network Services, Inc. | Methods and systems for monitoring network routing |
| US8204849B2 (en) * | 2003-07-10 | 2012-06-19 | Ca, Inc. | Web product interface system and method |
| CA2438997A1 (en) * | 2003-08-28 | 2005-02-28 | Ibm Canada Limited - Ibm Canada Limitee | System and method for carrying out legacy application transitions |
| US7370280B2 (en) * | 2003-09-23 | 2008-05-06 | International Business Machines Corporation | Apparatus, system, and method for defining a web services interface for MFS-based IMS applications |
| US7668093B1 (en) * | 2004-08-05 | 2010-02-23 | Convergys Information Management Group, Inc. | Architecture for balancing workload |
| US7437666B2 (en) * | 2003-10-22 | 2008-10-14 | Intel Corporation | Expression grouping and evaluation |
| US9288000B2 (en) * | 2003-12-17 | 2016-03-15 | International Business Machines Corporation | Monitoring a communication and retrieving information relevant to the communication |
| US7418508B2 (en) | 2004-01-26 | 2008-08-26 | International Machines Corporation | System and method to facilitate XML enabled IMS transactions between a remote client and an IMS application program |
| US7617459B2 (en) | 2004-01-28 | 2009-11-10 | International Business Machines Corporation | Apparatus, system, and method for automatically generating a web interface for an MFS-based IMS application |
| KR101150653B1 (en) * | 2004-06-04 | 2012-05-29 | 포티파이 소프트웨어 엘엘씨 | Apparatus and method for developing, testing and monitoring secure software |
| US7975306B2 (en) * | 2004-06-04 | 2011-07-05 | Hewlett-Packard Development Company, L.P. | Apparatus and method for monitoring secure software |
| US7707490B2 (en) * | 2004-06-23 | 2010-04-27 | Microsoft Corporation | Systems and methods for flexible report designs including table, matrix and hybrid designs |
| US8683318B1 (en) | 2004-07-14 | 2014-03-25 | American Express Travel Related Services Company, Inc. | Methods and apparatus for processing markup language documents |
| US7681118B1 (en) * | 2004-07-14 | 2010-03-16 | American Express Travel Related Services Company, Inc. | Methods and apparatus for creating markup language documents |
| US20060015511A1 (en) * | 2004-07-16 | 2006-01-19 | Juergen Sattler | Method and system for providing an interface to a computer system |
| US20060070043A1 (en) * | 2004-07-27 | 2006-03-30 | Viega John T | System and method for analyzing computer code |
| US7559023B2 (en) * | 2004-08-27 | 2009-07-07 | Microsoft Corporation | Systems and methods for declaratively controlling the visual state of items in a report |
| US7315853B2 (en) * | 2004-10-11 | 2008-01-01 | Sap Ag | Service-oriented architecture for accessing reports in legacy systems |
| US7644184B2 (en) * | 2004-12-08 | 2010-01-05 | International Business Machines Corporation | Universal adapter |
| US20060136483A1 (en) * | 2004-12-22 | 2006-06-22 | International Business Machines Corporation | System and method of decomposition of multiple items into the same table-column pair |
| US7620641B2 (en) * | 2004-12-22 | 2009-11-17 | International Business Machines Corporation | System and method for context-sensitive decomposition of XML documents based on schemas with reusable element/attribute declarations |
| US20060149731A1 (en) * | 2005-01-05 | 2006-07-06 | Schirmer Andrew L | System and method for deriving affinity relationships between objects |
| US7840610B2 (en) * | 2005-05-11 | 2010-11-23 | International Business Machines Corporation | Apparatus, system, and method for map definition generation |
| US20060262087A1 (en) * | 2005-05-23 | 2006-11-23 | Xerox Corporation | Unified status support over USB and HTTP |
| EP1934742A4 (en) * | 2005-08-25 | 2009-08-19 | Fortify Software Inc | Apparatus and method for analyzing and supplementing a program to provide security |
| US7581189B2 (en) | 2005-09-09 | 2009-08-25 | Microsoft Corporation | Dynamically generating a database report during a report building process |
| US20070067343A1 (en) * | 2005-09-21 | 2007-03-22 | International Business Machines Corporation | Determining the structure of relations and content of tuples from XML schema components |
| US7747942B2 (en) * | 2005-12-20 | 2010-06-29 | American Express Travel Related Services Company, Inc. | System and method for obtaining a markup language template through reversing engineering |
| US7529758B2 (en) | 2006-02-10 | 2009-05-05 | International Business Machines Corporation | Method for pre-processing mapping information for efficient decomposition of XML documents |
| US7984373B2 (en) * | 2006-02-24 | 2011-07-19 | Microsoft Corporation | EDI instance based transaction set definition |
| US7685208B2 (en) | 2006-02-24 | 2010-03-23 | Microsoft Corporation | XML payload specification for modeling EDI schemas |
| US7703099B2 (en) * | 2006-02-24 | 2010-04-20 | Microsoft Corporation | Scalable transformation and configuration of EDI interchanges |
| US7620645B2 (en) * | 2006-02-24 | 2009-11-17 | Microsoft Corporation | Scalable algorithm for sharing EDI schemas |
| US8656374B2 (en) * | 2006-06-16 | 2014-02-18 | Business Objects Software Ltd. | Processing cobol data record schemas having disparate formats |
| US8161078B2 (en) * | 2006-09-20 | 2012-04-17 | Microsoft Corporation | Electronic data interchange (EDI) data dictionary management and versioning system |
| US8370479B2 (en) | 2006-10-03 | 2013-02-05 | Axeda Acquisition Corporation | System and method for dynamically grouping devices based on present device conditions |
| US8065397B2 (en) | 2006-12-26 | 2011-11-22 | Axeda Acquisition Corporation | Managing configurations of distributed devices |
| US7873902B2 (en) * | 2007-04-19 | 2011-01-18 | Microsoft Corporation | Transformation of versions of reports |
| US8478861B2 (en) | 2007-07-06 | 2013-07-02 | Axeda Acquisition Corp. | Managing distributed devices with limited connectivity |
| US20090119415A1 (en) * | 2007-11-02 | 2009-05-07 | Chiang Chenhuei J | System and method for representing mfs control blocks in xml for mfs-based ims applications |
| US8831019B2 (en) | 2012-05-18 | 2014-09-09 | Renesys | Path reconstruction and interconnection modeling (PRIM) |
| US20210327009A1 (en) * | 2014-04-10 | 2021-10-21 | School Innovations & Achievement, Inc. | System and method for student attendance management |
| BR112017013836B1 (en) | 2014-12-24 | 2022-05-24 | Space Data Corporation | Detachment of a platform by pending collision |
| CA2972381A1 (en) | 2014-12-24 | 2016-06-30 | Space Data Corporation | Techniques for intelligent balloon/airship launch and recovery window location |
| US10059421B2 (en) | 2014-12-30 | 2018-08-28 | Space Data Corporation | Multifunctional balloon membrane |
| US10303753B2 (en) * | 2015-10-09 | 2019-05-28 | Bank Of America Corporation | System for copybook flat data conversion and inline transformation |
Family Cites Families (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5640550A (en) * | 1994-04-15 | 1997-06-17 | Coker; Drake | Computer system for generating SQL statements from COBOL code |
| US5857194A (en) | 1996-11-07 | 1999-01-05 | General Electric Company | Automatic transmission of legacy system data |
| CA2201254C (en) * | 1997-03-27 | 2002-08-20 | John Wright Stephenson | A system for automated interface generation for computer programs operating in different environments |
| US6502236B1 (en) * | 1999-03-16 | 2002-12-31 | Fujitsu Network Communications, Inc. | Method and apparatus for automatic generation of programs for processing data units of multiple formats |
| US6446110B1 (en) * | 1999-04-05 | 2002-09-03 | International Business Machines Corporation | Method and apparatus for representing host datastream screen image information using markup languages |
| US20030005410A1 (en) * | 1999-06-02 | 2003-01-02 | American Management Systems, Inc. Of Fairfax, Va. | Xml parser for cobol |
| US6209124B1 (en) * | 1999-08-30 | 2001-03-27 | Touchnet Information Systems, Inc. | Method of markup language accessing of host systems and data using a constructed intermediary |
| US6523042B2 (en) * | 2000-01-07 | 2003-02-18 | Accenture Llp | System and method for translating to and from hierarchical information systems |
| US7111233B1 (en) * | 2000-03-09 | 2006-09-19 | Electronic Data Systems Corporation | Method and system for applying XML schema |
-
2000
- 2000-03-09 US US09/522,056 patent/US6687873B1/en not_active Expired - Fee Related
-
2001
- 2001-03-07 AU AU2001242008A patent/AU2001242008B2/en not_active Ceased
- 2001-03-07 JP JP2001565042A patent/JP4495895B2/en not_active Expired - Fee Related
- 2001-03-07 WO PCT/US2001/007222 patent/WO2001067294A2/en active IP Right Grant
- 2001-03-07 EP EP01913333A patent/EP1264247A2/en not_active Ceased
- 2001-03-07 AU AU4200801A patent/AU4200801A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6687873B1 (en) | Method and system for reporting XML data from a legacy computer system | |
| AU2001243470B2 (en) | Method and system for modeling a legacy computer system | |
| AU2001240068B2 (en) | Method and system for applying XML schema | |
| AU2002257192B2 (en) | Method and system for reporting XML data based on precomputed context and a document object model | |
| AU2001242008A1 (en) | Method and system for reporting XML data from a legacy computer system | |
| AU2001243470A1 (en) | Method and system for modeling a legacy computer system | |
| AU2001240068A1 (en) | Method and system for applying XML schema | |
| AU2002257192A1 (en) | Method and system for reporting XML data based on precomputed context and a document object model | |
| US9268748B2 (en) | System, method, and computer program product for outputting markup language documents | |
| US6006242A (en) | Apparatus and method for dynamically creating a document | |
| US7421648B1 (en) | Reusable data markup language | |
| US6850950B1 (en) | Method facilitating data stream parsing for use with electronic commerce | |
| JP5106840B2 (en) | Modeling data elements | |
| US20050198042A1 (en) | Chart view for reusable data markup language | |
| US20080282139A1 (en) | Tree view for reusable data markup language | |
| US20070130512A1 (en) | Systems and methods for report design and generation | |
| US20050060317A1 (en) | Method and system for the specification of interface definitions and business rules and automatic generation of message validation and transformation software | |
| US20070203922A1 (en) | Schema mapping and data transformation on the basis of layout and content | |
| WO2002059755A1 (en) | Rdx enhancement of system and method for implementing reusable data markup language (rdl) | |
| CA2364295C (en) | Data parsing system for use in electronic commerce | |
| US20040083219A1 (en) | Method and system for reducing code in an extensible markup language program | |
| CN117131851A (en) | Method for automatically generating text version report |