Modeling Spatial and Temporal Set-Based Constraints During Conceptual Database Design

Faiz Currim () and Sudha Ram ()
Additional contact information
Faiz Currim: Tippie College of Business, University of Iowa, Iowa City, Iowa 52242
Sudha Ram: Eller College of Management, University of Arizona, Tucson, Arizona 85712

Information Systems Research, 2012, vol. 23, issue 1, 109-128

Abstract: From a database perspective, business constraints provide an accurate picture of the real world being modeled and help enforce data integrity. Typically, rules are gathered during requirements analysis and embedded in code during the implementation phase. We propose that the rules be explicitly modeled during conceptual design, and develop a framework for understanding and classifying spatiotemporal set-based (cardinality) constraints and an associated syntax. The constraint semantics are formally specified using first-order logic. Modeling rules in conceptual design ensures they are visible to designers and users and not buried in application code. The rules can then be semiautomatically translated into logical design triggers yielding productivity gains. Following the principles of design science research, we evaluate the framework's expressiveness and utility with a case study.

Keywords: data modeling; conceptual design; spatiotemporal cardinality constraints; data management spatiotemporal databases; design science research (search for similar items in EconPapers)
Date: 2012
References: View complete reference list from CitEc
Citations: View citations in EconPapers (4)

Downloads: (external link)
http://dx.doi.org/10.1287/isre.1100.0306 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orisre:v:23:y:2012:i:1:p:109-128

Access Statistics for this article

More articles in Information Systems Research from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher ().