• Journal of Digital Convergence
• /
• v.13 no.12
• /
• pp.319-324
• /
• 2015

This paper proposes an integrated management system for products of game software development. Those products generated over software life-cycle are generally huge in numbers, various in kinds and interconnected in relationships among them. Especially they are highly complex and tightly coupled each other because they are used to build another world which is composed of multi-modal data such as graphics, sound, logics and so on. Therefore it is critical to manage development products in an integrated manner to guarantee the quality of software. The proposed system is designed to provide project/requirement/configuration/traceability management capabilities and interfacing to CASE standards. To achieve the objective, it is based on data warehouse technologies which provide central repositories of heterogeneous data, multi-aspect reporting&analysis capabilities, traceability, verification, etc.

• Journal of the Korea Institute of Building Construction
• /
• v.11 no.2
• /
• pp.100-107
• /
• 2011

As construction duration significantly influences the performance and the success of construction projects, it is necessary to appropriately manage the impact factors affecting construction duration. Recently, interest in the construction industry has been rising due to the recent change in the construction legal system, and the competition among the construction companies on construction time. However, the impact factors are extremely diverse. The existing productivity data on impact factors is not sufficient to properly identify the impact factor and measure the productivity from various perspectives, such as subcontractor, time, crew, work and so on. In this respect, a multidimensional analysis by a data warehouse is very helpful in order to view the manner in which productivity is affected by impact factors from various perspectives. Therefore, this research proposes a method that effectively takes the diverse productivity data of impact factors, and generates a multidimensional analysis. Decision tree analysis, a data mining technique, is also applied in this research in order to supply construction managers with appropriate productivity data on impact factors during the construction management process.

• Information Systems Review
• /
• v.14 no.2
• /
• pp.47-63
• /
• 2012

The concept of data warehousing was born in the 1970-80s at the same time when Wal-Mart's growing database gave birth to its need to view records in a more effective way. As the world's largest retail warehouse, Wal-Mart represents the world's largest data warehouse. A large portion of the discussionaround Wal-Mart's database management heretofore has only been process-centric, however, not its data per se. The study largely involves technical concepts around database and takes a deep look at Wal-Mart's chronicle of pre-implementation (preparation), implementation, and post-implementation (evaluation) of the data warehousing project. The highlight underlies how Wal-Mart acted against solving endless problems and was able to gear their data management to business contribution. By revisiting their data warehousing project case from a current point of view, we expect their lessons to be still available and applicable. With the renewed interest in (big) data and business intelligence, Wal-Mart's high respect for data and technology holds a lot more meaning than a couple of decades ago.

• Journal of KIISE:Software and Applications
• /
• v.26 no.10
• /
• pp.1156-1166
• /
• 1999

의사결정 시스템은 전사적인 의사결정과 전략적 정보수집을 위해 거대한 량의 정보를 빠른 시간내에 제공할 것을 요구한다. 데이타 웨어하우스는 이러한 정보를 신속히 제공하기 위해 여러 지역 데이타베이스로부터 필요한 정보를 사전에 추출하고 가공 및 통합하여 별도의 저장공간에 저장한다. 일반적으로, 웨어하우스 내의 정보는 지역 데이타베이스에 저장된 정보에 대한 실체화된 뷰로서 간주하며 지역 데이타의 변경에 따라 일관성을 유지하도록 반영해야 한다. 본 논문에서는 일관성을 유지하기 위해 정보 공유가 가능한 데이타 웨어하우스 시스템의 구조와 비-보상 실체 뷰 관리 기법을 제안한다. 본 논문에서 제안한 데이타 웨어하우스 시스템의 구조는 지역 데이타베이스에서 추출된 정보를 관리하는 별도의 지역 정보 관리자를 두어 뷰 관리자들 간의 정보 공유가 가능하게 한다. 비-보상 실체 뷰 관리 기법은 지역 데이타 변경 사건에 따른 뷰 관리 시 다른 사건에 의해 영향을 받지 않도록 하기 때문에 기본의 사전 보상이나 나중 보상 기법과는 달리 추가적인 질의 처리를 요구하지 않는 기법이다.Abstract A decision support system(DSS) commonly requires fast access to tremendous volume of information. A data warehouse is a database storing the information that is extracted, filtered and integrated from several relevant local databases to reply upon aggregated queries. The information stored in the data warehouse can be regarded as materialized views. The materialized view has to be modified according to the change of the corresponding local databases to preserve the data consistency. In this paper, we propose a data warehousing system architecture allowing information sharing (DAWINS), and a non-compensating materialized view maintenance algorithm(NCA). DAWINS architecture allows relevant information to be shared by individual view managers with local data manager for each local database. Unlikely to the pre- or post-compensating algorithms, which are required to remove the effects of some events to other view in the process of view maintenance, NCA does not require any additional query processing, since a local data manager in DAWINS already maintains the effects of update events occurring in local systems.

• Journal of the Korean Society of Tobacco Science
• /
• v.17 no.2
• /
• pp.126-138
• /
• 1995

To investigate the changes of physicochemical properties of leaf tobacco during storage, cured leaves (both flue-cured(KF109) and burley(Burley 21) : 4 grades of leaves) were stored under the natural warehouse condition(room temperature) and processed leaves(both Rue-cured(NC82) and burly(Burley 21) : 6 grades of leaves) were stored at storerooms in tobacco processing plants(flue-cured Cheongju plant ; 2nd, 4th and 5th floor, burley : Kwangju plant ; 2nd floor, Chonju plant : 3rd and 5th floor). Tobacco leaves were sampled and analyzed every 3 months. Total sugar content of flue-cured leaf decreased slightly and the redness degree of leaf increased after 15 months' storage under the natural warehouse conditions. The pH of cured leaves were lowered both flue-cured and burley, and the decreasing rate of pH was large in flue-cured(0.24) as compared with burley(0.14). There was no significant differences of physicochemical properties of processed leaf among storerooms during 15 months' storage. The decreasing rate of processed leaf pH was somewhat large in flue-cured(0.26) as compared with burly (0.20), and in thick leaves as compared with thin leaves. The redness degree of flue-cured leaf increased slightly, while the degree of lightness and yellowness lowered slightly during storage. The lightness degree of burley leaf lowered slightly, too. The ageing process of cured leaf was similar to that of processed leaf, it is considered that the passing days after curing will be more reasonable than the passing days after processing for the establishment of proper ageing period.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.11 no.4
• /
• pp.641-647
• /
• 2007

It has been said that Warehouse Management System(WMS) in e-Trade has considerably contributed to improvement of distribution industry. However, in the aspect of management we have many technical problems such as transportation due to tremendous demands of online data. Therefore, for Korea to be a hub of distribution and information, this is the best time to prepare the foundation of Supply Chain Management(SCM) under Enterprise Resource Planning (ERP) the and make a good use of WMS. The purposes of this study are presented as follows: First, it is to examine the general flow process of WMS in each field of our e-Trade Second, it is to present problems and plans of improvements involved in WMS in e-Trade. In short, this study aims at presenting interpretative foundation of WMS in a practical viewpoint, not presenting technical directions of WMS.

• Journal of the Korean Society of Systems Engineering
• /
• v.17 no.2
• /
• pp.122-128
• /
• 2021

Despite various economic crises, the domestic parcel delivery market handled 3.37 billion parcels in 2020 while maintaining annual growth due to the activation of e-commerce. In particular, in the case of the metropolitan area, which accounts for about 70% of the nation's parcel throughput, the increase in parcel delivery volume is directly related to the increase in freight vehicles in central area of Seoul,. And it leads to an increase of unnecessary social and environmental costs such as traffic congestion, road damage, and environmental pollution in the city. Therefore, in this paper we proposed the underground urban logistics system utilizing the existing urban rail infrastructure, and establish a conceptual design by operational scenario. In order to establish conceptual design of underground urban logistics system, we use order picking system process, which is use in warehouse, produce result combined ISO/IEC 26702. The results of this study can be usefully used before the underground urban logistics system is introduced.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.11 no.2
• /
• pp.1148-1161
• /
• 2017

The success of a business process management system stands or falls on the quality of the business processes. Many experiments therefore have been devoting considerable attention to the modeling and analysis of business processes in process-centered organizations. One of those experiments is to apply the probabilistic theories to the analytical evaluations of business process models in order to improve their qualities. In this paper, we excogitate a conceptual way of applying a probability theory of proportions into modeling business processes. There are three types of routing patterns such as sequential, disjunctive, conjunctive and iterative routing patterns in modeling business processes, into which the proportion theory is applicable. This paper focuses on applying the proportion theory to the disjunctive routing patterns, in particular, and formally named proportional information control net that is the formal representation of a corresponding business process model. In this paper, we propose a conceptual approach to discover a proportional information control net from the enactment event histories of the corresponding business process, and describe the details of a series of procedural frameworks and operational mechanisms formally and graphically supporting the proposed approach. We strongly believe that the conceptual approach with the proportional information control net ought to be very useful to improve the quality of business processes by adapting to the reengineering and redesigning the corresponding business processes.

• 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.

• The KIPS Transactions:PartD
• /
• v.15D no.2
• /
• pp.187-196
• /
• 2008

The system development approach method of the new paradigm, as being standardizing MDA(Model Driven Architecture) in OMG(Object Management Group), the core technique of MDA definite technique structure for system materialization focusing on Model, is to build the design and the statement for system in PIM(Platform Independent Model), Materialization technique, and to build PSM(Platform Specific Model) adapt to materialization environment, and then to be the technique transforming into language Platform suitable to materialization environment. It includes MOF(Meta-Object Facility), UML, XMI(XML Metadata Interchange), CWM(Common Warehouse Metamodel), the core of MDA. Though these operations MDA support automatic tools product the practicable system after carrying out transform operation with the above information. In this thesis, it will be approached how to design and materialize the Bachelor management system based on MDA and the importance of modeling should be emphasized by applying to the approach method based on MDA. It should be suggested how to develop software efficiently, written it out in PIM, and suggested the process transforming PSM into EJB by J2EE Platform. The system is designed and implemented using automatic tool, edit machine(Together Architect 2006 for Eclipse, Edit plus2) supporting MDA and Database Modeling tool(ER/WIN 4.1). In conclusion, it should be suggested the efficiency analysis result for development process of traditional and based on MDA.