{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,29]],"date-time":"2025-11-29T07:32:50Z","timestamp":1764401570079},"reference-count":21,"publisher":"Oxford University Press (OUP)","issue":"10","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2012,5,15]]},"abstract":"<jats:title>Abstract<\/jats:title>\n               <jats:p>Motivation: Modern automated laboratories need substantial data management solutions to both store and make accessible the details of the experiments they perform. To be useful, a modern Laboratory Information Management System (LIMS) should be flexible and easily extensible to support evolving laboratory requirements, and should be based on the solid foundations of a robust, well-designed database. We have developed such a database schema to support an automated laboratory that performs experiments in systems biology and high-throughput screening.<\/jats:p>\n               <jats:p>Results: We describe the design of the database schema (AutoLabDB), detailing the main features and describing why we believe it will be relevant to LIMS manufacturers or custom builders. This database has been developed to support two large automated Robot Scientist systems over the last 5 years, where it has been used as the basis of an LIMS that helps to manage both the laboratory and all the experiment data produced.<\/jats:p>\n               <jats:p>Availability and implementation: The database schema has been made available as open source (BSD license), so that others may use, extend and improve it to meet their own needs. Example software interfaces to the database are also provided. http:\/\/autolabdb.sourceforge.net\/<\/jats:p>\n               <jats:p>Contact: \u00a0afc@aber.ac.uk<\/jats:p>","DOI":"10.1093\/bioinformatics\/bts140","type":"journal-article","created":{"date-parts":[[2012,3,31]],"date-time":"2012-03-31T00:24:47Z","timestamp":1333153487000},"page":"1390-1397","source":"Crossref","is-referenced-by-count":8,"title":["AutoLabDB: a substantial open source database schema to support a high-throughput automated laboratory"],"prefix":"10.1093","volume":"28","author":[{"given":"Andrew","family":"Sparkes","sequence":"first","affiliation":[{"name":"Department of Computer Science, Aberystwyth University, Penglais, Aberystwyth, SY23 3DB, UK"}]},{"given":"Amanda","family":"Clare","sequence":"additional","affiliation":[{"name":"Department of Computer Science, Aberystwyth University, Penglais, Aberystwyth, SY23 3DB, UK"}]}],"member":"286","published-online":{"date-parts":[[2012,3,29]]},"reference":[{"key":"2023012512303224000_B1","doi-asserted-by":"crossref","first-page":"179","DOI":"10.1186\/1471-2105-12-179","article-title":"Brunn: an open source laboratory information system for microplates with a graphical plate layout design process","volume":"12","author":"Alvarsson","year":"2011","journal-title":"BMC Bioinformatics"},{"key":"2023012512303224000_B2","article-title":"PubChem: integrated platform of small molecules and biological activities","volume-title":"Annual Reports in Computational Chemistry.","author":"Bolton","year":"2008"},{"key":"2023012512303224000_B3","doi-asserted-by":"crossref","DOI":"10.1145\/1274000.1274006","article-title":"Optimising the flow of experiments to a robot scientist with multi-objective evolutionary algorithms","volume-title":"Proceedings of the Genetic and Evolutionary Computation Conference (GECCO).","author":"Byrne","year":"2007"},{"key":"2023012512303224000_B4","doi-asserted-by":"crossref","first-page":"377","DOI":"10.1145\/362384.362685","article-title":"A relational model of data for large shared data banks","volume":"13","author":"Codd","year":"1970","journal-title":"Commun. ACM"},{"key":"2023012512303224000_B5","doi-asserted-by":"crossref","first-page":"D344","DOI":"10.1093\/nar\/gkm791","article-title":"ChEBI: a database and ontology for chemical entities of biological interest","volume":"36","author":"Degtyarenko","year":"2008","journal-title":"Nucleic Acids Res."},{"key":"2023012512303224000_B6","article-title":"Interact: an object oriented protein-protein interaction database","volume-title":"ISMB '99.","author":"Eilbeck","year":"1999"},{"key":"2023012512303224000_B7","volume-title":"The Art of SQL.","author":"Faroult","year":"2006"},{"key":"2023012512303224000_B8","doi-asserted-by":"crossref","DOI":"10.1145\/945445.945450","article-title":"The Google File System","volume-title":"19th ACM Symposium on Operating Systems Principles.","author":"Ghemawat","year":"2003"},{"key":"2023012512303224000_B9","doi-asserted-by":"crossref","first-page":"437","DOI":"10.1093\/bioinformatics\/btq676","article-title":"WIST: toolkit for rapid, customized LIMS development","volume":"27","author":"Huang","year":"2011","journal-title":"Bioinformatics"},{"key":"2023012512303224000_B10","first-page":"36","article-title":"A classification of object-relational impedance mismatch","volume-title":"First International Conference on Advances in Databases, Knowledge, and Data Applications","author":"Ireland","year":"2009"},{"key":"2023012512303224000_B11","article-title":"Recursive hierarchies: the relational taboo!","volume":"4","author":"Kamfonas","year":"1992","journal-title":"Rel. J."},{"key":"2023012512303224000_B12","doi-asserted-by":"crossref","first-page":"1495","DOI":"10.1016\/j.chembiol.2004.08.026","article-title":"A flexible data analysis tool for chemical genetic screens","volume":"11","author":"Kelley","year":"2004","journal-title":"Chem. Biol."},{"key":"2023012512303224000_B13","doi-asserted-by":"crossref","first-page":"85","DOI":"10.1126\/science.1165620","article-title":"The automation of science","volume":"324","author":"King","year":"2009","journal-title":"Science"},{"key":"2023012512303224000_B14","doi-asserted-by":"crossref","first-page":"283","DOI":"10.1093\/bioinformatics\/19.2.283","article-title":"QuickLIMS: facilitating the data management for DNA-microarray fabrication","volume":"19","author":"Kokocinski","year":"2003","journal-title":"Bioinformatics"},{"key":"2023012512303224000_B15","article-title":"Constraint-based optimisation tools for semi-automated refinement of genome-scale yeast metabolic models","volume-title":"Poster presentation at the 11th International Conference of Systems Biology (ICSB2010).","author":"Lu","year":"2010"},{"key":"2023012512303224000_B16","doi-asserted-by":"crossref","first-page":"752","DOI":"10.1016\/j.jbi.2010.04.004","article-title":"OpenFlyData: an exemplar data web integrating gene expression data on the fruit fly Drosophila melanogaster","volume":"43","author":"Miles","year":"2010","journal-title":"J. Biomed. Inform."},{"key":"2023012512303224000_B17","doi-asserted-by":"crossref","first-page":"193","DOI":"10.1093\/bib\/bbp004","article-title":"Life sciences on the Semantic Web: the Neurocommons and beyond","volume":"10","author":"Ruttenberg","year":"2009","journal-title":"Brief. Bioinform."},{"key":"2023012512303224000_B18","doi-asserted-by":"crossref","first-page":"1","DOI":"10.1186\/1759-4499-2-1","article-title":"Towards Robot Scientists for autonomous scientific discovery","volume":"2","author":"Sparkes","year":"2010","journal-title":"Autom. Exp."},{"key":"2023012512303224000_B19","article-title":"Overview of SciDB, large scale array storage, processing and analysis","volume-title":"SIGMOD'10.","author":"The SciDB Development Team","year":"2010"},{"key":"2023012512303224000_B20","doi-asserted-by":"crossref","first-page":"260","DOI":"10.1186\/1471-2105-11-260","article-title":"Screensaver: an open source lab information management system (LIMS) for high throughput screening facilities","volume":"11","author":"Tolopko","year":"2010","journal-title":"BMC Bioinformatics"},{"key":"2023012512303224000_B21","doi-asserted-by":"crossref","first-page":"1808","DOI":"10.1093\/bioinformatics\/btq271","article-title":"SLIMS \u2013 a user-friendly sample operations and inventory management system for genotyping labs","volume":"26","author":"Van Rossum","year":"2010","journal-title":"Bioinformatics"}],"container-title":["Bioinformatics"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/academic.oup.com\/bioinformatics\/article-pdf\/28\/10\/1390\/48866178\/bioinformatics_28_10_1390.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"https:\/\/academic.oup.com\/bioinformatics\/article-pdf\/28\/10\/1390\/48866178\/bioinformatics_28_10_1390.pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,1,25]],"date-time":"2023-01-25T15:56:36Z","timestamp":1674662196000},"score":1,"resource":{"primary":{"URL":"https:\/\/academic.oup.com\/bioinformatics\/article\/28\/10\/1390\/211917"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,3,29]]},"references-count":21,"journal-issue":{"issue":"10","published-print":{"date-parts":[[2012,5,15]]}},"URL":"https:\/\/doi.org\/10.1093\/bioinformatics\/bts140","relation":{},"ISSN":["1367-4811","1367-4803"],"issn-type":[{"value":"1367-4811","type":"electronic"},{"value":"1367-4803","type":"print"}],"subject":[],"published-other":{"date-parts":[[2012,5,15]]},"published":{"date-parts":[[2012,3,29]]}}}