• Title/Summary/Keyword: Data-Warehousing

Search Result 91, Processing Time 0.021 seconds

SNA Approach for Analyzing the Research Trend of China's Logistics (SNA 분석을 활용한 중국물류 연구동향 분석에 관한 연구)

  • Song, Shi-cheng;Park, Sung-hoon;Yeo, Gi-Tae
    • Journal of Digital Convergence
    • /
    • v.16 no.5
    • /
    • pp.55-63
    • /
    • 2018
  • Although there has been a great change in the Chinese logistics industry, there have been few studies on the research trends of logistics in China. Existing research has been conducted on subdivision topics such as transportation efficiency, warehouse location and port efficiency. In this study, the research trends of logistics in China from 2000 to 2017 were analyzed using SNA method. The data were collected from foreign journals and a total of 82 related papers were used for analysis. The first period (2000-2008) was derived from the top keywords such as "Globalization", "Hong Kong", "FDI" and "outsousing". The results of the second period (2009-2013) were derived from keywords such as "international trade" and "reverse logistics", and in the third period (2013-2017) "3PL", "warehousing", "railways" "supply chain", "economic", "port" and "Belt and Road" The analysis of China's logistics using SNA method shows that the research trend of China's logistics is evolving as China is changing rapidly under the globalization context.

A Study on analysis framework development for yield improvement in discrete manufacturing (이산 제조 공정에서의 수율 향상을 위한 분석 프레임워크의 개발에 관한 연구)

  • Song, Chi-Wook;Roh, Geum-Jong;Park, Dong-Jin
    • The Journal of Information Systems
    • /
    • v.26 no.2
    • /
    • pp.105-121
    • /
    • 2017
  • Purpose It is a major goal to improve the product yields during production operations in the manufacturing industry. Therefore, factory is trying to keep the good quality materials and proper production resources, also find the proper condition of facilities and manufacturing environment for yields improvement. Design/methodology/approach We propose the hybrid framework to analyze to dataset extracted from MES. Those data is about the alarm information generated from equipment, both measurement and equipment process value from production and cycle/pitch time measured from production data these covered products during production. We adapt a data warehousing techniques for organizing dataset, a logistic regression for finding out the significant factors, and a association analysis for drawing the rules which affect the product yields. And then we validate the framework by applying the real data generated from the discrete process in secondary cell battery manufacturing. Findings This paper deals with challenges to apply the full potential of modeling and simulation within CPPS(Cyber-Physical Production System) and Smart Factory implementation. The framework is being applied in one of the most advanced and complex industrial sectors like semiconductor, display, and automotive industry.

Implementation of the OLAP-based Subway Passenger Transit Pattern Analysis System (OLAP을 활용한 지하철 인구이동 맵 생성에 관한 연구)

  • Cho, Jae-Hee;Seo, Il-Jung
    • Information Systems Review
    • /
    • v.7 no.1
    • /
    • pp.65-80
    • /
    • 2005
  • The Seoul Metropolitan Subway Corporation (SMS) and the Seoul Metropolitan Rapid Transit Corporation (SMRT), which manage the city's eight subway lines, are intending to overcome their operational inefficiencies. The two investigators of the paper realize with emphasis that it is essential for the two subway authorities to analyze subway transit data prior to put policies and plans into practice. In this paper, the investigators propose a new, and an intuitive, way of analyzing subway passenger transit patterns. To achieve this goal, they have implemented a data mart by blending the "Pass Card" log data into the multidimensional model. The subway passenger's transit patterns and the practical implications of this system are also investigated.

A Database Schema Integration Method Using XML Schema (XML Schema를 이용한 이질의 데이터베이스 스키마 통합)

  • 박우창
    • Journal of Internet Computing and Services
    • /
    • v.3 no.2
    • /
    • pp.39-56
    • /
    • 2002
  • In distributed computing environments, there are many database applications that should share data each other such as data warehousing and data mining with autonomy on local databases. The first step to such applications is the integration of heterogeneous database schema, but there is no accepted common data model for the integration and also are difficulties on the construction of integration program. In this paper, we use the XML Schema for the representation of common data model and exploit XSLT for reducing the programming difficulties. We define the schema integration operations and develop a methodology for the semi-automatic schema integration according to schema conflicts types. Our integration method has benefits on standardization, extendibility on schema integration process comparing to existing methodologies.

  • PDF

View Maintenance Policy for considering MIN/MAX query in Data warehousing (데이터웨어하우징에서 MIN/MAX질의를 고려한 뷰관리 정책)

  • 김근형;김두경
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.6 no.8
    • /
    • pp.1336-1345
    • /
    • 2002
  • Materialized views in data warehouse play important roles in rapidly answering to users's requests for information Processing. More views in data warehouse, can respond to the users more rapidly because the user's requests may be processed by using only the materialized views with higher probabilities rather than accessing base relations. The limited duration, during which the materialized views are updated due to base relations's changes, limits the number of materialized views in data warehouse. In this paper, we propose efficient policy for updating the materialized views, which can save the update duration of views although MIN/MAX values frequently change in base relation. The policy updates the materialized views by distinguishing whether MIN/MAX values's changes in the base relation are insert value or delete value. Then, the number of accesses to the base relation is descreased when updating the MIN/MAX values in the materialized views.

An Efficient Query Processing in Stream DBMS using Query Preprocessor (질의 전처리기를 사용한 스트림 DBMS의 효율적 질의처리)

  • Yang, Young-Hyoo
    • Journal of the Korea Society of Computer and Information
    • /
    • v.13 no.1
    • /
    • pp.65-73
    • /
    • 2008
  • The telematics data management deals with queries on stream data coming from moving cars. So the stream DBMS should process the large amount of data stream in real-time. In this article, previous research projects are analyzed in the aspects of query processing. And a hybrid model is introduced where query preprocessor is used to process all types of queries in one singe system. Decreasing cost and rapidly increasing Performance of devices may guarantee the utmost parallelism of the hybrid system. As a result, various types of stream DBMS queries could be processed in a uniform and efficient way in a single system.

  • PDF

XML Element Matching Algorithm based on Structural Properties and Rules (룰과 구조적 속성에 기반한 XML 엘리먼트 매칭 알고리즘)

  • Park, Hyung;Jeong, Chanki
    • Journal of Information Technology and Architecture
    • /
    • v.10 no.1
    • /
    • pp.71-77
    • /
    • 2013
  • XML schema matching is the task of finding semantic correspondences between elements of two schemas. XML schema matching plays an important role in many application, such as schema integration, data integration, data warehousing, data transformation, peer-to-peer data management, semantic web etc. In this paper, we propose an XML element matching algorithm based on rules and structural properties. The proposed algorithm involves classifying elements as unique or non-unique elements according to the structural properties of XML documents and deciding on element matching in accordance with rules. We present experimental results that demonstrate the effectiveness of the proposed approach.

Development of a CASE Tool on Relational Databases for Distributed Object Systems (분산객체 시스템을 위한 관계형 데이터베이스 연동도구의 개발)

  • Park, U-Chang;,
    • The Transactions of the Korea Information Processing Society
    • /
    • v.7 no.1
    • /
    • pp.20-28
    • /
    • 2000
  • In distributed data processing environments, heterogeneous data sources should corporate each other. The CORBA standards proposed by OMG solve this problem by the integration of platform independent applications. In this paper, we design and implement a CASE tool that help linking CORBA applications to relational databases by interface method. This CASE tool manipulates the database schema and generates IDL and $C^{++}$ stubs corresponding to the schema. We explain the code generation process and evaluate the data access performance of the interface method compared to adapter method and various implementation languages. The implemented tool can be used for developing applications that need relational database corporation environments such as distributed information systems or data warehousing. etc.

  • PDF

Assessment & Justification of Data Warehousing from A Competitive Advantage Perspective (경쟁우위적 관점에서의 데이터 웨어하우징 평가 및 정당화)

  • Park, Yong-Tae
    • The Journal of Information Systems
    • /
    • v.16 no.1
    • /
    • pp.65-90
    • /
    • 2007
  • 전통적인 비용수익 분석법 (CBA approach) 과 활동기준원가계산 방법 (ABC approach)과 같은 지금까지의 방법으로는 전략적 정보시스템이나 정보 하부구조를 효과적으로 평가하고 정당화하는데 한계가 있다고 지적되어왔다. 따라서, 본 논문은 정보시스템의 하부구조를 이루고 있는 데이터 웨어하우징을 스물여섯 개의 데이터 웨어하우징 성공사례 분석을 통해서 데이터 웨어하우징이 가치사슬 모델의 각 활동에 어떻게 활용되고 있는지를 분석하고, 경쟁우위적 관점에서 이들 사례들의 공통점을 찾아내어, 데이터 웨어하우징을 경쟁우위적 관점에서 보다 효과적으로 정당화할 수 있는 모델을 제시하고 있다. 이 모델은 기존의 정보시스템 정당화에 사용되어왔던 방법들의 단점을 보완하여, 기업들이 데이터 웨어하우징이나 경쟁우위를 확보하기 위해서 구축하는 다른 정보시스템들을 경쟁우위적 관점에서 정당화하고자 할 때 유용한 도구로써, 기존의 방법들과 병행해서 사용하면 보다 효과적으로 정보시스템들을 평가하고 정당화할 수 있으리라 생각된다.

  • PDF

Meeting the Demands for Major International Traffic Flows through Railnet Austria's Maintenance and Capacity Planning Regime

  • Herbacek, R.;Petri, K.;Ertl, B.
    • International Journal of Railway
    • /
    • v.1 no.4
    • /
    • pp.134-142
    • /
    • 2008
  • Serving as a strategic crossing point for major corridors in Central Europe, Railnet Austria's Infrastructure Network incurs continual increases in international traffic flows and is therefore subject to accumulating traffic congestion with potential restrictions to infrastructure access. This imposes challenges towards preserving open access to Railnet Austria's existing railway network and hinders quality infrastructure service during maintenance, repair, and upgrading. Through Railnet Austria's experiences, the economic viability of a railway network can be sustained through maintaining open access with good quality service of planned trainpaths, thus representing new challenges for future infrastructure maintenance and capacity planning. Railnet Austria's Capacity Management Department has proven that these challenges can be accommodated more effectively through recent technological developments in data warehousing and software development.

  • PDF