• Title/Summary/Keyword: warehousing

Search Result 173, Processing Time 0.027 seconds

A Study of Similarity Measures on Multidimensional Data Sequences Using Semantic Information (의미 정보를 이용한 다차원 데이터 시퀀스의 유사성 척도 연구)

  • Lee, Seok-Lyong;Lee, Ju-Hong;Chun, Seok-Ju
    • The KIPS Transactions:PartD
    • /
    • v.10D no.2
    • /
    • pp.283-292
    • /
    • 2003
  • One-dimensional time-series data have been studied in various database applications such as data mining and data warehousing. However, in the current complex business environment, multidimensional data sequences (MDS') become increasingly important in addition to one-dimensional time-series data. For example, a video stream can be modeled as an MDS in the multidimensional space with respect to color and texture attributes. In this paper, we propose the effective similarity measures on which the similar pattern retrieval is based. An MDS is partitioned into segments, each of which is represented by various geometric and semantic features. The similarity measures are defined on the basis of these segments. Using the measures, irrelevant segments are pruned from a database with respect to a given query. Both data sequences and query sequences are partitioned into segments, and the query processing is based upon the comparison of the features between data and query segments, instead of scanning all data elements of entire sequences.

Warehouse System of Parts in Variable Location by Rule-Based Module Management for Context Awareness (규칙기반 상황인식 모듈관리에 의한 가변위치 부품창고 시스템)

  • Min, Deul-Le;Jun, Byung-Hwan
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.46 no.4
    • /
    • pp.111-120
    • /
    • 2009
  • In this paper, we propose ubiWarehouse system which can efficiently manages mass and many kinds of parts such as automotive parts. First, user's work situation is defined systematically as context type of 5W1H, context-aware system is separated on function, and each module operates independently. An efficient route is selected and relevant parts frequently treated at the same time are gathered by calculating the suitability of parts and racks. If other users currently are on a visit or are supposed to visit soon, the hun of visit is changed making a concession for preventing collision. As a result, the proposed system with avoiding competition can provide users with routes for inbound or outbound parts, and can effectively use spaces of a warehouse by arranging racks to gather relevant parts to near location. Also, individual service can be offered by evaluating user propensity using history of the warehouse job, and the accuracy of stock information can be improved by processing of unexpected context and real-time renewing of warehousing and delivering.

A Study on the Data Warehousing System of General Hospital (종합병원 데이터웨어하우스 시스템에 관한 연구)

  • 박찬석;고석하
    • Proceedings of the Korea Society of Information Technology Applications Conference
    • /
    • 2002.11a
    • /
    • pp.304-318
    • /
    • 2002
  • 본 연구는 종합병원에서 운영중인 병원정보시스템(Hospital Information System)을 기준으로 업무별 데이터 마트를 구성하여 종합병원 데이터 웨어하우스 시스템을 제안하는 연구이다. 본 연구에서 제안한 병원 데이터웨어하우스 모형은 충남대학교병원 데이터 웨어하우스 시스템 구축 보고서, Inmon의 데이터 웨어하우스 개발방법론에 기초를 두었다. 종합병원의 데이터하우스시스템을 제안하면 다음과 같다. 첫째, 원무 데이터마트, 병원의 원무팀에서 주로 사용하는 것으로써 수입에 관련된 정보, 진료인원에 관한 정보, 심사/청구/삭감에 관한 정보들로 구성되어 있다. 둘째, 약국 데이터마트, 처방전달 데이터 마트와 연결되어 외래/입원의 처방에 관한 정보, 약에 대한 효능과 성분에 대한 정보, 투약과 검사에 대한 정보들로 구성된다. 셋째, 의무기록 데이터마트, 의무기록팀에서 관리하는 퇴원 정보, 암환자에 대한 정보, 외래/입원 환자 통계에 대한 정보들로 이루어진다. 넷째, 처방전달 데이터마트, 주로 의사가 환자에게 행한 처치/처방/수술과 진료기록에 대한 정보들을 기준으로 환자진료나 임상연구에 필요한 정보를 제공한다. 다섯째, 병원 행정 데이터마트, 인사정보, 급여정보, 회계정보, 예산정보, 물류정보 등으로 구성되어 병원의 자원활용이나 행정에 대한 전반적인 정보를 제공한다. 여섯째, 경영지원 데이터마트, 병원경영에 필요한 수입정보, 원가분석 정보, 진료인원 정보들을 한 형태로 제공한다. 또한 의사결정 형태도 의료진 중심의 병원에서 환자중심의 병원으로 구조를 바꾸었고 투명한 정보공유와 기초 데이터들의 정제는 부가가치가 높은 정보로 가공할 수 있게 되었으며 각 전문 직종간의 단절된 정보 흐름을 유기적으로 교환할 수 있게 되어 지식의 교환을 촉진시켰다. 그리고 온라인거래처리시스템(OLTP)의 한계점인 하드웨어적인 문제와 성능 저하에 대한 문제를 해결하였고, OLTP시스템에서 분리되고 이원화된 코드체계와 데이터 형태의 이질화를 통일하는 방법으로 데이터웨어하우스 시스템을 제시하였다. 결국 병원에서 데이터웨어하우스 시스템의 구축은 임상, 연구, 교육의 유기적 순환관계를 정립하여 지식의 순환적 고리인 수집, 공유, 확산, 재창출을 지속적 유지할 수 있는 인프라를 구축해 준다. 반면 상이한 정보들간의 충돌과 이에 따른 해석의 오류로 잘못된 의사결정을 위한 정보를 제공할 수 있고 기초정보의 접근 및 추출의 유용성에 의해서 정보유출에 대한 문제가 한계점으로 나타났다.

  • PDF

Design and Implementation of RFID-based U-SCM System for Automobile Part Industry (자동차부품산업의 RFID기반 U-SCM시스템 설계 및 구현)

  • Moon, Tae-Soo;Choi, Sang-Min;Kang, Sung-Bae
    • The Journal of Society for e-Business Studies
    • /
    • v.14 no.4
    • /
    • pp.267-286
    • /
    • 2009
  • Most companies in automobile part industry need a SCM (Supply Chain Management) system under the cooperation with suppliers for assembling a automobile. Automobile part industry has a industry feature of hierarchical structure like 1st, 2nd, 3rd vendors. Recently, new cases to implement RFID (Radio Frequency Identification) technology appear in various areas required for integrated information system. Especially, supply chain environment in automobile part industry turns toward ubiquitous computing environment. Most companies in automobile part industry are interested in implementing RFID-based supply chain management system, which makes them shorten the business process, share the transaction information, and enhance the collaborative relationship between trading partners. This paper intends to implement RFID technology in the physical distribution area of automobile part industry such as warehousing, delivering, inventory management. The purpose of this paper is to improve the collaborative relationship of supply chain network using RFID applied to u-SCM system in ubiquitous computing environment. The contribution of this paper is to suggest a new system approach to transform existing business process into new business process through designing and implementing a RFID based SCM system using UML techniques.

  • PDF

The Entrepreneurship of Mayun and The Logistics Strategy of Alibaba Group (마윈(馬雲)의 기업가정신과 알리바바의 물류 전략)

  • Jo, Jin-Haeng
    • Journal of Korea Port Economic Association
    • /
    • v.33 no.4
    • /
    • pp.149-172
    • /
    • 2017
  • The Alibaba Company, founded by Mayun in 1997, captured no.1 position in the global electronic commerce industry in 2016. Logistics strategy and paying system of the firm have greatly contributed to its success. The study aims not only to investigate the entrepreneurship of Mayun to inspire Korean youths with it, but also to help Korean E Commerce industry with logistics strategy of the Alibaba Group. The study adopts the management history approach through a literature survey on life time story, management philosophy of Mayun. Results from a study on Ma Yun's entrepreneurship style showed certain key characteristics: a global mindset, marketing and advertising proficiency, patriotism, a challenging spirit, and creativity. Alibaba's logistics system has greatly contributed to the success of the company's E commerce trade so far. However, some things are left to be desired in the following areas: logistics management system, logistics contract unit price, competitiveness in warehousing compared to rival Chinese companies, and last mile delivery.

Multiagent Enabled Modeling and Implementation of SCM (멀티에이전트 기반 SCM 모델링 및 구현)

  • Kim Tae Woon;Yang Seong Min;Seo Dae Hee
    • The Journal of Information Systems
    • /
    • v.12 no.2
    • /
    • pp.57-72
    • /
    • 2003
  • The purpose of this paper is to propose the modeling of multiagent based SCM and implement the prototype in the Internet environment. SCM process follows the supply chain operations reference (SCOR) model which has been suggested by Supply Chain Counsil. SCOR model has been positioned to become the industry standard for describing and improving operational process in SCM. Five basic processes, plan, source, matte, deliver and return are defined in the SCOR model, through which a company establishes its supply chain competitive objectives. A supply chain is a world wide network of suppliers, factories, warehouses, distribution centers and retailers through which raw materials are acquired, transformed or manufactured and delivered to customers by autonomous or semiautonomous process. With the pressure from the higher standard of customer compliance, a frequent model change, product complexity and globalization, the combination of supply chain process with an advanced infrastructure in terms of multiagent systems have been highly required. Since SCM is fundamentally concerned with coherence among multiple decision makers, a multiagent framework based on explicit communication between constituent agents such as suppliers, manufacturers, and distributors is a natural choice. Multiagent framework is defined to perform different activities within a supply chain. Dynamic and changing functions of supply chain can be dealt with multi-agent by cooperating with other agents. In the areas of inventory management, remote diagnostics, communications with field workers, order fulfillment including tracking and monitoring, stock visibility, real-time shop floor data collection, asset tracking and warehousing, customer-centric supply chain can be applied and implemented utilizing multiagent. In this paper, for the order processing event between the buyer and seller relationship, multiagent were defined corresponding to the SCOR process. A prototype system was developed and implemented on the actual TCP/IP environment for the purchase order processing event. The implementation result assures that multiagent based SCM enhances the speed, visibility, proactiveness and responsiveness of activities in the supply chain.

  • PDF

Design and implementation of a Web-based OLAP metadata interchange system (웹 기반의 OLAP 메타데이터 교환 시스템의 설계 및 구현)

  • Lee, In-Gi;Lee, Min-Soo;Yong, Hwan-Seung
    • The KIPS Transactions:PartD
    • /
    • v.9D no.6
    • /
    • pp.971-980
    • /
    • 2002
  • As the importance of knowledge management is being recognized, there is a significant amount of increase for interest in data warehousing. On-Line Analytical Processing (OLAP) systems can effectively make use of data warehouses. Although there are many commercial OLAP products, they have been developed without any kind of standard resulting in poor data exchange and difficulty in interfacing among the OLAP products. In this paper we propose an OLAP metadata interchange model that can be used among different OLAP products and have implemented an OLAP metadata interchange system that can interchange the cubes created from the metadata. XML is used for the OLAP metadata model and the user interface is Web-based, which makes it easier to interchange metadata among different OLAP products. Users can experience the different analysis environments of different products without the need to learn the complex cube creation process for each product. By extending this research to design a common query language that can be used among OLAP products, OLAP products should be able to more easily talk to one another.

Automatic Identification of Database Workloads by using SVM Workload Classifier (SVM 워크로드 분류기를 통한 자동화된 데이터베이스 워크로드 식별)

  • Kim, So-Yeon;Roh, Hong-Chan;Park, Sang-Hyun
    • The Journal of the Korea Contents Association
    • /
    • v.10 no.4
    • /
    • pp.84-90
    • /
    • 2010
  • DBMS is used for a range of applications from data warehousing through on-line transaction processing. As a result of this demand, DBMS has continued to grow in terms of its size. This growth invokes the most important issue of manually tuning the performance of DBMS. The DBMS tuning should be adaptive to the type of the workload put upon it. But, identifying workloads in mixed database applications might be quite difficult. Therefore, a method is necessary for identifying workloads in the mixed database environment. In this paper, we propose a SVM workload classifier to automatically identify a DBMS workload. Database workloads are collected in TPC-C and TPC-W benchmark while changing the resource parameters. Parameters for SVM workload classifier, C and kernel parameter, were chosen experimentally. The experiments revealed that the accuracy of the proposed SVM workload classifier is about 9% higher than that of Decision tree, Naive Bayes, Multilayer perceptron and K-NN classifier.

A Study on the Data Warehousing System of General Hospital (종합병원 데이터웨어하우스 시스템에 관한 연구)

  • 박찬석;고석하
    • Proceedings of the Korea Society for Industrial Systems Conference
    • /
    • 2002.11a
    • /
    • pp.304-318
    • /
    • 2002
  • 본 연구는 종합병원에서 운영중인 병원정보시스템(Hospital Information System)을 기준으로 업무별 데이터 마트를 구성하여 종합병원 데이터 웨어하우스 시스템을 제안하는 연구이다. 본 연구에서 제안한 병원 데이터웨어하우스 모형은 충남대학교병원 데이터 웨어하우스 시스템 구축 보고서, Inmon의 데이터 웨어하우스 개발방법론에 기초를 두었다. 종합병원의 데이터하우스시스템을 제안하면 다음과 같다. 첫째, 원무 데이터마트, 병원의 원무팀에서 주로 사용하는 것으로써 수입에 관련된 정보, 진료인원에 관한 정보, 심사/청구/삭감에 관한 정보들로 구성되어 있다. 둘째, 약국 데이터마트, 처방전달 데이터 마트와 연결되어 외래/입원의 처방에 관한 정보, 약에 대한 효능과 성분에 대한 정보, 투약과 검사에 대한 정보들로 구성된다. 셋째, 의무기록 데이터마트, 의무기록팀에서 관리하는 퇴원요약 정보, 암환자에 대한 정보, 외래/입원 환자 통계에 대한 정보들로 이루어진다. 넷째, 처방전달 데이터마트, 주로 의사가 환자에게 행한 처치/처방/수술과 진료기록에 대한 정보들을 기준으로 환자진료나 임상연구에 필요한 정보를 제공한다. 다섯째, 병원 행정 데이터마트, 인사정보, 급여정보, 회계정보, 예산정보, 물류정보 등으로 구성되어 병원의 자원활용이나 행정에 대한 전반적인 정보를 제공한다. 여섯째, 경영지원 데이터마트, 병원경영에 필요한 수입정보, 원가분석 정보, 진료인원 정보들을 요약한 형태로 제공한다. 또한 의사결정 형태도 의료진 중심의 병원에서 환자중심의 병원으로 구조를 바꾸었고 투명한 정보공유와 기초 데이터들의 정제는 부가가치가 높은 정보로 가공할 수 있게 되었으며 각 전문 직종간의 단절된 정보 흐름을 유기적으로 교환할 수 있게 되어 지식의 교환을 촉진시켰다 그리고 온라인거래처리시스템(OLTP)의 한계점인 하드웨어적인 문제와 성능 저하에 대한 문제를 해결하였고, OLTP시스템에서 분리되고 이원화된 코드체계와 데이터 형태의 이질화를 통일하는 방법으로 데이터웨어하우스 시스템을 제시하였다. 결국 병원에서 데이터웨어하우스 시스템의 구축은 임상, 연구, 교육의 유기적 순환관계를 정립하여 지식의 순환적 고리인 수집, 공유, 확산, 재창출을 지속적 유지할 수 있는 인프라를 구축해 준다. 반면 상이한 정보들간의 충돌과 이에 따른 해석의 오류로 잘못된 의사결정을 위한 정보를 제공할 수 있고 기초정보의 접근 및 추출의 유용성에 의해서 정보유출에 대한 문제가 한계점으로 나타났다.

  • PDF

Development of Performance Analysis System for Construction Projects Using Data Warehousing Technology (데이터 웨어하우스 기술을 활용한 건설프로젝트 성과분석 시스템 개발)

  • Yu Jung-Ho;Song Sang-Hoon;You Won-Hee;Lee Hyun-Soo
    • Korean Journal of Construction Engineering and Management
    • /
    • v.6 no.1 s.23
    • /
    • pp.89-98
    • /
    • 2005
  • Recently the construction industry in Korea is facing problems such as low productivity, contraction of the domestic construction market, growing competition, and so on. To enhance the competitiveness continuously through efficiency in this business environments, construction companies need to make efforts to measure and accumulate performance data based on the strategic factors. When analysing performance of construction projects, the unique characteristics of each project should be considered properly, by which the managers can identify current status of project in various perspectives. This study proposes the performance analysis system using the concepts of balanced scorecard and data warehouse technology. The suggested system provides the management with the flexibility in analyzing performance data by applying the pre-defined key performance indicators and the function of multi-dimensional analysis.