Method and system for managing data objects

• US 20040015514A1
• Filed: 02/18/2003
• Published: 01/22/2004
• Est. Priority Date: 04/03/2002
• Status: Abandoned Application

• Current Assignee: Kent State University
• Original Assignee: Kent State University
• Inventors: Strah, Monica, Feng, Louis, Bartolo, Laura, Lowe, Cathy, Melton, Austin, Woolverton, Christopher J.
• Application Number:
  US10/368,301
• Publication Number:
  US 20040015514A1
• Time in Patent Office: Days
• US Class Current: 707/103R
• CPC Class Codes: G06F 16/2228 Indexing structures

Abstract

A system and method for managing a plurality of data objects with a database complying with the Dublin Core metadata schema. The database includes a plurality of tables including at least one metadata table containing metadata records conforming to the Dublin Core metadata schema and relating to data objects stored in one of the tables. In another embodiment, an electronic scientific laboratory notebook for managing a plurality of scientific laboratory notebook data objects including a computing device communicating with a system for managing the plurality of scientific laboratory notebook data objects. Data objects may be entered, searched and viewed through the electronic notebook. In another embodiment, a computer-readable medium containing a data structure for managing a plurality of data objects with a plurality of tables complying with the Dublin Core metadata schema. The data structure may include a modified relational database incorporating hierarchical structure between tables.

Claims

1. A system for managing a plurality of data objects, comprising:

a database having a plurality of tables, wherein each of the data objects is stored in at least one of the tables, and at least one of the tables is a metadata table, the metadata table including a plurality of metadata records, each of the plurality of metadata records conforming to a dublin core metadata schema, and each of the plurality of metadata records related to one of the data objects and containing metadata related thereto;

metadata tagging logic for tagging a data object; and

data object placement logic for placing a data object in a table of the database.

2. The system of claim 1, wherein the database is a modified relational database having a plurality of tables related hierarchically, and wherein the metadata table is related to each of the hierarchically related tables.

3. The system of claim 2, wherein the hierarchically related tables are related by a plurality of hierarchical levels characterized by a parent-child relationship wherein each parent-level table has at least one child-level table related thereto, and each child-level table has one parent-level table related thereto.

4. The system of claim 3, wherein the hierarchical relationship has a first, a second, a third and a fourth level of hierarchy.

5. The system of claim 4, wherein the first level of hierarchy includes a topic table, the second level of hierarchy includes a topic results table and an experiment goals table, the third level of hierarchy includes an experimental results table and a materials and methods table, the fourth level of hierarchy includes a material and method results table, and wherein the topic results table and the experiment goals table are children of the topic table, the experiment results table and the materials and methods table are children of the experiment goals table, and the materials and methods results table is a child of the materials and methods table.

6. The system of claim 1, wherein the metadata of each metadata record includes at least one field for each of a plurality of dublin core elements.

7. The system of claim 6, wherein the plurality of dublin core elements includes title, subject, description, source, language, relation, coverage, creator, publisher, contributor, rights, date, type, format and identifier.

8. The system of claim 6, wherein the plurality of dublin core elements consists of title, creator, subject, description, date, type, format, identifier, language and relation.

9. The system of claim 8 wherein the dublin core type element has a range of values defined by the dublin core metadata schema.

10. The system of claim 9 wherein the dublin core description element provides type-element description.

11. The system of claim 1 wherein each of the plurality of the data objects is related to one of the plurality of metadata records.

12. The system of claim 1 further comprising metadata classification logic for classifying the data object as a metadata-related data object.

13. The system of claim 1 wherein the metadata tagging logic further comprises:

metadata record creation logic for creating at least one metadata record based upon received element values; and

metadata record storage logic for storing at least one metadata record in the metadata table.

14. The system of claim 1 wherein the metadata tagging logic further comprises:

entry form logic for providing at least one form for entering metadata values;

element value reception logic for receiving at least one value for at least one metadata record element;

metadata record creation logic for creating at least one metadata record based upon received element values; and

metadata record storage logic for storing at least one metadata record in the metadata table.

15. The system of claim 1 further comprising metadata search logic for searching the database.

16. The system of claim 1 further comprising search result coordinating logic for coordinating multiple search results.

17. The system of claim 1 further comprising output logic for outputting search results.

18. A system for managing a plurality of data objects, comprising:

metadata classification logic for determining whether to classify the data object as a metadata-related data object;

a database having

a plurality of metadata-related tables, wherein each of the metadata-related data objects is stored in at least one of the metadata-related tables,

at least one metadata table, the metadata table related to each of the plurality of metadata-related tables, the metadata table having a plurality of metadata records,

each of the plurality of metadata records conforming to a dublin core metadata schema, each of the plurality of metadata records related to one of the metadata-related data objects and containing metadata related thereto, and each of the plurality of metadata-related data objects related to one of the metadata records, and

at least one non-metadata-related table, wherein each of the data objects which is not related to a metadata record is stored, and

wherein each of the plurality of metadata-related tables and each of the at least one non-metadata-related tables are related to at least one other of each of the plurality of metadata-related tables or of each of the at least one non-metadata-related tables;

metadata tagging logic for tagging a metadata-related data object; and

data object placement logic for placing a data object in a table of the database.

19. The system of claim 18 wherein the database is a modified relational database and the plurality of metadata-related tables are related hierarchically with a first, a second, a third and a fourth level of hierarchy, the hierarchical relationship characterized by a parent-child relationship wherein each parent-level table has at least one child-level table related thereto, and each child-level table has one parent-level table related thereto, and wherein the first level of hierarchy includes a topic table, the second level of hierarchy includes a topic results table and an experiment goals table, the third level of hierarchy includes an experimental results table and a materials and methods table, the fourth level of hierarchy includes a material and method results table, and wherein the topic results table and the experiment goals table are children of the topic table, the experiment results table and the materials and methods table are children of the experiment goals table, and the materials and methods results table is a child of the materials and methods table.

20. The system of claim 19 wherein the metadata of each metadata record includes at least one field for each of a plurality of dublin core elements, wherein the plurality of dublin core elements includes title, creator, subject, description, date, type, format, identifier, language and relation.

21. The system of claim 18 further comprising:

metadata search logic for searching the metadata-related data objects and output logic for outputting search results.

22. A system for managing a plurality of scientific laboratory notebook data objects relating to a plurality of topics, comprising:

metadata classification logic for determining whether to classify the scientific laboratory notebook data object as a metadata-related data object;

a modified relational database having

a plurality of metadata-related tables, each of the metadata-related tables related hierarchically with a plurality of levels of hierarchy, the hierarchical relationship characterized by a parent-child relationship wherein each parent-level table has at least one child-level table related thereto, and each child-level table has one parent-level table related thereto, and wherein each of the metadata-related data objects is stored in at least one of the metadata-related tables,

at least one metadata table, the metadata table related to each of the plurality of metadata-related tables, the metadata table having a plurality of metadata records, each of the plurality of metadata records conforming to a dublin core metadata schema, each of the plurality of metadata records related to one of the metadata-related data objects and containing metadata related thereto, and each of the plurality of metadata-related data objects related to one of the metadata records, and

a plurality of non-metadata-related tables, wherein each of the scientific laboratory notebook data objects which is not related to a metadata record is stored, and

wherein each of the plurality of metadata-related tables and each of the plurality of non-metadata-related tables are related to at least one other of each of the plurality of metadata-related tables or of each of the plurality of non-metadata-related tables;

metadata tagging logic for tagging a metadata-related data object;

metadata search logic for searching the metadata-related data;

data object placement logic for placing a data object in a table of the database; and

output logic for outputting search results.

23. The system of claim 22 wherein the hierarchical relationship among the metadata-related tables includes a first, a second, a third and a fourth level of hierarchy, wherein the first level of hierarchy includes a topic table, the second level of hierarchy includes a topic results table and an experiment goals table, the third level of hierarchy includes an experimental results table and a materials and methods table, the fourth level of hierarchy includes a material and method results table, and wherein the topic results table and the experiment goals table are children of the topic table, the experiment results table and the materials and methods table are children of the experiment goals table, and the materials and methods results table is a child of the materials and methods table.

24. The system of claim 23 wherein scientific laboratory notebook data objects include at least one project description, at least one experiment design concept, at least one procedures and materials used list, at least one result paper, at least one data table or graph, and at least one image or dataset, wherein:

all project description data objects are placed in a topic table, all experiment design concept data objects are placed in a experiment goals table, all procedures and materials used list data objects are placed in a materials and methods table, all results paper data objects are placed in a topic results table, all data table or graph data objects are placed in an experimental results table, and all image or dataset data objects are placed in a materials and method results table.

25. The system of claim 22 wherein the plurality of non-metadata-related tables includes at least one steps table, at least one materials table, at least one memos table and at least one users table.

26. The system of claim 25 wherein scientific laboratory notebook data objects include at least one specific procedural component, at least one material specification sheet, at least one set of contact information regarding a researcher, and at least one correspondence or note, wherein:

all specific procedural component data objects are placed in a steps table, all material specification sheet data objects are placed in a materials table, all correspondence or note data objects are placed in a memos table, and all contact information regarding a researcher data objects are placed in a users table.

27. An electronic scientific laboratory notebook for managing a plurality of scientific laboratory notebook data objects, the electronic notebook comprising a computing device communicating with a system for managing the plurality of scientific laboratory notebook data objects, the system including:

metadata classification logic for determining whether to classify the scientific laboratory notebook data object as a metadata-related data object;

a database having

a plurality of metadata-related tables, wherein each of the metadata-related data objects is stored in at least one of the metadata-related tables,

at least one metadata table, the metadata table related to each of the plurality of metadata-related tables, the metadata table having a plurality of metadata records,

each of the plurality of metadata records conforming to a dublin core metadata schema, each of the plurality of metadata records related to one of the metadata-related data objects and containing metadata related thereto, and each of the plurality of metadata-related data objects related to one of the metadata records, and

at least one non-metadata-related table, wherein each of the scientific laboratory notebook data objects which is not related to a metadata record is stored, and

wherein each of the plurality of metadata-related tables and each of the at least one non-metadata-related tables are related to at least one other of each of the plurality of metadata-related tables or of each of the at least one non-metadata-related tables;

metadata tagging logic for tagging a metadata-related data object;

data object placement logic for placing a data object in a table of the database;

metadata search logic for searching the metadata-related data objects; and

output logic for outputting search results to the electronic notebook.

28. The electronic notebook of claim 27 wherein the computing device is portable and communication with the system is wireless.

29. A computer-readable medium containing a data structure for use in allocating memory, the data structure containing:

a database having a plurality of tables, wherein each of the data objects is stored in at least one of the tables, and at least one of the tables is a metadata table, the metadata table including a plurality of metadata records, each of the plurality of metadata records conforming to a dublin core metadata schema, and each of the plurality of metadata records related to one of the data objects and containing metadata related thereto.

30. The computer-readable medium of claim 29, wherein the database is a modified relational database having a plurality of tables related hierarchically, and wherein the metadata table is related to each of the hierarchically related tables.

31. The computer-readable medium of claim 30, wherein the hierarchically related tables are related by a plurality of hierarchical levels characterized by a parent-child relationship wherein each parent-level table has at least one child-level table related thereto, and each child-level table has one parent-level table related thereto.

32. The computer-readable medium of claim 31, wherein the hierarchical relationship has a first, a second, a third and a fourth level of hierarchy.

33. The computer-readable medium of claim 32, wherein the first level of hierarchy includes a topic table, the second level of hierarchy includes a topic results table and an experiment goals table, the third level of hierarchy includes an experimental results table and a materials and methods table, the fourth level of hierarchy includes a material and method results table, and wherein the topic results table and the experiment goals table are children of the topic table, the experiment results table and the materials and methods table are children of the experiment goals table, and the materials and methods results table is a child of the materials and methods table.

34. The computer-readable medium of claim 29, wherein the metadata of each metadata record includes at least one field for each of a plurality of dublin core elements.

35. The computer-readable medium of claim 34, wherein the plurality of dublin core elements includes title, subject, description, source, language, relation, coverage, creator, publisher, contributor, rights, date, type, format and identifier.

36. The computer-readable medium of claim 35, wherein the plurality of dublin core elements consists of title, creator, subject, description, date, type, format, identifier, language and relation.

37. The computer-readable medium of claim 36 wherein the dublin core type element has a range of values defined by a dublin core metadata schema.

38. The computer-readable medium of claim 37 wherein the dublin core description element provides type-element description.

39. The computer-readable medium of claim 29 wherein each of the plurality of the data objects is related to one of the plurality of metadata records.

40. A computer-readable medium containing a data structure for use in allocating memory for storing a plurality of data objects and metadata-related data objects, the data structure containing:

a database having

a plurality of metadata-related tables, wherein each of the metadata-related data objects is stored in at least one of the metadata-related tables,

at least one metadata table, the metadata table related to each of the plurality of metadata-related tables, the metadata table having a plurality of metadata records,

each of the plurality of metadata records conforming to a dublin core metadata schema, each of the plurality of metadata records related to one of the metadata-related data objects and containing metadata related thereto, and each of the plurality of metadata-related data objects related to one of the metadata records, and

at least one non-metadata-related table, wherein each of the data objects which is not related to a metadata record is stored, and

wherein each of the plurality of metadata-related tables and each of the at least one non-metadata-related tables are related to at least one other of each of the plurality of metadata-related tables or of each of the at least one non-metadata-related tables.

41. The computer readable medium of claim 40 wherein the database is a modified relational database and the plurality of metadata-related tables are related hierarchically with a first, a second, a third and a fourth level of hierarchy, the hierarchical relationship characterized by a parent-child relationship wherein each parent-level table has at least one child-level table related thereto, and each child-level table has one parent-level table related thereto, and wherein the first level of hierarchy includes a topic table, the second level of hierarchy includes a topic results table and an experiment goals table, the third level of hierarchy includes an experimental results table and a materials and methods table, the fourth level of hierarchy includes a material and method results table, and wherein the topic results table and the experiment goals table are children of the topic table, the experiment results table and the materials and methods table are children of the experiment goals table, and the materials and methods results table is a child of the materials and methods table.

42. The computer readable medium of claim 40 wherein the metadata of each metadata record includes at least one field for each of a plurality of dublin core elements, wherein the plurality of dublin core elements includes title, creator, subject, description, date, type, format, identifier, language and relation.

43. A computer-readable medium containing a data structure for use in allocating memory for storing a plurality of scientific laboratory notebook data objects and metadata-related scientific laboratory notebook data objects, the data structure containing:

a modified relational database having

a plurality of metadata-related tables, each of the metadata-related tables related hierarchically with a plurality of levels of hierarchy, the hierarchical relationship characterized by a parent-child relationship wherein each parent-level table has at least one child-level table related thereto, and each child-level table has one parent-level table related thereto, and wherein each of the metadata-related data objects is stored in at least one of the metadata-related tables,

at least one metadata table, the metadata table related to each of the plurality of metadata-related tables, the metadata table having a plurality of metadata records,

each of the plurality of metadata records conforming to a dublin core metadata schema, each of the plurality of metadata records related to one of the metadata-related data objects and containing metadata related thereto, and each of the plurality of metadata-related data objects related to one of the metadata records, and

a plurality of non-metadata-related tables, wherein each of the scientific laboratory notebook data objects which is not related to a metadata record is stored, and

wherein each of the plurality of metadata-related tables and each of the plurality of non-metadata-related tables are related to at least one other of each of the plurality of metadata-related tables or of each of the plurality of non-metadata-related tables.

44. The computer-readable medium of claim 43 wherein the hierarchical relationship among the metadata-related tables includes a first, a second, a third and a fourth level of hierarchy, wherein the first level of hierarchy includes a topic table, the second level of hierarchy includes a topic results table and an experiment goals table, the third level of hierarchy includes an experimental results table and a materials and methods table, the fourth level of hierarchy includes a material and method results table, and wherein the topic results table and the experiment goals table are children of the topic table, the experiment results table and the materials and methods table are children of the experiment goals table, and the materials and methods results table is a child of the materials and methods table.

45. The computer-readable medium of claim 44 wherein scientific laboratory notebook data objects include at least one project description, at least one experiment design concept, at least one procedures and materials used list, at least one result paper, at least one data table or graph, and at least one image or dataset, wherein:

all project description data objects are placed in a topic table, all experiment design concept data objects are placed in a experiment goals table, all procedures and materials used list data objects are placed in a materials and methods table, all results paper data objects are placed in a topic results table, all data table or graph data objects are placed in an experimental results table, and all image or dataset data objects are placed in a materials and method results table.

46. The computer-readable medium of claim 43 wherein the plurality of non-metadata-related tables includes at least one steps table, at least one materials table, at least one memos table and at least one users table.

47. The computer-readable medium of claim 46 wherein scientific laboratory notebook data objects include at least one specific procedural component, at least one material specification sheet, at least one set of contact information regarding a researcher, and at least one correspondence or note, wherein:

all specific procedural component data objects are placed in a steps table, all material specification sheet data objects are placed in a materials table, all correspondence or note data objects are placed in a memos table, and all contact information regarding a researcher data objects are placed in a users table.

48. A method for managing a plurality of scientific laboratory notebook data objects with a dublin core metadata schema comprising the steps of:

gathering the data objects in digital form;

tagging at least one data object with metadata conforming to a dublin core metadata schema, whereby the metadata is stored in a metadata record which is related to the data object for which the metadata describes, and wherein the metadata record is stored in at least one metadata table;

storing each of the tagged data objects as a record in at least one of a plurality of tables of a modified relational database, each of the plurality of tables related to the metadata table;

searching the plurality of data objects by searching the metadata records associated with the data objects; and

outputting results of a search.

49. The method of claim 48, the tagging step further comprising the steps of:

providing an entry form for obtaining metadata regarding a data object;

receiving metadata regarding a data object into the entry form;

creating a metadata record from the metadata;

relating the metadata record to the data object; and

storing the metadata record in the metadata table.

50. The method of claim 48, wherein a dublin core metadata schema includes an element type, the storing step further comprising the steps of:

selecting the table in which to store the data object based upon metadata contained within the type element of the metadata record related to the data object; and

storing the data object in the selected table.

51. The method of claim 50, wherein the dublin core metadata schema includes an element identifier, the selecting step further comprising the step of selecting the table in which to store the data object based upon metadata contained within the identifier element of the metadata record related to the data object.

52. The method of claim 48, the searching step further comprising the steps of:

receiving at least one data object search parameter having at least one value for at least one dublin core metadata element included in the metadata records;

identifying the metadata records of the metadata table which have values which match the search parameter; and

retrieving the data objects from the database which are related to each identified metadata records.

53. The method of claim 52, further comprising the step of coordinating a plurality of data objects retrieved from the data base.

54. The method of claim 48, further comprising the step of storing each data object which is not tagged as a record in at least one of a plurality of non-metadata indexed tables of the modified relational database.

55. A method for populating a modified relational database with a plurality of scientific laboratory notebook data objects, the database having a plurality of tables for storing data objects and at least one metadata table having at least one metadata record related to each data object stored in each of the plurality of tables which is metadata-related, each of the metadata records conforming to a dublin core metadata schema, the method comprising the steps of:

obtaining at least one data object in digital form;

providing metadata relating to the data object which complies with the dublin core metadata schema; and

submitting the data object for storage in the database.

56. The method of claim 55, wherein each metadata record includes a plurality of dublin core elements, the providing step further comprising the steps of:

determining at least one value for each dublin core element; and

submitting the value for storage in the metadata record.

57. The method of claim 56, wherein the determining step further comprising the steps of:

receiving a list of potential values for at least one dublin core element; and

selecting a value for the dublin core element from the list.

58. The method of claim 57, wherein the dublin core metadata schema includes an element type, and wherein the list of potential values for the element type is in compliance with the dublin core approved values.

59. The method of claim 57, wherein the dublin core metadata schema includes at least one element identifier, wherein the list of potential values for the element identifier includes each of the plurality of tables in which a data object may be stored.

60. The method of claim 55, further comprising the step of:

determining whether a data object will be tagged.

61. The method of claim 55, wherein each metadata record includes a plurality of dublin core elements including an element relation and wherein the range of potential values for the relation element includes all data objects in the database which are related to a metadata record, the providing step further comprising the step of:

determining at least one value for at least one relation element from the range of potential values.

62. A method for accessing a modified relational database with a plurality of scientific laboratory notebook data objects, the database having a plurality of tables for storing data objects and at least one metadata table having at least one metadata record related to each data object stored in each of the plurality of tables which is metadata-related, each of the metadata records conforming to a dublin core metadata schema, the method comprising the steps of:

submitting at least one data object search parameter including at least one value for at least one dublin core metadata element included in the metadata records; and

receiving the data objects which have related metadata records which have at least one element value which matches a submitted search parameter.