US20040193630A1 - System and method for efficient integration of government administrative and program systems - Google Patents
System and method for efficient integration of government administrative and program systems Download PDFInfo
- Publication number
- US20040193630A1 US20040193630A1 US10/820,017 US82001704A US2004193630A1 US 20040193630 A1 US20040193630 A1 US 20040193630A1 US 82001704 A US82001704 A US 82001704A US 2004193630 A1 US2004193630 A1 US 2004193630A1
- Authority
- US
- United States
- Prior art keywords
- data source
- systems
- data
- database
- application
- 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.)
- Abandoned
Links
Images
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/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
- G06F16/972—Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99944—Object-oriented database structure
- Y10S707/99945—Object-oriented database structure processing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99948—Application of database or data structure, e.g. distributed, multimedia, or image
Definitions
- 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.
- 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 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).
- FEBizOpps formerly known as the Electronic Posting System
- CCR Central Contractor Registration
- FPDS Federal Procurement Data System
- FPDS Federal Acquisition Management Information System
- 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.
- a procurement system generates the purchase order, but the procurement process requires interoperability with several other systems.
- the purchasing agent may desire to post solicitation information to FedBizOpps to solicit bids.
- 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.
- 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.
- ERP Enterprise Resource Planning
- 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.
- 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.
- 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).
- EAI Enterprise Application Integration
- COTS commercial off the shelf
- 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.
- internal government systems e.g., program systems including customer relationship management, internal operations, and administrative systems including finance, procurement, property, asset sales, and grants
- external government systems e.g., FedBizOpps, CCR, FPDS or the Federal Acquisition Management Information System
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- FIG. 1 is a diagram of a system architecture in accordance with the present invention.
- FIG. 2 is a diagram of a dynamic start-up process, in accordance with the present invention.
- FIG. 3 is a diagram of a dynamic system update, in accordance with the present invention.
- FIG. 4 is a diagram of a process performed by an interoperability engine, in accordance with the present invention.
- 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.
- Web server 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.
- Web 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.
- 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 .
- 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 .
- 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).
- a supplemental data source 38 may be incorporated providing policies and best practices and also including one or more self-describing documents.
- 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 .
- 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 .
- 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.
- 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).
- AMS American Management Systems
- public site e.g., the General Services Administration
- an implementing organization site e.g., Department of Transportation, Department of the Interior, or any other commercial organization.
- 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.
- 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.
- 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.
- 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 .
- 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 .
- the interoperability engine 40 further dynamically generates an application database 45 .
- the application database 45 dynamically generates a reporting database 50 (i.e., the application database 45 generates on the fly the reporting database 50 ).
- 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.
- 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 .
- 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.
- 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 .
- 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.
- 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.
- 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.
- source documents that define systems that support classified operations or that contain proprietary source definitions would be posted with high levels of security.
- 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 .
- 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.
- 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).
- 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 .
- 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.
- 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.
- 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.
- the interoperability engine 40 may trigger the survey to the data source 36 and/or the supplemental data source 38 .
- 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.
- FIG. 2 is a diagram of a dynamic start-up process 100 .
- memories are cleared, initial flag conditions are set, etc., as is well known in the art.
- 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.
- process 100 proceeds to operation 130 , where process 100 dynamically generates the application database 45 structure.
- process 100 proceeds to operation 140 , where process 100 dynamically generates the reporting database 50 structure.
- 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 .
- 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.
- 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 .
- 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.
- 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 .
- process 100 performs operations 130 , 140 , 150 , and 160 sequentially.
- process 100 may perform operations 130 , 140 , 150 , and 160 concurrently.
- process 100 may be triggered on demand.
- 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 .
- 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).
- 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 .
- 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 .
- the interoperability engine 40 regularly triggers process 200 to survey for changes in the data source 36 and/or the supplemental data source 38 .
- the intelligence to automatically survey the data source 36 and/or the supplemental data source 38 is built in the self-describing documents.
- 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 .
- process 200 hereinafter described, is triggered by the interoperability engine 40 .
- 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.
- 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.
- 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.
- 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 .
- process 200 dynamically updates the reporting database 50 structure.
- 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.
- 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.
- 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 .
- 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>).
- 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.
- process 200 performs operations 260 , 280 , 290 , and 300 sequentially.
- process 200 may perform operations 260 , 280 , 290 , and 300 concurrently.
- process 200 may be triggered on demand.
- 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.
- FIG. 4 is a diagram of process 350 performed by the interoperability engine 40 .
- 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 .
- 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.
- 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 .
- 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 .
- 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.
- 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.
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.
Description
- This application is a divisional of application Ser. No. 09/691,058, filed Oct. 19, 2000, allowed.
- 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. Pat. application Ser. No. 09/691,058, filed Oct. 19, 2000, the contents being incorporated herein by reference.
- 1. Field of the Invention
- 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.
- 2. Description of the Related Art
- 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).
- 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.
- 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.
- 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.
- 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.
- 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).
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- FIG. 1 is a diagram of a system architecture in accordance with the present invention;
- FIG. 2 is a diagram of a dynamic start-up process, in accordance with the present invention;
- FIG. 3 is a diagram of a dynamic system update, in accordance with the present invention; and
- FIG. 4 is a diagram of a process performed by an interoperability engine, in accordance with the present invention.
- FIG. 1 is a schematic diagram of an embodiment of a
system 10 including aWeb portal 20 allowing multiple users, such ascitizens 22,agency staff 24, andother 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. - 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. - A
data source 36 is provided including one or more self-describing documents. The self-describing documents of thedata 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 theexternal systems 30, program systems 32, andadministrative systems 34 and their interrelationships. The DTD acts as a translator defining the terms and fields to be later used to communicate with theexternal systems 30, program systems 32, andadministrative systems 34. Thus, the DTD in the self-describing documents of thedata 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 theexternal systems 30, program systems 32, andadministrative systems 34. - 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. Thesystem 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 differentexternal systems 30, program systems 32, andadministrative systems 34 that share data elements. The self-describing documents of thedata source 36 may contain additional data definitions and data interoperability instructions as necessary to define thesystem 10 requirements and operating rules, for example, tags that specify the current date and version of thedata 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). - 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 thesupplemental data source 38, federal organizations have the option to define organization- specific self-describing documents that add data element components to thesystem 10 beyond those defined by thedata source 36. The federal organizations may provide modifications or updates to the data element components identified by thedata source 36 as optional. These modifications would be incorporated into the self-describing documents of thesupplemental data source 38 and would override the defining characteristics of the specific component contained in thedata 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 thedata source 36. - The self-describing documents of the
data source 36 and/or of thesupplemental data source 38 include data elements, data element contents, data element characteristics, and data interoperability rules for each data element required by the federalorganizations implementing system 10 such as those elements required by theexternal systems 30, program systems 32, andadministrative systems 34. Further, the self-describing documents of thedata source 36 and/or of thesupplemental data source 38 may be hosted. For example, the self-describing documents of thedata source 36 and/or of thesupplemental 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). - An
interoperability engine 40 provides interoperability between appreciation systems such as legacy, current, and emerging governmentexternal systems 30, program systems 32, andadministrative systems 34. Theinteroperability engine 40 is a data extraction, transformation, and transportation tool developed using common programming language (e.g., Java, XML, C++, Visual Basic, etc.). Theinteroperability engine 40 may be a transaction server, an application server, a component server, or a business rule server. The basic abilities of theinteroperability engine 40 include scalability, adaptability, recoverability, and manageability. - The
interoperability engine 40 dynamically generates an interoperability baseline data schema based on the self-describing documents from thedata source 36 and/or thesupplemental data source 38. Specifically, theinteroperability 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. - 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 toexternal systems 30, program systems 32, andadministrative systems 34. The data elements in the baseline data schema are mapped in a format that theEAI tool 36 or any other type of integration tool well known in the art can recognize. For instance, theEAI tool 36 may accept a common format of XML documents that theEAI tool 36 can import and can be used to map to the variousexternal systems 30, program systems 32, andadministrative systems 34. In one embodiment, theinteroperability engine 40 includes the Web server. Alternatively, the Web server may stand separate from theinteroperability engine 40 and connected to theWeb portal 20. - The
interoperability engine 40 further dynamically generates anapplication database 45. In turn, theapplication database 45 dynamically generates a reporting database 50 (i.e., theapplication 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. Theapplication database 45 and thereporting database 50 are database structures connected to theWeb portal 20. Theapplication database 45 and thereporting database 50 contain identical data elements as a baseline data schema of aninteroperability engine 40, to be later described, in a structured design. Theapplication database 45 provides the user with read/write access to theexternal systems 30, program systems 32, andadministrative systems 34. The reportingdatabase 50 is a data mart or a data warehouse that allows the user to access information from theexternal systems 30, program systems 32, andadministrative systems 34, for example, in a read only format. - The
interoperability engine 40 analyzes the self-describing documents received from thedata source 36 and/or thesupplemental data source 38, interprets the self-describing documents, and generates the baseline data schema. Theinteroperability engine 40 builds theWeb portal 20 based on the baseline data schema. Theinteroperability engine 40 enables the user to access theexternal systems 30, program systems 32, andadministrative systems 34 via, for example, theWeb portal 20 or any other means using theapplication database 45 and thereporting database 50, and supports messaging and sharing of information among theexternal systems 30, program systems 32, andadministrative systems 34. Thus, theinteroperability engine 40 dynamically generates theapplication database 45, the reportingdatabase 50 structure, and theWeb portal 20 by applying, for instance, COTS database, OLAP, and Web portal tools well known in the art. - Once a user logs in, the
Web portal 20 allows the user to access data information and/or navigate through theexternal systems 30, program systems 32, andadministrative systems 34. Furthermore, in the event the user wishes to access a particularexternal system 30, program system 32, andadministrative system 34, theexternal system 30, program system 32, andadministrative system 34 is configured, for example, to perform a security clearance prior to allowing the user to access the information. As an alternative, thedata source 36 and/or thesupplemental 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. - In another embodiment, the
interoperability engine 40 is programmed, for example, to monitor security clearance. Thesystem 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 particularexternal system 30, program system 32, oradministrative system 34. Further, thesystem 10 can be implemented, for example, where in the event the user is allowed to access a particularexternal system 30, program system 32, oradministrative system 34 but requires to access information from anotherexternal system 30, program system 32, andadministrative system 34, theinteroperability engine 40 may prompt the user, via theWeb portal 20, that further security clearance is required to access the information. - 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 theWeb 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 theWeb 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). - Furthermore, the
interoperability engine 40 may include, for instance, mechanisms to dynamically survey the information in thedata source 36 and/or thesupplemental data source 38 to determine if any changes have occurred within thedata source 36 and/or thesupplemental data source 38. For instance, theinteroperability engine 40 would dynamically survey the tags in the self-describing documents of thedata source 36 and/or of thesupplemental data source 38 specifying the current date and version of thedata source 36 and/orsupplemental data source 38, and thereby trigger the dynamic system update, to be described in FIG. 3. In the alternative, theinteroperability engine 40 would dynamically survey the tags in each data element in the self-describing documents of thedata source 36 and/or of thesupplemental data source 38 to determine if the current date and/or version have changed and thereby trigger the dynamic system update. Thesystem 10 may also provide a mechanism to trigger a survey of thedata source 36 and/or thesupplemental data source 38 on demand. For example, thedata source 36 and/or thesupplemental 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 thedata source 36 and/or thesupplemental data source 38 has been posted. In another embodiment, theinteroperability engine 40 may trigger the survey to thedata source 36 and/or thesupplemental data source 38. - 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 thedata source 36 and/or thesupplemental data source 38. If the version has not changed, theinteroperability engine 40 dynamically updates theapplication database 45, the reportingdatabase 50, the baseline data schema, and theWeb portal 20 to reflect the current version number along with current date and time as the last version survey conducted. - FIG. 2 is a diagram of a dynamic start-up
process 100. Atoperation 110, memories are cleared, initial flag conditions are set, etc., as is well known in the art. Fromoperation 110,process 100 proceeds tooperation 120, whereprocess 100 dynamically surveys and analyzes data elements, data element contents, data element characteristics, and data interoperability rules included in thedata source 36 and/or thesupplemental data source 38 self-describing documents. Fromoperation 120,process 100 proceeds tooperation 130, whereprocess 100 dynamically generates theapplication database 45 structure. Fromoperation 130,process 100 proceeds tooperation 140, whereprocess 100 dynamically generates thereporting database 50 structure. As previously described, theapplication database 45 allows the user to read/write information from and to theexternal systems 30, program systems 32, andadministrative systems 34 via theWeb portal 20 to theexternal systems 30, program systems 32, andadministrative systems 34. The reportingdatabase 50 allows the user to read information only from theexternal systems 30, program systems 32, andadministrative systems 34 via theWeb portal 20. - From
operation 140,process 100 proceeds tooperation 150, whereprocess 100 dynamically generates the userinterface Web portal 20. Specifically,process 100 creates aWeb portal 20 corresponding to eachexternal systems 30, program systems 32, andadministrative systems 34 based on the information provided by either the proprietary host or public host in the self-describing documents of thedata source 36 and/or of thesupplemental data source 38. Fromoperation 150,process 100 proceeds tooperation 160, whereprocess 100 dynamically generates the baseline data schema.Process 100 analyzes the information in thedata source 36 and/or thesupplemental data source 38, interprets the information, and maps the information into the baseline data schema. - From
operation 160,process 100 proceeds tooperation 170, whereprocess 100 associates the baseline data schema with theEAI tool 36. The baseline data schema serves as a common denominator to leverage theEAI tool 36, to enable theexternal systems 30, program systems 32, andadministrative systems 34 to share information, and to allow a user to access information from theexternal systems 30, program systems 32, andadministrative systems 34. Fromoperation 170,process 100 proceeds tooperation 180, where the integration unit is applied to map theexternal systems 30, the program systems 32, and theadministrative systems 34 to the baseline data schema. Fromoperation 180,process 100 proceeds tooperation 185, where theEAI tool 36 is applied facilitating transmission and messaging between the baseline data schema and theexternal systems 30, the program systems 32, and theadministrative systems 34. Furthermore, in the embodiment described herein and illustrated in FIG. 2,process 100 performsoperations process 100 may performoperations process 100 may be triggered on demand. - 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 theapplication database 45. Entries into theapplication database 45 trigger theEAI tool 36 to allow data sharing from theapplication database 45 to the relevant administrative and programmatic systems. This interoperability enables users via theWeb portal 20 to interact with stovepipeexternal systems 30, program systems 32, andadministrative 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, onceprocess 100 migrates all the information contained in theexternal systems 30, the program systems 32, and theadministrative systems 34 to theapplication database 45,process 100 provides an implementing organization, the option to shut down thesystems - Once
process 100 is completed, theapplication database 45, the reportingdatabase 50, the user interface, and the baseline data schema are dynamically updated by regularly polling thedata source 36 and/or thesupplemental data source 38 via asystem update process 200. In one embodiment, theinteroperability engine 40 regularly triggersprocess 200 to survey for changes in thedata source 36 and/or thesupplemental data source 38. In an alternative embodiment, the intelligence to automatically survey thedata source 36 and/or thesupplemental data source 38 is built in the self-describing documents. In another alternative embodiment,process 200 is triggered to survey thedata source 36 and/or thesupplemental data source 38, on demand, through the proprietary host, the public host, the implementing organization host or theWeb portal 20. For illustrative purposes,process 200, hereinafter described, is triggered by theinteroperability engine 40. - 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 whereprocess 200 begins atoperation 210 where memories are cleared, initial flag conditions are set, etc., as is well known in the art. Fromoperation 210,process 200 proceeds tooperation 220, whereprocess 200 dynamically scans thedata source 36 and/or thesupplemental data source 38 self-describing documents for data-specific flags that identify new or changeddata source 36 and/or thesupplemental data source 38 components. A new or changed component may constitute a variety of distinct adjustments to the self-describing documents of thedata source 36 and/or of thesupplemental 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 thedata source 36 and/or thesupplemental data source 38 exists. - From
operation 220,process 200 proceeds tooperation 230, where a determination is made whether changes occurred in the self-describing documents of thedata source 36 and/or of thesupplemental data source 38. In the event that no changes are made to the self-describing documents of thedata source 36 and/or of thesupplemental data source 38,process 200 proceeds tooperation 240. Atoperation 240,process 200 updates the time the survey on the self-describing documents of thedata source 36 and/or of thesupplemental data source 38 is performed. However, if atoperation 230, changes are made to the self-describing documents of thedata source 36 and/or of thesupplemental data source 38,process 200 proceeds tooperation 250. Atoperation 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. - From
operation 250,process 200 proceeds tooperation 260, whereprocess 200 processes the changes to the data elements, data element contents, data element characteristics, and data interoperability rules and updates therefrom theapplication database 45. Similarly, atoperation 280,process 200 dynamically updates thereporting database 50 structure. Fromoperation 280,process 200 proceeds tooperation 290, whereprocess 200 dynamically updates theWeb portal 20. Specifically,process 200 updates (e.g., read, edit, delete) data elements viewed from the web-based portal. - From
operation 290,process 200 proceeds tooperation 300, whereprocess 200 surveys and analyzes the updated data source and/or supplemental data source self-describing documents of thedata source 36 and/or of thesupplemental data source 38 and dynamically updates the baseline data schema.Process 200 analyzes the updated information in thedata source 36 and/or thesupplemental data source 38, interprets the information and maps the information into a baseline data schema. - From
operation 300,process 200 proceeds tooperation 310, whereprocess 200 associates the baseline data schema with theEAI 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 theexternal systems 30, the program systems 32, and theadministrative systems 34. Fromoperation 310,process 200 proceeds tooperation 320, where the integration unit is applied to map the application system data to the updated baseline data schema. Fromoperation 320,process 200 proceeds tooperation 330, where the integration unit is applied facilitating messaging among theexternal systems 30, program systems 32,administrative systems 34, and theapplication database 45. - Thus,
process 200 dynamically updates the baseline data schema and theapplication database 45 to identify the identifying version information (e.g., version number, date) of the surveyed and analyzeddata source 36 and/or thesupplemental 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>). - Thus,
process 200 allows efficient and effective upgrade process for governmentexternal systems 30, program systems 32, andadministrative 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 performsoperations process 200 may performoperations process 200 may be triggered on demand. - Because the
interoperability engine 40 dynamically updates the changes to the self-describing documents of thedata source 36 and/orsupplemental data source 38, the baseline data schema, theWeb portal 20, theapplication database 45, and thereporting database 50, thesystem update process 200 is effective and efficient. However, in the alternative, theinteroperability engine 40 may also update the entire the self-describing documents of thedata source 36 and/orsupplemental data source 38, the baseline data schema, theWeb portal 20, theapplication database 45, and thereporting database 50. Further, thesystem update process 200 allows the users accessing theexternal systems 30, the program systems 32, and theadministrative systems 34 information via theWeb portal 20, to have accurate and most up-to-date information. - FIG. 4 is a diagram of
process 350 performed by theinteroperability engine 40. Atoperation 351,process 350 receives data elements, data element contents, data element characteristics, and data interoperability rules from thedata source 36 and/or thesupplemental data source 38. Fromoperation 351,process 350 proceeds tooperation 352, where a new table(s) are either created or updated in theapplication database 45 depending on whether the dynamic start-upprocess 100 is performed or if the dynamicsystem update process 200 is performed. Fromoperation 352,process 350 proceeds tooperation 354, where new database field(s) are created/updated in theapplication database 45 and, atoperation 356,process 350 allocates space for new data elements captured in theapplication database 45. Fromoperation 356,process 350 proceeds tooperation 358, where any data element content that resides in thedata source 36 and/orsupplemental data source 38 is fed into the space allocated in the new table(s)/field(s) in theapplication database 45. - 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, andadministrative 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-describingdata source 36 and/or thesupplemental data source 38, or by building their own privately held self-describingdata source 36 and/or thesupplemental 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 thesupplemental 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. - 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.
- 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.
Claims (12)
1. A method, comprising:
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 method as recited in claim 1 wherein the surveying of the data source is initiated on demand.
3. The method as recited in claim 1 , wherein the surveying of the data source is regularly initiated.
4. A method, comprising:
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 method as recited in claim 4 , wherein the surveying of the data source is initiated on demand.
6. The method as recited in claim 4 , wherein the surveying of the data source is regularly initiated.
7. 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.
8. The computer readable storage medium as recited in claim 7 , wherein the surveying of the data source is initiated on demand.
9. The computer readable storage medium as recited in claim 7 , wherein the surveying of the data source is regularly initiated.
10. 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.
11. The computer readable storage medium as recited in claim 10 , wherein the surveying of the data source is initiated on demand.
12. The computer readable storage medium as recited in claim 10 , wherein the surveying of the data source is regularly initiated.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/820,017 US20040193630A1 (en) | 2000-09-13 | 2004-04-08 | System and method for efficient integration of government administrative and program systems |
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US23093800P | 2000-09-13 | 2000-09-13 | |
US09/691,058 US6754672B1 (en) | 2000-09-13 | 2000-10-19 | System and method for efficient integration of government administrative and program systems |
US10/820,017 US20040193630A1 (en) | 2000-09-13 | 2004-04-08 | System and method for efficient integration of government administrative and program systems |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/691,058 Division US6754672B1 (en) | 2000-09-13 | 2000-10-19 | System and method for efficient integration of government administrative and program systems |
Publications (1)
Publication Number | Publication Date |
---|---|
US20040193630A1 true US20040193630A1 (en) | 2004-09-30 |
Family
ID=32474057
Family Applications (3)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/691,058 Expired - Lifetime US6754672B1 (en) | 2000-09-13 | 2000-10-19 | System and method for efficient integration of government administrative and program systems |
US10/820,018 Abandoned US20040193651A1 (en) | 2000-09-13 | 2004-04-08 | System and method for efficient integration of government administrative and program systems |
US10/820,017 Abandoned US20040193630A1 (en) | 2000-09-13 | 2004-04-08 | System and method for efficient integration of government administrative and program systems |
Family Applications Before (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/691,058 Expired - Lifetime US6754672B1 (en) | 2000-09-13 | 2000-10-19 | System and method for efficient integration of government administrative and program systems |
US10/820,018 Abandoned US20040193651A1 (en) | 2000-09-13 | 2004-04-08 | System and method for efficient integration of government administrative and program systems |
Country Status (1)
Country | Link |
---|---|
US (3) | US6754672B1 (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050114291A1 (en) * | 2003-11-25 | 2005-05-26 | International Business Machines Corporation | System, method, and service for federating and optionally migrating a local file system into a distributed file system while preserving local access to existing data |
US20050132334A1 (en) * | 2003-11-14 | 2005-06-16 | Busfield John D. | Computer-implemented systems and methods for requirements detection |
US20090183251A1 (en) * | 2004-12-15 | 2009-07-16 | Honeywell International Inc. | Integrated information management system and method |
US7885900B1 (en) | 2006-10-31 | 2011-02-08 | Polaris Solutions, LLC | Grant management system and method |
Families Citing this family (72)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6158010A (en) * | 1998-10-28 | 2000-12-05 | Crosslogix, Inc. | System and method for maintaining security in a distributed computer network |
US7673323B1 (en) * | 1998-10-28 | 2010-03-02 | Bea Systems, Inc. | System and method for maintaining security in a distributed computer network |
US7356482B2 (en) | 1998-12-18 | 2008-04-08 | Alternative Systems, Inc. | Integrated change management unit |
US7051069B2 (en) * | 2000-09-28 | 2006-05-23 | Bea Systems, Inc. | System for managing logical process flow in an online environment |
US7389341B2 (en) * | 2001-01-31 | 2008-06-17 | Accenture Llp | Remotely monitoring a data processing system via a communications network |
US20030041050A1 (en) * | 2001-04-16 | 2003-02-27 | Greg Smith | System and method for web-based marketing and campaign management |
US7499948B2 (en) * | 2001-04-16 | 2009-03-03 | Bea Systems, Inc. | System and method for web-based personalization and ecommerce management |
US7392546B2 (en) * | 2001-06-11 | 2008-06-24 | Bea Systems, Inc. | System and method for server security and entitlement processing |
US7251693B2 (en) * | 2001-10-12 | 2007-07-31 | Direct Computer Resources, Inc. | System and method for data quality management and control of heterogeneous data sources |
WO2003036609A1 (en) * | 2001-10-24 | 2003-05-01 | Bea Systems, Inc. | Portal administration tool |
US7350226B2 (en) * | 2001-12-13 | 2008-03-25 | Bea Systems, Inc. | System and method for analyzing security policies in a distributed computer network |
US8037091B2 (en) | 2001-12-20 | 2011-10-11 | Unoweb Inc. | Method of using a code to track user access to content |
US20030120560A1 (en) * | 2001-12-20 | 2003-06-26 | John Almeida | Method for creating and maintaning worldwide e-commerce |
US7496687B2 (en) * | 2002-05-01 | 2009-02-24 | Bea Systems, Inc. | Enterprise application platform |
US7725560B2 (en) * | 2002-05-01 | 2010-05-25 | Bea Systems Inc. | Web service-enabled portlet wizard |
US20040010598A1 (en) * | 2002-05-01 | 2004-01-15 | Bea Systems, Inc. | Portal setup wizard |
US6993534B2 (en) * | 2002-05-08 | 2006-01-31 | International Business Machines Corporation | Data store for knowledge-based data mining system |
CN100422932C (en) * | 2002-12-31 | 2008-10-01 | 上海科泰世纪科技有限公司 | Processing method for self discribing data object |
US7089232B2 (en) * | 2003-01-30 | 2006-08-08 | International Business Machines Corporation | Method of synchronizing distributed but interconnected data repositories |
US6917975B2 (en) * | 2003-02-14 | 2005-07-12 | Bea Systems, Inc. | Method for role and resource policy management |
US7591000B2 (en) | 2003-02-14 | 2009-09-15 | Oracle International Corporation | System and method for hierarchical role-based entitlements |
US7653930B2 (en) * | 2003-02-14 | 2010-01-26 | Bea Systems, Inc. | Method for role and resource policy management optimization |
US8831966B2 (en) * | 2003-02-14 | 2014-09-09 | Oracle International Corporation | Method for delegated administration |
US7840614B2 (en) * | 2003-02-20 | 2010-11-23 | Bea Systems, Inc. | Virtual content repository application program interface |
US7293286B2 (en) | 2003-02-20 | 2007-11-06 | Bea Systems, Inc. | Federated management of content repositories |
US7562298B2 (en) * | 2003-02-20 | 2009-07-14 | Bea Systems, Inc. | Virtual content repository browser |
US20040230679A1 (en) * | 2003-02-28 | 2004-11-18 | Bales Christopher E. | Systems and methods for portal and web server administration |
US7810036B2 (en) * | 2003-02-28 | 2010-10-05 | Bea Systems, Inc. | Systems and methods for personalizing a portal |
US20040230917A1 (en) * | 2003-02-28 | 2004-11-18 | Bales Christopher E. | Systems and methods for navigating a graphical hierarchy |
US20040230557A1 (en) * | 2003-02-28 | 2004-11-18 | Bales Christopher E. | Systems and methods for context-sensitive editing |
US7685010B2 (en) | 2003-04-04 | 2010-03-23 | Netsuite, Inc. | Concise communication of real-time business information in an enterprise network |
US7685515B2 (en) * | 2003-04-04 | 2010-03-23 | Netsuite, Inc. | Facilitating data manipulation in a browser-based user interface of an enterprise business application |
US20050257245A1 (en) * | 2003-10-10 | 2005-11-17 | Bea Systems, Inc. | Distributed security system with dynamic roles |
US20050251852A1 (en) * | 2003-10-10 | 2005-11-10 | Bea Systems, Inc. | Distributed enterprise security system |
US7644432B2 (en) * | 2003-10-10 | 2010-01-05 | Bea Systems, Inc. | Policy inheritance through nested groups |
US20050097352A1 (en) * | 2003-10-10 | 2005-05-05 | Bea Systems, Inc. | Embeddable security service module |
US7594224B2 (en) * | 2003-10-10 | 2009-09-22 | Bea Systems, Inc. | Distributed enterprise security system |
US20050251851A1 (en) * | 2003-10-10 | 2005-11-10 | Bea Systems, Inc. | Configuration of a distributed security system |
US20050144082A1 (en) * | 2003-12-30 | 2005-06-30 | Coolman Jeron W. | Systems and methods for ordering from multiple vendors |
US20050144129A1 (en) * | 2003-12-30 | 2005-06-30 | Coolman Jeron W. | Systems and methods for paying vendors using CCR data |
US20050188295A1 (en) * | 2004-02-25 | 2005-08-25 | Loren Konkus | Systems and methods for an extensible administration tool |
US7774601B2 (en) * | 2004-04-06 | 2010-08-10 | Bea Systems, Inc. | Method for delegated administration |
US20050251512A1 (en) * | 2004-04-13 | 2005-11-10 | Bea Systems, Inc. | System and method for searching a virtual content repository |
US20060028252A1 (en) * | 2004-04-13 | 2006-02-09 | Bea Systems, Inc. | System and method for content type management |
US7475091B2 (en) * | 2004-04-13 | 2009-01-06 | Bea Systems, Inc. | System and method for viewing a virtual content repository |
US7236990B2 (en) * | 2004-04-13 | 2007-06-26 | Bea Systems, Inc. | System and method for information lifecycle workflow integration |
US7236989B2 (en) * | 2004-04-13 | 2007-06-26 | Bea Systems, Inc. | System and method for providing lifecycles for custom content in a virtual content repository |
US7246138B2 (en) * | 2004-04-13 | 2007-07-17 | Bea Systems, Inc. | System and method for content lifecycles in a virtual content repository that integrates a plurality of content repositories |
US7162504B2 (en) * | 2004-04-13 | 2007-01-09 | Bea Systems, Inc. | System and method for providing content services to a repository |
US7240076B2 (en) | 2004-04-13 | 2007-07-03 | Bea Systems, Inc. | System and method for providing a lifecycle for information in a virtual content repository |
US20050240714A1 (en) * | 2004-04-13 | 2005-10-27 | Bea Systems, Inc. | System and method for virtual content repository deployment |
US20050251503A1 (en) * | 2004-04-13 | 2005-11-10 | Bea Systems, Inc. | System and method for content and schema versioning |
US7236975B2 (en) * | 2004-04-13 | 2007-06-26 | Bea Systems, Inc. | System and method for controlling access to anode in a virtual content repository that integrates a plurality of content repositories |
US20050228784A1 (en) * | 2004-04-13 | 2005-10-13 | Bea Systems, Inc. | System and method for batch operations in a virtual content repository |
US20050228816A1 (en) * | 2004-04-13 | 2005-10-13 | Bea Systems, Inc. | System and method for content type versions |
US7761865B2 (en) * | 2004-05-11 | 2010-07-20 | Sap Ag | Upgrading pattern configurations |
US20050289531A1 (en) * | 2004-06-08 | 2005-12-29 | Daniel Illowsky | Device interoperability tool set and method for processing interoperability application specifications into interoperable application packages |
JP4527605B2 (en) * | 2004-06-21 | 2010-08-18 | 三星エスディアイ株式会社 | Electrolytic solution for lithium ion secondary battery and lithium ion secondary battery including the same |
US9009313B2 (en) | 2004-07-12 | 2015-04-14 | NetSuite Inc. | Simultaneous maintenance of multiple versions of a web-based business information system |
US7558843B2 (en) | 2004-07-12 | 2009-07-07 | Netsuite, Inc. | Phased rollout of version upgrades in web-based business information systems |
US8122034B2 (en) * | 2005-06-30 | 2012-02-21 | Veveo, Inc. | Method and system for incremental search with reduced text entry where the relevance of results is a dynamically computed function of user input search string character count |
US20070239717A1 (en) * | 2005-09-01 | 2007-10-11 | International Business Machines Corporation | System and method for architecting pattern based models within a governmental framework |
US7917537B2 (en) | 2005-09-26 | 2011-03-29 | Oracle International Corporation | System and method for providing link property types for content management |
US7818344B2 (en) | 2005-09-26 | 2010-10-19 | Bea Systems, Inc. | System and method for providing nested types for content management |
US7752205B2 (en) | 2005-09-26 | 2010-07-06 | Bea Systems, Inc. | Method and system for interacting with a virtual content repository |
US7953734B2 (en) | 2005-09-26 | 2011-05-31 | Oracle International Corporation | System and method for providing SPI extensions for content management system |
US7921432B2 (en) * | 2006-03-17 | 2011-04-05 | Microsoft Corporation | Managed application execution application programming interface and schema |
US7908611B2 (en) * | 2006-03-17 | 2011-03-15 | Microsoft Corporation | Unmanaged programming language interoperability with managed internet protocol context |
US8463852B2 (en) | 2006-10-06 | 2013-06-11 | Oracle International Corporation | Groupware portlets for integrating a portal with groupware systems |
US8265969B2 (en) * | 2006-11-17 | 2012-09-11 | Microsoft Corporation | Policy-based management of data elements in a document schema for data transactions |
US20140181303A1 (en) * | 2012-12-21 | 2014-06-26 | Scott Andrew Meyer | Custom local content provision |
US20160048383A1 (en) * | 2014-08-13 | 2016-02-18 | Microsoft Technology Licensing, Llc | Isv update delivery |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5970490A (en) * | 1996-11-05 | 1999-10-19 | Xerox Corporation | Integration platform for heterogeneous databases |
US6338151B1 (en) * | 1998-08-21 | 2002-01-08 | International Business Machines Corporation | Input/output recovery which is based an error rate and a current state of the computer environment |
US6418448B1 (en) * | 1999-12-06 | 2002-07-09 | Shyam Sundar Sarkar | 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 |
Family Cites Families (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5732270A (en) * | 1994-09-15 | 1998-03-24 | Visual Edge Software Limited | System and method for providing interoperability among heterogeneous object systems |
CA2173695A1 (en) * | 1995-04-14 | 1996-10-15 | Panagiotis Kougiouris | Method and system for providing interoperability among processes written to execute on different operating systems |
US5832483A (en) * | 1995-12-15 | 1998-11-03 | Novell, Inc. | Distributed control interface for managing the interoperability and concurrency of agents and resources in a real-time environment |
CN1115822C (en) * | 1996-10-16 | 2003-07-23 | 汤姆森消费电子有限公司 | Device interoperability |
US6085198A (en) * | 1998-06-05 | 2000-07-04 | Sun Microsystems, Inc. | Integrated three-tier application framework with automated class and table generation |
EA003744B1 (en) | 1998-11-18 | 2003-08-28 | Сага Софтвеар, Инк. | Extensible distributed enterprise application integration system |
US6393456B1 (en) * | 1998-11-30 | 2002-05-21 | Microsoft Corporation | System, method, and computer program product for workflow processing using internet interoperable electronic messaging with mime multiple content type |
US6484177B1 (en) * | 2000-01-13 | 2002-11-19 | International Business Machines Corporation | Data management interoperability methods for heterogeneous directory structures |
US7761319B2 (en) * | 2001-06-08 | 2010-07-20 | Click Acqusitions, Inc. | Supply chain management |
-
2000
- 2000-10-19 US US09/691,058 patent/US6754672B1/en not_active Expired - Lifetime
-
2004
- 2004-04-08 US US10/820,018 patent/US20040193651A1/en not_active Abandoned
- 2004-04-08 US US10/820,017 patent/US20040193630A1/en not_active Abandoned
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5970490A (en) * | 1996-11-05 | 1999-10-19 | Xerox Corporation | Integration platform for heterogeneous databases |
US6338151B1 (en) * | 1998-08-21 | 2002-01-08 | International Business Machines Corporation | Input/output recovery which is based an error rate and a current state of the computer environment |
US6418448B1 (en) * | 1999-12-06 | 2002-07-09 | Shyam Sundar Sarkar | 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 |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050132334A1 (en) * | 2003-11-14 | 2005-06-16 | Busfield John D. | Computer-implemented systems and methods for requirements detection |
US20050114291A1 (en) * | 2003-11-25 | 2005-05-26 | International Business Machines Corporation | System, method, and service for federating and optionally migrating a local file system into a distributed file system while preserving local access to existing data |
US7243089B2 (en) * | 2003-11-25 | 2007-07-10 | International Business Machines Corporation | System, method, and service for federating and optionally migrating a local file system into a distributed file system while preserving local access to existing data |
US20090183251A1 (en) * | 2004-12-15 | 2009-07-16 | Honeywell International Inc. | Integrated information management system and method |
US7885900B1 (en) | 2006-10-31 | 2011-02-08 | Polaris Solutions, LLC | Grant management system and method |
US8589308B1 (en) | 2006-10-31 | 2013-11-19 | Polaris Solutions, LLC | Grant management system and method |
Also Published As
Publication number | Publication date |
---|---|
US6754672B1 (en) | 2004-06-22 |
US20040193651A1 (en) | 2004-09-30 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US6754672B1 (en) | System and method for efficient integration of government administrative and program systems | |
US7343348B2 (en) | System for performing real-estate transactions over a computer network using participant templates | |
US9256655B2 (en) | Dynamic access of data | |
US7761591B2 (en) | Central work-product management system for coordinated collaboration with remote users | |
US7634478B2 (en) | Metadata driven intelligent data navigation | |
US7814142B2 (en) | User interface service for a services oriented architecture in a data integration platform | |
US8060553B2 (en) | Service oriented architecture for a transformation function in a data integration platform | |
US7814470B2 (en) | Multiple service bindings for a real time data integration service | |
US7386578B2 (en) | Associations between duplicate master data objects | |
US8041760B2 (en) | Service oriented architecture for a loading function in a data integration platform | |
US20040010496A1 (en) | Apparatus and method for integrating variable subsidiary information with main office information in an enterprise system | |
US20070100857A1 (en) | Computer-implemented method, tool, and program product for storing a business document in an enterprise software application environment | |
US20050222931A1 (en) | Real time data integration services for financial information data integration | |
US20050262193A1 (en) | Logging service for a services oriented architecture in a data integration platform | |
US20030088534A1 (en) | Method and apparatus for work management for facility maintenance | |
US20050228808A1 (en) | Real time data integration services for health care information data integration | |
US20060010195A1 (en) | Service oriented architecture for a message broker in a data integration platform | |
US20050240354A1 (en) | Service oriented architecture for an extract function in a data integration platform | |
US20050262189A1 (en) | Server-side application programming interface for a real time data integration service | |
US20050262190A1 (en) | Client side interface for real time data integration jobs | |
US20050232046A1 (en) | Location-based real time data integration services | |
US20100319002A1 (en) | Systems and methods for metadata driven dynamic web services | |
US7536361B2 (en) | Web-based solution for managing information traditionally managed within private electronic environments | |
US20030023471A1 (en) | Method and tool for achieving data consistency in an enterprise resource planning system | |
EP1638019A2 (en) | Advanced object mapping by mapping key sub-object |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |