Systems, methods and apparatus for assessing compliance and federating databases

摘要

Systems, methods, and apparatus as discussed herein, provide for enabling a user to select containers and parent level requirements to be retrieved. A navigation panel is provided that enables a user to navigate through the selected containers. A sieve module filters non applicable requirements in the containers based on the selected parent level requirements. The system further joins and integrates compliance information stored within in the Compliance Database, and the associated requirements stored in the containers. The system further stores, manages and reports compliance information associated with specific requirements located in the identified container. Additionally, a federation module may enable user to link requirements located in different containers, and may copy requirements from one container and paste into another container.

主权项

1. A method for accessing data stored in at least one of a plurality of remote databases, the method comprising:
enabling access to the plurality of databases, at least two of the plurality of remote databases having different data structures; receiving input identifying at least one of the plurality of remote databases for accessing; obtaining meta data locally stored and associated with the identified at least one remote database; generating a navigation control and displaying the navigation control on a display; receiving input from a user identifying an object type; creating and executing a first query at the identified at least one remote database to obtain all parent level objects associated with the at least one object type; receiving input identifying at least one selected parent level object within the identified at least one remote database from the obtained parent level objects and storing the input onto a local database configured to store compliance information, wherein said compliance information includes meta data associated with the selected remote databases and information associated with parent and sub-parent level objects stored in the plurality of remote databases; creating and executing a second query at the local database to obtain meta data from the local database, the meta data relating to the at least one remote database and the meta data being associated with the selected at least one parent level object; creating and executing a third query at the at least one remote database to retrieve only sub-parent level objects associated with the selected at least one parent level object, wherein the third query includes a first filter, based on the meta data and the selected at least one parent level object, for filtering out sub-parent level objects that are only associated with non-selected parent level objects, and a second filter to be executed against the at least one remote database based on the selected at least one parent level object and based on meta data associated with the at least one remote database, the second filter provides selection of only those sub-parent level objects associated with the selected parent level object; and providing, based on said compliance information, linking of a first requirement in at least one remote database to a second requirement in another remote database and storing information relating to the link of the two requirements in the local database.