• Title/Summary/Keyword: DB standardization

Search Result 95, Processing Time 0.022 seconds

Database Basic Design for Safe Management Radioactive Waste (방사성폐기물 안전관리 데이터베이스 기본설계)

  • 손동찬;안경일;정덕진;조용백
    • Proceedings of the Korean Radioactive Waste Society Conference
    • /
    • 2003.11a
    • /
    • pp.470-483
    • /
    • 2003
  • As the amount of radioactive waste and related information to be managed are increasing, some organizations are trying or planning to computerize the management on radioactive waste. When we consider that information on safe management of radioactive waste should be used In association with national radioactive waste management project, standardization of data form and its protocol is required. Korea Institute of Nuclear Safety(KINS) will establish and operate nationwide integrated database in order to effectively manage a large amount of information on national radioactive waste. This database allows not only to trace and manage the trend of radioactive waste occurrence and in storage but also to produce reliable analysis results for the quantity accumulated. Consequently, we can provide necessary information for national radioactive waste management policy and related industry's planing. This study explains the database design which is the essential element for information management.

  • PDF

Building the Database with Herbal Formulas Based on the Korean Medical Classics (기존한약서 수재 처방 Database 구축 연구)

  • Kim, Ji-Hoon;Lee, Dae-Jung;Yun, Sung-Joong;Ahn, Sang-Woo;Kim, Yun-Kyung
    • Herbal Formula Science
    • /
    • v.23 no.2
    • /
    • pp.209-224
    • /
    • 2015
  • Objective : The main purpose of this study is to find a reasonable solutions for utilization of herbal formulas based on the medical classics. Methods : We used official Ten 'Selected Korean Medical Classics(SKMC)'. For input of formulas from SKMC, we had to select proper editions of them. After consultations with experts of 'The Korean Medicine Society for the Herbal Formula Study' and 'Korean Society of Medical History', we chose the proper editions of SKMC, and according to those books, we built formulas database using microsoft office excel sheets, respectively. Results : After whole input procedures, we requested several experts to inspect the results and also, to correct errors in them. Input categories were name of formula, name of classic, classification, original source, composition herb, weight, unit of weight, weight conversion index, converted weight, basic formula, indications, reason for modification, preparing method, taking method and contraindications. Final number of whole formulas in DB was 32,882. Conclusions : We used SKMC and built database using excel program. Through this procedure, we can provide a developmental ways to make a foundation for herbal formulas from the medical classics, so that we can make herbal formulas be standardized or industrialized more efficiently.

Development of FAPIS(Forest Aerial Photograph Interpretation System) for Digital Forest Cover Type Mapping(Version 1.0) (수치임상도 제작을 위한 산림항공사진 영상판독시스템 개발(Version 1.0))

  • You, Byung-Oh;Kim, Chong-Chan;Kim, Sung-Ho
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.14 no.2
    • /
    • pp.128-137
    • /
    • 2011
  • The purpose of the FAPIS(Forest Aerial Photograph Interpretation System) development is to increase accuracy and efficiency of the digital forest cover type mapping for improving conventional analog-based mapping procedures by optimizing work-flow and mapping technology. The database models including digital forest cover type map, aerial photograph, and topographic map were designed for use in this system construction. The interface configured concisely to connect with functions such as search engine, display control, conversion to stereo interpretation mode, modification tools, automation of print layout and database models. It is expected that the standardization methodology based on this system can be applied and extended in making all kinds of digital thematic maps, providing decision-making and information of forest resources.

Distributed REID Information Service Architecture for Ubiquitous Logistics (유비쿼터스 물류를 위한 분산형 RFID 정보서비스 구조)

  • Lee, Jae-Won;Lee, Young-Koo
    • Journal of Intelligence and Information Systems
    • /
    • v.11 no.2
    • /
    • pp.105-121
    • /
    • 2005
  • To realize a ubiquitous logistics management system using the smart object of Electronic Product Code(EPC) enabled RFID tag, the design and management of RFID Information Service is very important. RFID Information Service searches, transfers and responds to the other's PML request, but Physical Markup Language (PML) data management between trading system elements has issues of standardization of PML data description and processing, and problems of data traffic and communication time overload because of the innate distributed characteristics. As a complementary study, this research analyzes the usage patterns and data types of PML. On that analysis we provide a design of the distributed RFID Information Service architecture of PML data management that is using DB middleware. Standalone and Integrated type of RFID IS were proposed.

  • PDF

Standardization of machining process for progressive press die (순차이송형 프레스 금형의 가공표준화)

  • Lee, S.M.;Lee, S.J.
    • Journal of the Korean Society for Precision Engineering
    • /
    • v.10 no.2
    • /
    • pp.114-125
    • /
    • 1993
  • In the present study the newly developed CAD/CAM system is applied to the process of the molding design, machining for mini-sized and precise processive die, and the production of press-stamped parts. When the design of a die was completed by means of CAD, wire cut NC data were generated with the aid of a design drawing in the CAD system and then inputed into the wire cut machine, and with the aid of a hole chart which had been made for this purpose, all the data were classified into the categories of CNC milling, jig boring, jig grinding, and machine center, and then developing a program of generating NC data, errors in process were reduced and programming time was shortened. The program was developed by using Autolisp language which was built-in the CAD, and realizing the intergation of designing a die, generating and processing NC data directly by a designer, designing time and machinery processing time were shorted. And the traditionally required working time for design. NC program required 6 days of work becomes 4 days of work by using the developed CAD/CAM system so that the efficiency shows 150% of the reduction working time. The prpgram of the design of the automation a progressive die mold was developed in the PC-Class Autocad system, therefore development expense could be reduced, and the integration of the CAD/CAM of the progressive die mold with the standard DB being built could be realized.

  • PDF

GIS-based Market Analysis and Sales Management System : The Case of a Telecommunication Company (시장분석 및 영업관리 역량 강화를 위한 통신사의 GIS 적용 사례)

  • Chang, Nam-Sik
    • Journal of Intelligence and Information Systems
    • /
    • v.17 no.2
    • /
    • pp.61-75
    • /
    • 2011
  • A Geographic Information System(GIS) is a system that captures, stores, analyzes, manages and presents data with reference to geographic location data. In the later 1990s and earlier 2000s it was limitedly used in government sectors such as public utility management, urban planning, landscape architecture, and environmental contamination control. However, a growing number of open-source packages running on a range of operating systems enabled many private enterprises to explore the concept of viewing GIS-based sales and customer data over their own computer monitors. K telecommunication company has dominated the Korean telecommunication market by providing diverse services, such as high-speed internet, PSTN(Public Switched Telephone Network), VOLP (Voice Over Internet Protocol), and IPTV(Internet Protocol Television). Even though the telecommunication market in Korea is huge, the competition between major services providers is growing more fierce than ever before. Service providers struggled to acquire as many new customers as possible, attempted to cross sell more products to their regular customers, and made more efforts on retaining the best customers by offering unprecedented benefits. Most service providers including K telecommunication company tried to adopt the concept of customer relationship management(CRM), and analyze customer's demographic and transactional data statistically in order to understand their customer's behavior. However, managing customer information has still remained at the basic level, and the quality and the quantity of customer data were not enough not only to understand the customers but also to design a strategy for marketing and sales. For example, the currently used 3,074 legal regional divisions, which are originally defined by the government, were too broad to calculate sub-regional customer's service subscription and cancellation ratio. Additional external data such as house size, house price, and household demographics are also needed to measure sales potential. Furthermore, making tables and reports were time consuming and they were insufficient to make a clear judgment about the market situation. In 2009, this company needed a dramatic shift in the way marketing and sales activities, and finally developed a dedicated GIS_based market analysis and sales management system. This system made huge improvement in the efficiency with which the company was able to manage and organize all customer and sales related information, and access to those information easily and visually. After the GIS information system was developed, and applied to marketing and sales activities at the corporate level, the company was reported to increase sales and market share substantially. This was due to the fact that by analyzing past market and sales initiatives, creating sales potential, and targeting key markets, the system could make suggestions and enable the company to focus its resources on the demographics most likely to respond to the promotion. This paper reviews subjective and unclear marketing and sales activities that K telecommunication company operated, and introduces the whole process of developing the GIS information system. The process consists of the following 5 modules : (1) Customer profile cleansing and standardization, (2) Internal/External DB enrichment, (3) Segmentation of 3,074 legal regions into 46,590 sub_regions called blocks, (4) GIS data mart design, and (5) GIS system construction. The objective of this case study is to emphasize the need of GIS system and how it works in the private enterprises by reviewing the development process of the K company's market analysis and sales management system. We hope that this paper suggest valuable guideline to companies that consider introducing or constructing a GIS information system.

A Study on the Improvement of RIMGIS for an Efficient River Information Service (효율적인 하천정보 서비스를 위한 RIMGIS 개선방안 연구)

  • Shin, Hyung-Jin;Chae, Hyo-Sok;Hwang, Eui-Ho;Lim, Kwang-Suop
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.16 no.1
    • /
    • pp.15-25
    • /
    • 2013
  • The RIMGIS(River Information Management GIS) has been developed since 2000 for public service and practical applications of related works after the standardization of national river data such as the river facility register report, river survey map, attached map, and etc. The RIMGIS has been improved in order to respond proactively to change in the information environment. Recently, Smart River-based river information services and related data have become so large as to be overwhelming, making necessary improvements in managing big data. In this study a plan was suggested both to respond to these changes in the information environment and to provide a future Smart River-based river information service by understanding the current state of RIMGIS, improving RIMGIS itself, redesigning the database, developing distribution, and integrating river information systems. Therefore, primary and foreign key, which can distinguish attribute information and entity linkages, were redefined to increase the usability of RIMGIS. Database construction of attribute information and entity relationship diagram have been newly redefined to redesign linkages among tables from the perspective of a river standard database. In addition, this study was undertaken to expand the current supplier-oriented operating system to a demand-oriented operating system by establishing an efficient management of river-related information and a utilization system capable of adapting to the changes of a river management paradigm.

Study on the Standardization of Management Form through Integrated Management of CCTV (CCTV 통합관리를 위한 관리대장 표준화 연구)

  • PARK, Jeong-Woo;LEE, Seong-Ho;NAM, Kwang-Woo
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.19 no.2
    • /
    • pp.63-72
    • /
    • 2016
  • Closed-circuit television(CCTV) is a facility that forms the backbone of the ubiquitous services provided by the Integrated Management Center of the Ministry of Land, Infrastructure and Transport and the Integrated Control Center of the Ministry of the Interior. However, it is installed and managed according to different laws, as it is operated and managed by each department. Moreover, because there are no regulatory grounds for unified management of CCTV, each municipality responsible for the actual management manages it based on the individual standards of each department. Thus, the purpose of this study is to develop a standardized management form to establish an integrated management plan. The author inspected the existing situation by examining the legal system and public data and through hands-on worker interviews, and discovered the managed element by reviewing the specifications of the bidding system. The management form for integrated management comprises the above requirements along with the management histories and linkage of intelligent facilities. A uniform management form for integrated management containing specifications of the CCTVs installed by various departments is created, and is easily searched for facilities to check requirements for joint use. The result of this study can contribute to building the database of facility management system for integrated management of facilities at the integrated management center as well as for a detailed simulation of the selection of location of CCTV depending on the CCTV's specifications.

A Prospect for Growth and Economic Size of Foods-for-Elderly Industry -Focused on Health Functional Foods and Foods for Special Dietary Uses- (고령친화식품산업의 성장과 규모 전망 -건강기능식품과 특수용도식품을 중심으로-)

  • Jin, Hyun Joung;Woo, Hee Dong
    • Journal of Food Hygiene and Safety
    • /
    • v.27 no.4
    • /
    • pp.339-348
    • /
    • 2012
  • The purpose of this study is to predict the economic size of foods-for-elderly market, which will be valuable information for establishing related policy and backup system. After setting the scope of related industry, detailed information for current market situation was investigated and a systematic forecast for market changes in the future was performed. Economic growth, changes in consumer expenditure and economic status of the elderly, current subscription of medical insurance and saving for pension were reflected. In addition, a survey toward related firms was completed and changes in aged population and incidence of chronic disease in the elderly were taken into account. Results show that the annual growth rate of the market was predicted to be the minimum 4.54% through the maximum 8.32% from 2010 to 2025 and its market size was forecasted to be the minimum 7,073 ten million won through the maximum 10,976 ten million won. It is expected that the market of foods-for-elderly will grow rapidly with development of foods technology and fast increase of aged population. Especially, growth of health functional foods and foods for special dietary uses for elderly will be distinguished. However, it seems that related firms are on the hedge, watching current trend of the related industry. This may results in insufficient supply against the demand. Therefore, policy for foods-for-elderly should be introduced and systematically administered, including R&D support, standardization and authentication for foods-for-elderly, construction of related database system.

Development of IFC Standard for Securing Interoperability of BIM Data for Port Facilities (항만 BIM 데이터의 상호운용성 확보를 위한 IFC 표준 개발)

  • Moon, Hyoun-Seok;Won, Ji-Sun;Shin, Jae-Young
    • Journal of KIBIM
    • /
    • v.10 no.1
    • /
    • pp.9-22
    • /
    • 2020
  • Recently, BIM has been extended to infrastructures such as roads and bridges, and the demand for BIM standard development for ports is increasing internationally. Due to the low level of utilization of classification system and drawing standards compared to other infrastructures, and the closed nature of national security facilities, ports have insufficient level of connection and sharing environment among external systems or users. In addition, since the standardization of data for port facilities is not made, it is still necessary to establish an independent DB for each system and to ensure interoperability of data between these systems since it does not have a shared environment among similar data. Therefore, the purpose of this study is to develop and verify IFC, the international standard for BIM, in order to cope with the BIM environment and to be commonly used in the design, construction, and maintenance of port facilities. To this end, we build a standard schema with port-specific Express Notation according to buildingSMART International's standard development methodology. First, domestic and international reference model standards were analyzed to derive components such as space and facilities of port facilities. Based on this, the components of the port facility were derived through the codification, categorization, and normalization process developed by the research team. This was extended based on the port BIM object classification system developed by the research team. Normalization results were verified by designers and associations. Then, IFC schema construction was based on Express-G data modeling based on IFC 4 * 2 Candidate, which is a bridge candidate standard based on IFC4 (ISO16739), and IFC 4 * 3 Draft, which is developed by buildingSMART International. The final schema was validated using the commercialized validation tool. In addition, in order to verify the structural verification of the port IFC schema, the transformation process was verified by converting the caisson model into a Part21 file. In the future, this result will not only be used as a delivery standard for port BIM products, but will also be applied as a linkage standard between systems and a common data format for port BIM platforms when BIM is used in the maintenance phase. In particular, it is expected to be used as a core standard for data exchange in the port maintenance stage.