• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.16 no.4
• /
• pp.2784-2790
• /
• 2015

The column-oriented database storage is a very advanced model for large-volume data transactions because of its superior I/O performance. Traditional data storages exploit row-oriented storage where the attributes of a record are placed contiguously in hard disk for fast write operations. However, for search-mostly data warehouse systems, column-oriented storage has become a more proper model because of its superior read performance. Recently, solid state drive using flash memory is largely recognized as the preferred storage media for high-speed data analysis systems. In this research, we propose a new transaction recovery scheme for a column-oriented database environment which is based on a flash media file system. We improved traditional shadow paging schemes by reusing old data pages which are supposed to be invalidated in the course of writing a new data page in the flash file system environment. In order to reuse these data pages, we exploit reused shadow list structure in our column-oriented shadow recovery(CoSR) scheme. CoSR scheme minimizes the additional storage overhead for keeping shadow pages and minimizes the I/O performance degradation caused by column data compression of traditional recovery schemes. Based on the results of the performance evaluation, we conclude that CoSR outperforms the traditional schemes by 17%.

• The KIPS Transactions:PartD
• /
• v.14D no.2
• /
• pp.157-168
• /
• 2007

For effective analyses in various business applications, OLAP(On-Line Analytical Processing) systems represent the multidimensional data as the horizontal format of tables whose columns are corresponding to values of dimension attributes. Because the traditional RDBMSs have the limitation on the maximum number of attributes in table columns(MS SQLServer and Oracle permit each table to have up to 1,024 columns), horizontal tables cannot be directly stored into relational database systems. In this paper, we propose various efficient optimization strategies in transforming horizontal queries to equivalent vertical queries. To achieve this goral, we first store a horizontal table using an equivalent vertical table, and then develop various query transformation rules for horizontal table queries using the PIVOT operator. In particular, we propose various alternative query transformation rules for the basic relational operators, selection, projection, and join. Here, we note that the transformed queries can be executed in several ways, and their execution times will differ from each other. Thus, we propose various optimization strategies that transform the horizontal queries to the equivalent vertical queries when using the PIVOT operator. Finally, we evaluate these methods through extensive experiments and identify the optimal transformation strategy when using the PIVOT operator.

• The Journal of Society for e-Business Studies
• /
• v.21 no.2
• /
• pp.47-59
• /
• 2016

Parcel service is to deliver goods from one place to the designated destination requested according to user request. Parcel operations such as sorting, distributing, etc. or the managed information are heterogeneous by the companies. Additionally, it is impossible to support interoperability between companies with unformatted data of manual processing. Most parcel package boxes attached to paper typed waybill is attached is delivered to consignee. So, security problems such as personal information leaking are occurred, or extra processing time and logistics costs are needed due to wrong or the damaged information. Business environment of parcel service is rapidly changed as introducing unmanned delivery or the advanced technology such as Internet of Things. User want to know the accurate status or steps from parcel service request to delivery. To provide these requirements, the unified and integrated waybill information for reliable transportation of parcel service is needed. This information will provide to pickup or delivery carrier, warehouse or terminal, and parcel service user per pickup, transport, and delivery stage of parcel delivery service. Therefore, this paper defines the simplified and unified information model for parcel service waybill by analyzing information systems used for logistics unit processes that is occurred to parcel service, and manual work processes, and developing the relevant information of work flows occurred between business processes or transactions with the collected or processed information by from parcel service's stages. It is possible to share these standard model between business entities, and replacing paper typed waybill will improve national life safety as preventing security threats by paper typed waybill. As a result, it will promote the public interest from the stakeholder's perspective.

• Journal of Advanced Marine Engineering and Technology
• /
• v.37 no.2
• /
• pp.220-226
• /
• 2013

Recently, with the rapid development of factory automation and logistics system, a few workers were able to manage the broad workplace such as large vessels and warehouse. To estimate the exact location of these workers in the conventional wireless indoor localization systems, three or more fixed nodes are generally used to recognize the location of a mobile node consisting of a single node. However, these methods are inefficient in terms of node deployment because the broad workplace requires a lot of fixed nodes compared to workers(mobile nodes). Therefore, to efficiently deploy fixed nodes in these environments that need a few workers, this paper presents a novel estimation algorithm which can reduce the number of fixed nodes by efficiently recognizing the relative coordinates of two fixed nodes through a mobile node composed of three nodes. Also, to minimize the distance errors between mobile node and fixed node, rounding estimation(RE) technique is proposed. Experimental results show that the error rate of localization is improved, by using proposed RE technique, 90.9% compared to conventional trilateration in the free space. In addition, despite the number of fixed nodes can be reduced by up to 50% in the indoor free space, the proposed estimation algorithm recognizes precise location which has average error of 0.15m.

• 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 the Korea Institute of Information and Communication Engineering
• /
• v.11 no.7
• /
• pp.1407-1413
• /
• 2007

University environment on campus has been changed faster than before in today. Especially, they have devised middle & long-term development plans such as improving the image of campus and increasing campus competitive power to overcome difficulties in campus management. Therefore, many of those have made every effort to provide convenient university services for campus students and to improve the image of campus through building a Ubiquitous-Campus. But existing systems of a Ubiquitous-Campus have not understood actual conditions of IT (Information Technology) for campus students or not provided basic environment to analyze actual conditions of efficient using the system, expectations of the following people about a Ubiquitous-Campus is getting higher md higher though. Must become technology base ubiquitous campus construction, and is real erudition that ubiquitous campus model who can utilize substantially through service construction that is required newly with student's IT infra practical use analysis hereupon such as is required to solve these problems, But there is a limitation on designing the model in rapidly changed university environment on campus. In this paper, we studied about a Students Centralized Ubiquitous Campus model through U-Learning, U-Recruit, U-Printer, and personal information history service which are based on data warehouse for students analysis which is a key point element of building a Ubiquitous Campus.

• Journal of Biosystems Engineering
• /
• v.3 no.1
• /
• pp.47-63
• /
• 1978

This study was conducted to obtain a basic information necessary to assess present rice milling technology in Korea The profiles for milling plants was analyzed by survey work.For the private custom-work mills, which process about 80 percent of domestic rice consumption ,their actual milling test for the identical samples as used for filed mills was conducted. Two rice varieties Japonica and Tongil-type were associated with the experiments. The results are summarized as follows: 1. Analyses for private custom-work mills showed their general aspects as; about 91 percent of the mills belonged to an individual owner ship ; more than 93 percent of the mills was established earlier than 1950 ; about 80 percent of the mills was powered with electric motor; mills having less than two employees were about 75 percent; about 45 percent of the mills provided for warehouse in storing customers cereal grains. 2. The polishers installed in 1,255mills within the surveyed area (7 counties) have been supplied by 44 different domestic manufacturers ;in but about 60 percent of which was supplied by 6major manufacturers. The polishers could be classified into two categories in terms of principles of their polishing actions ;jet-pearler and friction types. About 51 percent of the mills was equipped with the former which has been recognized as giving greater milling recovery than the friction types. 3. Reason for owners of private mills to supplement new machines was due mainly to pgrading their mills to meet the requirements that established by the Government. However, about 60 percent of the mill owners intended to replace with new pearler by their own needs to meet with new high yielding varieties. 4. Processing systems of each previate rice mills surveyed could be classified into three categories, depending upon whether the systems posessed such components as precleaner and paddy separator or not. Only 36.7 percent of mills was installed with both precleanr ad paddy seperrator, 5.0 percent of mills did have neither percleaner nor paddy seperator, and rest of them equipped only one of the two. Hence,it is needed for about 63% of rice miils to be supplemented with these basic facilities to meet with the requirements for the standaized system. 5. Actual milling capacity measured at each field rice mills was shown a wide variation, having range from about 190 to 1,210 kg/hr. The percentages of mills classified according to daily milling capacity based on this hourly capacity were 24.3% for the capacity less than 3 M/T a day; 20.0% for 3-4 M/T; 15.6% for 4-5 M/T; 6.7% for 5-6 M/T; 22.3% for 6-7 M/T; and 11.0% for more than 7 M/T a day. 6. Actual amount of rice processed was about 310 M/T a year in average. About 42% of total milled rice was processed during October to Decembear, which formed a peak demand period for rice mills. The amount of rice milled during January to May was relatively small, but it had still a large amount compared to that during June to September. 7. Utilization rate of milling facility, i. e., percentage of the actual amount of milled rice to the capacity of rice mills, was about 18% on the year round average, about 41% in the peak demand season, and about 10% during June to September. Average number of operating days for mills surveyed was about 250 days a year, and about 21 days a month. 8. Moisture contents of paddy at the time of field mill tests were ranged 14.5% to 19.5% for both Japonica and Tong-i] varieties, majority of paddy grains having moisture level much higher than 1530. To aviod potential reduction of milling recovery while milling and deterioration of milled rice while storage due to these high grain mJisture contents, it may be very important for farmers holding rice to dry by an artificial drying method. 9. Milling recovery of JapJnica varieties in rice mills was 75.0% in average and it was widely ranged from 69.0% to 78.0 % according to mills. Potential increase in milJing recovery of Japonica variety with improvement of mill facilities was estimated to about 1.9%. On the other hand, milling recovery of Tong-il varieties in the field mill tests was 69.8% in average and it ranged from 62% to 77 %, which is much wider than that of Japonica varieties. It is noticed that the average milling recovery of Tong-il variety of 69.8% was much less than that of the Japonica-type. It was estimated th3.t up to about 5.0% of milling recovery for Tong-il variety could be improved by improving the present lo'.ver graded milling technology. 10. Head rice recoveries, as a factor of representing the quality of commercial goods, of Japonica and Tong-il varieties were 65.9% and 53.8% in average, and they were widely ranged from 52% to 73% and from 44% to 65% , respectively. It was assessed that head rice recovery of Japonica varieties can be improved up 3.3% and that of Tong-il varieties by 7.0% by improving mill components and systems.

• Journal of Intelligence and Information Systems
• /
• v.16 no.3
• /
• pp.163-179
• /
• 2010

Recentlythe concept of fast fashion is drawing attention as customer needs are diversified and supply lead time is getting shorter in fashion industry. It is emphasized as one of the critical success factors in the fashion industry how quickly and efficiently to satisfy the customer needs as the competition has intensified. Because the fast fashion is inherently susceptible to trend, it is very important for fashion retailers to make quick decisions regarding items to launch, quantity based on demand prediction, and the time to respond. Also the planning decisions must be executed through the business processes of procurement, production, and logistics in real time. In order to adapt to this trend, the fashion industry urgently needs supports from intelligent quick response(QR) system. However, the traditional functions of QR systems have not been able to completely satisfy such demands of the fast fashion industry. This paper proposes an intelligent quick response system for the fast fashion(IQRS-FF). Presented are models for QR process, QR principles and execution, and QR quantity and timing computation. IQRS-FF models support the decision makers by providing useful information with automated and rule-based algorithms. If the predefined conditions of a rule are satisfied, the actions defined in the rule are automatically taken or informed to the decision makers. In IQRS-FF, QRdecisions are made in two stages: pre-season and in-season. In pre-season, firstly master demand prediction is performed based on the macro level analysis such as local and global economy, fashion trends and competitors. The prediction proceeds to the master production and procurement planning. Checking availability and delivery of materials for production, decision makers must make reservations or request procurements. For the outsourcing materials, they must check the availability and capacity of partners. By the master plans, the performance of the QR during the in-season is greatly enhanced and the decision to select the QR items is made fully considering the availability of materials in warehouse as well as partners' capacity. During in-season, the decision makers must find the right time to QR as the actual sales occur in stores. Then they are to decide items to QRbased not only on the qualitative criteria such as opinions from sales persons but also on the quantitative criteria such as sales volume, the recent sales trend, inventory level, the remaining period, the forecast for the remaining period, and competitors' performance. To calculate QR quantity in IQRS-FF, two calculation methods are designed: QR Index based calculation and attribute similarity based calculation using demographic cluster. In the early period of a new season, the attribute similarity based QR amount calculation is better used because there are not enough historical sales data. By analyzing sales trends of the categories or items that have similar attributes, QR quantity can be computed. On the other hand, in case of having enough information to analyze the sales trends or forecasting, the QR Index based calculation method can be used. Having defined the models for decision making for QR, we design KPIs(Key Performance Indicators) to test the reliability of the models in critical decision makings: the difference of sales volumebetween QR items and non-QR items; the accuracy rate of QR the lead-time spent on QR decision-making. To verify the effectiveness and practicality of the proposed models, a case study has been performed for a representative fashion company which recently developed and launched the IQRS-FF. The case study shows that the average sales rateof QR items increased by 15%, the differences in sales rate between QR items and non-QR items increased by 10%, the QR accuracy was 70%, the lead time for QR dramatically decreased from 120 hours to 8 hours.

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