On augmenting database design-support environments to capture the geo-spatio-temporal data semantics

  • Authors:

  • Vijay Khatri;Sudha Ram;Richard T. Snodgrass

  • Affiliations:

  • Information Systems Department, Kelley School of Business, Indiana University, 1309 East Tenth Street, BU 560, Bloomington, IN 47405 1701, USA;Department of Management Information Systems, University of Arizona, Tucson, AZ 85721,USA;Department of Computer Science, University of Arizona, Tucson, AZ 85721, USA

  • Venue:
  • Information Systems
  • Year:
  • 2006

Quantified Score

Hi-index 0.00

Visualization

Abstract

A database design-support environment supports a data analyst in eliciting, articulating, specifying and validating data-related requirements. Extant design-support environments-based on conventional conceptual models-do not adequately support applications that need to organize data based on time (e.g., accounting, portfolio management, personnel management) and/or space (e.g., facility management, transportation, logistics). For geo-spatio-temporal applications, it is left to database designers to discover, design and implement-on an ad-hoc basis-the temporal and geospatial concepts that they need to represent the miniworld. To elicit the geo-spatio-temporal data semantics, we characterize guiding principles for augmenting the conventional conceptual database design approach, present our annotation-based approach, and illustrate how our proposed approach can be instantiated via a proof-of-concept prototype. Via a proof-of-concept database design-support environment, we exemplify our annotation-based approach, and show how segregating ''what'' from ''when/where'' via annotations satisfies ontologic- and cognition-based requirements, dovetails with existing database design methodologies, results in upward-compatible conceptual as well as XML schemas, and provides a straightforward mechanism to extend extant design-support environments.