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

Research output: Contribution to journalArticle

17 Citations (Scopus)

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.

Original languageEnglish (US)
Pages (from-to)98-133
Number of pages36
JournalInformation Systems
Volume31
Issue number2
DOIs
StatePublished - Mar 2006

Fingerprint

Semantics
Database design
XML
Logistics
Annotation
Personnel

Keywords

  • Computer-Aided Software/System Engineering tool
  • Data semantics
  • Database design
  • Geo-spatio-temporal database
  • Semantic model

ASJC Scopus subject areas

  • Management Information Systems
  • Management of Technology and Innovation
  • Hardware and Architecture
  • Information Systems
  • Software

Cite this

On augmenting database design-support environments to capture the geo-spatio-temporal data semantics. / Khatri, Vijay; Ram, Sudha; Snodgrass, Richard Thomas.

In: Information Systems, Vol. 31, No. 2, 03.2006, p. 98-133.

Research output: Contribution to journalArticle

@article{11a1f2c3624f4ba59f03c26c9a87f032,
title = "On augmenting database design-support environments to capture the geo-spatio-temporal data semantics",
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.",
keywords = "Computer-Aided Software/System Engineering tool, Data semantics, Database design, Geo-spatio-temporal database, Semantic model",
author = "Vijay Khatri and Sudha Ram and Snodgrass, {Richard Thomas}",
year = "2006",
month = "3",
doi = "10.1016/j.is.2004.10.001",
language = "English (US)",
volume = "31",
pages = "98--133",
journal = "Information Systems",
issn = "0306-4379",
publisher = "Elsevier Limited",
number = "2",

}

TY - JOUR

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

AU - Khatri, Vijay

AU - Ram, Sudha

AU - Snodgrass, Richard Thomas

PY - 2006/3

Y1 - 2006/3

N2 - 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.

AB - 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.

KW - Computer-Aided Software/System Engineering tool

KW - Data semantics

KW - Database design

KW - Geo-spatio-temporal database

KW - Semantic model

UR - http://www.scopus.com/inward/record.url?scp=27844494706&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=27844494706&partnerID=8YFLogxK

U2 - 10.1016/j.is.2004.10.001

DO - 10.1016/j.is.2004.10.001

M3 - Article

VL - 31

SP - 98

EP - 133

JO - Information Systems

JF - Information Systems

SN - 0306-4379

IS - 2

ER -