The Development of a Database Management in GIS Applications in Oman

The development of applying database management applications is currently underway within Geographical Information Systems (GIS) applications in the Sultanate of Oman.The establishment of a national database management system in Oman is considered as the backbone that is required within the Geographic Information System project in Oman. The principal of the GIS project in Oman was built upon unifying the used software packages over the sultanate which is ARC/INFO as GIS Package and ORACLE as database management software. These packages are used within the different participating Ministries in the GIS project in Oman.The participating ministries will handle information that are shared between them. The shared information among the different ministries is the attributed data which is defined as descriptive information extracted from geographic features that usually existed on the topographic maps and the ministries maps (utility maps). The map features can be classified into different layers according to the principles of ARC/INFO GIS Package. Accordingly, the main objectives of this research paper is to explain the technique proposed for establishing a national database management system that can handle and manage the shared information amongst the participating ministries in the project. The proposed database design will be made using the ORACLE database management system. Moreover, the paper will handle a proposed idea for linking the geographic map layers with the corresponding attributed database in order to create Geographic Information System applications. As a Conclusion, it is Proposed that all the government GIS departments in the Sultanate will share the same information within a unique national database management which can be considered one of the major benefits in applying database management in the field of Geographic Information Systems.

Download Full-text

Geographic Information Systems

Utilizing Decision Support Systems for Strategic Public Policy Planning - Advances in Public Policy and Administration ◽

10.4018/978-1-7998-1916-5.ch008 ◽

2020 ◽

pp. 122-138

Keyword(s):

Information System ◽

Information Systems ◽

Geographic Information System ◽

Geographic Information Systems ◽

Computer System ◽

Management System ◽

Database Management ◽

Geographic Information ◽

Database Management System

The chapter presents the geographic information systems. A geographic information system (GIS) is a computer system that allows various sources to gather and organize, manage, analyze and combine, develop, and present geographically located information contributing in particular to the management from space. A geographic information system is also a database management system for entering, storing, retrieving, querying, analyzing, and displaying localized data. It is a set of data located in space, structured so that it can conveniently extract syntheses useful to the decision.

Download Full-text

Development of Bridges Maintenance Management System based on Geographic Information System Techniques (Case study: Al-Muthanna \ Iraq)

Journal of Engineering ◽

10.31026/j.eng.2020.09.09 ◽

2020 ◽

Vol 26 (9) ◽

pp. 137-154

Author(s):

Saif Abdul ameer Aattan ◽

Maythm Al-Bakri

Keyword(s):

Information System ◽

Geographic Information System ◽

Spatial Data ◽

Management System ◽

Satellite Image ◽

Geographic Information ◽

Database Management System ◽

Maintenance Management ◽

Attribute Data ◽

Colour Image

A Geographic Information System (GIS) is a computerized database management system for accumulating, storage, retrieval, analysis, and display spatial data. In general, GIS contains two broad categories of information, geo-referenced spatial data and attribute data. Geo-referenced spatial data define objects that have an orientation and relationship in two or three-dimensional space, while attribute data is qualitative data that can be counted for recording and analysis. The main aim of this research is to reveal the role of GIS technology in the enhancement of bridge maintenance management system components such as the output results, and make it more interpretable through dynamic colour coding and more sophisticated visualization techniques than the conventional tabular data format. To achieve the main objective of this research, two study areas have been chosen: the old constructionbridge (Al-Qadisiyah bridge) and the newly constructed bridge (Barboty bridge). Both of them are in Al-Muthanna city \ Iraq. The data collection process was achieved in two stages: the first stage is providing a georeferenced satellite image for each study area for the purpose of producing a two-dimensional map. The second stage includes the field surveying process by total station and level instruments. GIS have been used to create a comprehensive database (Geodatabase) for both study areas. Geostatistical analysis was carried out in which the settlement areas of both study areas were defined by producing a colour image. The statistical tables for these analyses showed that the highest decline in the elevation reached at Al-Qadisiyah bridge to 19 mm in the middle of the bridge which is coloured as a red areas. On the other hand, it was found that the highest decline in the elevation of the Barboty bridge is 16 mm in the last part of steel space which is also coloured as a red areas.

Download Full-text

Development of Bridges Maintenance Management System based on Geographic Information System Techniques

Journal of Engineering ◽

10.31026/j.eng.2019.07.02 ◽

2019 ◽

Vol 25 (7) ◽

pp. 21-36

Author(s):

Saif Abdul Ameer Wattan ◽

Maythm Al-Bakri

Keyword(s):

Information System ◽

Geographic Information System ◽

Spatial Data ◽

Management System ◽

Satellite Image ◽

Geographic Information ◽

Database Management System ◽

Maintenance Management ◽

Attribute Data ◽

Colour Image

A Geographic Information System (GIS) is a computerized database management system for accumulating, storage, retrieval, analysis, and display spatial data. In general, GIS contains two broad categories of information, geo-referenced spatial data and attribute data. Geo-referenced spatial data define objects that have an orientation and relationship in two or three-dimensional space, while attribute data is qualitative data that can be counted for recording and analysis. The main aim of this research is to reveal the role of GIS technology in the enhancement of bridge maintenance management system components such as the output results, and make it more interpretable through dynamic colour coding and more sophisticated visualization techniques than the conventional tabular data format. To achieve the main objective of this research, two study areas have been chosen: the old construction bridge (Al-Qadisiyah bridge) and the newly constructed bridge (Barboty bridge). Both of them are in Al-Muthanna city \ Iraq. The data collection process was achieved in two stages: the first stage is providing a georeferenced satellite image for each study area for the purpose of producing a two-dimensional map. The second stage includes the field surveying process by total station and level instruments. GIS have been used to create a comprehensive database (Geodatabase) for both study areas. Geostatistical analysis was carried out in which the settlement areas of both study areas were defined by producing a colour image. The statistical tables for these analyses showed that the highest decline in the elevation reached at Al-Qadisiyah bridge to 19 mm in the middle of the bridge which is coloured as a red area. On the other hand, it was found that the highest decline in the elevation of the Barboty bridge is 16 mm in the last part of steel space which is also coloured as a red area.

Download Full-text

adronização da Informação Geográfica e Metadados Geoespaciais Digitais

GEOgraphia ◽

10.22409/geographia2002.v4i7.a13424 ◽

2009 ◽

Vol 4 (7) ◽

pp. 65

Author(s):

Gilberto Pessanha Ribeiro

Keyword(s):

Information Systems ◽

Geographic Information Systems ◽

Management System ◽

Database Management ◽

Geographic Information ◽

Database Management System ◽

Management Systems ◽

Abstract Objects ◽

Metadata Management ◽

De Se

RESUMO Um sistema gerenciador de banco de dados pode possuir uma extensão de um banco de dados voltada para o armazenamento e recuperação de metadados baseados em objetos abstratos. O objetivo deste trabalho é alcançar um entendimento melhor dos requisitos básicos para um gerenciador de metadados. operar satisfatoriamente, além de testar ao máximo um modelo de armazenamento avaliando o seu desempenho, diante dos diversos tipos de dados geográficos existentes. O trabalho aponta a necessidade de se conhecer melhor o desempenho de sistemas já desenvolvidos, ou em desenvolvimento, com objetivos de gerenciar metadados geográficos digitais. Palavras-chave: Sistemas de Informação Geográfica, Geoprocessamento, Geografia, Bancos de Dados, Computação.ABSTRACT Database management systems can be design with an extended database in order to store and retrieve metadata based on abstract objects. The target of this paper is a better understanding of basic requirements to this database management system operates satisfactorily, above all to test at best a model to store, analysing your performance, in front of several types of existing geographic data. The aim of this paper is to show some needs to know developed systems performance, or in developing, which purpose is digital geographic metadata management. Keywords: Geographic Information Systems, Geoprocessing, Geography, Databases, Computation.

Download Full-text

Database Reverse Engineering

Handbook of Research on Innovations in Database Technologies and Applications ◽

10.4018/978-1-60566-242-8.ch021 ◽

2009 ◽

pp. 181-189 ◽

Cited By ~ 4

Author(s):

Jean-Luc Hainaut ◽

Jean Henrard ◽

Didier Roland ◽

Jean-Marc Hick ◽

Vincent Englebert

Keyword(s):

Information System ◽

Information Systems ◽

Reverse Engineering ◽

Management System ◽

Database Management ◽

Database Management System ◽

Data Intensive ◽

Business System ◽

Data Files ◽

Legacy Information Systems

Database reverse engineering consists of recovering the abstract descriptions of files and databases of legacy information systems. A legacy information system can be defined as a “data-intensive application, such as [a] business system based on hundreds or thousands of data files (or tables), that significantly resists modifications and changes” (Brodie & Stonebraker, 1995). The objective of database reverse engineering is to recover the logical and conceptual descriptions, or schemas, of the permanent data of a legacy information system, that is, its database, be it implemented as a set of files or through an actual database management system.

Download Full-text

Geographic Information System Applications in the Public Sector

Modern Public Information Technology Systems ◽

10.4018/978-1-59904-051-6.ch015 ◽

2011 ◽

pp. 293-311

Author(s):

Douglas A. Carr ◽

T. R. Carr

Keyword(s):

Decision Making ◽

Information System ◽

Information Systems ◽

Geographic Information System ◽

Geographic Information Systems ◽

Geographic Information ◽

Management Decision ◽

Public Managers ◽

Gis Applications ◽

Management Decision Making

Geographic information systems emerged in the 1970s and have become a significant decision-making tool as their capabilities have been enhanced. This chapter discusses various GIS applications and highlights issues that public managers should consider when evaluating implementation of a geographic information system. GIS applications provide benefits at the planning level by producing maps efficiently, and at the management decision-making level through an ability to geographically display important information for policy-level decisions. While GIS analysis can be a powerful tool, there are a number of issues that pubic managers should consider in order to achieve effective implementation and use of geographic information systems.

Download Full-text

DATA VISUALIZATION FOR PIG HERDS IN TRA VINH PROVINCE BASED ON GEOGRAPHIC INFORMATION SYSTEM (GIS)

Scientific Journal of Tra Vinh University ◽

10.35382/18594816.1.1.2019.85 ◽

2019 ◽

Vol 1 (1) ◽

pp. 37-41

Author(s):

Quoc Khac Nguyen ◽

Sang Van Nguyen

Keyword(s):

Information System ◽

Statistical Analysis ◽

Geographic Information System ◽

Open Source ◽

Data Visualization ◽

Database Management ◽

Processing Map ◽

Geographic Information ◽

Database Management System ◽

Map Data

Building a system of data visualization of pig herds in Tra Vinh province based on GIS (Geographic Information System) will help management agencies update, do statistical analysis of and forecast the fluctuation in pig herds within the provincial area. Since then, pig farmers will have reliable information, which canmake their investment more efficient. The system is built on the WebGIS platform combining solutions for processing map data with PostGIS - an extension of PostgreSQL database management system to manage GIS objects. Additionally, the system will also provide solutions to handle and share pig herd data on the map with Geoserver - an open source server with the aim of connecting geographic information from PostGIS to Geoweb.

Download Full-text

Databases and Information Systems

Advances in Business Information Systems and Analytics - Automated Enterprise Systems for Maximizing Business Performance ◽

10.4018/978-1-4666-8841-4.ch008 ◽

2016 ◽

pp. 123-149

Author(s):

Nazih Heni ◽

Habib Hamam

Keyword(s):

Information System ◽

Information Systems ◽

Management System ◽

Database Management ◽

Database System ◽

Database Management System ◽

Modern Business ◽

Efficient Information ◽

System Information ◽

Technological World

In this recent technological world, it is necessary that we get accustomed to all types of advanced technological techniques. In the process, we are becoming more aware about database and information system. But what is database system information? The Database Management System which works through the storing of data can be used any time. The importance of database and information Systems in modern business is inevitable. In this chapter, we define Information Systems by its categories of Information System, type and the usefulness for efficient Information System. Then, we will proceed to explaining the management of information systems by taking a short look at its history and list some of its domains of application. After that, we define the relation between Information Systems and database. Finally, we will explore the problem of storage and some issues related to information systems and databases.

Download Full-text

adronização da Informação Geográfica e Metadados Geoespaciais Digitais

GEOgraphia ◽

10.22409/geographia2002.47.a13424 ◽

2009 ◽

Vol 4 (7) ◽

pp. 65

Author(s):

Gilberto Pessanha Ribeiro

Keyword(s):

Information Systems ◽

Geographic Information Systems ◽

Management System ◽

Database Management ◽

Geographic Information ◽

Database Management System ◽

Management Systems ◽

Abstract Objects ◽

Metadata Management ◽

De Se

Download Full-text

Pemodelan UML Sistem Informasi Geografis Pasar Tradisional Kota Pekanbaru

Digital Zone Jurnal Teknologi Informasi dan Komunikasi ◽

10.31849/digitalzone.v7i2.600 ◽

2016 ◽

Vol 7 (2) ◽

pp. 89-99

Author(s):

Sutejo Sutejo

Keyword(s):

Information System ◽

Information Systems ◽

Geographic Information System ◽

Geographic Information Systems ◽

Unified Modeling Language ◽

Geographic Information ◽

Web Based ◽

Traditional Markets ◽

Traditional Market ◽

Future Events

Abstrak- Dunia sistem informasi terdapat banyak model sistem informasi, kaitan pasar dengan sistem informasi geografis adalah untuk memberikan berbagai macam informasi, terutama letak geografis pasar tersebut. Pentingnya informasi ini memberi banyak inspirasi terhadap pembuat model untuk merancang sistem-sistem yang mendekati dunia nyata. Model sistem informasi juga diharapkan dapat digunakan sebagai alat prediksi kejadian di masa depan dengan mendasarkan pada data yang ada pada masa lalu dan masa sekarang. Sistem Informasi Geografis (SIG) ini di rancang untuk mengumpulkan data, meyimpan dan mengubah data, serta menganalisis objek beserta data geografis yang bersifat penting untuk di analisis. GIS yang disajikan dengan berbasis web pada perancangan ini juga dapat digunakan sebagai alat pemberian informasi kepada masyarakat luas. Hasil penelitian dengan pemodelan UML (Unified Modelling Language) sangat membantu dalam proses perancangan sebuah sistem informasi geografis pasar tradisional serta aplikasi sistem informasi geografis pasar tradisional berbasis web ini dapat digunakan sebagai sarana informasi pasar, khususnya bagi para calon pedagang yang ingin berdagang di salah satu pasar tradisional yang ada di Kota Pekanbaru. Kata Kunci : Sistem Informasi Geografis, Web, Pasar Tradisional, Pemodelan, UML. Abstract- The world of information systems provides many models of information systems, the link of market with a geographic information system is to provide various kinds of information, specially the geographical markets. The importance of this information gives a lot of inspiration for the model makers to design systems that approximates the real world. Model of information system is also expected to be used as predictors of future events by basing on the existing data on past and present. Geographic Information Systems (GIS) is designed to collect data, store and modify data, and analyzing object along with geographic data which is important for analysis. GIS is presented with a web based on this design can also be used as a tool to provide information to the general public. The results of research by modeling UML (Unified Modeling Language) is very helpful in the process of designing a geographic information system of traditional markets as well as the application of geographic information system web-based traditional market can be used as a means of market information, especially for potential traders who want to trade in one of the traditional markets in the city of Pekanbaru. Keywords: Geographic Information Systems, Web, Traditional Market, Modeling, UML.

Download Full-text