• Journal of Korean Society of Rural Planning
• /
• v.11 no.2 s.27
• /
• pp.43-49
• /
• 2005

As information has been brought to public attention, information storage as well as information usability has been important. Rural information is produced in many areas and institutions. However, it is difficult to use rural information comprehensively. Since formats for management are various, it is difficult to have unified frame. In this research, a schema of database fer integrating rural data is designed to improve usability using dimensional modeling. First of all, rural data are analyzed for designing integrated rural database schema. Rural data used are 'National Agricultural Statistics' and 'Gun annual statistical report'. Analysis shows that there are three considerations; administrative district, time-dependency and classification of data. Considering these three requisite, we designed database schema using dimensional modeling. The reason of using dimensional modeling is to improve usability and effectiveness. If the database was designed using ER modeling, many tables have to be joined every searching time. Separately from integrated rural database schema, user's database schema is designed considering usability. Through user's database, users can modify data or generate new data and save these processes. These make it possible to use generated data repeatedly. We evaluate usability, contribution, and effectiveness of data manipulation on the integrated rural database. We propose an integrated rural database structure improving the accessibility and usability of rural data and information and verified the data model based on a practical example.

• Journal of Advanced Research in Ocean Engineering
• /
• v.4 no.3
• /
• pp.96-104
• /
• 2018

The importance of data management for the efficient maintenance and operation of offshore structures is becoming increasingly important. This paper has discussed the data schema and business rules that standardize the data exchange between ship design, operation and maintenance. Technical documentation that meets the international standards of ShipDex and S1000D for exchanging the operation and management data in neutral or standard formats has been introduced into the life cycle management of ships. The schema of the data exchange is represented by XML (eXtensible Markup Language) and the lifecycle data is implemented by a structured document. Lifecycle data is represented as data modules defined by XML schema. Given the feasible data generation, an example of a technical document is introduced by a general XML authoring tool.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2004.05b
• /
• pp.354-357
• /
• 2004

Data warehouse is subject-oriented, integrated, non-volatiled data, and it used for OLAP(On-Line Analytical Processing) the extraction of information from making decision processing. In the present, lots of study have been devoted to multidimensional modeling between OLAP operator and star schema. In this paper, the design of using the snowflake schema for object-oriented conceptual relation is more extended than using drill-across operator. The object-oriented relation schema which was not applicable has been improved through the design.

• Korean Journal of Computational Design and Engineering
• /
• v.18 no.4
• /
• pp.267-274
• /
• 2013

This study focuses on the data schema and data content, which includes maintenance data, data structures and illustration data relevant with the maintenance process of ship and offshore structures. Product lifecycle management (PLM) is expected to encompass all the product data generated for the operation and maintenance information as well as the design and production. This paper introduces a data exchange schema in PLM of ship and offshore, serving as the basis for the role of standards required by the middle-of-life PLM. Also this paper identifies a typology of standards relevant to PLM that addresses the schema of evolving standards and identifies a XML schema supporting the exchange of data related with maintenance operations. Technical document based on standards in accordance with S1000D and Shipdex is explained. A case study illustrating the use of standard data exchange and technical document is presented.

• Journal of KIISE:Databases
• /
• v.31 no.5
• /
• pp.527-539
• /
• 2004

As more and more documents are published in XML, generating relational schemas to store XML documents in a relational database is also getting important. This paper describes a technique as well as its implementation to produce a relational schema from the XML Schema, a standard recently recommended by W3C. The DTD-based inlining technique cannot be applied to the XML Schema, because the XML Schema has many new features, which don't exist in the DTD. Various built-in data types, inheritance, and polymorphism, for example, strengthen the XML Schema, but make the generation of a relational schema from an XML Schema more difficult. We propose an XML Schema Inlining Technique, based on the previous work. The technique first maps various data types in the XML Schema to those of the relational database. After that, it construct the schema graph and the type graph from types and elements defined in the XML Schema. The relational schema is generated while traversing the type graphs. Besides, we describe techniques for handling xsi：type, used for the polymorphism, and the anon#moos type. We also propose a couple of heuristic methods for enhancing the performance of the system. Finally, we conducted experiments to show that our technique is better than the binary table approach.

• International Journal of Advanced Culture Technology
• /
• v.9 no.3
• /
• pp.327-333
• /
• 2021

Inbody is a tool for measuring health information with high reliability and accuracy to analyze body composition. Unlike the existing method of storing/processing and outputting data on the server side, the health information generated by InBody requires accurate support for health sharing and data analysis services using mobile devices. However, in the process of transmitting body composition measurement information to a mobile service, a problem may occur in data transmission/reception processing. The reason for this is that, since the network network in the cloud environment is used, if the connection is cut off or the connection is changed, it is necessary to provide a global service, not a temporary area, focusing on the mobility of InBody information. In addition, since InBody information is transmitted to mobile devices, a standard schema should be defined in the mobile cloud environment to enable information transfer between standardized InBody data and mobile devices. We propose a mobile cloud system using EMRA(Extended Metadata Registry Access) in which a mobile device processes and transmits body data generated in the inbody and manages the data of each local organization with a standard schema. The proposed system processes the data generated in InBody and converts it into a standard schema using EMRA so that standardized data can be transmitted. In addition, even when the mobile device moves through the area, the coordinator subsystem is in charge of providing access services. In addition, EMRA is applied to the collision problem due to schema heterogeneity occurring in the process of accessing data generated in InBody.

• Journal of KIISE:Computing Practices and Letters
• /
• v.16 no.3
• /
• pp.324-330
• /
• 2010

XML schema is widely used as an effective tool for organizing and validating XML data. Although W3C released XQuery and XQuery Update Facility as the standard methods for searching and updating XML data, there is no consideration about providing facilities for updating XML schema itself until now. So users can only update an XML schema file directly by using editors. However, the direct update has several problems: It cannot prevent user's illegal update; it is hard to apply to the XML schemas stored in databases, needs much time to analyze schema, and is likely to make syntactic errors. In this paper, we propose an XML schema update facility, which enables creation, deletion and modification of XML schema by using commands.

• Journal of the Korea Society of Computer and Information
• /
• v.7 no.4
• /
• pp.83-88
• /
• 2002

Large sets of conceptual schema have been constructed for database design. In recent times, the need of analytic aid for schema reuse is increasing. In this paper, it is presented analysis technique of conceptual schema, and experimented schema analysis for extraction of reference schema. It is desirable for integration of related schema to have been applied in case of similarity value above 0.6. Reference schema which is created through the analysis technique enable to describe concepts of them and can be the way of schema reuse. And a feature analysis can be effective measure to set details of analytic data which is necessary for extraction of reference schema.

• Journal of National Security and Military Science
• /
• s.1
• /
• pp.269-310
• /
• 2003

AS Extensible Markup Language(XML) is emerging as the data format of the Internet era, there are increasing needs to efficiently transform between database and XML documents. In this paper, we propose a schema transformation method from relational database to XML database. To transform the schema, we represent input schema as Entity-Relationship diagram. Entity-Relationship model translator scans the input Entity-Relationship diagram using BFS (breadth First Search) and translates the diagram into hierarchical structure model. The XML Schema generator produces XML Scema code using the transformed hierarchical structure model. The proposed method has a merit that having reusability facility of XML Schema property in comparison with existing researches.

• Journal of Internet Computing and Services
• /
• v.4 no.4
• /
• pp.35-44
• /
• 2003

XML becomes the standard for exchanging documents and data on the Web. Schema is used to define XML documents. Among schema, XDR schema, developed chiefly by Microsoft, is a leading schema for practical use. UML is a notation in object-oriented software development and a useful tool to represent the structure of a system. In this paper, we study the transformation method and algorithm from XDR schema to UML diagram. By this transformation, the structure of XDR schema is represented graphically. Thus we can easily understand the structure of XDR schema and we can create XML documents effectively by enhancing reusability and flexibility.