Indexing
All Issues
Submission
Author Guidelines
Reviewers
Editorial Members
Publication Fee
Vol.2 , No. 2, Publication Date: Apr. 25, 2015, Page: 15-22
| [1] | Hagahmoodi S. O., Computer Science Department, College of Computer Science and Software Engineering, University of Hail, Hail City, Saudi Arabia. |
The City of Hail is one of the ancient cities in the Kingdom of Saudi Arabia; just more recently City of Hail experience a dramatic change in urban growth to become a world city class, a number of development’s projects now are under construction at both infrastructure and urban services; these fast development of the city attracted peoples to migrate from rustic area to stay in Hail, these migration possess the planners to provide adequate urban services and better management of the city. An excellent management of the city and urban development to fulfill the people’s requirements in Hail City depend on the timeous analysis of urban planning data. The analysis and process of urban data face a number of problems, in particular relating to the storage and integrative processing of large spatial and non-spatial datasets from various sources and different formats, data types, and multi-dimensional locations. These problems complicate database structure and design, algorithm operations, relationships, and require data types that joined the spatial and non-spatial in seamless manor, providing ad hoc queries, and as well as offering a practical visualization of the urbandata. The current database system used by planners in the City of Hail is characterized by limited data types, isolated spatial and non-spatial data, and a lack of ad hoc queries. Thus, it is limited in managing complex applications and queries, combining various objects, and providing sufficient information. The system omits one of the most important steps in creation and implementation of an effective database, namely the schema design. A database design schema should be preceded by determination of user requirements. The proposed system is expected to provide a number of tools for data storage, analysis of spatial and non-spatial datasets with visualization representation adequate enough to support decision making in urban planning and development.
Keywords
Urban Planning, Database, Spatial, Non-Spatial, Visualization, Data, Dataset
Reference
| [01] | Bennett, S., McRobb, S. and Farmer, R., 1999: Object-oriented Systems Analysis and Design using UML, McGraw-Hill Publishing Company, London, UK. |
| [02] | Blaha, M. and Premerlani, W., 1998: Object-oriented Modelling and Design for Database Applications. Prentice Hall. USA. |
| [03] | Connolly, T. and Begg, C., 2005: Database Systems; APractical Approachto Design, Implementation, and Management, (Fourth edition), Addison-Wesley, USA. |
| [04] | En.wikipedia.org/wiki/Hail; October 2013. |
| [05] | Egenhofer, J. M. and Frank, V. A., 1992: Object-oriented Modelling for GIS, Journal of Urban and Regional Information System Association, 4, 2, 3-19. |
| [06] | ESRI, 2004a: ArcGIS: Using ArcMap, ESRI, USA. |
| [07] | ESRI, 2004b: ArcGIS®9.x:,UsingArcCatalogTM, Redlands, CA, USA. |
| [08] | Fowler, M., 2000:UML Distilled: A Brief Guide to the Object-Oriented Design, Prentice-Hall, USA |
| [09] | Günther, O. and Lamberts, J., 1994: Object-Oriented Techniques for the Management of Geographic and Environmental Data, The Computer Journal, 37, 1, 16-25. |
| [10] | Hagahmoodi, S. O., 2010: The Use of Software Engineering Technique to Develop a GIS-Based System for Infrastructure Asset. Proceeding ACRS2010 conference, Hanoi, Vietnam. |
| [11] | Hagahmoodi, S. O., Ahmed, F., and Hill, T. R., 2007:User Requirements Analysis and the Design of an Object-oriented Spatial Database for Multi-purpose Planning: Durban Metro, South Africa. Proceeding ACRS2007 conference, Kuala Lumpur, Malaysia. |
| [12] | Henderson, B., and Edwards, J. M., 1994: Book Two of Object-oriented Knowledge: Working Object, Prentice-Hall, Australia. |
| [13] | Hoffer, J. A., George, J. F. and Valacich, J. S., 2002a: Modern Systems Analysis and Design, (Third edition), Prentice Hall, USA. |
| [14] | Hoffer, J. A., Prescott, M. B. and McFadden, F. R., 2002b: Modern Database Management, (sixth edition), Prentice Hall, New Jersey, USA. |
| [15] | Jacobson, I. M., Christerson, P. J. and Overgaard, G., 1992: Object-Oriented Software Engineering: AUse-Case Driven Approach, Addison-Wesley, USA. |
| [16] | Kyariga, A. T., 2001: GIS as a Decision Making tool for Urban Planning and Management: A Practical case of Tanzania, CORP, Vienna University of Technology, 103-106. |
| [17] | Laurini, R., 2001:Information System for Urban Planning: A hypermedia Co-Operative Approach, Taylor and Francis, London, UK. |
| [18] | Otair, M., 2013: Effectively and Efficiency Consideration for Spatial Database: International Journal of Computer Application, Vol 74 No. 7/2013, pp 32-37. |
| [19] | Velicanu, A., and Olaru, S., 2010: Optimizing Spatial Databses: Informatica Economica Vol. 14, no. 2/2010 pp 61-71. |
