Design Of Database System Research Articles

Design and Realization of 3S Technology-Based Geological Disaster Database System in Liaoning Province

This paper absorbs much successful experience from geological disasters database system designed and built at home and abroad, based on remote sensing (RS), geographic information systems (GIS) and GPS technology, adopt AHP, fuzzy comprehensive evaluation model and method of establishing three-dimensional model of geological disasters in high-risk areas, the paper constructs geological disasters database system in Liaoning Province, this database system can manage and monitor geological disasters and provide strong support analysing geological disasters for Liaoning province areas.

A Study on the Data Design of Residents Electronic Health Records System

Residents' health records is different from general hospital medical records, because it is not just about people receive medical service records, or a continuous, sustained, long-term, comprehensive, more extensive information about health information. This article according to the actual situation to the residents of electronic health records system database design are analyzed, and the residents' information table, the doctor information table, a medical information table, health file information table, travel information table and announcement information table 6 design of basic data table made a specific description.

Building efficient query engines in a high-level language

In this paper we advocate that it is time for a radical rethinking of database systems design. Developers should be able to leverage high-level programming languages without having to pay a price in efficiency. To realize our vision of abstraction without regret , we present LegoBase, a query engine written in the high-level programming language Scala. The key technique to regain efficiency is to apply generative programming: the Scala code that constitutes the query engine, despite its high-level appearance, is actually a program generator that emits specialized, low-level C code. We show how the combination of high-level and generative programming allows to easily implement a wide spectrum of optimizations that are difficult to achieve with existing low-level query compilers, and how it can continuously optimize the query engine. We evaluate our approach with the TPC-H benchmark and show that: (a) with all optimizations enabled, our architecture significantly outperforms a commercial in-memory database system as well as an existing query compiler, (b) these performance improvements require programming just a few hundred lines of high-level code instead of complicated low-level code that is required by existing query compilers and, finally, that (c) the compilation overhead is low compared to the overall execution time, thus making our approach usable in practice for efficiently compiling query engines.

Communication Principle of Literature Database Based on Spatial and Temporal Segmentation Technology

In this paper we introduce cross tree and block mathematical principles into the design of database system, divide the time sequence and storage space of computer database system, establish the mathematical model and algorithm of computer resources database system, and design the test database system. In this paper, we use high performance interface of Display Port, by way of coupling to communicate on two port control, and use RHEL 6.2 Linux virtual machine to do simulation experiment on process of database system. Through the simulation we find the API which is called by Read, Close, Mmap, Stat, Fstat is similar. It is consistent with the actual situation, and verifies the reliability of the program. Finally, we apply the database system to the network database construction of sports literature resources in the new town of Poyang Lake area. It reaches the effect that sport resources are shared by all. It provides technical support for the application of computer database system.

Design and Development of Database and Automatic Speech Recognition System for Travel Purpose in Marathi

Past research in mathematics, acoustics, and speech technology have provided many methods for converting data that can be considered as information if interpreted correctly. In order to find some statistically relevant information from data, it is important to have mechanisms for reducing the information of each segment in the audio signal into features. These features should describe each segment in such a characteristic way that other similar segments can be grouped together by comparing their features. Preprocessing of speech signals is considered a crucial step in the development of a robust and efficient speech or speaker recognition system. This paper deals with result obtained by MFCC and LPC feature extraction technique and SVM feature matching technique.

Model Telediagnosis Serangan Jantung untuk Para Praktisi Kesehatan Menggunakan Mobile Phone

The lack of medical experts such as doctors at rural areas resulted in some problems such as the high cost of medical care and low service of doctors and medical resource provider. The conditions results in an idea to implement a communication system between rural medical practitioners and doctors in urban areas to perform remote diagnosis on patients (telediagnosis). The research involves several parties such as doctors, health centers, health practitioners (paramedics), patients, and hospitals and health institutions. The telediagnosis system development consists of the construction of a software application prototype as media input for patient data which will be sent to doctors at town, database systems design, integration of basic multimedia devices, medical diagnostic device integration, and application testing of telediagnosis performance using an android-based mobile application. Data integration patterns include patient data delivery patterns, checking a patient's diagnosis, saving and continuing to the physician or health care practitioner with real-timesystem. This study is conducted according to standard research stages: problem collection, problem analysis, research materials collection, research design, and research implementation. Telediagnosis system is used to facilitate remote diagnosis of patients at rural areas which is able to serve patients more quickly, and helps find out nearest location for patients to get medicines as well as recommendation of nearest hospital. This system helps decrease the workload of hospitals.

선진화된 하천측량자료 활용 및 관리를 위한 하상변동 자료관리 프로그램 기반의 하도유지관리체계 개선에 관한 연구

ABSTRACT The systematic management of river is difficult due to various environmental factors such as season and terrain deformation. Especially, river terrain are rapidly changing by natural and anthropogenic factors such as torrential rain during the summer and river development projects. Thus in this conditions, building the advanced river management system is an essential condition to support the ongoing management of survey data and to acquire data regularly through river terrain survey in order to maintain an active river. The need to build an efficient system have been increased through the enhancement and advancement of River Management Geographic Information Systems(RIMGIS). In this study, database design system and Riverbed Change Data Management Program was developed for systematic management of new river terrain survey data and the efficient use of river data dynamic changes. The key features are construction of river survey data, cross and longitudinal section monitoring and analysis of riverbed change data. Maintenance tasks which can be utilized in river-based architecture was constructed. The expected results are to be able to manage river systematically, and utilization of river topographic survey data efficiently for river maintenance work.KEYWORDS : Bathymetry Data, River-bed Change, Data Management, DB Design, RIMGIS

The Design and Realization of Mineral Resources Management Information System Based on GIS

The traditional means of mineral resource management is backward, to this problem, The paper put forwards the mineral resource management information system based on GIS , the system is established by GIS and database technology. From the following aspects discuss the design and realization of the system , such as system requirement analysis, the design of system database and function modules,the realization of the system function,The system can effectively improve the management level and lay a foundation for mineral resources information.

Research on Based on Encrypted Database System Design

Research on Based on Encrypted Database System Design

Cluster Detection Analysis Using Fuzzy RelationalDatabase

In order to handle imprecise and ambiguous information, the application of fuzzy set theory for the design of database, information storage and retrieval systems has been gaining popularity recently. This paper gives emphasis on the basic characteristics of fuzzy relational databases, their properties, along with the data clustering in database systems. Indian premier league dataset has been considered for the detection of clusters. Several clustering parameters like centroid, radius and Manhattan distance measure have been applied. The definition of clusters as well as the membership function has been implemented using PL/SQL. The results obtained from Indian premier league batting statistics dataset detect two clusters, namely Cluster 1 and Cluster 2. Finally, this article proposed a fuzzy database organization and clustering of records which provides efficient and accurate fuzzy retrieval.

Design and Realization of Forest Fire Monitoring System Based on GIS in Henan Province, China

Geographic Information System (GIS) is applied to the forest fire monitoring and management in Henan province, China. A forest fire monitoring system architecture is presented, which consists of the mobile client, the monitoring and management client, the map data server, and the business data processing server. The paper carried out the system database design and function design and realized the functions of forest resources inquire, fire warning, positioning and navigation of fire point, fire situation real-time dynamic plotting, and so on. The system can promote efficiently the informatization of monitoring, management, early warning in forest fire.

Analisis dan Perancangan Basis Data dan Aplikasi Pegadaian pada PT Langitan Segi Putera

This article contains analysis and design of pawnshop database systems and its application design that can be used by PT Langitan Segi Putera for acquiring information about pawn goods, decision making in pawnshop system, how to increase the effectiveness and efficiency of employee performance as well as how to reduce error in data input. The methodology used in this research consists of literature study, survey, and analysis and design. The result obtained is a conceptual, logical and physical database design for pawn process in PT Langitan Segi Putera and its application that is suitable with the design. The design of database and its application meets the company requirement and improves company performance due to the availability of accurate and timely information, improvement in data security, and reduction of data redundancy.

Security Design of Web-Based Information Integrated System

Security is an important index in the design of information integrated system. Combined with the development of an information integrated system, the security design of database system and network of the Web-based information integrated system are researched. The safety management methods and implementation measures are presented, which have certain reference value in the actual execution process.

NoDB in action

As data collections become larger and larger, users are faced with increasing bottlenecks in their data analysis. More data means more time to prepare the data, to load the data into the database and to execute the desired queries. Many applications already avoid using traditional database systems, e.g., scientific data analysis and social networks, due to their complexity and the increaseddata-to-querytime, i.e. the time between getting the data and retrieving its first useful results. For many applications data collections keep growing fast, even on a daily basis, and thisdata delugewill only increase in the future, where it is expected to have much more data than what we can move or store, let alone analyze.In this demonstration, we will showcase a new philosophy for designing database systems called NoDB. NoDB aims at minimizing the data-to-query time, most prominently by removing the need to load data before launching queries. We will present our prototype implementation, PostgresRaw, built on top of PostgreSQL, which allows for efficient query execution over raw data files with zero initialization overhead. We will visually demonstrate how PostgresRaw incrementally and adaptively touches, parses, caches and indexes raw data files autonomously and exclusively as a side-effect of user queries.

MDA based approach towards Design of Database for Banking System

The Indian Banks collects huge amount of data which the banks are unable to turn into fast transaction and also unable to maintain and utilize it in a proper manner. Other problems are also occurring w.r.t. the reusability of the system in a different environment designed by the developer. Nowadays we are focusing upon interoperability of database and system hardware. In this paper we have proposed a new design of banking Database system of a bank using the modern MDA approach of software engineering to improve the maintainability, portability and flexibility. We have shown that MDA approach also provides interoperability, easy maintenance of highly computational business oriented system by taking the study of banking database. In this paper we have shown how database modeling is done with MDA for modelling at different levels like CIM, PIM, and PSM, which gives a new dimension to the database based application development.

The Design and Realization of the Material Series Database System

Abstract Aiming at the special material equipment, a multi-layer database structure was studied. The data characteristics, the intrinsic relationship of each layer, and the multi-layer database structure related to the material trademark and its performance were defined. The logical organization and the physical structure of the material series database and the material performance database were designed, as well as the software system was developed based on the Oracle and the J2EE technology. The data exchange between the two databases of the material trademark and the performance can be seamlessly connected, which shows that the system can effectively manage and intuitionisticly display the material series framework and detail information with text, picture, forms and so on.

Consistency Tradeoffs in Modern Distributed Database System Design: CAP is Only Part of the Story

The CAP theorem's impact on modern distributed database system design is more limited than is often perceived. Another tradeoff-between consistency and latency -has had a more direct influence on several well-known DDBSs. A proposed new formulation, PACELC, unifies this tradeoff with CAP.

Research on the Application of Geographic Information System in Tourism Management

The 21st century is the era of information economy. With economic development and social progress, people's material and cultural standard of living continues to improve and leisure time continues to increase, tourism has become increasingly popular as a kind of leisure way. The geographic information system applied to tourism management is the preferred platform of tourism information. On the basis of introducing the concepts of Geographic Information System (GIS) and Travel Geographic Information System (TGIS), this paper illustrates the role that the geographic information system plays in tourism management. Tourism has a strong geographical attributes. And GIS itself is information system offering services to geographic research and decision-making, which can play a role in tourism management. In particular, possessing the functions, such as data collection, storage, processing, spatial analysis and so on, GIS directly provides services for tourism management. The roles of GIS in tourism management are mainly in the following areas: conducting tourism information management; being able to produce a comprehensive thematic map. The paper analyzes the existing problems of GIS applications in tourism management. Take a panoramic view of the current technology and management system, the key technology and problems to establish TGIS are: the construction of tourism geographic information database; the establishment of data structure and the data model; the design of Tourism Geographic Information Database System. The essay also proposes the development prospects of the combination of GIS with new information technologies. GIS applied in Tourism Management has played a significant role. At the same time, it should be noted that information technology continuously changes, GIS applied in tourism management also need to improve according to the development of information technology to adapt to the information technology development. Looking the prospects of GIS applied in tourism management, the following areas need to be improved: RS, GPS as supplementary means applied to GIS data collection and update to enhance information collection ability of the system; combining the multimedia and virtual technology with GIS to enhance the attractiveness of the system for tourists; Combining the expert system technology with GIS to enhance the capacity of the system to solve travel problems.

Problem-Based e-Learning and Evaluation System forDatabase Design and Programming in SQL

 Abstract—Problem-based e-Learning (PBeL) can be a highly successful model for the teaching and learning of Database, one of the core courses of Computer Science and Engineering in undergraduate level. There are very few e-Learning systems found to support the learning of the different components of Database course. Existing systems provide only the partial solution of extensive learning of this course and also do not support the automatic evaluation of student performance. The main components of database practical course are: database design, SQL, PL/SQL and implementation of database projects. In this research, we have developed a system: SQL Learning and Evaluation System (SQL-LES) for effective teaching and learning of all of the above components of the practical parts of the database course. We have developed a question bank covering all areas of SQL questions and answers. The question bank can be used for both learning and automatic evaluation of student's performance by creating test sets and assigning the test sets to the individual students. The system can effectively be used for the teaching, learning and evaluation of database design, PL/SQL and database projects as well. SQL-LES has been applied in teaching, learning and evaluation of database laboratory course in undergraduate level of the Department of Computer Science and Engineering (CSE), Bangladesh University of Engineering and Technology (BUET) in several years and found to be very effective in classroom environment. Index Terms—E-learning, problem based learning (PBL),

Design and Optimization of Expert Database System for Cast and Roll Production of Copper Tubes

To solve the problems of change design and massive work and low efficiency during Cast & Roll processes design, an expert database system for Cast & Roll process design of copper tubes has been developed. Knowledge reasoning, Artificial Neural Networks (ANN), Genetic Algorithm (GA), Numerical Simulation, Uniform Design, CAD Parameterization Design, database and Intranet have been integrated into the system for process design and parameter optimization, which can exert the advantage of each technology. The design method has been proved to be successful.