Databases for highway inventories. Proposal for a new model

Higuera de Frutos, Santiago and Castro Malpica, María (2016). Databases for highway inventories. Proposal for a new model. "Transportation Research Procedia", v. 18 ; pp. 205-211. ISSN 2352-1465. https://doi.org/10.1016/j.trpro.2016.12.028.

Description

Title: Databases for highway inventories. Proposal for a new model
Author/s:
  • Higuera de Frutos, Santiago
  • Castro Malpica, María
Item Type: Article
Título de Revista/Publicación: Transportation Research Procedia
Date: December 2016
Volume: 18
Subjects:
Freetext Keywords: Road; Inventory; Maintenance; Geometric Design
Faculty: E.T.S.I. Caminos, Canales y Puertos (UPM)
Department: Matemática e Informática Aplicadas a la Ingenierías Civil y Naval
Creative Commons Licenses: Recognition - No derivative works - Non commercial

Full text

[img]
Preview
PDF - Requires a PDF viewer, such as GSview, Xpdf or Adobe Acrobat Reader
Download (99kB) | Preview

Abstract

Database models for road inventories are based on classical schemes for relational databases: many related tables, in which the database designer establishes, a priori, every detail that they consider relevant for inventory management. This kind of database presents several problems. First, adapting the model and its applications when new database features appear is difficult. In addition, the different needs of different sets of road inventory users are difficult to fulfil with these schemes. For example, maintenance management services, road authorities and emergency services have different needs. In addition, this kind of database cannot be adapted to new scenarios, such as other countries and regions (that may classify roads or name certain elements differently). The problem is more complex if the language used in these scenarios is not the same as that used in the database design. In addition, technicians need a long time to learn to use the database efficiently. This paper proposes a flexible, multi-language and multipurpose database model, which gives an effective and simple solution to the aforementioned problems.

More information

Item ID: 48828
DC Identifier: http://oa.upm.es/48828/
OAI Identifier: oai:oa.upm.es:48828
DOI: 10.1016/j.trpro.2016.12.028
Official URL: https://www.sciencedirect.com/science/article/pii/S2352146516307839
Deposited by: Memoria Investigacion
Deposited on: 08 Jan 2018 13:20
Last Modified: 08 Jan 2018 13:20
  • Logo InvestigaM (UPM)
  • Logo GEOUP4
  • Logo Open Access
  • Open Access
  • Logo Sherpa/Romeo
    Check whether the anglo-saxon journal in which you have published an article allows you to also publish it under open access.
  • Logo Dulcinea
    Check whether the spanish journal in which you have published an article allows you to also publish it under open access.
  • Logo de Recolecta
  • Logo del Observatorio I+D+i UPM
  • Logo de OpenCourseWare UPM