TL;DR: A system that automatically extracts relational data from spreadsheets, thereby enabling relational spreadsheet integration and a novel view of how users organize their data in spreadsheets is presented.
Abstract: Spreadsheets contain a huge amount of high-value data but do not observe a standard data model and thus are difficult to integrate. A large number of data integration tools exist, but they generally can only work on relational data. Existing systems for extracting relational data from spreadsheets are too labor intensive to support ad-hoc integration tasks, in which the correct extraction target is only learned during the course of user interaction.This paper introduces a system that automatically extracts relational data from spreadsheets, thereby enabling relational spreadsheet integration. The resulting integrated relational data can be queried directly or can be translated into RDF triples. When compared to standard techniques for spreadsheet data extraction on a set of 100 random Web spreadsheets, the system reduces the amount of human labor by 72% to 92%. In addition to the system design, we present the results of a general survey of more than 400,000 spreadsheets we downloaded from the Web, giving a novel view of how users organize their data in spreadsheets.
TL;DR: OPIS demonstrates the feasibility and power of using standard object-oriented project models to achieve CAPM system integration and uses a shared object–oriented database as the central unifying core of an integrated project planning system.
Abstract: Future computer-aided project management (CAPM) software will be greatly improved through the technologies of project modeling—the rich, general-purpose representation of the project in the computer—and system integration—the sharing of computer models among applications Our approach is to achieve system integration by establishing standard models that all applications can adopt and share This requires a standard data model that specifies the general data-representation approach, a standard domain model that provides a schema or language for representing construction information, and a project model or database for information about a specific project that can be shared among multiple computer applications This paper reviews these standard models and then describes our prototype integrated system called the object model–based project information system, or OPIS OPIS uses a shared object–oriented database as the central unifying core of an integrated project planning system that includes an interface to an intelligent CADD program, a plan-generation expert system, an estimating application, and a scheduling application OPIS demonstrates the feasibility and power of using standard object-oriented project models to achieve CAPM system integration
TL;DR: The main contributions of this work are the formalization of the ODMG standard data model and its extension with time, and the investigation, on a formal basis, of the main issues arising from the introduction of time in an object-oriented model.
Abstract: Although many temporal extensions of the relational data model have been proposed, there is no comparable amount of work in the context of object-oriented data models. Moreover, extensions to the relational model have been proposed in the framework of SQL standards, whereas no attempts have been made to extend the standard for objectoriented databases, defined by ODMG. This paper presents T_ODMG, a temporal extension of the ODMG-93 standard data model. The main contributions of this work are, thus, the formalization of the ODMG standard data model and its extension with time. Another contribution of this work is the investigation, on a formal basis, of the main issues arising from the introduction of time in an object-oriented model.
TL;DR: Taking into account the necessity of a more interoperable and intelligent system to manage e-Procurement processes and the emerging application of semantics in different domains, this special issue is intended to provide researchers, developers and practitioners a summary of the current status of e- procsurement applying semantics.
TL;DR: This study pointed out the critical points embedded in the format as an evidence base for future development and described the results of the benchmark related to IFC, the counterpart of CityGML within building information modeling.
Abstract: Industry Foundation Classes (IFC), the buildingSMART open standard for BIM, is underused with respect to its promising potential, since, according to the experience of practitioners and researchers working with BIM, issues in the standard’s implementation and use prevent its effective use. Nevertheless, a systematic investigation of these issues has never been carried out, and there is thus insufficient evidence for tackling the problems. The GeoBIM benchmark project is aimed at finding such evidence by involving external volunteers, reporting on various aspects of the behavior of tools (geometry, semantics, georeferencing, functionalities), analyzed and described in this article. Interestingly, different IFC software programs with the same standardized data sets yield inconsistent results, with few detectable common patterns, and significant issues are found in their support of the standard, probably due to the very high complexity of the standard data model. A companion article (Part II) describes the results of the benchmark related to CityGML, the counterpart of IFC within geoinformation.