Skip to main content

LUP Student Papers

LUND UNIVERSITY LIBRARIES

Constructing and developing an integrated smart spatial database for Malmö Municipality : case study : Västra innerstaden in Malmö

Alavi, Sayed Hassan LU (2018) In Student thesis series INES NGEM01 20171
Dept of Physical Geography and Ecosystem Science
Abstract
GIS Section of Street and Park department of Malmö Municipality continuously receives new spatial data from different contractors that need to be saved to the GIS section traffic database. Due to spatial relationships and daily updates of traffic database, it is evident that the traffic database requires more consistency and integration in an automatic way.
Since there is a spatial and conceptual relationship between the data, making a change in the traffic database and failing to make appropriate changes to other related features will eliminate the integrity of the data and the logical relationship of the data. Making appropriate changes manually are very hard and time-consuming. Thus, it is necessary to devise a mechanism, which update... (More)
GIS Section of Street and Park department of Malmö Municipality continuously receives new spatial data from different contractors that need to be saved to the GIS section traffic database. Due to spatial relationships and daily updates of traffic database, it is evident that the traffic database requires more consistency and integration in an automatic way.
Since there is a spatial and conceptual relationship between the data, making a change in the traffic database and failing to make appropriate changes to other related features will eliminate the integrity of the data and the logical relationship of the data. Making appropriate changes manually are very hard and time-consuming. Thus, it is necessary to devise a mechanism, which update database automatically. For this purpose, it is needed to understand different techniques for implementing a smart database and selecting one for implementation based on possibilities and capabilities of GIS section.
Triggers, which are written using the SQL programming language for the traffic database, are used to apply the essential rules to the traffic database to make the traffic database smart. Using triggers, one can run a set of SQL commands with every change in the traffic database, which increase the consistency, integrity and attribution of the quantities automatically in the traffic database. However, using triggers has some disadvantages such as loop of triggers. To get rid of this problem in the traffic database, the iTRIMAN user interface is designed and implemented in a desktop and a web version. iTRIMAN allows triggers to be created on the traffic database when needed and to be dropped when they are not needed. (Less)
Popular Abstract
The smartness of a database can accelerate the work, make high-quality database and decrease the cost of updating. This smart database can understand the smallest changes and apply appropriate responses to the changes. By applying any change in the database, all dependent information is automatically updated and manual editing is not required.
This research is provided for the GIS section of Street and Park Department of Malmö Municipality. In this study, different methods of creating a smart database, tailored to the requirements of the GIS section, are studied. Then a method is selected which is according to the facilities and needs of GIS section. Eventually a pilot database is created in the traffic area, which is called the Traffic... (More)
The smartness of a database can accelerate the work, make high-quality database and decrease the cost of updating. This smart database can understand the smallest changes and apply appropriate responses to the changes. By applying any change in the database, all dependent information is automatically updated and manual editing is not required.
This research is provided for the GIS section of Street and Park Department of Malmö Municipality. In this study, different methods of creating a smart database, tailored to the requirements of the GIS section, are studied. Then a method is selected which is according to the facilities and needs of GIS section. Eventually a pilot database is created in the traffic area, which is called the Traffic Database.
Active Database method has been selected to create a smart database. Triggers have the most important role in the active database. By using triggers can detect any changes in the database and then make the necessary updates to the database. In other words, with any change in a table of the database, the trigger of that table is activated and makes the necessary updates according to predefined rules. For a better use of triggers, the iTRIMAN interface is designed to handle the triggers management. Finally, the database produced from this research has high data quality and high speed updates. (Less)
Please use this url to cite or link to this publication:
author
Alavi, Sayed Hassan LU
supervisor
organization
alternative title
Creating spatial smart database for Malmö Municipality
course
NGEM01 20171
year
type
H2 - Master's Degree (Two Years)
subject
keywords
Physical Geography and Ecosystem analysis, GIS section of street and park department of Malmö Municipality, consistency, integration, iTRIMAN, traffic database, smart database, geomatics
publication/series
Student thesis series INES
report number
446
language
English
id
8942883
date added to LUP
2018-05-28 15:45:48
date last changed
2018-05-28 15:45:48
@misc{8942883,
  abstract     = {{GIS Section of Street and Park department of Malmö Municipality continuously receives new spatial data from different contractors that need to be saved to the GIS section traffic database. Due to spatial relationships and daily updates of traffic database, it is evident that the traffic database requires more consistency and integration in an automatic way.
Since there is a spatial and conceptual relationship between the data, making a change in the traffic database and failing to make appropriate changes to other related features will eliminate the integrity of the data and the logical relationship of the data. Making appropriate changes manually are very hard and time-consuming. Thus, it is necessary to devise a mechanism, which update database automatically. For this purpose, it is needed to understand different techniques for implementing a smart database and selecting one for implementation based on possibilities and capabilities of GIS section.
Triggers, which are written using the SQL programming language for the traffic database, are used to apply the essential rules to the traffic database to make the traffic database smart. Using triggers, one can run a set of SQL commands with every change in the traffic database, which increase the consistency, integrity and attribution of the quantities automatically in the traffic database. However, using triggers has some disadvantages such as loop of triggers. To get rid of this problem in the traffic database, the iTRIMAN user interface is designed and implemented in a desktop and a web version. iTRIMAN allows triggers to be created on the traffic database when needed and to be dropped when they are not needed.}},
  author       = {{Alavi, Sayed Hassan}},
  language     = {{eng}},
  note         = {{Student Paper}},
  series       = {{Student thesis series INES}},
  title        = {{Constructing and developing an integrated smart spatial database for Malmö Municipality : case study : Västra innerstaden in Malmö}},
  year         = {{2018}},
}