• Title/Summary/Keyword: DB design

Search Result 839, Processing Time 0.034 seconds

A study on Integrating Strategy of Low-carbon Urban Planning System (탄소저감 도시계획 시스템의 통합화 방안 도출 연구)

  • Park, Chan Ho;Kim, Bum Seok
    • Spatial Information Research
    • /
    • v.21 no.2
    • /
    • pp.99-106
    • /
    • 2013
  • Through the rapid economic growth, modern society have achieved the industrialization but needed to respond to climate change and low-carbon green growth on a scale of urban area. Many studies about the low-carbon city and the green city are on going, but most of them are not integrated but go along in each area(construction, transportation, energy, etc) In this paper, we surveyed the current status of researches about information system to design low-carbon city or green city, and define the method to integrate the outcomes from the each area. As a result integrated model of 'Low-carbon Urban Planning integrated System' in the paper, Individual system is developed by way of C/S form because web system raised problems for data load in analysis. The integrated system was decided to develop by way of Web form, and integrated system was developed by can use the analysed DB in the individual system. We expect this study can help future researches to develop more economical and efficient integrated information system model to design the low-carbon city and the green city.

Fabrication of Lightweight Sandwich Structural Components with Superplastic Forming/Diffusion Bonding Technology (초소성/확산접합 기술을 이용한 티타늄 샌드위치 경량구조물 제작)

  • Lee, Ho-Sung;Yoon, Jong-Hoon;Yi, Yeong-Moo;Shin, Dong Hyuk
    • Journal of the Korean Society for Aeronautical & Space Sciences
    • /
    • v.35 no.9
    • /
    • pp.778-782
    • /
    • 2007
  • In the present study, design and forming process of fabricating titianium lightweight components are developed with applicaton of superplastic forming and diffusion bonding technology. SPF/DB(Superplastic forming/Diffusion bonding) technology is one of the advanced technologies to reduce production cost and weight and currently applied to aircrafts and space launchers in foreign countries. The present study constructs an analysis model to predict superplastic forming behavior of titanium alloy, which is well known for its resistance to deform. The experimental results show the forming of titanium lightweight sandwich structure is successfully performed from 3 sheets of Ti-6Al-4V. The results demonstrate that the developed technology to process design of SPF/DB by the finite element method can be applied to various types of components.

Analysis of Fatigue Truck Model for LRFD Code (LRFD 설계기준(안) 피로설계트럭 모형 분석)

  • Cho, Eun Young;Shin, Dong Ku
    • Journal of Korean Society of Steel Construction
    • /
    • v.21 no.3
    • /
    • pp.331-342
    • /
    • 2009
  • A reliability analysis of the fatigue failure of highway steel bridges was performed by applying the Miner's fatigue damage rule for the fatigue design truck proposed for the LRFD code and for the current DB 24 truck. The limit state function for fatigue failure is expressed as a function of various random variables that affect fatigue damage. Among these variables, the statistical parameters for the equivalent moment, the impact factor, and the loadometer were obtained by analyzing recently measured domestic traffic data, and the parameters for the fatigue strength, the girder distribution factor, and the headway factor were obtained from the measured data reported in literature. Based on the reliability analysis, the fatigue truck model for the LRFD code was proposed. After applying the proposed fatigue truck to the LRFD code, 16 composite plate and box girder bridges were designed based on the LRFD method, and the LRFD design results for the fatigue limit state were compared with those by the current KHBDC.

Design of the MS-SQL Password Vulnerability Checking Function Using OLE Remote Connection (OLE 원격 접속 기능을 이용한 MS-SQL 패스워드 취약점 점검 기능 설계)

  • Jang, Seung Ju
    • KIPS Transactions on Computer and Communication Systems
    • /
    • v.4 no.3
    • /
    • pp.97-104
    • /
    • 2015
  • This paper will feature designs for security vulnerability based on MS-SQL Database and OLE connectivity by checking the MS-SQL database password policy, the user account password access attempts, a user without password, and password does not be changed for a period of time. This paper uses the MS-SQL database and C++ linkage in order to use the OLE DB function. The design module should judge presence or absence of security vulnerability by checking database password policy, the user account password access attempts, a user without password, password does not be changed for a period of time. The MS-SQL database password associated with a feature, judging from the many features allows you to check for security vulnerability. This paper strengthen the security of the MS-SQL database by taking the advantage of the proposed ability.

A Research on how to turn informationization Database of construction materials to practical use (건설 자재정보 DataBase의 실용화 방안 연구)

  • Kwon, Oh-Yong;Han, Chung-Han;Lee, Hwa-Young
    • Proceedings of the Korean Institute Of Construction Engineering and Management
    • /
    • 2007.11a
    • /
    • pp.747-750
    • /
    • 2007
  • Information of construction material is served through internet to user but it is poor to use information of construction material because of lack of information which is accumulated and insufficience of standardization. So informationization of civil materials are closely connected with works and then it is promoted to be used through works like design, construction etc. Informationization for management of information of construction material which reflects questionnaires about opinion of workers presents promotion by stage considering first, continuous renewal of information of construction material and increase in quantity, second classification system and standardization of terms in order to share and connect information of construction material third, developing inquiry method of material information needed in construction stage fourth, connecting material information DB and application through design and construction.

  • PDF

Analytical System Development for Reinforced Tall Buildings with Construction Sequence (시공단계에 따른 철근콘크리트 고층건물의 해석시스템 개발)

  • Lee, Tae-Gyu
    • The Journal of the Korea Contents Association
    • /
    • v.13 no.9
    • /
    • pp.410-417
    • /
    • 2013
  • Long-term behavior analysis considering construction sequence should be performed in the design and the actual construction of reinforced tall buildings. Most of the analytical studies on this subject, however, has not been applied directly to the structural design and the construction caused by the simple approach. As the axial force redistribution of shores and columns is time-dependent, the actual construction sequence with the placement of concrete, form removal, reshoring, shore removal, and the additional load application is very important. Object-oriented analysis program considering construction sequence, especially time-dependent deformation in early days, is developed. This system is composed of input module, database module, database store module, analysis module, and result generation module. Linkage interface between the central database and each of the related module is implemented by the visual c# concept. Graphic user interface and the relational database table are supported for user's convenience.

Design and Implementation of Realtime Information Service based on Ubiquitous Sensor Network Using MySQL and Tiny-DB (Tiny-DB와 MySQL을 이용한 유비쿼터스 센서 네트워크 기반의 실시간 정보 서비스 설계 및 구현)

  • Kang, Kyoung-Ok;Kim, Yong-Woo;Kwon, Hoon;Kim, Bu-Rim;Kim, Do-Hyeun
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.7 no.2
    • /
    • pp.175-181
    • /
    • 2006
  • Wireless sensor network forms the self-organization network, and transfers the information among sensor nodes that have computing technology ability and wireless communication ability. The recent sensor network is study for low-power, micro, low cost of node is proceeded. Recently, the research of application services in wireless sensor networks is proceeded. Therefore, in this paper, we design the prototype of the real-time information service that support a user the information of temperature, illumination etc. And, we implement the alarm application service fer the disaster prevention on Internet base on IPv4/IPv6. We develop the module of the extract information using the query processing based on TinyOS, and the module of the server's database using MySQL data base management system and JDBC. Additionally, we develop the client module that receive the real-time sensing data using ODBC in Internet based on IPv4/IPv6.

  • PDF

Life Cycle Assessment of Rural Community Buildings Using OpenLCATM DB (OpenLCATM DB를 이용한 농촌 공동체 건축물 전과정평가)

  • Kim, Yongmin;Lee, Byungjoon;Yoon, Seongsoo
    • Journal of The Korean Society of Agricultural Engineers
    • /
    • v.63 no.3
    • /
    • pp.97-105
    • /
    • 2021
  • Most of the rural development projects for the welfare of residents are mainly new construction and remodeling projects for community buildings such as village halls and senior citizens. However, in the case of the construction industry, it has been studied that 23% of the total carbon dioxide emissions generated in Korea are generated in the building-related sector. (GGIC, 2015) In order to reduce the emission of environmental pollutants resulting from construction of rural community buildings, there is a need to establish a system for rural buildings by predicting the environmental impact. As a result of this study, the emissions of air pollutants from buildings in rural communities were analyzed by dividing into seven stages: material production, construction, operation, maintenance, demolition, recycling, and transportation activities related to disposal. As a result, 12 kg of carbon dioxide (CO), 0.06 kg of carbon monoxide (CO), 0.02 kg of methane (CH), 0.04 kg of nitrogen oxides (NO), 0.02 kg of sulfurous acid gas (SO), and non-methane volatile organics per 1m of buildings in rural communities It was analyzed that 0.02 kg of compound (NMVOC) and 0.00011 kg of nitrous oxide (NO) were released. This study proved that environmentally friendly design is possible with a quantitative methodology for the comparison of operating energy and air pollutant emissions through the design specification change based on the statement of the rural community building. It is considered that it can function as basic data for further research by collecting major structural changes and materials of rural community buildings.

Design and Implementation of MongoDB-based Unstructured Log Processing System over Cloud Computing Environment (클라우드 환경에서 MongoDB 기반의 비정형 로그 처리 시스템 설계 및 구현)

  • Kim, Myoungjin;Han, Seungho;Cui, Yun;Lee, Hanku
    • Journal of Internet Computing and Services
    • /
    • v.14 no.6
    • /
    • pp.71-84
    • /
    • 2013
  • Log data, which record the multitude of information created when operating computer systems, are utilized in many processes, from carrying out computer system inspection and process optimization to providing customized user optimization. In this paper, we propose a MongoDB-based unstructured log processing system in a cloud environment for processing the massive amount of log data of banks. Most of the log data generated during banking operations come from handling a client's business. Therefore, in order to gather, store, categorize, and analyze the log data generated while processing the client's business, a separate log data processing system needs to be established. However, the realization of flexible storage expansion functions for processing a massive amount of unstructured log data and executing a considerable number of functions to categorize and analyze the stored unstructured log data is difficult in existing computer environments. Thus, in this study, we use cloud computing technology to realize a cloud-based log data processing system for processing unstructured log data that are difficult to process using the existing computing infrastructure's analysis tools and management system. The proposed system uses the IaaS (Infrastructure as a Service) cloud environment to provide a flexible expansion of computing resources and includes the ability to flexibly expand resources such as storage space and memory under conditions such as extended storage or rapid increase in log data. Moreover, to overcome the processing limits of the existing analysis tool when a real-time analysis of the aggregated unstructured log data is required, the proposed system includes a Hadoop-based analysis module for quick and reliable parallel-distributed processing of the massive amount of log data. Furthermore, because the HDFS (Hadoop Distributed File System) stores data by generating copies of the block units of the aggregated log data, the proposed system offers automatic restore functions for the system to continually operate after it recovers from a malfunction. Finally, by establishing a distributed database using the NoSQL-based Mongo DB, the proposed system provides methods of effectively processing unstructured log data. Relational databases such as the MySQL databases have complex schemas that are inappropriate for processing unstructured log data. Further, strict schemas like those of relational databases cannot expand nodes in the case wherein the stored data are distributed to various nodes when the amount of data rapidly increases. NoSQL does not provide the complex computations that relational databases may provide but can easily expand the database through node dispersion when the amount of data increases rapidly; it is a non-relational database with an appropriate structure for processing unstructured data. The data models of the NoSQL are usually classified as Key-Value, column-oriented, and document-oriented types. Of these, the representative document-oriented data model, MongoDB, which has a free schema structure, is used in the proposed system. MongoDB is introduced to the proposed system because it makes it easy to process unstructured log data through a flexible schema structure, facilitates flexible node expansion when the amount of data is rapidly increasing, and provides an Auto-Sharding function that automatically expands storage. The proposed system is composed of a log collector module, a log graph generator module, a MongoDB module, a Hadoop-based analysis module, and a MySQL module. When the log data generated over the entire client business process of each bank are sent to the cloud server, the log collector module collects and classifies data according to the type of log data and distributes it to the MongoDB module and the MySQL module. The log graph generator module generates the results of the log analysis of the MongoDB module, Hadoop-based analysis module, and the MySQL module per analysis time and type of the aggregated log data, and provides them to the user through a web interface. Log data that require a real-time log data analysis are stored in the MySQL module and provided real-time by the log graph generator module. The aggregated log data per unit time are stored in the MongoDB module and plotted in a graph according to the user's various analysis conditions. The aggregated log data in the MongoDB module are parallel-distributed and processed by the Hadoop-based analysis module. A comparative evaluation is carried out against a log data processing system that uses only MySQL for inserting log data and estimating query performance; this evaluation proves the proposed system's superiority. Moreover, an optimal chunk size is confirmed through the log data insert performance evaluation of MongoDB for various chunk sizes.

FMS용 치공구 표준 DB 구축

  • 김기범;김종호
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 1995.10a
    • /
    • pp.1177-1181
    • /
    • 1995
  • Fixtures are devided into special purpose fixtures, modular fixtures and general purpose fixtures. In this paper, the database of modual fixtures for flexible manufacturing systems is estabilished. Modular fixtures are classified into base plates, supporting elements, locating elements, clamping elements and accessories. Also the concept for the modular fixture design expert system is proposed.

  • PDF