• The KIPS Transactions:PartD
• /
• v.16D no.4
• /
• pp.463-474
• /
• 2009

To analyze multidimensional data conveniently and efficiently, OLAP (On-Line Analytical Processing) systems or e-business are widely using views in a horizontal form to represent measurement values over multiple dimensions. These views can be stored as materialized views derived from several sources in order to support accesses to the integrated data. The horizontal views can provide effective accesses to complex queries of OLAP or e-business. However, we have a problem of occurring maintenance of the horizontal views since data sources are distributed over remote sites. We need a method that propagates the changes of source tables to the corresponding horizontal views. In this paper, we address incremental maintenance of horizontal views that makes it possible to reflect the changes of source tables efficiently. We first propose an overall framework that processes queries over horizontal views transformed from source tables in a vertical form. Under the proposed framework, we propagate the change of vertical tables to the corresponding horizontal views. In order to execute this view maintenance process efficiently, we keep every change of vertical tables in a differential file and then modify the horizontal views with the differential file. Because the differential file is represented as a vertical form, its tuples should be converted to those in a horizontal form to apply them to the out-of-date horizontal view. With this mechanism, horizontal views can be efficiently refreshed with the changes in a differential file without accessing source tables. Experimental results show that the proposed method improves average performance by 1.2$\sim$5.0 times over the existing methods.

• Journal of Appropriate Technology
• /
• v.6 no.2
• /
• pp.126-135
• /
• 2020

Recently, with the development of the 4th Industrial Revolution era and the popularization of technologies the maker movement is spreading worldwide in various ways for education, entrepreneurship, and solving social problems. This paper introduces a case of establishing and operating a maker space in Tanzania, East Africa, one of the developing countries. iTEC Tech-shop was established in the first half of 2018 at the Nelson Mandela African Institution of Science and Technology (NM-AIST) in Arusha, Tanzania by Innovative Technology and Energy Center (iTEC), and has been operating for nearly two years. With the allocation of empty warehouse space from NM-AIST, physical facilities were established through the purchase and installation of equipment and hand tools. Based on the advice from Idea Factory of Seoul National University and Fab-Lab Seoul, iTEC Tech-shop operational system were established. Through a total of 7 technical workshops, iTEC Tech-shop provided training courses for about 180 local personnel. In addition, the smart Techshop test-bed project was promoted in order to improve the operation level along with securing sustainability of the Techshop. The case of the iTEC Tech-shop could be a useful case for institutions or organizations promoting the maker movement to developing countries.

• Journal of Korea Port Economic Association
• /
• v.38 no.2
• /
• pp.139-152
• /
• 2022

In this paper, samples are collected for individual companies and the factors affecting worker wages (average annual salary) are analyzed in depth. In addition to the average annual salary of workers in a company, we would like to conduct an in-depth analysis of the average annual salary of first-time employees. Specifically, we tried to explain the size of companies, the production structure of capital and labor, and the impact of business on the average annual salary of first-time, college, and graduate school graduates by educational background of first-time employees. The difference in average annual salary of first-time employees of logistics companies is a decisive factor in the main project on sales, and first-time graduates and college graduates provided high salaries in the overseas passenger cargo transportation, port operation, and unloading management, and low salaries in the land cargo and warehouse industries. n addition, Korean logistics companies had relationships between the location of the headquarters, the number of employees, the proportion of labor costs to sales, and the four characteristic factors of the main business on sales. This fact is that Seoul-based foreign passenger cargo transportation, corporate logistics agency, complex transportation, and international transportation relay are large companies, with a low proportion of labor costs and a higher proportion of capital, technology, and information-intensive investments.

• Journal of Navigation and Port Research
• /
• v.48 no.1
• /
• pp.17-26
• /
• 2024

Port distripark can activate more functions. It is adjacent to a port. However, domestic port distripark is still limited to support port because of the shortage of infrastructure facilities, government policy, and investment. Therefore, this study tried to investigate the operation status of domestic port distripark and derive policy implications by conducting DEA analysis and productivity analysis based on internal data of each port distripark. As a result of Data Envelopment analysis, it was found that the west port distripark of Gwangwang and the northern port distripark of Incheon were efficient in the warehouse industry while the northern port distripark of Incheon and the Ulsan 1 port distripark were efficient in the manufacturing industry. In addition, in the case of foreign investment productivity, the west side port distripark of Gwangyang and the stage 1 port distripark of Pyeongtaek Dangjin were found to be higher than the others. In the case of facility investment productivity, the port distripark on the west side of Gwangyang and the north side of Incheon had the highest productivity. Lastly, in the case of labor productivity, the north side of Incheon and Busan ungdong port distripark showed the highest productivity. These results imply that it is important to review handling item when picking up enterprises in the port distripark for enhancing efficiency, foreign investment, and facility investment. The number of employees is not directly affecting the productivity improvement.

• Journal of KIISE:Computing Practices and Letters
• /
• v.15 no.3
• /
• pp.154-166
• /
• 2009

Database query and reporting tools, OLAP tools and data mining tools are typical front-end tools in Business Intelligence environment which is able to support gathering, consolidating and analyzing data produced from business operation activities and provide access to the result to enterprise's users. Traditional reporting tools have an advantage of creating sophisticated dynamic reports including SQL query result sets, which look like documents produced by word processors, and publishing the reports to the Web environment, but data source for the tools is limited to RDBMS. On the other hand, OLAP tools and data mining tools have an advantage of providing powerful information analysis functions on each own way, but built-in visualization components for analysis results are limited to tables or some charts. Thus, this paper presents a system that integrates three typical front-end tools to complement one another for BI environment. Traditional reporting tools only have a query editor for generating SQL statements to bring data from RDBMS. However, the reporting tool presented by this paper can extract data also from OLAP and data mining servers, because editors for OLAP and data mining query requests are added into this tool. Traditional systems produce all documents in the server side. This structure enables reporting tools to avoid repetitive process to generate documents, when many clients intend to access the same dynamic document. But, because this system targets that a few users generate documents for data analysis, this tool generates documents at the client side. Therefore, the tool has a processing mechanism to deal with a number of data despite the limited memory capacity of the report viewer in the client side. Also, this reporting tool has data structure for integrating data from three kinds of data sources into one document. Finally, most of traditional front-end tools for BI are dependent on data source architecture from specific vendor. To overcome the problem, this system uses XMLA that is a protocol based on web service to access to data sources for OLAP and data mining services from various vendors.