This Article 
 Bibliographic References 
 Add to: 
Augmenting a Conceptual Model with Geospatiotemporal Annotations
November 2004 (vol. 16 no. 11)
pp. 1324-1338
While many real-world applications need to organize data based on space (e.g., geology, geomarketing, environmental modeling) and/or time (e.g., accounting, inventory management, personnel management), existing conventional conceptual models do not provide a straightforward mechanism to explicitly capture the associated spatial and temporal semantics. As a result, it is left to database designers to discover, design, and implement—on an ad hoc basis—the temporal and spatial concepts that they need. We propose an annotation-based approach that allows a database designer to focus first on nontemporal and nongeospatial aspects (i.e., "what”) of the application and, subsequently, augment the conceptual schema with geospatiotemporal annotations (i.e., "when” and "where”). Via annotations, we enable a supplementary level of abstraction that succinctly encapsulates the geospatiotemporal data semantics and naturally extends the semantics of a conventional conceptual model. An overarching assumption in conceptual modeling has always been that expressiveness and formality need to be balanced with simplicity. We posit that our formally defined annotation-based approach is not only expressive, but also straightforward to understand and implement.

[1] C. Batini, S. Ceri, and S.B. Navathe, Conceptual Database Design: An Entity-Relationship Approach. Benjamin/Cummings Publishing Company, 1992.
[2] M.H. Böhlen, C.S. Jensen, and R.T. Snodgrass, Temporal Statement Modifiers ACM Trans. Database Systems, vol. 25, no. 4, pp. 407-456, 2000.
[3] P.P. Chen, The Entity-Relationship Model Toward a Unified View of Data ACM Trans. Database Systems, vol. 1, no. 1, pp. 9-36, 1976.
[4] C. Claramunt, C. Parent, and M. Thériault, An Entity-Relationship Model for Spatio-Temporal Processes Data Mining and Reverse Eng.: Searching for Semantics, Proc. IFIP TC2/WG2.6 Seventh Conf. Database Semantics (DS-7), pp. 455-475, 1997.
[5] F.A. D'Agnese, C.C. Faunt, A.K. Turner, and M.C. Hill, Hydrogeologic Evaluation and Numerical Simulation of the Death Valley Regional Ground-Water Flow System, Nevada and California US Geological Survey Water Resources 96-4300, 1997.
[6] C.E. Dyreson, W.S. Evans, H. Lin, and R.T. Snodgrass, “Efficiently Supporting Temporal Granularities,” IEEE Trans. Knowledge and Data Eng., vol. 12, no. 4, pp. 568-587, 2000.
[7] R. Elmasri and S.B. Navathe, Fundamentals of Database Systems. second ed. Redwood City, Calif.: Benjamin/ Cummings Publishing Co., 1994.
[8] S.K. Gadia, A Homogeneous Relational Model and Query Languages for Temporal Databases ACM Trans. Database Systems, vol. 13, no. 4, pp. 418-448, 1988.
[9] S.C. Guptill, Multiple Representations of Geographic Entities through Space and Time Proc. Fourth Int'l Symp. Spatial Data Handling, pp. 859-868, 1990.
[10] A.F. Hutchings and S.T. Knox, Creating Products Customers Demand Comm. ACM, vol. 38, no. 5, pp. 72-80, 1995.
[11] C.S. Jensen, C.E. Dyreson, M. Bohlen, J. Clifford, R. Elmasri, S.K. Gadia, F. Grandi, P. Hayes, S. Jajodia, W. Kafer, N. Kline, N. Lorentzos, Y. Mitsopoulos, A. Montanari, D. Nonen, E. Peresi, B. Pernici, J.F. Roddick, N.L. Sarda, M.R. Scalas, A. Segev, R.T. Snodgrass, M.D. Soo, A. Tansel, R. Tiberio, and G. Wiederhold, A Consensus Glossary of Temporal Database Concepts-February 1998 Version Temporal Databases: Research and Practice, O. Etzion, S. Jajodia, and S. Sripada, eds., Springer-Verlag, 1998.
[12] J. Jing, A. Helal, and A.K. Elmagarmid, Client-Server Computing in Mobile Environments ACM Computing Surveys, vol. 31, no. 2, pp. 117-157, 1999.
[13] S. Juhn and J. Naumann, The Effectiveness of Data Representation Characteristics on User Validation Proc. Sixth Int'l Conf. Information Systems, pp. 212-226, 1985.
[14] V. Khatri, Bridging the Spatio-Temporal Semantic Gap: A Theoretical Framework, Evaluation and A Prototype System Doctoral Thesis: Management Information Systems Dept., Tucson, Ariz.: Univ. of Arizona, p. 320, 2002.
[15] V. Khatri, S. Ram, and R.T. Snodgrass, ST-USM: Bridging the Semantic Gap with a Spatio-Temporal Conceptual Model TimeCenter Technical Report TR-64, 2001.
[16] V. Khatri, S. Ram, and R.T. Snodgrass, Supporting User-Defined Granularities and Indeterminacy in a Spatiotemporal Conceptual Model Annals of Math. and Artificial Intelligence, vol. 36, nos. 1-2, pp. 195-232, 2002.
[17] B. Kuipers, Modeling Spatial Knowledge Cognitive Science, vol. 2, pp. 129-153, 1978.
[18] Y.C. Lee and M. Isdale, The Need for a Spatial Data Model Proc. Canadian Conf. in GIS-911991, year?
[19] D.M. Mark and A.U. Frank, Experiential and Formal Models of Geographic Space Environment and Planning, vol. 23, no. 1, pp. 3-24, 1996.
[20] J.L. Mennis, D.J. Peuquet, and L. Qian, A Conceptual Framework for Incorporating Cognitive Principles into Geographical Database Representation Int'l J. Geographic Information Science, vol. 14, no. 6, pp. 501-520, 2000.
[21] D.J. Peuquet, It's About Time: A Conceptual Framework for the Representation of Temporal Dynamics in Geographic Information Systems Annals of the Assoc. of Am. Geographers, vol. 83, no. 3, pp. 441-461, 1994.
[22] S. Ram, Intelligent Database Design Using the Unifying Semantic Model Information and Management, vol. 29, no. 4, pp. 191-206, 1995.
[23] C.V. Ramamoorthy, A. Prakash, W. Tsai, and Y. Usuda, Software Engineering: Problems and Perspectives Computer, vol. 17, no. 10, pp. 191-209, Oct. 1984.
[24] J.F. Roddick and R.T. Snodgrass, Schema Versioning The TSQL2 Temporal Query Language, R.T. Snodgrass, ed., pp. 427-449, Boston: Kluwer Academic Publishers, 1995.
[25] P. Serrano-Alvarado, C. Roncancio, and M.E. Adiba, Analyzing Mobile Transaction Supports for DBMS Proc. 12th Int'l Workshop Database and Expert Systems Applications (DEXA 2001), pp. 595-600, 2001.
[26] A. Sheth, Data Semantics: What, Where and How? Proc. Sixth IFIP Working Conf. Data Semantics (DS-6), pp. 601-610, 1995.
[27] A. Silbershatz, H. Korth, and S. Sudarshan, Database System Concepts. third ed., WCB/McGraw Hill, 1997.
[28] R.T. Snodgrass and I. Ahn, Temporal Databases Computer, vol. 19, no. 9, pp. 35-42, Sept. 1986.
[29] N. Tryfona and C.S. Jensen, Conceptual Data Modeling for Spatiotemporal Applications Geoinformatica, vol. 3, no. 3, pp. 245-268, 1999.
[30] J.W. van Roessel, Design of a Spatial Data Structure Using the Relational Normal Form Int'l J. Geographical Information Systems, vol. 1, no. 1, pp. 33-50, 1987.
[31] Y. Wand, D.E. Monarchi, J. Parsons, and C.C. Woo, Theoretical Foundations for Conceptual Modeling in Information Systems Development Decision Support Systems, vol. 15, no. 4, pp. 285-304, 1995.
[32] Y. Wand, V.C. Storey, and R. Weber, On Ontological Analysis of the Relationship Construct in Conceptual Modeling ACM Trans. Database Systems, vol. 24, no. 4, pp. 494-528, 1999.
[33] M.F. Worboys, H.M. Hearshaw, and D.J. Maguire, Object-Oriented Data Modeling for Spatial Databases Int'l J. Geographical Information Systems, vol. 4, no. 4, pp. 369-383, 1990.

Index Terms:
Data semantics, database design, semantic model, geospatial databases, temporal databases.
Vijay Khatri, Sudha Ram, Richard T. Snodgrass, "Augmenting a Conceptual Model with Geospatiotemporal Annotations," IEEE Transactions on Knowledge and Data Engineering, vol. 16, no. 11, pp. 1324-1338, Nov. 2004, doi:10.1109/TKDE.2004.66
Usage of this product signifies your acceptance of the Terms of Use.