ObjTables: structured spreadsheets that promote data quality, reuse, and integration
ObjTables: structured spreadsheets that promote data quality, reuse, and integration
复制标题
ObjTables：促进数据质量、重用和集成的结构化电子表格
DOI：
--
复制
发表时间：
2020
期刊：
影响因子：
--
通讯作者：
Bilal Shaikh
中科院分区：
文献类型：
--
作者：
Jonathan R. Karr;Wolfram Liebermeister;A. P. Goldberg;John A. P. Sekar;Bilal Shaikh
科学中的一个核心挑战是理解系统行为是如何从复杂网络中产生的。这通常需要聚合、重用和集成异类信息。文章的补充电子表格是一个关键的数据来源。电子表格很受欢迎，因为它们易于阅读和写入。但是，电子表格通常很难重新分析，因为它们捕获的数据特别没有定义它们所表示的对象、关系和属性的模式。为了帮助研究人员重用和合成电子表格，我们开发了ObjTables，这是一个工具包，通过将电子表格与模式和对象关系映射系统相结合，使电子表格可供人和机器阅读。ObjTables包括模式的格式；用于指示由每个电子表格和列表示的类和属性的标记；用于科学信息的多种数据类型；以及用于使用模式来读取、写入、验证、比较、合并、修订和分析电子表格的高级软件。通过使电子表格更易于重复使用，ObjTables可以实现前所未有的二次元分析。通过使为新类型的数据构建新格式和相关软件变得容易，ObjTables还可以加速新兴科学领域的发展。
A central challenge in science is to understand how systems behaviors emerge from complex networks. This often requires aggregating, reusing, and integrating heterogeneous information. Supplementary spreadsheets to articles are a key data source. Spreadsheets are popular because they are easy to read and write. However, spreadsheets are often difficult to reanalyze because they capture data ad hoc without schemas that define the objects, relationships, and attributes that they represent. To help researchers reuse and compose spreadsheets, we developed ObjTables, a toolkit that makes spreadsheets human- and machine-readable by combining spreadsheets with schemas and an object-relational mapping system. ObjTables includes a format for schemas; markup for indicating the class and attribute represented by each spreadsheet and column; numerous data types for scientific information; and high-level software for using schemas to read, write, validate, compare, merge, revision, and analyze spreadsheets. By making spreadsheets easier to reuse, ObjTables could enable unprecedented secondary meta-analyses. By making it easy to build new formats and associated software for new types of data, ObjTables can also accelerate emerging scientific fields.