Search Images Maps Play YouTube News Gmail Drive More »
Sign in
Screen reader users: click this link for accessible mode. Accessible mode has the same essential features but works better with your reader.

Patents

  1. Advanced Patent Search
Publication numberUS20040193651 A1
Publication typeApplication
Application numberUS 10/820,018
Publication dateSep 30, 2004
Filing dateApr 8, 2004
Priority dateSep 13, 2000
Also published asUS6754672, US20040193630
Publication number10820018, 820018, US 2004/0193651 A1, US 2004/193651 A1, US 20040193651 A1, US 20040193651A1, US 2004193651 A1, US 2004193651A1, US-A1-20040193651, US-A1-2004193651, US2004/0193651A1, US2004/193651A1, US20040193651 A1, US20040193651A1, US2004193651 A1, US2004193651A1
InventorsAndrew McLauchlin
Original AssigneeAmerican Management System, Inc.
Export CitationBiBTeX, EndNote, RefMan
External Links: USPTO, USPTO Assignment, Espacenet
System and method for efficient integration of government administrative and program systems
US 20040193651 A1
Abstract
A system and method includes an interoperability engine dynamically generating and updating an application database, a web-based portal in a computer communications network, and a baseline data schema from at least one of a data source and a supplemental data source comprising self-describing documents, and enabling interoperability among application systems. The application database dynamically generates a reporting database. The web-based portal provides access to the application systems via the application database and the reporting database. The self-describing documents may be hosted. An integration unit maps the application systems to the baseline data schema and facilitates transmission and messaging between the baseline data schema and the application systems.
Images(5)
Previous page
Next page
Claims(6)
What is claimed is:
1. A computer readable storage medium controlling a computer and comprising a process of surveying a data source; dynamically generating a point of access user interface, an application database, a reporting database, a baseline data schema based on the data source; enabling interoperability among the application systems using the baseline data schema; mapping the application systems to the baseline data schema; and providing access to the application systems via the point of access using the application database and the reporting database.
2. The computer readable storage medium as recited in claim 1, wherein the surveying of the data source is initiated on demand.
3. The computer readable storage medium as recited in claim 1, wherein the surveying of the data source is regularly initiated.
4. A computer readable storage medium controlling a computer and comprising a process of surveying a data source; capturing changes to the data source; dynamically updating a point of access user interface based on the changes to the data source; dynamically updating an application database and a reporting database based on the changes to the data source; dynamically updating an interoperability engine baseline data schema based on the changes to the data source; allocating space in the application database for the changes to the data source; applying an integration unit mapping the application systems to the baseline data schema; and providing access to the application systems via the point of access using the application database and the reporting database.
5. The computer readable storage medium as recited in claim 4, wherein the surveying of the data source is initiated on demand.
6. The computer readable storage medium as recited in claim 4, wherein the surveying of the data source is regularly initiated.
Description
CROSS-REFERENCE TO RELATED APPLICATION

[0001] This application is a divisional of application Ser. No. 09/691,058, filed Oct. 19, 2000, allowed.

[0002] This application is based upon and claims priority of U.S. Provisional Application No. 60/230,938 filed on Sep. 13, 2000, and U.S. patent application Ser. No. 09/691,058, filed Oct. 19, 2000, the contents being incorporated herein by reference.

BACKGROUND OF THE INVENTION

[0003] 1. Field of the Invention

[0004] The present invention is directed to a system designed to assist federal government organizations in facilitating the integration and sharing of core administrative and program data among disparate but inter-related application systems via a web-based portal and a back-end interoperability engine.

[0005] 2. Description of the Related Art

[0006] Federal organizations perform their operations using a fragmented set of computer systems. Each computer system associated with a particular federal organization addresses specific administrative needs, such as financial management, procurement, property management, asset sales, and grants management. Each computer system may further support program specific activities specific to the federal organization's mission, for example, environmental permitting, patent application processing, or managing customer relationship for social services. The federal organization may build its computer system in-house, purchase commercial-off-the-shelf products vendors, or implement a system developed by other federal organizations (e.g., the National Institutes of Health=s contractor past performance system). In addition, the federal organization may desire or be required to use external publicly accessible systems such as FedBizOpps (formerly known as the Electronic Posting System), the Central Contractor Registration (“CCR”), the Federal Procurement Data System (“FPDS”), or the Federal Acquisition Management Information System (proposed to replace FPDS).

[0007] Each system provides value to the corresponding federal organization in automating the individual processes and functions for which they are designed. However, the functions of these systems often overlap, or need to interoperate. Consider the simple example of buying a desk. A procurement system generates the purchase order, but the procurement process requires interoperability with several other systems. For instance, the purchasing agent may desire to post solicitation information to FedBizOpps to solicit bids. Further, as part of the procurement decision process, the purchasing agent is required to consider the past performance of potential vendors, for example, by accessing past performance systems such as the NIH past performance system. The purchasing agent may require additional detailed vendor data, which may be stored in a CCR system. Further, before an order is finalized, the organization=s financial system needs to be polled to ensure that funds are available in the budget for the purchase and to obligate money for the ensuing payment. The purchasing agent may also need to report order data to FPDS. A property manager may also want to track the newly purchased item as a fixed asset in a property management system.

[0008] To date, federal organizations have had limited options to achieve system integration. The federal organizations may build individual interfaces between two systems to enable those two systems to communicate and then repeat the process for other systems. However, this approach may result in a confusing network of related but separately developed interfaces that pose a high risk of being out of synch. Some federal organizations resort to re-keying the data into each system; however, this approach is labor intensive and repetitive.

[0009] In the late 1990s, Enterprise Resource Planning (“ERP”) systems were implemented in an attempt to solve interoperability problems among administrative systems in federal organizations by providing a single application that performs a variety of administrative functions, ranging from human resource management to financial management and procurement. However, the ERP system posed its own set of problems. For instance, switching to the ERP system required organizations to replace legacy applications with a new system and encumbered major system implementation expenses and management issues.

[0010] Additionally, the ERP system capabilities in specific functions, such as procurement, often fell short of robust functionality offered by best-of-breed products that were designed specifically to support those functions, thereby forcing organizations to choose between achieving a minimum level of administrative integration at the expense of deep functional support. Furthermore, it is difficult for any single software application system to anticipate and support all of the federal organization=s potential programmatic needs, as well as, administrative needs. Even though the ERP system may meet some needs, it still requires a network of interfaces to other applications within the organization (e.g., program support systems and administrative systems not covered by the ERP) and requires a network of interfaces to publicly owned applications such as CCR and FedBizOpps. Seamless integration and communication among the various application systems requires extensive infrastructure or middleware architecture.

[0011] Portal tools enable delivery of data to employees, customers and business partners via a web-based interface. Yet, the portal tools need underlying instructions regarding what data to share among business partners, and the rules within which that data should be shared (e.g., read only, not visible, editable, deletable).

[0012] Enterprise Application Integration (“EAI”) products offer robust tools for such interoperability tasks as mapping one system to a defined data schema and sending messages from one system to another. EAI tools often provide out-of-the-box, “no coding” adapters that integrate widely used commercial off the shelf (“COTS”) products. While EAI tools provide a platform that can facilitate interoperability and out-of-the-box adapters may provide a good integration starting point, several factors exist that require an additional layer of interoperability automation. For example, in many cases, federal organizations have built their own custom systems for which no standard adapter schema for a COTS product exists.

[0013] Additionally, out-of-the-box adapters are typically designed and developed for lowest-common-denominator data integration needs and for corporate business processes, not for federal organizations. Although much can be leveraged from commercial adapters to create federal adapters, these adapters must be changed or rewritten to accommodate core federal requirements (e.g., verifying funds availability before a purchase order is finalized). A federal interoperability tool is needed that enables federal organizations to pull their disparate application systems together and to base the interoperability and integration on rules established as both government-wide and organization-wide policy.

SUMMARY OF THE INVENTION

[0014] It is an object of the present invention to provide for a system that allows internal government systems (e.g., program systems including customer relationship management, internal operations, and administrative systems including finance, procurement, property, asset sales, and grants) and external government systems (e.g., FedBizOpps, CCR, FPDS or the Federal Acquisition Management Information System) to communicate and exchange messages and allows an end user to access the plurality of disparate legacy, current, and emerging government application systems from a point of entry web-based portal in a computer communications network. Further, the present invention ensures that information is accessed and used only in authorized ways and maintains the integrity, availability, and/or confidentiality of the information.

[0015] It is an object of the present invention to provide for a system, a method, and a computer readable storage medium providing users of a federal organization administrative and program processes a single web-based system interface from which to conduct all business transactions and exchanges of information. In particular, a data source includes self-describing documents including data elements, definitions of data elements, data element contents, data element characteristics and business function interoperability rules for each data element in the application systems. An interoperability engine processes the definitions and the interoperability rules and provides interoperability among the application systems. A point of entry web-based portal connected to the back-end interoperability engine provides access to disparate federal application systems.

[0016] In accordance with another object of the present invention, a data source is regularly surveyed and the interoperability engine analyzes changes to the data source. The interoperability engine dynamically generates and/or updates a baseline data schema based on changes to the data source. The invention applies the baseline data schema in various ways to dynamically build and maintain a single point of access to and interoperability among multiple external, administrative and programmatic systems, as follows.

[0017] The interoperability engine dynamically updates an application database structure based on changes to the data source as defined in the baseline data schema. The interoperability engine dynamically updates the web-based portal interface based on the changes to the data source as defined in the baseline data schema. The interoperability engine dynamically updates system interoperability among multiple external, administrative, and programmatic systems based on changes to the data source as defined in the baseline data schema. An integration unit is associated with the baseline data schema to facilitate mapping and messaging of data among the external systems, administrative systems, programmatic systems, and the application database. The web portal provides access to the application database, which interoperates with the external, administrative, and programmatic systems via the integration unit based on rules defined by the baseline data schema.

[0018] In accordance with another object of the present invention, a system includes an interoperability engine dynamically generating a point of access, an application database, and a baseline data schema and enabling interoperability among application systems.

[0019] In accordance with another aspect of the present invention, a method including dynamically generating a point of access, an application database, and a baseline data schema, enabling interoperability among application systems using the baseline data schema, and providing access to the application systems via the point of access using the application database.

[0020] In accordance with a further object of the present invention, a computer readable storage medium controlling a computer and including dynamically generating a point of access, an application database, and a baseline data schema, enabling interoperability among application systems using the baseline data schema, and providing access to the application systems via the point of access using the application database.

[0021] These together with other objects and advantages, which will be subsequently apparent, reside in the details of construction and operation as more fully hereinafter described and claimed, reference being had to the accompanying drawings forming a part hereof, wherein like numerals refer to like parts throughout.

BRIEF DESCRIPTION OF THE DRAWINGS

[0022]FIG. 1 is a diagram of a system architecture in accordance with the present invention;

[0023]FIG. 2 is a diagram of a dynamic start-up process, in accordance with the present invention;

[0024]FIG. 3 is a diagram of a dynamic system update, in accordance with the present invention; and

[0025]FIG. 4 is a diagram of a process performed by an interoperability engine, in accordance with the present invention.

DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0026]FIG. 1 is a schematic diagram of an embodiment of a system 10 including a Web portal 20 allowing multiple users, such as citizens 22, agency staff 24, and other government staff 26 to access most current information from various application systems, such as federal government application systems (e.g., external systems 30, program systems 32, and administrative systems 34). These application systems may be of various types and use various languages and protocols, such as Java, XML, C++, Visual Basic, etc.

[0027] Connected to the Web portal 20 is a Web server (not shown) that delivers an HTML document, or “Web page,” to a Web browser (not shown) when requested. These browsers take a document formatted in HTML, generate its visual display, and perform any associated processing. Internet communications are mainly based upon Hypertext transport protocol (“HTTP”), Common gateway interface (“CGI”), Internet inter ORB protocol (“IIOP”), and Java database connectivity (“JDBC”). HTTP is the main communication mechanism among web browsers and servers.

[0028] A data source 36 is provided including one or more self-describing documents. The self-describing documents of the data source 36 are, for example, XML documents based on document table definitions (“DTD”) that define terms and fields of a core set of data elements for the external systems 30, program systems 32, and administrative systems 34 and their interrelationships. The DTD acts as a translator defining the terms and fields to be later used to communicate with the external systems 30, program systems 32, and administrative systems 34. Thus, the DTD in the self-describing documents of the data source 36 may include, for example, data elements, data element contents, data element characteristics, and data interoperability rules that may be necessary to facilitate communication and messaging among the external systems 30, program systems 32, and administrative systems 34.

[0029] In an exemplary embodiment, the data elements may include data labels such as quantity, price, unit, award date, and obligated amount. Data element characteristics include fields such as Required, Optional, Text, Numeric. Data interoperability rules include operation rules of system 10. The system 10 operation rules include required edit checks among other data elements, for instance, cross-data edits currently specified in the FPDS Reporting Manual, instructions identifying, at a generic level, the data elements that a particular data source requires (e.g., labels such as Property, Finance, Procurement, Supplier, Citizen), and instructions identifying the different external systems 30, program systems 32, and administrative systems 34 that share data elements. The self-describing documents of the data source 36 may contain additional data definitions and data interoperability instructions as necessary to define the system 10 requirements and operating rules, for example, tags that specify the current date and version of the data source 36 and/or tags that specify the current date and version for each data element within the self-describing documents of the data source 36 (i.e., DTD).

[0030] A supplemental data source 38, for example, may be incorporated providing policies and best practices and also including one or more self-describing documents. Using the supplemental data source 38, federal organizations have the option to define organization-specific self-describing documents that add data element components to the system 10 beyond those defined by the data source 36. The federal organizations may provide modifications or updates to the data element components identified by the data source 36 as optional. These modifications would be incorporated into the self-describing documents of the supplemental data source 38 and would override the defining characteristics of the specific component contained in the data source 36. Further, organizations may add components (e.g., organization-specific data elements or interoperability requirements) in addition to the components already provided for in the data source 36.

[0031] The self-describing documents of the data source 36 and/or of the supplemental data source 38 include data elements, data element contents, data element characteristics, and data interoperability rules for each data element required by the federal organizations implementing system 10 such as those elements required by the external systems 30, program systems 32, and administrative systems 34. Further, the self-describing documents of the data source 36 and/or of the supplemental data source 38 may be hosted. For example, the self-describing documents of the data source 36 and/or of the supplemental data source 38 may be hosted at a site owned by a proprietary owner (e.g., American Management Systems, AMS), at a public site (e.g., the General Services Administration), or at an implementing organization site (e.g., Department of Transportation, Department of the Interior, or any other commercial organization).

[0032] An interoperability engine 40 provides interoperability between appreciation systems such as legacy, current, and emerging government external systems 30, program systems 32, and administrative systems 34. The interoperability engine 40 is a data extraction, transformation, and transportation tool developed using common programming language (e.g., Java, XML, C++, Visual Basic, etc.). The interoperability engine 40 may be a transaction server, an application server, a component server, or a business rule server. The basic abilities of the interoperability engine 40 include scalability, adaptability, recoverability, and manageability.

[0033] The interoperability engine 40 dynamically generates an interoperability baseline data schema based on the self-describing documents from the data source 36 and/or the supplemental data source 38. Specifically, the interoperability engine 40 generates in real time, in an automated manner and without human intervention, the baseline data schema. The baseline data schema is a computer medium, self-describing documents, or files, such as XML, which can be used for generating Web portals, generating databases, and defining adaptors used by EAI tools. In essence, the baseline data schema functions as a common denominator to leverage and enable interoperability among various systems.

[0034] These various systems may be any type of system that need to interoperate with other systems and may be in any given format. In an exemplary embodiment, the baseline data schema functions as a common denominator to leverage an EAI tool 36, to be later discussed, to communicate to external systems 30, program systems 32, and administrative systems 34. The data elements in the baseline data schema are mapped in a format that the EAI tool 36 or any other type of integration tool well known in the art can recognize. For instance, the EAI tool 36 may accept a common format of XML documents that the EAI tool 36 can import and can be used to map to the various external systems 30, program systems 32, and administrative systems 34. In one embodiment, the interoperability engine 40 includes the Web server. Alternatively, the Web server may stand separate from the interoperability engine 40 and connected to the Web portal 20.

[0035] The interoperability engine 40 further dynamically generates an application database 45. In turn, the application database 45 dynamically generates a reporting database 50 (i.e., the application database 45 generates on the fly the reporting database 50). Once again, dynamic generation may be accomplished by generating in real time or in an automated manner without human intervention. The application database 45 and the reporting database 50 are database structures connected to the Web portal 20. The application database 45 and the reporting database 50 contain identical data elements as a baseline data schema of an interoperability engine 40, to be later described, in a structured design. The application database 45 provides the user with read/write access to the external systems 30, program systems 32, and administrative systems 34. The reporting database 50 is a data mart or a data warehouse that allows the user to access information from the external systems 30, program systems 32, and administrative systems 34, for example, in a read only format.

[0036] The interoperability engine 40 analyzes the self-describing documents received from the data source 36 and/or the supplemental data source 38, interprets the self-describing documents, and generates the baseline data schema. The interoperability engine 40 builds the Web portal 20 based on the baseline data schema. The interoperability engine 40 enables the user to access the external systems 30, program systems 32, and administrative systems 34 via, for example, the Web portal 20 or any other means using the application database 45 and the reporting database 50, and supports messaging and sharing of information among the external systems 30, program systems 32, and administrative systems 34. Thus, the interoperability engine 40 dynamically generates the application database 45, the reporting database 50 structure, and the Web portal 20 by applying, for instance, COTS database, OLAP, and Web portal tools well known in the art.

[0037] Once a user logs in, the Web portal 20 allows the user to access data information and/or navigate through the external systems 30, program systems 32, and administrative systems 34. Furthermore, in the event the user wishes to access a particular external system 30, program system 32, and administrative system 34, the external system 30, program system 32, and administrative system 34 is configured, for example, to perform a security clearance prior to allowing the user to access the information. As an alternative, the data source 36 and/or the supplemental data source 38 might be configured, for example, to incorporate security constraints in accordance with predefined security requirements from the external, administrative, and program systems. For example, source documents that define unclassified systems such as finance, procurement, or property, and that are hosted by a public site, may be posted with low levels of security. Whereas, source documents that define systems that support classified operations or that contain proprietary source definitions, would be posted with high levels of security.

[0038] In another embodiment, the interoperability engine 40 is programmed, for example, to monitor security clearance. The system 10 architecture might be implemented to ensure user security administration and validation key management on the network. The security clearance can be verified, for example, at the time the user attempts to access the particular external system 30, program system 32, or administrative system 34. Further, the system 10 can be implemented, for example, where in the event the user is allowed to access a particular external system 30, program system 32, or administrative system 34 but requires to access information from another external system 30, program system 32, and administrative system 34, the interoperability engine 40 may prompt the user, via the Web portal 20, that further security clearance is required to access the information.

[0039] This integration of the invention with internal and external systems enables all business partners both, inside and outside the implementing federal organization, to interact with each other and share data via the Web portal 20. Entries into the Web portal 20 trigger EAI-enabled sharing of data from the baseline data schema to the relevant internal and external systems. This interoperability enables users, from the Web portal 20, to interact with internal and external systems and perform business transactions (e.g., post requests for quotations, access established sources of vendor data, post procurement synopsis and award notices).

[0040] Furthermore, the interoperability engine 40 may include, for instance, mechanisms to dynamically survey the information in the data source 36 and/or the supplemental data source 38 to determine if any changes have occurred within the data source 36 and/or the supplemental data source 38. For instance, the interoperability engine 40 would dynamically survey the tags in the self-describing documents of the data source 36 and/or of the supplemental data source 38 specifying the current date and version of the data source 36 and/or supplemental data source 38, and thereby trigger the dynamic system update, to be described in FIG. 3. In the alternative, the interoperability engine 40 would dynamically survey the tags in each data element in the self-describing documents of the data source 36 and/or of the supplemental data source 38 to determine if the current date and/or version have changed and thereby trigger the dynamic system update. The system 10 may also provide a mechanism to trigger a survey of the data source 36 and/or the supplemental data source 38 on demand. For example, the data source 36 and/or the supplemental data source 38 may have a master version number data element that the invention surveys, compares to the last version number, and determines whether a new version of the data source 36 and/or the supplemental data source 38 has been posted. In another embodiment, the interoperability engine 40 may trigger the survey to the data source 36 and/or the supplemental data source 38.

[0041] If the version has changed, the interoperability engine 40 dynamically initiates maintenance or update adjustments based on the data contained in the self-describing documents of the data source 36 and/or the supplemental data source 38. If the version has not changed, the interoperability engine 40 dynamically updates the application database 45, the reporting database 50, the baseline data schema, and the Web portal 20 to reflect the current version number along with current date and time as the last version survey conducted.

[0042]FIG. 2 is a diagram of a dynamic start-up process 100. At operation 110, memories are cleared, initial flag conditions are set, etc., as is well known in the art. From operation 110, process 100 proceeds to operation 120, where process 100 dynamically surveys and analyzes data elements, data element contents, data element characteristics, and data interoperability rules included in the data source 36 and/or the supplemental data source 38 self-describing documents. From operation 120, process 100 proceeds to operation 130, where process 100 dynamically generates the application database 45 structure. From operation 130, process 100 proceeds to operation 140, where process 100 dynamically generates the reporting database 50 structure. As previously described, the application database 45 allows the user to read/write information from and to the external systems 30, program systems 32, and administrative systems 34 via the Web portal 20 to the external systems 30, program systems 32, and administrative systems 34. The reporting database 50 allows the user to read information only from the external systems 30, program systems 32, and administrative systems 34 via the Web portal 20.

[0043] From operation 140, process 100 proceeds to operation 150, where process 100 dynamically generates the user interface Web portal 20. Specifically, process 100 creates a Web portal 20 corresponding to each external systems 30, program systems 32, and administrative systems 34 based on the information provided by either the proprietary host or public host in the self-describing documents of the data source 36 and/or of the supplemental data source 38. From operation 150, process 100 proceeds to operation 160, where process 100 dynamically generates the baseline data schema. Process 100 analyzes the information in the data source 36 and/or the supplemental data source 38, interprets the information, and maps the information into the baseline data schema.

[0044] From operation 160, process 100 proceeds to operation 170, where process 100 associates the baseline data schema with the EAI tool 36. The baseline data schema serves as a common denominator to leverage the EAI tool 36, to enable the external systems 30, program systems 32, and administrative systems 34 to share information, and to allow a user to access information from the external systems 30, program systems 32, and administrative systems 34. From operation 170, process 100 proceeds to operation 180, where the integration unit is applied to map the external systems 30, the program systems 32, and the administrative systems 34 to the baseline data schema. From operation 180, process 100 proceeds to operation 185, where the EAI tool 36 is applied facilitating transmission and messaging between the baseline data schema and the external systems 30, the program systems 32, and the administrative systems 34. Furthermore, in the embodiment described herein and illustrated in FIG. 2, process 100 performs operations 130,140, 150, and 160 sequentially. In the alternative, an ordinary person skilled in the art can appreciate that process 100 may perform operations 130,140, 150, and 160 concurrently. Further, an ordinary person skilled in the art can appreciate that process 100 may be triggered on demand.

[0045] This integration of the invention with administrative and programmatic systems enables all business partners within the federal organizations to interact with each other and share data via the Web portal 20. As a result, any data entered via the portal is stored in the application database 45. Entries into the application database 45 trigger the EAI tool 36 to allow data sharing from the application database 45 to the relevant administrative and programmatic systems. This interoperability enables users via the Web portal 20 to interact with stovepipe external systems 30, program systems 32, and administrative systems 34 and share data (e.g., update related records, trigger related transactions, access/validate/verify historical related data on demand for improved decision making). Thus, once process 100 migrates all the information contained in the external systems 30, the program systems 32, and the administrative systems 34 to the application database 45, process 100 provides an implementing organization, the option to shut down the systems 30, 32, 34.

[0046] Once process 100 is completed, the application database 45, the reporting database 50, the user interface, and the baseline data schema are dynamically updated by regularly polling the data source 36 and/or the supplemental data source 38 via a system update process 200. In one embodiment, the interoperability engine 40 regularly triggers process 200 to survey for changes in the data source 36 and/or the supplemental data source 38. In an alternative embodiment, the intelligence to automatically survey the data source 36 and/or the supplemental data source 38 is built in the self-describing documents. In another alternative embodiment, process 200 is triggered to survey the data,source 36 and/or the supplemental data source 38, on demand, through the proprietary host, the public host, the implementing organization host or the Web portal 20. For illustrative purposes, process 200, hereinafter described, is triggered by the interoperability engine 40.

[0047] For new or changed components, the dynamic system update process 200 illustrated in FIG. 3 is performed to update data element, data element contents, data element characteristics, and data interoperability rules for each data element flagged as being new or changed. FIG. 3 illustrates a dynamic system update where process 200 begins at operation 210 where memories are cleared, initial flag conditions are set, etc., as is well known in the art. From operation 210, process 200 proceeds to operation 220, where process 200 dynamically scans the data source 36 and/or the supplemental data source 38 self-describing documents for data-specific flags that identify new or changed data source 36 and/or the supplemental data source 38 components. A new or changed component may constitute a variety of distinct adjustments to the self-describing documents of the data source 36 and/or of the supplemental data source 38, such as, a new data element or a revised edit check for an existing data element. In an alternative embodiment, process 200 surveys and compares a master version number with a last version number and determines whether a new version of the data source 36 and/or the supplemental data source 38 exists.

[0048] From operation 220, process 200 proceeds to operation 230, where a determination is made whether changes occurred in the self-describing documents of the data source 36 and/or of the supplemental data source 38. In the event that no changes are made to the self-describing documents of the data source 36 and/or of the supplemental data source 38, process 200 proceeds to operation 240. At operation 240, process 200 updates the time the survey on the self-describing documents of the data source 36 and/or of the supplemental data source 38 is performed. However, if at operation 230, changes are made to the self-describing documents of the data source 36 and/or of the supplemental data source 38, process 200 proceeds to operation 250. At operation 250, process 200 dynamically updates changes to the characteristics of the data element and updates changes to the associated relationships among data elements within the self-describing documents.

[0049] From operation 250, process 200 proceeds to operation 260, where process 200 processes the changes to the data elements, data element contents, data element characteristics, and data interoperability rules and updates therefrom the application database 45. Similarly, at operation 280, process 200 dynamically updates the reporting database 50 structure. From operation 280, process 200 proceeds to operation 290, where process 200 dynamically updates the Web portal 20. Specifically, process 200 updates (e.g., read, edit, delete) data elements viewed from the web-based portal.

[0050] From operation 290, process 200 proceeds to operation 300, where process 200 surveys and analyzes the updated data source and/or supplemental data source self-describing documents of the data source 36 and/or of the supplemental data source 38 and dynamically updates the baseline data schema. Process 200 analyzes the updated information in the data source 36 and/or the supplemental data source 38, interprets the information and maps the information into a baseline data schema.

[0051] From operation 300, process 200 proceeds to operation 310, where process 200 associates the baseline data schema with the EAI tool 36. Specifically, process 200 dynamically updates the data elements, data element contents, data element characteristics, and data interoperability rules in the baseline data schema thereby dynamically updating the baseline data schema to leverage the integration unit to communicate to the external systems 30, the program systems 32, and the administrative systems 34. From operation 310, process 200 proceeds to operation 320, where the integration unit is applied to map the application system data to the updated baseline data schema. From operation 320, process 200 proceeds to operation 330, where the integration unit is applied facilitating messaging among the external systems 30, program systems 32, administrative systems 34, and the application database 45.

[0052] Thus, process 200 dynamically updates the baseline data schema and the application database 45 to identify the identifying version information (e.g., version number, date) of the surveyed and analyzed data source 36 and/or the supplemental data source 38. This version information is constantly displayed to the user via the web interface (e.g., Certified current through FAC 2000-1 dated <date>. Last surveyed: <date and time last surveyed>).

[0053] Thus, process 200 allows efficient and effective upgrade process for government external systems 30, program systems 32, and administrative systems 34. Process 200 provides dynamic migration from any given legacy system to contemporary technologies, without interruption in functionality or data access. Furthermore, in the embodiment described herein and illustrated in FIG. 3, process 200 performs operations 260, 280, 290, and 300 sequentially. In the alternative, an ordinary person skilled in the art can appreciate that process 200 may perform operations 260, 280, 290, and 300 concurrently. In the alternative, process 200 may be triggered on demand.

[0054] Because the interoperability engine 40 dynamically updates the changes to the self-describing documents of the data source 36 and/or supplemental data source 38, the baseline data schema, the Web portal 20, the application database 45, and the reporting database 50, the system update process 200 is effective and efficient. However, in the alternative, the interoperability engine 40 may also update the entire the self-describing documents of the data source 36 and/or supplemental data source 38, the baseline data schema, the Web portal 20, the application database 45, and the reporting database 50. Further, the system update process 200 allows the users accessing the external systems 30, the program systems 32, and the administrative systems 34 information via the Web portal 20, to have accurate and most up-to-date information.

[0055]FIG. 4 is a diagram of process 350 performed by the interoperability engine 40. At operation 351, process 350 receives data elements, data element contents, data element characteristics, and data interoperability rules from the data source 36 and/or the supplemental data source 38. From operation 351, process 350 proceeds to operation 352, where a new table(s) are either created or updated in the application database 45 depending on whether the dynamic start-up process 100 is performed or if the dynamic system update process 200 is performed. From operation 352, process 350 proceeds to operation 354, where new database field(s) are created/updated in the application database 45 and, at operation 356, process 350 allocates space for new data elements captured in the application database 45. From operation 356, process 350 proceeds to operation 358, where any data element content that resides in the data source 36 and/or supplemental data source 38 is fed into the space allocated in the new table(s)/field(s) in the application database 45.

[0056] In an alternative embodiment, any organization in the public or private sector could use the invention to achieve interoperability among multiple, disparate external systems 30, program systems 32, and administrative systems 34 and provide a single web-based interface for all business partners. They may control the system design by either accepting a publicly held standard self-describing data source 36 and/or the supplemental data source 38, or by building their own privately held self-describing data source 36 and/or the supplemental data source 38. The invention could also include the development of proprietary AMS self-describing data structures that can be sold to members of specific industries as an “out-of-the-box” data source 36 and/or the supplemental data source 38 for implementing the invention. Furthermore, an ordinary person skilled in the art will appreciate that interoperability may be achieved using multiple data sources and/or supplemental data sources, multiple application and reporting databases, and multiple baseline data schema, or multiple Web portals.

[0057] The above embodiments are described as using various languages and protocols, such as Java, XML, C++, Visual Basic, etc. However, the present invention is not limited to these languages and protocols, and others can be used.

[0058] The many features and advantages of the invention are apparent from the detailed specification and, thus, it is intended by the appended claims to cover all such features and advantages of the invention which fall within the true spirit and scope of the invention. Further, since numerous modifications and changes will readily occur to those skilled in the art, it is not desired to limit the invention to the exact construction and operation illustrated and described, and accordingly all suitable modifications and equivalents may be resorted to, falling within the scope of the invention.

Referenced by
Citing PatentFiling datePublication dateApplicantTitle
US7089232 *Jan 30, 2003Aug 8, 2006International Business Machines CorporationMethod of synchronizing distributed but interconnected data repositories
US7685010Apr 4, 2003Mar 23, 2010Netsuite, Inc.Concise communication of real-time business information in an enterprise network
US7685515 *Sep 18, 2003Mar 23, 2010Netsuite, Inc.Facilitating data manipulation in a browser-based user interface of an enterprise business application
US7761865 *May 11, 2004Jul 20, 2010Sap AgUpgrading pattern configurations
US7970901Jun 4, 2009Jun 28, 2011Netsuite, Inc.Phased rollout of version upgrades in web-based business information systems
US8195493Feb 2, 2010Jun 5, 2012Netsuite, Inc.Concise communication of real-time business information in an enterprise network
US8214239Aug 30, 2010Jul 3, 2012Netsuite, Inc.Concise communication of real-time business information in an enterprise network
US8484346Jun 7, 2011Jul 9, 2013NetSuite Inc.Simultaneous maintenance of multiple versions of a web-based business information system
US8838465Jun 29, 2012Sep 16, 2014NetSuite Inc.Concise communication of real-time business information in an enterprise network
US8949705 *Oct 29, 2012Feb 3, 2015NetSuite Inc.Facilitating data manipulation in a browser-based user interface of an enterprise business application
US20130174019 *Oct 29, 2012Jul 4, 2013NetSuite Inc.Facilitating data manipulation in a browser-based user interface of an enterprise business application
Classifications
U.S. Classification1/1, 707/E17.117, 707/999.107
International ClassificationG06F17/30
Cooperative ClassificationY10S707/99948, Y10S707/99945, G06F17/30893
European ClassificationG06F17/30W7L