A MySQL-Based Software System of Urban Land Planning Database of Shanghai in China

With the development of the digital city,data and data analysis have become more and more important.The database is the foundation of data analysis.In this paper,the software system of the urban land planning database of Shanghai in China is developed based on MySQL.The conceptual model of the urban land planning database is proposed,and the entities,attributes and connections of this model are discussed.Then the E-R conceptual model is transformed into a logical structure,which is supported by the relational databasemanagement system(DBMS).Based on the conceptual and logical structures,by using Spring Boot as the back-end framework and using MySQL and Java API as the development tools,a platformwith datamanagement,information sharing,map assistance and other functions is established.The functionalmodules in this platformare designed.The results of J Meter test show that the DBMS can add,store and retrieve information data stably,and it has the advantages of fast response and low error rate.The software system of the urban land planning database developed in this paper can improve the efficiency of storing and managing land data,eliminating redundant data and sharing data.

An architecture for mobile database management system

In order to design a new kind of mobile database management system (DBMS)more suitable for mobile computing than the existent DBMS, the essence of database systems in mobilecomputing is analyzed. An opinion is introduced that the mobile database is a kind of dynamicdistributed database, and the concept of virtual servers to translate the clients' mobility to theservers' mobility is proposed. Based on these opinions, a kind of architecture of mobile DBMS, whichis of versatility, is presented. The architecture is composed of a virtual server and a local DBMS,the virtual server is the kernel of the architecture and its functions are described. Eventually,the server kernel of a mobile DBMS prototype is illustrated.

An OWL-Based Specification of Database Management Systems

In the context of a proliferation of DatabaseManagement Systems(DBMSs),we have envisioned and produced an OWL 2 ontology able to provide a high-level machine-processable description of the DBMSs domain.This conceptualization aims to facilitate a proper execution of various software engineering processes and database-focused administration tasks.Also,it can be used to improve the decision-making process for determining/selecting the appropriate DBMS,subject to specific requirements.The proposed model describes the most important features and aspects regarding the DBMS domain,including the support for various paradigms(relational,graph-based,key-value,tree-like,etc.),query languages,platforms(servers),plus running environments(desktop,Web,cloud),specific contexts—i.e.,focusing on optimizing queries,redundancy,security,performance,schema vs.schema-less approaches,programming languages/paradigms,and others.The process of populating the ontology with significant individuals(actual DBMSs)benefits from the existing knowledge exposed by free and open machine-processable knowledge bases,by using structured data fromWikipedia and related sources.The pragmatic use of our ontology is demonstrated by two educational software solutions based on current practices in Web application development,proving support for learning and experimenting key features of the actual semantic Web technologies and tools.This approach is also an example of using multiple knowledge from database systems,semanticWeb technologies,and software engineering areas.

A New Approach for Database Fragmentation and Allocation to Improve the Distributed Database Management System Performance

The efficiency and performance of Distributed Database Management Systems (DDBMS) is mainly measured by its proper design and by network communication cost between sites. Fragmentation and distribution of data are the major design issues of the DDBMS. In this paper, we propose new approach that integrates both fragmentation and data allocation in one strategy based on high performance clustering technique and transaction processing cost functions. This new approach achieves efficiently and effectively the objectives of data fragmentation, data allocation and network sites clustering. The approach splits the data relations into pair-wise disjoint fragments and determine whether each fragment has to be allocated or not in the network sites, where allocation benefit outweighs the cost depending on high performance clustering technique. To show the performance of the proposed approach, we performed experimental studies on real database application at different networks connectivity. The obtained results proved to achieve minimum total data transaction costs between different sites, reduced the amount of redundant data to be accessed between these sites and improved the overall DDBMS performance.

Database Management System Construction for the Evaluation Results of Intensive Land Use in the Development Areas of Hunan Province

Using spatial data integration and database technology,analyzing and integrating the assessment results in all the development zones at different time in Hunan Province,the paper is intended to construct the database and managerial system for the assessment results of land use intensity in development zones,thus formulating"one map"of Hunan Development zones and realizing the integrated management and application of the assessment results in all the development zones at any time of Hunan above the provincial level.It has been proved that the system has good application effect and promising development in land management for land management departments and development zones.

Version based spatial record management techniques for spatial database management system

The search operation of spatial data was a principal operation in existent spatial database management system, but the update operation of spatial data such as tracking are occurring frequently in the spatial database management system recently. So, necessity of concurrency improvement among transactions is increasing. In general database management system, many techniques have been studied to solve concurrency problem of transaction. Among them, multi version algorithm does to minimize interference among transactions. However, to apply existent multi version algorithm to improve concurrency of transaction to spatial database management system, the waste of storage happens because it must store entire version for spatial record even if only aspatial data of spatial record is changed. This paper has proposed the record management techniques to manage separating aspatial data version and spatial data version to decrease waste of storage for record version and improve concurrency among transactions.

GIS Database Template for Environmental Management of Mining in Indonesia

Mining sector in Indonesia faces many challenges including needed to support national economy, compliance to central and local government regulations, local community empowerment and environmental impact management. Mining companies are mandatory to perform the environmental management efforts to minimize the negative impact to the environment and pursue sustainability of post-mining land use and as much as possible to restore land to the initial conditions. There are many challenges on management multi parameter and multi temporal spatial data of environmental management. The aim of this research is to design the GIS database template for environmental management in Indonesia’s mining operation. This GIS database is designed using ArcCatalog ArcGIS 9.3 software, through following steps: inventory and assessment government regulations, inventory and assessment environmental quality standards, sorting and grouping parameters, design feature class and attribute, create GIS database, create GIS database dictionary. According to research result, GIS database template has many advantages for environmental management include integrated into a single database, avoid redundancy data, reduce volume data, uniformity data, easy to find and track data, integrated spatial and attribute data, can be used as an input for GIS analysis for decision-making and development strategies.

Design and Implementation of Highly Secure Residents Management System Using Blockchain

This article presents the design and implementation of highly secure and reliable database system for resident records management system using blockchain technology. Blockchain provides highly secure and reliable data access environment. In blockchain, several data fragments are packed into one block and all blocks are connected to form the chain of blocks. In our prototype, each event of resident such as birth, moving, employment and so on, is assigned to data fragment and certain amount of data fragment, says 20 fragments are packed into block. We also developed the web application interface to avoid installing any applications in users’ PC or smartphone. Prototype development proved the possibility to use the blockchain technology to large amount of data management system with highly secure and reliable features.

A Domain Engineering Approach to Increase Productivity in the Development of a Service for Changes Notification of the Configuration Management Database

This paper presents a domain engineering approach to build a software product line that supports the change notification service in a Configuration Management Database (CMDB) according to the Information Technology Infrastructure Library (ITIL) best practices. For the development of this product line, the proposed approach makes use of a construction of products methodology by analogy: this is a new notation which reports the variability of the products, obtaining metrics as important as the number of products and uses a language that enables, by means of the flexibilization of a product and the development of some generators, to build the rest of the product line. In addition the paper offers a standard for the analysis and design of the CMDB as well. Finally, the paper presents an economic model for the product line, where the profitability and productivity of the proposed solution are analyzed.

An Advanced Energy Management System

A brief outline of Energy Management System (EMS) in China is given and OPEN-2000 EMS, combined with the novel technique of computer science, is introduced. The system has been developed by Power System Control Division of NARI and put into operation in the middle of 1998.

Highly Secure Residents Life Event Management System Based on Blockchain by Hyperledger Fabric

This article describes the design and implementation of Residents Life Event Management System (hereinafter called as RLEMS) with high level reliability and security by blockchain technology. The data access environment provided by blockchain is highly secure and trustworthy. In Blockchain system, some data fragments are grouped into one piece called as blocks, and all blocks are connected to create a chain of blocks in database. When blocks are connected, hash value is used to connect blocks properly. Blockchain technology enables highly secure and reliable data management system under relatively poor ICT environment. For example, developing countries such as African countries do not have sufficient ICT environment. Therefore adopting blockchain technology is suitable for such countries. Based on this consideration, we have started to build RLEMS on the blockchain system. In previous work, we used the MultiChain as a blockchain platform. However, as MultiChain platform is mainly for private blockchain system, it is not suitable for government-level data management system. Therefore, we tried to use another blockchain framework. We selected Hyperledger Fabric which was developed by Linux Foundation. It enables to implement all styles of blockchain system. This article describes the design and implementation of RLEMS by using Hyperledger Fabric. Furthermore, to provide the best user experience, we also built the web application interface with Java web application framework named PrimeFace. The implementation of a prototype revealed that the Hyperledger Fabric blockchain technology is more suitable than MultiChain.

A regional environmental management information system for Chinese EPA—the system analysis and design

REMIS is one of key research projects sponsored by the central government. It is recommended to regional EPAs as a main tool of the environmental management. REMIS simulates the functions of the regional EPAs and aimed to improve their management level. The national environmental management information system will base on REMIS.Functional analysis is the kernel of the REMIS system analysis. Data and data flow analysis are used to support the functional analysis.Investigations on the functions of the local EPAs of eight provinces and 12 cities have been taken. The functions were carefully sorted. Modular design method was used in system analysis and system design.The system analysis included functional analysis, data analysis and data flow analysis. The system design is based on the system analysis. HIPO diagram of each modular, data base structure, menu design, selection of hardware and software environment were the main items of the system design.

A MAPPING APPROACH TO RESOLVING SCHEMA INCOMPATIBILITY IN A FEDERATED DATABASE SYSTEM

Schema incompatibility is a major challenge to a federated database systemfor data sharing among heterogeneous,multiple and autonomous databases.This paperpresents a mapping approach based on import schema,export schema and domain conver-sion function,through which schema incompatibility problems such as naming conflict,domain incompatibility and entity definition incompatibility can be resolved effectively.The implementation techniques are also discussed.

System View of Product Data Management and Its Application

A product data management system for a manufacturing enterprise is to make sure that the proper product data can be communicated to the right people at the right time.This paper describes a system analysis paradigm for data analysis in a product data management(PDM)development.Three aspects of the paradigm,i.e.,function,structure and behavior are rep- resented.The use of the paradigm explains why so many kinds of objects are necessary in a commercial database matrix and what models are available for developing a PDM application.As another result,a lot of models are derived from the analysis of product data system paradigm to model product data and PDM database definitions.

Building a Database for the Future:Humans and Lakes within Ecosystems

1 Introduction Fresh or saline,lakes constantly exchange with other water bodies on the Earth.Together,they form a crucial part of the water cycle–one of the most important ecosystem functions supporting humans and other biological communities.Lakes have provided invaluable and irreplaceable ecosystem services(benefits)for the

Security Research on Engineering Database System

Engine engineering database system is an oriented C AD applied database management system that has the capability managing distributed data. The paper discusses the security issue of the engine engineering database management system (EDBMS). Through studying and analyzing the database security, to draw a series of securi ty rules, which reach B1, level security standard. Which includes discretionary access control (DAC), mandatory access control (MAC) and audit. The EDBMS implem ents functions of DAC, MAC and multigranularity audit. DAC solves the problems o f role inheritance, right contain, authorization identify and cascade revoke, et c; MAC includes subject and object security setup rule, security modify rule and multilevel relation access operation rule, etc; Audit allows making the sub ject, object or operation type as different audit object to implement flexible a nd multigranularity audit method. The model is designed act as a security agent to access daemon database. At present, the model is implemented which runs on th e Windows 2000 environments.

A Proposal for a Geospatial Database to Support Emergency Management

The basic procedure of the Italian Civil Protection Department aims at reducing disaster losses by giving prominence to a proactive strategy, focusing on prevision and prevention of hazard events rather than postdisater activities. Italian law commits municipalities to produce Emergency Plans that include risk scenarios as well as all data required for emergency management, such as structures, infrastructures and human resources. However the law in the matter of Civil Protection does not supply information about how to produce and archive necessary data for emergency planning and management. For this reason, we propose a standard methodology to create a geodatabase using GIS software, to collect all data that could be used by municipalities to create Emergency Plans. The resulting geodatabase provides a tool for hazard mitigation planning, allowing not only the identification of areas at risk, but also the structures, infrastructures and resources needed to overcome a crisis, thus improving all strategies of risk reduction and the resilience of the system [1].

Research and Development on the Visualization System for Official and Scientific Management in Enterprise

A visualization system for the official and scientific management has been designed on C++. By this system, the information of database has been shown to users intuitively, which makes it possible for users to be free from the data sea. The system can realize the information mining and the integrated display, at the same time, improve the information’s constructive level and integration degree.

Building Urban Land Information Management System in PostgreSQL,for the Case of Ethiopia

Population growth and rapid urbanization have caused an exponential increase in urban land demand in Ethiopia.The information required for land administration and management has been tremendously increasing as well.Therefore,this paper describes the steps for a building database prototype for urban land information management system for the case of Ethiopia which results to develop an efficient and effective way of spatial and non-spatial urban land data management system.This research project will develop a central database system using a PostgreSQL software to retrieve,update and store the required data using a user-friendly graphical interface.System requirement and specification is devoted to a system design which incorporates the intended system behaviour using a use case diagram,logical design of the system using a class diagram.The design system is validated and tested via sample data which can store,retrieve,and update the required data as per the user requirement.Developing this type of urban land information management system,therefore,facilitates and increases the efficiency of land registration and related activities at the municipality level.Thence,citizens would be satisfied by the service delivery of the municipality.The land and real estate ownerships registration will also become automated.Furthermore,any spatial and non-spatial data related with the system can be stored in the database which will be ready for more analysis as to be able to use by policymakers,urban planners for the purpose of sustainable development of urban area infrastructural developments and land use policy.The research will lay ground for another task to develop CityGML 3D modelling for selected cities thereby contributes to spatial data infrastructure development to Ethiopia.