• Journal of the Korea Society of Computer and Information
• /
• v.23 no.3
• /
• pp.49-54
• /
• 2018

A data warehouse is a system that collectively manages and integrates data of a company. And provides the basis for decision making for management strategy. Nowadays, analysis data volumes are reaching critical size challenging traditional data ware housing approaches. Current implemented solutions are mainly based on relational database that are no longer adapted to these data volume. NoSQL solutions allow us to consider new approaches for data warehousing, especially from the multidimensional data management point of view. In this paper, we extend the data warehouse design methodology based on relational database using star schema, and have developed a consistent design methodology from information requirement analysis to data warehouse construction for large scale data warehouse construction based on MongoDB, one of NoSQL.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1998.10a
• /
• pp.342-351
• /
• 1998

The purpose of this study is to develop a central database and a database management system to store and manage information systematically from each module of an integrated structural design system. In order to efficiently express structural design process related to the data which is very complex, we used an object-oriented modeling methodology to propose the possibility to apply a database schema for application programs in an integrated system for reinforced concrete structural design. Based on this model, we developed an interface between each module and central database. After modeled by using object modeling technique, the database was mapped by the relational database table. Then the central database and the interface were programed by using Visual C/syo ++/, a windows environmental development tool.

• Journal of the Society of Disaster Information
• /
• v.10 no.1
• /
• pp.15-24
• /
• 2014

The study presents work information classification system of apartment house which can organize all construction management services throughout the planning and management of a construction such as the decomposition of the design process, the assembly of construction process and cost estimating, etc. In addition, the study suggested a way to connect work information classification system based on a relational database in working order and built a conceptual model for automated cost estimating by utilizing established data base. A conceptual model for automated cost estimating will resolve the fundamental problems of the existing cost estimating system and will be able to take advantage of scientific cost estimating system at the construction site of apartment house.

• The Transactions of the Korean Institute of Electrical Engineers P
• /
• v.64 no.2
• /
• pp.85-91
• /
• 2015

With the increasing popularity of Smart Grid infrastructure, it is much easier to collect energy usage data using AMI (Advanced Measuring Instrument) from residential housing, buildings and factories. Several researches have been done to improve an energy efficiency by analyzing the collected energy usage data. However, it is not easy to store and analyze the energy data using a traditional relational database management system since the data size grows exponentially with an increasing popularity of Smart grid infrastructure. In this paper, we are proposing a Hadoop based Big data system to store and analyze energy usage data. Based on our limited experiments, Hadoop based energy data analysis is three times faster than that of a relational database management system based approach with the current system.

• Proceedings of the KSRS Conference
• /
• 2005.10a
• /
• pp.778-784
• /
• 2005

Miniaturization of computing devices, and advances in wireless communication and positioning systems will create a wide and increasing range of database applications such as location-based services, tracking and transportation systems that has to deal with Moving Objects. Various types of queries could be posted to moving objects, including past, present and future queries. The key problem is how to model the location of moving objects and enable Database Management System (DBMS) to predict the future location of a moving object. It is obvious that there is a need for an innovative, generic, conceptually clean and application-independent approach for spatio-temporal handling data. This paper presents behavioral aspect of the spatio-temporal databases for managing and querying moving objects. Our objective is to impelement and extend the Spatial TAU (STAU) system developed by Dr.Pelekis that provides spatio-temporal functionality to an Object-Relational Database Management System to support modeling and querying moving objecs. The results of the impelementation are demonstrated in this paper.

• Proceedings of the IEEK Conference
• /
• 2001.06c
• /
• pp.113-116
• /
• 2001

XML (extensible Markup Language) is a flexible way to create common information formats and share both the format and the data on the World Wide Web, intranets, and elsewhere. A document type definition (DTD) is a specific definition of the rules of the Standard Generalized Markup Language. A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. An RDBMS takes Structured Query Language (SQL) statements entered by a user or contained in an application program and creates, updates, or provides access to the database. This paper has been studied a method of mappings from XML DTD to RDB schemas based on object model.

• Journal of the Korea Computer Industry Society
• /
• v.10 no.1
• /
• pp.1-12
• /
• 2009

In this thesis, founded on those considerings, plan the formula of media data for the information of drawing for the production of steel plate by establishing the concept of relational data model, plan the surroundings for query for the interface of user, and introduce the process materialized actually in detail as use the management system of drawing.

• The Transactions of The Korean Institute of Electrical Engineers
• /
• v.63 no.8
• /
• pp.1111-1115
• /
• 2014

With the increasing interest of a demand side management using a Smart Grid infrastructure, the demand resources and energy usage data management becomes an important factor in energy industry. In addition, with the help of Advanced Measuring Infrastructure(AMI), energy usage data becomes a Big Data System. Therefore, it becomes difficult to store and manage the demand resources big data using a traditional relational database management system. Furthermore, not many researches have been done to analyze the big energy data collected using AMI. In this paper, we are proposing a Hadoop based Big Data system to manage the demand resources energy data and we will also show how the demand side management systems can be used to improve energy efficiency.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.23 no.57
• /
• pp.21-39
• /
• 2000

BOM(Bill of Materials) is a listing or description of raw materials, parts, and assemblies that define a product. In manufacturing companies that produce various products with short life cycles, it is very important to manage the BOM of products with various options and versions efficiently. BOM information should be required to share among the departments of engineering, production control, material purchasing, cost management, and shop floor within a manufacturing company. In order to share BOM information efficiently, information system based on WWW(World Wide Web) should be developed. Thus, this paper models and implements Web-based Generic BOM Management System (WGBMS) for management of a number of variant products which are consisted of standard parts under ATO(Assemble To Order) production environment. Also, object-oriented methodology was used to model a generic BOM and phases of navigational design and interface design were introduced to implement the prototype of WGBMS. And Object-Relational Database Management System (ORDBMS) was used to construct the WGBMS database.

• Proceedings of the Computational Structural Engineering Institute Conference
• /
• 1993.10a
• /
• pp.163-172
• /
• 1993

This paper presents a database approach to integrating the structural analysis and design processes for a typical shear wall apartment building design. Our initial efforts have focused on extracting various graphic information from CAD(AutoCAD™) systems. But now, we concentrate our research efforts on organizing specific information generated during the structural analysis and design processes. The proposed overall system consists of a conventional structural analysis package, a conventional CAD system, and different application interface programs. This system is based on an engineering database which is developed by using an object-oriented data modelling approach. The system is actually implemented on an ORACLE™-based relational database management system.