System and method for efficient integration of government administrative and program systems

• US 6,754,672 B1
• Filed: 10/19/2000
• Issued: 06/22/2004
• Est. Priority Date: 09/13/2000
• Status: Expired due to Term

• Current Assignee: CGI Technologies and Solutions Incorporated (CGI Group)
• Original Assignee: American Management Systems, Incorporated (CGI, Inc.)
• Inventors: McLauchlin, Andrew William
• Primary Examiner(s): Shah, Sanjiv
• Application Number:
  US09/691,058
• Time in Patent Office: 1,342 Days
• Field of Search: 707/104, 707/10, 707/100, 707/102, 707/101, 707/103, 707/8, 709/316, 709/328, 709/200
• US Class Current: 1/1
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

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.

Claims

1. A system, comprising:

an interoperability engine dynamically generating a web based user interface, providing access to application systems, and a baseline data schema and enabling interoperability among the application systems, wherein the baseline data schema is a common denominator data structure among the application systems, and the application systems comprise at least one of an external system, a program system, and an administrative system.

2. The system as recited in claim 1, wherein the interoperability engine further dynamically generates an application database.

3. The system as recited in claim 2, wherein the application database dynamically generates a reporting database.

4. The system as recited in claim 1, wherein the interoperability engine generates the baseline data schema from at least one of a data source and a supplemental data source.

5. The system as recited in claim 1, further comprising an integration unit mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

6. A system, comprising:

an interoperability engine dynamically generating a web based user interface providing access to application systems, an application database, and a baseline data schema from at least one of a data source and a supplemental data source and enabling interoperability among the application systems, wherein the supplemental data source adds, deletes, modifies, and/or updates data element components to the system beyond the data elements components defined by the data source, and the application systems comprise at least one of an external system, a program system, and an administrative system.

7. The systems as recited in claim 6, wherein the interoperability engine further dynamically updates the user interface, the application database, and the baseline data schema.

8. The system as recited in claim 6, wherein the at least one of the data source and the supplemental database comprise self-describing documents comprising data elements, data element contents, data element characteristics, and data interoperability rules.

9. The system as recited in claim 8, wherein the self-describing documents are hosted at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.

10. The system as recited in claim 8, wherein the interoperability engine receives the self-describing documents to dynamically generate the baseline data schema.

11. The system as recited in claim 8, wherein the interoperability engine receives at least one data element component from the self-describing documents of the supplemental data source overriding defining characteristics of the at least one data element component in the data source.

12. The system as recited in claim 6, wherein the application database dynamically generates a reporting database.

13. The system as recited in claim 6, further comprising an integration unit mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

14. A system, comprising:

an interoperability engine dynamically generating

an application database,

a web based user interface providing access to application systems via the application database,

a baseline data schema from at least one of a data source and a supplemental data source comprising self-describing documents, wherein

the supplemental data source adds, deletes, modifies, and/or updates data element components to the system beyond the data elements components defined by the data source,

the self-describing documents comprise data elements, data element contents, data element characteristics, and data interoperability rules,

the interoperability engine enables interoperability among the application systems, and

the application systems comprise at least one of an external system, a Program system, and an administrative system.

15. The systems as recited in claim 14, wherein the interoperability engine further dynamically updates the user interface, the application database, and the baseline data schema.

16. The system as recited in claim 14, wherein the self-describing documents are hosted at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.

17. The system as recited in claim 14, wherein the application database dynamically generates a reporting database.

18. A system, comprising:

an interoperability engine dynamically generating

an application database,

a web based user interface in a computer communications network providing access to application systems via the application database,

a baseline data schema from at least one of a data source and a supplemental data source comprising self-describing documents, wherein

the supplemental data source adds, deletes, modifies, and/or updates data element components to the system beyond the data elements components defined by the data source,

the self-describing documents comprise data elements, data element contents, data element characteristics, and data interoperability rules,

the interoperability engine enables interoperability among the application systems, and

the application systems comprise at least one of an external system, a program system, and an administrative system; and

an integration unit mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

19. The systems as recited in claim 18, wherein the interoperability engine further dynamically updates the user interface, the application database, and the baseline data schema.

20. The system as recited in claim 18, wherein the self-describing documents are hosted at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.

21. The system as recited in claim 18, wherein the application database allows read/write operations.

22. The system as recited in claim 18, wherein the reporting database allows read only operations.

23. A method, comprising:

dynamically generating a web based user interface, providing access to application systems, and a baseline data schema; and

enabling interoperability among the application systems, wherein the baseline data schema is a common denominator data structure among the application systems, and the application systems comprise at least one of an external system, a program system, and an administrative system.

24. The method as recited in claim 23, further comprising dynamically generating an application database.

25. The method as recited in claim 23, further comprising dynamically generating a reporting database.

26. The method as recited in claim 23, further comprising mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

27. A method, comprising:

dynamically generating a web based user interface, 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 user interface using the application database, wherein the baseline data schema is a common denominator data structure among the application systems, and the application systems comprise at least one of an external system, a program system, and an administrative system.

28. The method as recited in claim 27, further dynamically updating the user interface, the application database, and the baseline data schema.

29. The method as recited in claim 27, further comprising generating and storing self-describing documents comprising data elements, data element contents, data element characteristics, and data interoperability rules.

30. The method as recited in claim 29, further comprising hosting the self-describing documents at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.

31. The method as recited in claim 27, further comprising mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

32. A method, comprising:

dynamically generating an application database, a reporting database, a web based user interface, and a baseline data schema from self-describing documents in a data source comprising data elements, data element contents, data element characteristics, and data interoperability rules;

enabling interoperability among the application systems; and

providing access to the application systems via the user interface using the application database and the reporting database, wherein the application systems comprise at least one of an external system, a program system, and an administrative system and the application database provides a user with read/write access to the application systems.

33. The method as recited in claim 32, further comprising hosting the self-describing documents at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.

34. The method as recited in claim 32, further comprising mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

35. The method as recited in claim 32, further comprising:

generating the baseline data schema from at least one of a data source and a supplemental data source; and

receiving at least one data element component from the self-describing documents of the supplemental data source overriding defining characteristics of the at least one data element component in the data source.

36. A method, comprising:

dynamically generating an application database, a reporting database, a web based user interface in a computer communications network, and a baseline data schema from self-describing documents in a data source comprising data elements, data element contents, data element characteristics, and data interoperability rules;

enabling interoperability among the application systems, wherein the baseline data schema is a common denominator data structure among the application systems, and the application systems comprise at least one of an external system, a program system, and an administrative system;

mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems; and

providing access to the application systems via the user interface using the application database and the reporting database, wherein the application database provides a user with read/write access to the application systems.

37. The method as recited in claim 36, further comprising hosting the self-describing documents at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.

38. A method, comprising:

dynamically generating and updating an application database, a reporting database, a web-based portal in a computer communications network, and a baseline data schema from self-describing documents in a data source comprising data elements, data element contents, data element characteristics, and data interoperability rules necessary to facilitate communication and messaging among application systems;

enabling interoperability among application systems using the baseline data schema;

providing access to the application systems providing via the user interface using the application database and the reporting database, wherein the application database provides a user with read/write access to the application systems;

hosting the self-describing hosting the self-describing documents at one or more of a proprietary owner host site, a public host site, and an implementing organization host site; and

mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems, wherein the application systems comprise at least one of federal administrative, programmatic, and external systems.

39. A computer readable storage medium controlling a computer and comprising a process of dynamically generating a web based user interface, providing access to application systems, and a baseline data schema;

and enabling interoperability among the application systems, wherein the baseline data schema is a common denominator data structure among the application systems, and the application systems comprise at least one of an external system, a program system, and an administrative system.

40. The computer readable storage medium as recited in claim 39, further comprising dynamically generating an application database.

41. The computer readable storage medium as recited in claim 39, further comprising dynamically generating a reporting database.

42. The computer readable storage medium as recited in claim 39, further comprising mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

43. A computer readable storage medium controlling a computer and comprising a process of dynamically generating a web based user interface, 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 user interface using the application database, wherein the baseline data schema is a common denominator data structure among the application systems, and the application systems comprise at least one of an external system, a program system, and an administrative system.

44. The computer readable storage medium as recited in claim 43, further comprising dynamically updating the user interface, the application database, and the baseline data schema.

45. The computer readable storage medium as recited in claim 43, further comprising generating and storing self-describing documents comprising data elements, data element contents, data element characteristics, and data interoperability rules.

46. The computer readable storage medium as recited in claim 45, further comprising hosting the self-describing documents at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.

47. The computer readable storage medium as recited in claim 43, further comprising mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

48. A computer readable storage medium controlling a computer and comprising a process of dynamically generating an application database, a reporting database, a web based user interface, and a baseline data schema from self-describing documents in a data source comprising data elements, data element contents, data element characteristics, and data interoperability rules;

enabling interoperability among the application systems; and

providing access to the application systems via the user interface using the application database and the reporting database, wherein the application systems comprise at least one of an external system, a program system, and an administrative system and the application database provides a user with read/write access to the application systems.

49. The computer readable storage medium as recited in claim 48, further comprising hosting the self-describing documents at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.

50. The computer readable storage medium as recited in claim 48, further comprising mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems.

51. A computer readable storage medium controlling a computer and comprising a process of dynamically generating an application database, a reporting database, a web based user interface in a computer communications network, and a baseline data schema from self-describing documents in a data source comprising data elements, data element contents, data element characteristics, and data interoperability rules;

enabling interoperability among the application systems, wherein the baseline data schema is a common denominator data structure among the application systems, and the application systems comprise at least one of an external system, a program system, and an administrative system;

mapping the application systems to the baseline data schema and facilitating transmission and messaging between the baseline data schema and the application systems; and

providing access to the application systems via the user interface using the application database and the reporting database, wherein the application database provides a user with read/write access to the application systems.

52. The computer readable storage medium as recited in claim 51, further comprising hosting the self-describing documents at one or more of a proprietary owner host site, a public host site, and an implementing organization host site comprising predetermined security restrictions.