• 한국컴퓨터정보학회논문지
• /
• 제23권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.

• 한국전산구조공학회:학술대회논문집
• /
• 한국전산구조공학회 1998년도 가을 학술발표회 논문집
• /
• 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.

• 한국재난정보학회 논문집
• /
• 제10권1호
• /
• pp.15-24
• /
• 2014

본 연구는 설계 과정의 분해, 시공 과정의 조립, 공사비 적산 등 공사의 계획과 관리에 걸친 모든 공사 관리의 업무를 체계화할 수 있는 공동주택의 공사정보분류체계를 제시하였다. 또한, 본 연구는 이 공사정보분류체계를 작업순서에 따라 관계형 데이터베이스(Data Base)로 구축 방법을 제시하였고, 구축된 데이터베이스를 근거로 적산 자동화 시스템 개념 모형을 구축하였다. 이러한 적산 자동화 시스템 개념 모형은 기존 적산 시스템들의 근본적인 문제점이었던 부적절함을 해소하여 공동주택 건설현장에서 효과적으로 적용가능한 과학적인 적산 시스템으로 활용할 수 있을 것이다.

• 전기학회논문지P
• /
• 제64권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.

• 대한원격탐사학회:학술대회논문집
• /
• 대한원격탐사학회 2005년도 Proceedings of ISRS 2005
• /
• 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.

• 대한전자공학회:학술대회논문집
• /
• 대한전자공학회 2001년도 하계종합학술대회 논문집(3)
• /
• 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.

• 한국컴퓨터산업학회논문지
• /
• 제10권1호
• /
• pp.1-12
• /
• 2009

이 논문은 설계자동화로 강판절단 과정에 필요한 도면과 도면정보를 데이터베이스로 구축함으로써 도면을 효율적으로 관리하고, 검색함으로써 기존의 설계방식에 비해 경제성과 생산성 측면에서 보다 효율적이고 사용자의 편리성에서 매우 유리하며, 또한 수정도 용이하게 수행할 수 있다. 본 논문에서는 이러한 필요성에 기반을 두고 관계 데이터 모델의 개념을 정립하여 강판 제작에 따른 도면 정보를 위한 미디어 데이터 형식을 설계하였고, 사용자 인터페이스를 위한 질의 환경을 설계하였으며, 도면 관리시스템을 이용하여 실제 구현되는 과정을 자세히 소개하였다.

• 전기학회논문지
• /
• 제63권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.

• 산업경영시스템학회지
• /
• 제23권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.

• 한국전산구조공학회:학술대회논문집
• /
• 한국전산구조공학회 1993년도 가을 학술발표회논문집
• /
• 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.