On design and implementation of an object-relational spatial database for activity/travel behaviour research

Abstract.The development of micro level models of urban processes has partially been facilitated by increased availability of detailed activity/travel survey data. Managing and exploring these data can be resource intensive and time consuming. Researchers and municipal planning organizations increasingly face information management challenges. This paper reviews an experiment in design and implementation of an object-relational geographic database using the principles of object-orientation. A data model is specified using the Unified Modeling Language notation and a visual modeling tool, and then implemented as an object-relational spatial database. The resulting database acts as an information foundation capable of supporting empirical research and application development. The experience suggests that a formal approach to information management can enhance our understanding of complex activity/travel data contributing to informed application of these data to transportation research questions.

[1]  Alan Borning,et al.  An extensible, modular architecture for simulating urban development, transportation, and environmental impacts , 2001, Comput. Environ. Urban Syst..

[2]  Donggen Wang,et al.  A spatio-temporal data model for activity-based transport demand modelling , 2001, Int. J. Geogr. Inf. Sci..

[3]  Pavlos S. Kanaroglou,et al.  Commute minimization in the Greater Toronto Area: applying a modified excess commute , 2002 .

[4]  Pavlos S. Kanaroglou,et al.  Exploration of Massive Movement Data: a Visual Analytics Approach , 2008 .

[5]  Randall W. Jackson.  OBJECT‐ORIENTED MODELING IN REGIONAL SCIENCE: AN ADVOCACY VIEW , 2005 .

[6]  Meryl Darren Scott.  Toward an Operational Model of Daily Household Activity-Travel Behavior , 2000 .

[7]  Shih-Lung Shaw,et al.  Integrated land use and transportation interaction: a temporal GIS exploratory data analysis approach , 2003 .

[8]  Frank S. Koppelman,et al.  Integrated Model System of Stop Generation and Tour Formation for Analysis of Activity and Travel Patterns , 1999 .

[9]  Danielle J. Marceau,et al.  Spatio‐Temporal Object‐Oriented Data Model for Disaggregate Travel Behavior , 2002, Trans. GIS.

[10]  Torsten Hägerstraand.  WHAT ABOUT PEOPLE IN REGIONAL SCIENCE , 1970 .

[11]  Zhong-ren Peng,et al.  The Jobs-Housing Balance and Urban Commuting , 1997 .

[12]  Nigel Thrift,et al.  Human activity and time geography , 1978 .

[13]  John E. Abraham,et al.  Microsimulating urban systems , 2004, Comput. Environ. Urban Syst..

[14]  M. Wegener,et al.  Land-Use Transport Interaction: State of the Art , 2004 .

[15]  M. Kwan,et al.  Bringing Time Back In: A Study on the Influence of Travel Time Variations and Facility Opening Hours on Individual Accessibility , 2002 .

[16]  Thomas F. Golob,et al.  A Simultaneous Model of Household Activity Participation and Trip Chain Generation , 1999 .

[17]  Shih-Lung Shaw,et al.  Handling Disaggregate Spatiotemporal Travel Data in GIS , 2000, GeoInformatica.

[18]  Ivar Jacobson,et al.  The unified modeling language reference manual , 2010 .

[19]  Mei-Po Kwan,et al.  Interactive geovisualization of activity-travel patterns using three-dimensional geographical information systems: a methodological exploration with a large data set , 2000 .

[20]  Nicholas A. Koncz,et al.  A data model for multi-dimensional transportation applications , 2002, Int. J. Geogr. Inf. Sci..

[21]  David R. Maidment,et al.  Object-oriented modeling of rivers and watershed in geographic information systems , 2000 .

[22]  M. McNally,et al.  A MODEL OF ACTIVITY PARTICIPATION AND TRAVEL INTERACTIONS BETWEEN HOUSEHOLD HEADS , 1996 .

[23]  James D. Westervelt,et al.  Modeling mobile individuals in dynamic landscapes , 1999, Int. J. Geogr. Inf. Sci..

[24]  Michael Zeiler,et al.  Modeling our world : the ESRI guide to geodatabase design , 1999 .

[25]  강문설.  [서평]「The Unified Modeling Language User Guide」 , 1999 .

[26]  John Bowman,et al.  System of activity-based models for Portland, Oregon , 1998 .

[27]  P. Waddell.  UrbanSim: Modeling Urban Development for Land Use, Transportation, and Environmental Planning , 2002 .

[28]  Ling Bian,et al.  Object-oriented representation for modelling mobile objects in an aquatic environment , 2000, Int. J. Geogr. Inf. Sci..

[29]  Paul Harmon,et al.  Uml for Visual Basic 6.0 Developers: Using Visual Modeler and Rational Rose 98 , 1998 .

[30]  Y. Bédard.  VISUAL MODELLING OF SPATIAL DATABASES: TOWARDS SPATIAL PVL AND UML , 1999 .

[31]  Michael Zeiler.  Exploring ArcObjects : GIS by ESRI , 2001 .

[32]  Perry O. Hanson,et al.  THE TRAVEL-ACTIVITY PATTERNS OF URBAN RESIDENTS: DIMENSIONS AND RELATIONSHIPS TO SOCIODEMOGRAPHIC CHARACTERISTICS , 1981 .

[33]  Moshe Ben-Akiva,et al.  PII: S0965-8564(99)00043-9 , 2000 .

[34]  Carl Abbott,et al.  City profile: Portland, Oregon , 2002 .

[35]  P. Kanaroglou,et al.  AN ACTIVITY-EPISODE GENERATION MODEL THAT CAPTURES INTERACTIONS BETWEEN HOUSEHOLD HEADS: DEVELOPMENT AND EMPIRICAL ANALYSIS , 2002 .

[36]  Richard Healey,et al.  Simulation modelling with object-oriented GIS : a prototype application to the time geography of shopping behaviour , 1997 .

[37]  Yvan Bédard,et al.  Principles of spatial database analysis and design , 1999 .

[38]  M. McNally.  AN ACTIVITY-BASED MICROSIMULATION MODEL FOR TRAVEL DEMAND FORECASTING , 1996 .

[39]  Xiaoduan Sun,et al.  Household Travel, Household Characteristics, and Land Use: An Empirical Study from the 1994 Portland Activity-Based Travel Survey , 1998 .

[40]  Michael F. Goodchild,et al.  Extending geographical representation to include fields of spatial objects , 2002, Int. J. Geogr. Inf. Sci..

[41]  Grady Booch,et al.  Object-oriented analysis and design with applications (2nd ed.) , 1993 .