EP1228444A2 - Appareil, systemes et procedes de developpement, de gestion, de commande et d'integration de donnees electroniques dans un environnement de reseau de communications mondial - Google Patents

Appareil, systemes et procedes de developpement, de gestion, de commande et d'integration de donnees electroniques dans un environnement de reseau de communications mondial

Info

Publication number
EP1228444A2
EP1228444A2 EP00972508A EP00972508A EP1228444A2 EP 1228444 A2 EP1228444 A2 EP 1228444A2 EP 00972508 A EP00972508 A EP 00972508A EP 00972508 A EP00972508 A EP 00972508A EP 1228444 A2 EP1228444 A2 EP 1228444A2
Authority
EP
European Patent Office
Prior art keywords
document
data
instmctions
object model
stmcture
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.)
Withdrawn
Application number
EP00972508A
Other languages
German (de)
English (en)
Inventor
Robert Houben
John Hunter
Philip Mansfield
Yuri Khramov
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.)
Liberty Integration Software Inc
Original Assignee
Liberty Integration Software Inc
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 Liberty Integration Software Inc filed Critical Liberty Integration Software Inc
Publication of EP1228444A2 publication Critical patent/EP1228444A2/fr
Withdrawn legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90—Details of database functions independent of the retrieved data types
    • G06F16/95—Retrieval from the web
    • G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking

Definitions

  • the method to convert the source data to the Internet data stmcture comprises several steps.
  • the computer translates the metadata into a set of DTD declarations and a conesponding tree-based stmcture definition. If the metadata is not in a form readily accessible by the computer, then the first step is to translate the metadata into a form that is readily accessible by the computer.
  • FIG. 6c is a dataflow diagram of data through a business server
  • FIG. 6d is a data flow diagram of the operations ofa sorter object according to the present invention
  • FIG. 12 depicts an exemplary XML stmcture of typical invoice data
  • FIG. 13 is a formatted representation of an invoice record in an exemplary legacy data stmcture
  • FIG. 14 is a representation of the way in which the record depicted in FIG. 13 is stored in memory
  • FIGS. 35 and 36 are graphic representations of interactive online display graphic user Q-Pointer interface features of the invention.
  • FIG. 45 is a graphic representation of an interactive online display graphic user Getltem interface feature of the invention.
  • the legacy database contains data accessible in a format not normally suited for Internet applications.
  • the business server provides services to Internet based clients to retrieve, manipulate, transmit, and store legacy data using the database server.
  • Other databases accessible to the business server such as the Internet database served by the database server, contain documents suitable for transfer over the Internet using one of the suite of Internet communications protocols such as HTTP or SMTP.
  • the business server and the database server communicate to each other via the local area network.
  • FIG. 3 is a sequence diagram illustrating an exemplary business transaction between a business server and a partner server.
  • Customer 1305 uses Web client 1055 to send response document request 1315 to business server 1015.
  • the body of the response document request contains item selection 1310 and instmctions for purchase of the selected item from an online catalog.
  • the requested response document is an acknowledgment of the item selection and purchase instmctions.
  • the business server receives the response document request and parses 1320 out the item selection and purchase instmctions from the response document request and creates a response.
  • the business server queries legacy database 1000 (FIG. 1) for item availability and pricing and composes a response document based on templates stored in Internet database 1010 (FIG. 1).
  • the business server sends response document 1310 to the Web client and the Web client interprets 1335 the response document to create a display.
  • Style Language Transformation (XSLT) document exists for each translation.
  • An XSLT document specifies how one XML document may be translated into another XML document.
  • the translator reads in the external XML document and translates it using XSLT document document 1725 into the internal XML document.
  • the internal XML document is then sent on to other server objects for use within the business server.
  • the translator may also handle translations from internal XML documents into external XML documents in an analogous manner.
  • the translator reads an internal XML document and uses a XSLT document document to translate the internal XML document into an external XML document.
  • FIG. 6c is a dataflow diagram of data through the business server.
  • Business server 1400 instantiates and invokes a pipeline object 1405.
  • the business server passes in an incoming document in the form of an XML document as well as request, response, and application objects 1425 from the business server environment.
  • the pipeline creates dictionary object 1420 for the storage of doclets and DOM objects.
  • a DOM object is instantiated and invoked. Once invoked, the DOM object encapsulates the incoming XML document.
  • the DOM object is stored in the dictionary.
  • sorter 1410 creates a DOM object to encapsulate the incoming XML document.
  • the mles object performs any necessary operations on the working DOM object to complete the business transaction. Modifications to the DOM object are immediately reflected in the working doclet stored in the dictionary.
  • the adapter invokes outgoing translator 1775 passing in a name for an XSLT document specifying the conversion of the working doclet into an outgoing XML document.
  • the XMLDOM has, for each XML element or attribute, an XMLDOMNode object.
  • the document that created is an "instance" of the template or class of document being created.
  • an instance is made of the object that the template describes.
  • Instantiating a DOM object automatically instantiates the underlying XMLDOM object.
  • DOM and XMLDOM objects are classes with class definitions; the class definitions of DOM and XMLDOM objects function as templates.
  • a class definition means a template that defines properties, methods, and in some cases, code procedures, that underlie an object. Accordingly, when a programmer wishes to use a DOM object, the programmer must use a class to instantiate the DOM object into a software object.
  • the Document component object is what is first created when a new document is created.
  • the Document component wraps the Microsoft XMLDOM XML tree by tag name, exposing Node component objects at each level. Most of the work happens at the Node component level. However, Node components are generally always attached to a Document component, directly or indirectly.
  • the ninth 57 data field is a multivalued data field containing two customer check amounts "1000" 58 and "1480" 60 separated by a value delimiter 59.
  • the append Element method creates a new element (a Child element) under an existing mvNode with the name provided in the elementName parameter and returns an mvNode.
  • the following syntax example is illustrative:
  • the name parameter consists of a String. Provided the name parameter String value is present, childNodes method returns either a list of nodes with the tag name indicated in the name parameter String or a NULL value if the call fails.
  • the following example is illustrative:
  • an exists method is provided for searching the cunent element for any immediate child element that has the name specified in the search criteria.
  • the exists method returns a value of tme if a match is found; otherwise it returns a value of false.
  • the following example is illustrative: if not obj.MVData.exists("Record") then msgBox "No items in your data! end if
  • the above exists method example checks to see if there are any Record elements immediately under the MVData element.
  • the present invention provides a method for converting Internet data to a simple legacy data stmcture.
  • the Internet data stmcture may be characterized by a tree-based stmcture definition.
  • the legacy data stmcture may be characterized by a particular stmcture and by a set of relationships.
  • the stmcture and the set of relationships that characterize the legacy data may be described by metadata comprising a plurality of metadata components.
  • the adapter asks the highest level node 600 to list all of its immediate children.
  • the adapter obtains a list of all of the children to the highest level node, e.g., 602 and 603 are depicted as options, because the details for those records will not be discussed herein, and 601.
  • the adapter will traverse the tree one Record node at a time. Beginning in our example with Record node 601 , the adapter initializes a legacy data record for the data contained in the Record node 601 branch; the adapter inserts the ID, "00101" attribute of the Record node 601 into the beginning of the new legacy data record 22, and inserts a " ⁇ " delimiter after the attribute 100.
  • the adapter then encounters the next Field node 606 and immediately inserts a Field delimeter " ⁇ " 101.
  • the adapter recognizes the single data element "ABC” 607. Accordingly, the adapter inserts the data field "ABC" 607 into the new legacy record 26.
  • the adapter provides a number of conversion and integration capabilities, including, among others, methods that delete records from a file (e.g., a method named "DeleteXML” in an XML Internet environment), read records from a file (e.g., a method named "ReadXML”in an XML Internet environment), and write records to a file (e.g., a method named "WriteXML”in an XML Internet environment).
  • methods that delete records from a file e.g., a method named "DeleteXML” in an XML Internet environment
  • read records from a file e.g., a method named "ReadXML”in an XML Internet environment
  • write records to a file e.g., a method named "WriteXML”in an XML Internet environment.
  • the Provider property method in the exemplary embodiment depicted here, exposes the ADODB.Connection Provider property and defaults to "GAXOleDB.”
  • An example of the Provider property method is:
  • the adapter sets a property, such as the En. Source property, to "Provider.”
  • VBScript Visual Basic Script
  • VBScript tries to interpret (or “parse") the reference “obj.invoice.orderDate.text”
  • VBScript starts with the term “obj” 811 and searches its symbol table.
  • the VBScript program finds the term “obj” 811 in its symbol table as an ActiveX object. After it resolves the highest level node, in this case "obj" 811, the scripting language relies on the ActiveX control to determine whether or not the properties and methods the programmer is calling with the subsequent nodes are valid.
  • nodepath This identifies the path of the parent node o of the collection in the XML document tree. If the nodepath results in an attribute instead of an element, an enor is thrown.
  • collectionelementname This identifies the element name shared by a set of child nodes. index This is a one-based integer identifying 5 particular child nodes within a collection on a left-to-right basis. However, collection elements are only treated logically if they are adjacent If other child nodes not matching the specified collectionelementname are interspersed, they may be ignored. 0
  • an XML object is available to the browser that contains the legacy data, but it is in a form that, although modified, is reflective of the needs of the legacy DBMS and the accessing browser.
  • Trading partners have stmctures and naming tags proprietary to their respective enterprises, or in the alternative, conform to one of the many available "standard" formats promulgated by numerous vendors.
  • a DBMS server e.g., 305a
  • each DBMS server e.g., 305a
  • the legacy software methods and programs when executed, provide information about the particular DBMS server system
  • the invention further provides a browser interface for managing "Q-Pointers", such as in a multivalue system environment.
  • Q-Pointer is a synonym reference to a file, where the file being referenced can be in the same account, but under a different name, or in a different account with either the same name or a different name.
  • the invention uses another web page, "NewQPointer.asp", to add a new Q-Pointer.
  • NewQPointer.asp presents a simple HTML form through which the invention requests and retrieves information for a new Q-Pointer entered by a user. The invention then submits the user-supplied new Q-Pointer information to another page, "AddQPointer.asp".
  • the AddQPointer.asp page accepts the HTML form values from the previous NewQPointer.asp page, parses this information, and uses it to validate the creation of a new Q-Pointer that conforms to the user-supplied information.
  • AddQPointer.asp page Creates the new Q-Pointer and returns a browser page which displays the status (success or failure) of the operation as well as an option to go back to the first page.
  • the lines of Visual Basic code illustrated above provide a graphic user interface with which to determine the existence ofa particular item, such as the RHQ item 446 as depicted in FIG. 36, and which exposes the account, item and file information.
  • Exemplary Visual Basic code for performing the precautionary step of ensuring that an existing item will not be overwritten is as follows:
  • the XML schema builder provides the user with the ability to reference specific RDBMS elements, for example, catalogs, publishers, tables of authors and titles, and stored procedures.
  • the View Definition Builder is a program that creates an empty View Definition and then prompts the user to create a new view.
  • the View Definition Builder applies the resulting DOM tree as an ASCII XML file to the Root Element, which in the case of the illustrative example is, "myEnte ⁇ riseView.xml".
  • the cunent invention prompts the user to select the view types, e.g., ADO, file: HTML, etc.
  • the cunent invention further prompts the user to select a name for the view and to assign all relevant OLE DB properties to establish a connection.
  • Stylesheet Language are used to determine the client type and generate the appropriate WML (Wireless Markup Language)/ WAP (Wireless Access Protocol) or HTML/HTTP code for the client device.
  • WML Wireless Markup Language
  • WAP Wireless Access Protocol
  • HTML/HTTP code HTML/HTTP code
  • a data integration server is programmed to provide access to Line-Of-Business Legacy data from such sources as RDBMS, HTTP, FTP, COM, CORBA and others; the server is programmed to use Internet standards.
  • the exemplary embodiment provides eBusiness application developers with the ability to leverage W3C Industry standards to integrate varied data sources by providing a uniform model of data representation, a uniform data access programming model, and uniform datatyping.
  • the cunent invention further provides a virtual in-memory tree and virtual instantiation.
  • the user asks for a property of a cunent node.
  • the cunent invention checks the status of the cunent node and reports the status as: 1.) it is from a static layer cunently in memory; or 2.) it represents a layer that is supplied by a data source and is a.) cunently in memory; or b.) it is not in memory at which point the cunent invention reads the node and loads it into memory.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Document Processing Apparatus (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

L"invention concerne un appareil, des systèmes et des procédés d"intégration de données stockées utilisant des systèmes de gestion de bases de données existantes (souvent appelées ici "données existantes") à l"aide de données accessibles par un environnement de réseau de communications mondial (parfois appelées ici "données Internet") tel que l"Internet. Un serveur produit un traitement structuré permettant une circulation efficace des données par la transformation des documents entrants, la mise en application de règles commerciales, et l"acheminement de documents en réponse. Des données existantes et Internet sont converties et intégrées, sans perte, à l"aide de structures de données intermédiaires encapsulées à l"intérieur d"objets logiciels avec des procédés exposés de création, de navigation, d"actualisation et d"accès de données à l"intérieur des objets logiciels. Ces objets logiciels peuvent aussi être utilisés pour développer, pour gérer, pour commander et pour intégrer des données Internet depuis n"importe quel langage hébergé de script Windows, notamment entre autres le script VB (Basic Visuel), JScript et PerlSscript. Dans un autre mode de réalisation, un portail Internet de données existantes est prévu pour l"intégration de systèmes logiciels d"applications existants dans un réseau de communications mondial tel que l"Internet, lequel expose la capacité d"exécuter un procédé sur un serveur de bases de données existantes utilisant une application Internet sur un serveur Web. Les résultats du procédé exécuté sont renvoyés au serveur Web sous la forme d"une structure arborescente de données Internet.
EP00972508A 1999-10-29 2000-10-27 Appareil, systemes et procedes de developpement, de gestion, de commande et d'integration de donnees electroniques dans un environnement de reseau de communications mondial Withdrawn EP1228444A2 (fr)

Applications Claiming Priority (11)

Application Number Priority Date Filing Date Title
US16271799P 1999-10-29 1999-10-29
US162717P 1999-10-29
US16945599P 1999-12-07 1999-12-07
US16945499P 1999-12-07 1999-12-07
US169455P 1999-12-07
US169454P 1999-12-07
US17959500P 2000-02-01 2000-02-01
US179595P 2000-02-01
US19839600P 2000-04-19 2000-04-19
US198396P 2000-04-19
PCT/CA2000/001280 WO2001033387A2 (fr) 1999-10-29 2000-10-27 Appareil, systemes et procedes de developpement, de gestion, de commande et d"integration de donnees electroniques dans un environnement de reseau de communications mondial

Publications (1)

Publication Number Publication Date
EP1228444A2 true EP1228444A2 (fr) 2002-08-07

Family

ID=27538668

Family Applications (1)

Application Number Title Priority Date Filing Date
EP00972508A Withdrawn EP1228444A2 (fr) 1999-10-29 2000-10-27 Appareil, systemes et procedes de developpement, de gestion, de commande et d'integration de donnees electroniques dans un environnement de reseau de communications mondial

Country Status (4)

Country Link
EP (1) EP1228444A2 (fr)
AU (1) AU782134B2 (fr)
CA (1) CA2395091A1 (fr)
WO (1) WO2001033387A2 (fr)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111753234A (zh) * 2020-06-24 2020-10-09 中国建设银行股份有限公司 一种数据可视化方法、装置、服务器和介质

Families Citing this family (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20020147745A1 (en) * 2001-04-09 2002-10-10 Robert Houben Method and apparatus for document markup language driven server
CA2348706A1 (fr) 2001-05-25 2002-11-25 Ibm Canada Limited-Ibm Canada Limitee Conversion de code source d'interface utilisateur d'une application patrimoniale en pages web
US7096278B2 (en) 2001-07-27 2006-08-22 Fraser Research, Inc. Electronically readable name tags for network communications
GB2387085A (en) * 2002-03-25 2003-10-01 Sony Uk Ltd System
AU2003300142A1 (en) 2002-12-30 2004-07-29 West Services, Inc. Knowledge-management systems for law firms
US7428729B2 (en) 2004-01-30 2008-09-23 International Business Machines Corporation Methods, systems, and computer program products for integrating legacy applications into a platform-independent environment
US7765254B2 (en) 2005-10-26 2010-07-27 International Business Machines Corporation Integration of legacy applications
CN113157257B (zh) * 2021-04-12 2024-03-29 山东省城市商业银行合作联盟有限公司 针对银行系统的快速开发装置
US11487931B1 (en) * 2021-10-18 2022-11-01 International Business Machines Corporation Replaying a webpage based on virtual document object model

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO1997015018A1 (fr) * 1995-10-16 1997-04-24 Bell Communications Research, Inc. Procede et systeme permettant un acces homogene a des informations heterogenes
US5970490A (en) * 1996-11-05 1999-10-19 Xerox Corporation Integration platform for heterogeneous databases

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See references of WO0133387A2 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111753234A (zh) * 2020-06-24 2020-10-09 中国建设银行股份有限公司 一种数据可视化方法、装置、服务器和介质

Also Published As

Publication number Publication date
AU782134B2 (en) 2005-07-07
WO2001033387A3 (fr) 2002-04-04
CA2395091A1 (fr) 2001-05-10
WO2001033387A2 (fr) 2001-05-10
AU1123101A (en) 2001-05-14

Similar Documents

Publication Publication Date Title
US5737592A (en) Accessing a relational database over the Internet using macro language files
US7444643B2 (en) Accessing a ERP application over the internet using strongly typed declarative language files
US6901403B1 (en) XML presentation of general-purpose data sources
US6418448B1 (en) Method and apparatus for processing markup language specifications for data and metadata used inside multiple related internet documents to navigate, query and manipulate information from a plurality of object relational databases over the web
US6799184B2 (en) Relational database system providing XML query support
US8924408B2 (en) Automatic generation of database invocation mechanism for external web services
US6456308B1 (en) Embedded web server
US5793966A (en) Computer system and computer-implemented process for creation and maintenance of online services
US6105043A (en) Creating macro language files for executing structured query language (SQL) queries in a relational database via a network
US5973696A (en) Embedded web server
US8290977B2 (en) Database system providing methodology for execution of functions in XML queries
US6356920B1 (en) Dynamic, hierarchical data exchange system
US20020099738A1 (en) Automated web access for back-end enterprise systems
US6658624B1 (en) Method and system for processing documents controlled by active documents with embedded instructions
US20020147745A1 (en) Method and apparatus for document markup language driven server
US20040088713A1 (en) System and method for allowing client applications to programmatically access web sites
US20060004910A1 (en) Postback input handling by server-side control objects
JP2005507523A (ja) 文書生成に関する改良
JPH11502346A (ja) オンラインサービスの作成および保守用のコンピュータシステムおよびコンピュータ実行プロセス
Maluf et al. NASA Technology Transfer System
AU782134B2 (en) Apparatus, systems and methods for electronic data development, management, control and integration in a global communications network environment
US7624397B1 (en) Universal component system for application servers
Lu et al. Integrating database and world wide web technologies
WO2001082133A2 (fr) Aplanisseur de xml
Thangarathinam PROFESSIONAL ASP. NET 2.0 XML

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

17P Request for examination filed

Effective date: 20020529

AK Designated contracting states

Kind code of ref document: A2

Designated state(s): AT BE CH CY DE DK ES FI FR GB GR IE IT LI LU MC NL PT SE

AX Request for extension of the european patent

Free format text: AL;LT;LV;MK;RO;SI

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION IS DEEMED TO BE WITHDRAWN

18D Application deemed to be withdrawn

Effective date: 20060503