• The Journal of the Korea Contents Association
• /
• v.16 no.6
• /
• pp.441-449
• /
• 2016

The integrated data is an essential in the analysis for the balanced development of the local governments, but economic, social and cultural data in local governments is not being made with integrated management. A variety of information is being published according to the Government 3.0 era, but the researchers has great difficulty in integrating the analysis for one topic because related information is scattered in various sites. This paper proposes an integrated database(DB) of local governments to support the research activities. It has to contains total information of economic, social and cultural activities of local governments, and accommodate the distributed and heterogeneous data. It has the schema designed to integrate the entire data for considering the differences between local governments or data components. We should focus to build a framework for the multifaceted research to enable the cross analysis over common elements.

• International journal of advanced smart convergence
• /
• v.4 no.1
• /
• pp.88-92
• /
• 2015

Today, the medical information system has evolved in the way of integrated healthcare IT information systems. Therefore, it is trying to build advanced U-Healthcare service. Though the U-Healthcare environments is exchanged the information between systems in many cases, however since the each system is different, the integration and exchange of data is difficult. To overcome this problem, in this paper it proposes that we suggests a possible DBaaS(DataBase as a Service) for the heterogeneous integration of medical information management and data exchange. First, the proposed system builds DBaaS cloud by integrating the meta-DB Schema level and DB Schema for each hospital. And, the mapping the schema data and the existing hospital information system is possible using the International Standard HL7. By applying the proposed method to the hospital system, it comes true the efficient exchange of information between the patients, doctors, staffs through the data mapping of the one to multi-system.

• Journal of Korean Library and Information Science Society
• /
• v.50 no.4
• /
• pp.137-158
• /
• 2019

This study aims to develop metadata elements and vocabularies of 'Chosunsibo' issued in Korea during the Japanese colonial era. Despite the vast amount and historical values, newspaper articles in Chosunsibo are still unsearchable and difficult to access. To the end, this study includes as follows: (1) analyzed the DB construction and metadata elements of newspapers issued in Korea during the Japanese colonial, (2) investigated the morphological characteristics and content of 'Chosunsibo', and (3) derived metadata elements, encoding schemes and controlled vocabularies for 'Chosunsibo'. The final draft was verified in three methods: (1) review and revise through data input tests, (2) consulting by a DB expert agency, and (3) drawing up of crosswalks with metadata standards and related cases. The scope of this study is to design the metadata schema of the historical newspaper 'Chosunsibo' and develop a data input system based on that schema.

• International Journal of Internet, Broadcasting and Communication
• /
• v.10 no.3
• /
• pp.51-58
• /
• 2018

In order to utilize various data provided by Korea public open data portal, data should be systematically managed using a database. Since the range of open data is enormous, and the amount of data continues to increase, it is preferable to use a database capable of processing big data in order to analyze and utilize the data. This paper proposes data modeling and implementation method suitable for public data. The target data is subway related data provided by the public open data portal. Schema of the public data related to Seoul metro stations are analyzed and problems of the schema are presented. To solve these problems, this paper proposes a method to normalize and structure the subway data and model it in NoSQL database. In addition, the implementation result is shown by using MongDB which is a document-based database capable of processing big data.

• Journal of Korea Spatial Information System Society
• /
• v.5 no.1 s.9
• /
• pp.49-63
• /
• 2003

Recently, two international standard organizations, ISO and OGC, have done the work of standardization for GIS. Current standardization work for providing interoperability among GIS DB focuses on the design of open interfaces. But, this work has not considered procedures and methods for designing GIS DB. Eventually, GIS DB has its own model. When we share the data by open interface among heterogeneous GIS DB, differences between models result in the loss of information. Our aim in this paper is to revise the design guidelines for geographic information databases in order to make consistent spatial data models, logical structures, and semantic structure of populated geographical databases. In details, we propose standard guidelines which convert ISO abstract schema into relation model, object-relation model, object-centered model, and geometry-centered model. Furthermore, we provide sample models for applying these guidelines in commercial GIS S/Ws. Building GIS DB based on design guidelines proposed in the paper has the following advantages: the interoperability among databases, the standardization of schema definitions, and the catalogue of GIS databases through.

• Proceedings of the KSR Conference
• /
• 2007.11a
• /
• pp.1824-1826
• /
• 2007

Since standardization project is composed of complicate system, such as vehicle, signal, electric power and railway, how to build management system of the project has influence on the success of the project for the first stage of the project. The computer system design tool supports to carry out requirement analysis, DB construction, and history and follow-up management efficiently. Therefore, the aim of this study is to investigate the method to optimize schema using computer system design tool.

• IE interfaces
• /
• v.17 no.3
• /
• pp.330-337
• /
• 2004

Since XML (eXtensible Markup Language) was highlighted as an information interchange format, there is an increasing demand for incorporating XML with databases. Most of the approaches are focused on RDB (Relational Databases) because of legacy systems. But these approaches depend on the database system. Countless researches are being focused on DTD (Document Type Definition). However XML Schema is more comprehensive and efficient in many perspectives. We propose a meta-model for XML Schema that is independent of the database. There are three processes to build our meta-model: DOM (Document Object Model) tree analysis, object modeling and storing object into a fixed DB schema using model mapping approach. We propose four mapping rules for object modeling, which conform to the ODMG (Object Data Management Group) 3.0 standard. We expect that the model will be especially useful in building XML-based e-business applications.

• Journal of Korea Society of Digital Industry and Information Management
• /
• v.6 no.2
• /
• pp.39-53
• /
• 2010

In this paper, we suggest an XML Development Support(XDS) System as a good developing tool to solve the problems that related with the database integration, increased to the developing terms and costs when the developing of XML programming base on the web server. XDS System is designed for the purpose of easily coding the XML program, of simply changing the programming structure and of completely maintaining the program environment. According to the predefined policy, XDS System provides necessary informations such as tables, columns, or relational keys from Database for developer. The developer step by step selects or sets what he needs. And XDS System creates an XML Tree with the result of selected information. The XML Tree includes all information of making an XML Schema and some XML Stylesheet. XDS System creates an XML Schema for all clients and creates many XML Stylesheets for each client using the XML Tree.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2013.10a
• /
• pp.957-959
• /
• 2013

A SNS(Social Networking Service) is an online platform to build social networks or social relations among people who, for example, share free communication, information, and make more personal connections. In this paper, we find representative entities, develop relationships among them, and draw an ERD based on the entities and their relationships. And then we design a SNS database schema by converting the ERD into collections according to data model of MongoDB, which is an NoSQL database.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.12 no.3
• /
• pp.143-151
• /
• 2009

Forest type map is a main forest thematic map which shows forest type, age class, diameter class and density. This map has been used as a base data in various fields such as forest policy decision-making, land suitability assessment and eco map production etc. But the existing map had many kinds of errors and no metadata because there was no standard for digital map production. On this study, we developed standard for digital forest type map production consisting of 33 unit processes including DB schema design, mapping process, quality control and metadata input process. Based on this standard, country-wide digital forest type map can be produced with consistent quality and standard metadata.