Enterprise framework and applications supporting meta-data and data traceability requirements

• US 20030187821A1
• Filed: 03/29/2002
• Published: 10/02/2003
• Est. Priority Date: 03/29/2002
• Status: Active Grant

• Current Assignee: Agilent Technologies, Inc.
• Original Assignee: Agilent Technologies, Inc.
• Inventors: VanSant, Mary Jane, Cotton, Todd, Konitzer, Robert, Gardner, Karen M.
• Granted Patent: US 7,016,919 B2
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• 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

An application adapted to run within an enterprise wide, web-based framework which provides reusable services and facilities such as security, meta-data management and traceability of data and a framework supporting the same. The framework supports decision making across the value chain, with an emphasis on the meta-data needed for decision making. The framework can support the activities of a virtual organization (internal or external) and the inevitable variations in data types, file formats etc. without requiring massive integration between the various sources of data involved.

Claims

1. A method of managing data within an enterprise-wide, web-based framework, said method comprising the steps of:

marking up data to be managed within the framework with predefined types of meta-data;

submitting the marked up data to the framework;

assigning a unique identifier to be associated with the data and a location in which the data is to be stored;

storing the unique identifier and location for subsequent access to the data;

assigning a unique primary key to each item of meta-data associated with the data;

storing each item of meta-data with its unique primary key, type of meta-data and the unique identifier connecting the item of meta-data with the data.

2. The method of claim 1, further comprising the step of:

providing a hierarchy of dossiers into which artifacts, defined by the meta-data stored, are classified.

3. The method of claim 2, further comprising the steps of:

defining at least one specified role, team or users; and

defining which of the dossiers each user, role or team will be entitled to access.

4. The method of claim 3, further comprising the step of

defining a level of entitlement that each user, role and team has with regard to each dossier, wherein a level of entitlement may be selected from a read only level;

a read and edit level;

a read, edit and submit new data level;

a read, edit and export data level; and

a read, edit, submit new data and export level.

5. The method of claim 1, further comprising the step of:

assigning a unique entitlement token to a user upon sign in for access to the framework, wherein the unique entitlement token is good only for the session, and deleting the unique entitlement token upon sign off.

6. The method of claim 4, further comprising the step of:

allowing a user, role or team access to only those dossiers which the user, role or team has been defined to be entitled to, and only at the entitlement level defined.

7. The method of claim 1, further comprising rejecting the submitted data prior to said assigning and storing steps if all items of meta-data required by a schema defining the submission have not been entered with the data.

8. The method of claim 1, further comprising rejecting the submitted data prior to said assigning and storing steps if the user submitting the data is not entitled to submit data.

9. The method of claim 1, further comprising the step of:

preventing any overwriting, alteration, editing or deletion of the data and meta-data once the unique identifier has been stored.

10. The method of claim 1, further comprising

allowing annotations to be written with regard to the submitted data by a user with entitlement, and storing the annotations with the meta-data.

11. The method of claim 6, further comprising the step of:

searching on the stored meta-data associated with artifacts selected by a user from a dossier among those dossiers which the user is entitled to, thereby defining a subset of the data collected in the dossier.

12. The method of claim 11, further comprising the step of:

selecting a predefined template from a collection of templates; and

assembling select portions of t he subset of data into the selected template.

13. The method of claim 12, further comprising the step of storing the template containing select portions of data as a new artifact, and linking the new artifact to unique identifiers of the s elect portions of data.

14. The method of claim 12, wherein the selected template is 27 C.F.R. 11 compliant.

15. The method of claim 12 wherein the selected template is formatted to comply with requirements for the submission of an Investigational New Drug submission to the FDA.

16. The method of claim 12, further comprising the step of exporting the template containing select portions of data to the user'"'"'s local drive.

17. The method of claim 6, wherein users, roles or teams which are entitled to write to a dossier containing the stored meta-data linked to the submitted data can submit new versions of the data, write annotations to the data, or mark the data for deletion;

wherein each of these functions generates an event, and wherein each of these functions is stored with the meta-data associated with the data and is linked to the unique identifier of the data.

18. The method of claim 17, wherein the submission of marked up data also generates an event, and wherein other predefined manipulations of the data generate events, each event being stored with an associated time stamp.

19. The method of claim 18, further comprising the step of generating a traceability report based on the events, thereby creating a history of all events that have occurred with regard to the data.

20. An application adapted to run within an enterprise wide, web-based framework, said application comprising:

a schema requiring predefined types of meta-data to be marked up with new data to be submitted to the framework;

means for assigning a unique identifier to each new data submitted;

means for assigning an address outside of the framework where the new data will be stored;

means for storing the unique identifier associated with the address; and

means for assigning primary keys to each item of meta-data associated with the new data and storing each item of meta data associated with its primary key, type of meta-data and a foreign key which points to the unique identifier.

21. The application of claim 20, further comprising:

means for generating an event each time new data is submitted and each time annotations, alterations, or new versions of the data are entered into the application;

means for linking the events to the unique identifier of the associated data; and

means for storing the events and linking unique identifiers.

22. The application of claim 21, further comprising:

means for generating a traceability report of the entire history of an artifact of data, based on searching the events generated and stored with regard to that data.

23. The application of claim 20, further comprising:

means for creating a hierarchical classification of dossiers;

means for assigning data to a selected dossier;

means for defining user entitlement to each dossier created, wherein a system administrator establishes users, roles and teams and defines which of the dossiers each specific user, role or team is entitled to access; and

means for preventing access to data in a dossier which a user, role or team is not entitled to access.

24. The application of claim 23, further comprising:

means for creating a personal dossier at the user level, which a user can create and manage and which can be shared by other users having entitlement thereto.

25. The application of claim 23, further comprising:

means for identifying and searching on information that a user wishes to associate with data selected from a dossier that the user is entitled to.

26. The application of claim 25, wherein said means for identifying and searching comprises means for performing a similarity search on meta-data associated with the data to find values within a predefined range of a search value.

27. The application of claim 25, wherein said means for identifying and searching comprises means for formulating a Boolean search based on a preselected dossier or group of dossiers and one or more types of stored meta-data, annotations associated with stored meta-data or stored meta-data and said annotations.

28. The application of claim 20, further comprising:

means for assigning a unique UserID and password to each user authorized to use the application.

29. The application of claim 28, further comprising:

means for assigning an entitlement token to a user, based on matching the user'"'"'s unique UserID and password with the same UserID and password stored in the application, wherein said entitlement token is good only for a current session of use, is deleted when the user logs off, and a new entitlement token is generated when the user signs on again.

30. The application of claim 20, further comprising front means, said front means providing a single point of access to the application for all users.

31. The application of claim 23, further comprising means for assembling selected data into a template.

32. The application of claim 31, further comprising means for exporting the data assembled into a template from the application.