• Title/Summary/Keyword: data warehousing

Search Result 91, Processing Time 0.022 seconds

A Study on the Brand-based Warehouse Management in Online Clothing Shops (온라인 쇼핑몰의 브랜드 중심 창고관리 기법에 대한 연구)

  • Song, Yong-Uk;Ahn, Byung-Hyuk
    • Journal of Information Technology Applications and Management
    • /
    • v.18 no.1
    • /
    • pp.125-141
    • /
    • 2011
  • As the sales volume of online shops increases, the job burden in the back-offices of the online shops also increases. Order picking is the most labor-intensive operation among the jobs in a back-office and mid-size pure click online shops are experiencing the time delay and complexity in order picking nowadays while fulfilling their customers' orders. Those warehouses of the mid-size shops are based on manual systems, and as order pickings are repeated, the warehouses get a mess and lots of products in those warehouses are getting missing, which results in severe delay in order picking. To overcome this kind of problem in online clothing shops, we research a methodology to locate warehousing products. When products arrive at a warehouse, they are packed into a box and located on a rack in the warehouse. At this point, the operator should determine the box to be put in and the location on the rack for the box to be put on. This problem could be formulated as an Integer Programming model, but the branch-and bound algorithm to solve the IP model requires enormous computation, and sometimes it is even impossible to get a solution in a proper time. So, we relaxed the problem, developed a set of heuristics as a methodology to get a semi-optimum in an acceptable time, and proved by an experiment that the solutions by our methodology are satisfactory and acceptable by field managers.

Distribution Strategy: Lessons from the United States COVID-19 Vaccine Distribution

  • KIM, Dongho;YOUN, Myoung-Kil
    • Journal of Distribution Science
    • /
    • v.19 no.8
    • /
    • pp.5-12
    • /
    • 2021
  • Purpose: The purpose of this paper is to analyze and examine the issues that are directly associated with the United States COVID-19 vaccine distribution and its strategies so that other countries may learn from it and develop sound distribution strategies. Research design, data and methodology: This paper has applied both historical and narrative models to review, identify, and analyze existing literatures to assess the United States' vaccine distribution strategy. Results: Distribution strategy developed by the United States seems to have focused heavily on the basic tenets of physical distribution, i.e., transportation, warehousing, inventory, and large-venue mass-vaccination sites, and the strategy seems to have been successful when looking only at the physical tenets of distribution. However, the analysis indicates that the distribution strategy has not either focused on or included the major activities of distribution, such as inward and outward communication, information, and customer satisfaction. Conclusions: The countries that are currently developing or implementing COVID-19 vaccine distribution strategy should review and learn from the United States' vaccine distribution strategy and its implementation. The countries should include and address all the activities of distribution, including inward and outward communication, information, and customer satisfaction to achieve their vaccination goals, minimize confusion, reduce wasting of doses and vaccine desserts, and improve vaccination rates.

Factors Affecting the Application of Strategy Management Accounting in Vietnamese Logistics Enterprises

  • VU, Thi Kim Anh;DAM, Bich Ha;HA, Thi Thuy Van
    • Journal of Distribution Science
    • /
    • v.20 no.1
    • /
    • pp.27-39
    • /
    • 2022
  • Purpose This research aims to investigate factors affecting the application of strategic management accounting in Vietnamese Logistics Enterprises. Design/Methodology/Approach: Quantitative research was conducted and data was collected by sending questionnaires to 188 accountants and directors from Vietnamese Logistics Enterprises (including, transportation, warehousing and forwarding). 5 factors (namely: size and organizational structure, technological advancement, and strategic management accounting implementing costs) were selected to measure the application of strategic management accounting (SMA) in Vietnamese Logistics Enterprises (LEs) through correlation and regression analysis. Results: The empirical findings show that there exists a significant association between these factors and the SMA application. LEs have strongly supported the application of SMA as a tool to provide information for making their strategic decisions. The factors including size and organizational structure, technological advancement, SMA implementing c osts, and strategy positively impact the SMA application in both financial and non-financial aspects. This finding helps the adm inistrators realize the importance of SMA. Conclusions: This study provided an overview of SMA application and its benefits to enterprises. It helps managers have a better understanding of SMA and future directions for application. Moreover, the research results will be useful for managers to identify factors influencing their SMA practices and improve the current management process applied in organizations.

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.

Development and Application of a Big Data Platform for Education Longitudinal Study Analysis (교육종단연구 분석을 위한 빅데이터 플랫폼 개발 및 적용)

  • Park, Jung;Cho, Wan-Sup
    • The Journal of Bigdata
    • /
    • v.5 no.1
    • /
    • pp.11-27
    • /
    • 2020
  • In this paper, we developed a big data platform to store, process, and analyze effectively on such education longitudinal study data. And it was applied to the Seoul Education Longitudinal Study(SELS) to confirm its usefulness. The developed platform consists of data preprocessing unit and data analysis unit. The data preprocessing unit 1) masking, 2) converts each item into a factor 3) normalizes / creates dummy variables 4) data derivation, and 5) data warehousing. The data analysis unit consists of OLAP and data mining(DM). In the multidimensional analysis, OLAP is performed after selecting a measure and designing a schema. The DM process involves variable selection, research model selection, data modification, parameter tuning, model training, model evaluation, and interpretation of the results. The data warehouse created through the preprocessing process on this platform can be shared by various researchers, and the continuous accumulation of data sets makes further analysis easier for subsequent researchers. In addition, policy-makers can access the SELS data warehouse directly and analyze it online through multi-dimensional analysis, enabling scientific decision making. To prove the usefulness of the developed platform, SELS data was built on the platform and OLAP and DM were performed by selecting the mathematics academic achievement as a measure, and various factors affecting the measurements were analyzed using DM techniques. This enabled us to quickly and effectively derive implications for data-based education policies.

A Case Study of e-Business Implementation in Part Manufacturing Industry(B2B in PCB Industry) (부품 제조 산업에서의 e-Business 구축 사례(PCB 산업의 B2B))

  • Bae, Joon-Soo;Bae, Eun-Hae;Cheong, Min-Chang;Shin, In-Ki;Park, Young-Chul
    • IE interfaces
    • /
    • v.13 no.3
    • /
    • pp.503-511
    • /
    • 2000
  • The main theme of this research is a case of e-Business implementation in part manufacturing industry, especially in a PCB manufacturing company. The characteristics of part manufacturing industry are as follows. First, an ERP system runs as a legacy system that is ready to be combined with e-Business system. Secondly, the number of customers is very small. The customers are not many individuals but only a few big electronic enterprises that are strategically affiliated with the part manufacturing company. This means that the e-Business of the part manufacturing industry needs to focus on sharing pertinent information throughout the transactions with the customers, not on data-warehousing or data-mining customers' potential needs or requests. In this paper, we extracted e-Business opportunity domains from a PCB manufacturing company, a typical part manufacturing industry. We are intended to enhance information sharing between customers and the company, and provide functions of transactions necessary in the whole value chain from order to shipment. Implementing the e-Business system on the Web can increase the visibility of customers, and further, the company can be transformed into an extended enterprise where the relationship with the customers becomes very close and interleaved. Also, the Cyber Office functionality of the e-Business system can support the salespersons effectively, so that they can spend more time on customer satisfaction. Such efforts, in the future, can be a basis for active adaptation to the industry transformations such as forming e-community and participating in the marketplace.

  • PDF

CS-Tree : Cell-based Signature Index Structure for Similarity Search in High-Dimensional Data (CS-트리 : 고차원 데이터의 유사성 검색을 위한 셀-기반 시그니쳐 색인 구조)

  • Song, Gwang-Taek;Jang, Jae-U
    • The KIPS Transactions:PartD
    • /
    • v.8D no.4
    • /
    • pp.305-312
    • /
    • 2001
  • Recently, high-dimensional index structures have been required for similarity search in such database applications s multimedia database and data warehousing. In this paper, we propose a new cell-based signature tree, called CS-tree, which supports efficient storage and retrieval on high-dimensional feature vectors. The proposed CS-tree partitions a high-dimensional feature space into a group of cells and represents a feature vector as its corresponding cell signature. By using cell signatures rather than real feature vectors, it is possible to reduce the height of our CS-tree, leading to efficient retrieval performance. In addition, we present a similarity search algorithm for efficiently pruning the search space based on cells. Finally, we compare the performance of our CS-tree with that of the X-tree being considered as an efficient high-dimensional index structure, in terms of insertion time, retrieval time for a k-nearest neighbor query, and storage overhead. It is shown from experimental results that our CS-tree is better on retrieval performance than the X-tree.

  • PDF

출생 및 사망신고체계의 현황과 발전방향

  • Park Jeong-Han
    • 대한예방의학회:학술대회논문집
    • /
    • 2001.04a
    • /
    • pp.50-72
    • /
    • 2001
  • 국민건강 수준과 문제점의 파악, 보건사업의 기획 및 평가를 위해 정확한 출생과 사망에 관한 통계자료가 필수적이다. 그러나 출생신고 이전에 신생아가 사망하는 경우에 대부분 출생과 사망 모두를 신고하지 않아 영아사망률을 비롯한 보건통계를 산출하지 못하여 합리적인 보건사업의 기획 및 평가가 어려우며, OECD 회원국으로서 제시해야 할 기본적인 보건통계를 제시하지 못하고 있다. 또한 현행 출생신고자료에는 신생아와 산모의 건강상태에 관한 자료가 없어 보건서비스제공과 모자보건관련 역학적 연구에 활용 가치가 거의 없다. 지역보건의료정보화, 예방접종기록전산화, 미숙아 및 선천성기형아 등록 등 각종 등록 및 전산화사업이 진행중이나 이러한 사업들이 독립적으로 진행되고 있어 같거나 비슷한 자료의 중복 입력하게 되고, 상호 연계가 되지 않아 자료의 활용성이 낮고, 그 어느 사업도 전체 분모를 파악할 수 없는 단점이 있다. 이러한 문제들은 전산정보체계의 확립으로 해결할 수 있다. 약 99%의 분만이 의료기관에서 일어나고, 정부의 초고속 통신망을 비롯한 의료기관과 보건소의 전산화가 빠르게 진행되고 있어 전산정보체계를 위한 여건이 성숙되고 있다. 분만의료기관이 산모의 거주지 보건소로 직접 출생신고를 하면 보건소는 적기에 산모와 신생아에게 필요한 보건서비스를 제공할 수 있고, 보건소가 읍 면 동사무소로 출생신고 자료를 전송하면 산모는 동사무소에 가지 않고도 출생신고를 할 수 있으며, 보건통계자료수집과 출생신고관리에 필요한 인력과 시간을 절약할 수 있고, 정확한 생정통계를 얻을 수 있고, 예방접종기록과 미숙아 및 선천성기형아 등록은 쉽게 해결되고, 완전한 보건사업대상자의 database를 구축할 수 있어 평생건강관리체계의 기틀을 마련하게 된다. 이러한 전산신고체계를 확립하기 위하여 연자 등은 정부의 연구용역사업으로 전산프로그램과 표준신고양식과 신고체계를 개발하여, 포항과 천안시에서 2000년 3월에서 8월까지 시험 운영하였다. 시험운영결과 출생신고율은 99.9%이었으나 신생아사망의 전산신고율은 11.1%로 낮았다. 그러나 일단 출생신고된 신생아의 사망은 반드시 확인될 수 있는 것이 본 신고체계의 큰 장점이었다. 전산신고의 중요한 장애 요소는 현행법상 의료기관이 출생신고를 직접 할 의무가 없으므로 신고를 강요할 수 없고, 의료기관의 일손 부족으로 출생신고서를 충실하게 기재하지 못하는 것과 의료기관간의 전산화 수준의 차이가 심한 것이었다. 의료기관이 직접 신고를 하도록 하기 위하여 모자보건법 등 관련법 개정이 필요하며, 의료기관의 출생신고자료 송부에 대한 정당한 보상이 있어야 할 것이다. 의료기관 간의 전산화 수준의 차이는 data warehousing과 on-line analytical processing과 같은 기술을 이용하면 해결 가능할 것이다.

  • PDF

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

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