{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,8]],"date-time":"2026-03-08T04:32:58Z","timestamp":1772944378649,"version":"3.50.1"},"reference-count":25,"publisher":"MDPI AG","issue":"1","license":[{"start":{"date-parts":[[2019,2,22]],"date-time":"2019-02-22T00:00:00Z","timestamp":1550793600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"DOI":"10.13039\/501100001659","name":"Deutsche Forschungsgemeinschaft","doi-asserted-by":"publisher","award":["SCHU 2271\/6-2"],"award-info":[{"award-number":["SCHU 2271\/6-2"]}],"id":[{"id":"10.13039\/501100001659","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Data"],"abstract":"<jats:p>Assessing the impact of chemicals on the environment and addressing subsequent issues are two central challenges to their safe use. Environmental data are continuously expanding, requiring flexible, scalable, and extendable data management solutions that can harmonize multiple data sources with potentially differing nomenclatures or levels of specificity. Here, we present the methodological steps taken to construct a rule-based labeled property graph database, the \u201cMeta-analysis of the Global Impact of Chemicals\u201d (MAGIC) graph, for potential environmental impact chemicals (PEIC) and its subsequent application harmonizing multiple large-scale databases. The resulting data encompass 16,739 unique PEICs attributed to their corresponding chemical class, stereo-chemical information, valid synonyms, use types, unique identifiers (e.g., Chemical Abstract Service registry number CAS RN), and others. These data provide researchers with additional chemical information for a large amount of PEICs and can also be publicly accessed using a web interface. Our analysis has shown that data harmonization can increase up to 98% when using the MAGIC graph approach compared to relational data systems for datasets with different nomenclatures. The graph database system and its data appear more suitable for large-scale analysis where traditional (i.e., relational) data systems are reaching conceptional limitations.<\/jats:p>","DOI":"10.3390\/data4010034","type":"journal-article","created":{"date-parts":[[2019,2,22]],"date-time":"2019-02-22T11:26:14Z","timestamp":1550834774000},"page":"34","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":9,"title":["Graphing Ecotoxicology: The MAGIC Graph for Linking Environmental Data on Chemicals"],"prefix":"10.3390","volume":"4","author":[{"given":"Sascha","family":"Bub","sequence":"first","affiliation":[{"name":"Institute for Environmental Sciences, University of Koblenz-Landau, D-76829 Landau, Germany"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-0211-2191","authenticated-orcid":false,"given":"Jakob","family":"Wolfram","sequence":"additional","affiliation":[{"name":"Institute for Environmental Sciences, University of Koblenz-Landau, D-76829 Landau, Germany"}]},{"given":"Sebastian","family":"Stehle","sequence":"additional","affiliation":[{"name":"Institute for Environmental Sciences, University of Koblenz-Landau, D-76829 Landau, Germany"},{"name":"Eusserthal Ecosystem Research Station, University of Koblenz-Landau, D-76857 Eusserthal, Germany"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-2831-1962","authenticated-orcid":false,"given":"Lara L.","family":"Petschick","sequence":"additional","affiliation":[{"name":"Institute for Environmental Sciences, University of Koblenz-Landau, D-76829 Landau, Germany"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-6348-6971","authenticated-orcid":false,"given":"Ralf","family":"Schulz","sequence":"additional","affiliation":[{"name":"Institute for Environmental Sciences, University of Koblenz-Landau, D-76829 Landau, Germany"}]}],"member":"1968","published-online":{"date-parts":[[2019,2,22]]},"reference":[{"key":"ref_1","unstructured":"Newman, M.C. (2014). Fundamentals of Ecotoxicology: The Science of Pollution, CRC Press. [4th ed.]."},{"key":"ref_2","unstructured":"National Water Quality Monitoring Council (2018, October 27). Water Quality Portal, Available online: https:\/\/www.waterqualitydata.us\/."},{"key":"ref_3","unstructured":"Russom, C.L. (2002, January 9\u201310). U.S. EPA\u2019s ECOTOX Database. Proceedings of the Joint regional SETAC\/SOT Annual Meeting, Duluth, MN, USA."},{"key":"ref_4","unstructured":"European Food Safety Authority (2018, October 27). Openfoodtox. Available online: https:\/\/dwh.efsa.europa.eu\/bi\/asp\/Main.aspx."},{"key":"ref_5","unstructured":"Pesticide Action Network (2018, October 27). Pesticide Database\u2014Chemicals. Available online: http:\/\/www.pesticideinfo.org\/Search_Chemicals.jsp."},{"key":"ref_6","unstructured":"Baker, N.T. (2016). Agricultural Pesticide Use Estimates for the USGS National Water Quality Network, 1992\u20132014, U.S. Geological Survey Data Release."},{"key":"ref_7","doi-asserted-by":"crossref","first-page":"7","DOI":"10.1186\/1758-2946-5-7","article-title":"InChI\u2014The Worldwide Chemical Structure Identifier Standard","volume":"5","author":"Heller","year":"2013","journal-title":"J. Cheminform."},{"key":"ref_8","doi-asserted-by":"crossref","first-page":"146","DOI":"10.1021\/c160030a007","article-title":"107 Years of Line-Formula Notations (1861\u20131968)","volume":"8","author":"Wiswesser","year":"1968","journal-title":"J. Chem. Doc."},{"key":"ref_9","doi-asserted-by":"crossref","first-page":"31","DOI":"10.1021\/ci00057a005","article-title":"Smiles, a Chemical Language and Information System. 1. Introduction to Methodology and Encoding Rules","volume":"28","author":"Weininger","year":"1988","journal-title":"J. Chem. Inf. Comput. Sci."},{"key":"ref_10","doi-asserted-by":"crossref","unstructured":"(1978). CAS Registry System. J. Chem. Inf. Comput. Sci., 18, 58.","DOI":"10.1021\/ci60013a609"},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"61","DOI":"10.1186\/s13321-017-0247-6","article-title":"The Comptox Chemistry Dashboard: A Community Data Resource for Environmental Chemistry","volume":"9","author":"Williams","year":"2017","journal-title":"J. Cheminform."},{"key":"ref_12","doi-asserted-by":"crossref","first-page":"5750","DOI":"10.1073\/pnas.1500232112","article-title":"Agricultural Insecticides Threaten Surface Waters at the Global Scale","volume":"112","author":"Stehle","year":"2015","journal-title":"Proc. Natl. Acad. Sci. USA"},{"key":"ref_13","doi-asserted-by":"crossref","first-page":"4","DOI":"10.1093\/toxsci\/kfp097","article-title":"Chiral Toxicology: It\u2019s the Same Thing\u2026Only Different","volume":"110","author":"Smith","year":"2009","journal-title":"Toxicol. Sci."},{"key":"ref_14","doi-asserted-by":"crossref","unstructured":"Vicknair, C., Macias, M., Zhao, Z., Nan, X., Chen, Y., and Wilkins, D. (2010, January 15\u201317). A Comparison of a Graph Database and a Relational Database: A Data Provenance Perspective. Proceedings of the 48th Annual Southeast Regional Conference, Oxford, MS, USA.","DOI":"10.1145\/1900008.1900067"},{"key":"ref_15","first-page":"509","article-title":"Comparative Analysis of Relational and Graph Databases","volume":"2","author":"Batra","year":"2012","journal-title":"Int. J. Soft Comput. Eng."},{"key":"ref_16","doi-asserted-by":"crossref","unstructured":"Holzschuher, F., and Peinl, R. (2013, January 18\u201322). Performance of Graph Query Languages: Comparison of Cypher, Gremlin and Native Access in Neo4j. Proceedings of the Joint EDBT\/ICDT 2013 Workshops, Genoa, Italy.","DOI":"10.1145\/2457317.2457351"},{"key":"ref_17","first-page":"38","article-title":"Running Complex Queries on a Graph Database: A Performance Evaluation of Neo4j","volume":"12","author":"Constantinov","year":"2015","journal-title":"Ann. Univ. Craiova"},{"key":"ref_18","first-page":"16","article-title":"Type of NOSQL Databases and Its Comparison with Relational Databases","volume":"5","author":"Nayak","year":"2013","journal-title":"Int. J. Appl. Inf. Syst."},{"key":"ref_19","unstructured":"Robinson, I., Webber, J., and Eifrem, E. (2013). Graph Databases, O\u2019Reilly Media, Inc.. [1st ed.]."},{"key":"ref_20","first-page":"1","article-title":"Comparative Study of the New Generation, Agile, Scalable, High Performance NOSQL Databases","volume":"48","author":"Tauro","year":"2012","journal-title":"Int. J. Comput. Appl."},{"key":"ref_21","doi-asserted-by":"crossref","first-page":"35","DOI":"10.1145\/1773912.1773922","article-title":"Cassandra: A Decentralized Structured Storage System","volume":"44","author":"Lakshman","year":"2010","journal-title":"ACM SIGOPS Oper. Syst. Rev."},{"key":"ref_22","doi-asserted-by":"crossref","unstructured":"Sivasubramanian, S. (2012, January 20\u201324). Amazon dynamoDB: A Seamlessly Scalable Non-Relational Database Service. Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data, Scottsdale, AZ, USA.","DOI":"10.1145\/2213836.2213945"},{"key":"ref_23","doi-asserted-by":"crossref","first-page":"14452","DOI":"10.1021\/acs.est.8b04651","article-title":"Meta-Analysis of Insecticides in United States Surface Waters: Status and Future Implications","volume":"52","author":"Wolfram","year":"2018","journal-title":"Environ. Sci. Technol."},{"key":"ref_24","unstructured":"Beck, K. (2003). Test-Driven Development: By Example, Addison-Wesley Professional. [1st ed.]."},{"key":"ref_25","unstructured":"(2018, December 25). InChI Technical FAQ. Available online: https:\/\/www.inchi-trust.org\/technical-faq-2\/."}],"container-title":["Data"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2306-5729\/4\/1\/34\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,11]],"date-time":"2025-10-11T12:34:08Z","timestamp":1760186048000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2306-5729\/4\/1\/34"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,2,22]]},"references-count":25,"journal-issue":{"issue":"1","published-online":{"date-parts":[[2019,3]]}},"alternative-id":["data4010034"],"URL":"https:\/\/doi.org\/10.3390\/data4010034","relation":{},"ISSN":["2306-5729"],"issn-type":[{"value":"2306-5729","type":"electronic"}],"subject":[],"published":{"date-parts":[[2019,2,22]]}}}