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

• Journal of the Korean association of regional geographers
• /
• v.6 no.2
• /
• pp.21-40
• /
• 2000

The retail trades in many countries have changed recently according to the high quality, diversification, and marked individuality of consumer needs. Under the continually competing system of the WTO agreement, corporations based in the USA and the EU try to raise their market share in other countries so it is inevitable for Korean retail enterprises to compete with them. This paper is aimed at contributing to the efficient growth for Korean retail trade from the analysis of the development process in retail trade and its changing locations comparing Korea and the USA. Retailers in the USA have practiced diversified marketing strategies considerably in order to survive in a rapidly changing retailing environment. American retailing, which has the most advanced marketing system in the world, has been of growing concern to marketing strategies in Korea. The following is a brief summary of this study. 1. Speedy and higher quality consumption is needed in accordance with the great increase in the single-family household and the female labor force participation both in Korea and in the USA. Senior citizens have become a new consumer group due to the aging population. In the future the retail trade will switch over to diversified retail formats and internet shopping as countries are transformed into information and communication societies. 2. In Korea, the former retail system characterized by markets and department stores has been greatly changed since the late 1980s with emphasis on high quality and convenience in consumption behaviors, with large domestic enterprises and foreign distribution corporations participating in Korean retailing. In the USA, retailing mergers and takeovers by major retails, bankruptcies, and extra-large shopping centers have emerged since the late 1980s. Recently, the USA retailing formats have been changed from the lower price-oriented discount types to the large scale theme parks. Much emphasis was put on entertainment, resorts, and convention centers. On the other hand, non-store types, such as the internet shopping, the CATV shopping, as well as catalog and mail-order sales are drastically increasing, although the proportion of their sales is low up to now. 3. In Korea, most of the retail facilities are concentrated in Seoul and the Metropolitan Region, and the distribution ratio of facilities came to 52% in 1997. The periodic markets, traditional markets which open on a periodic basis, are located mainly in Chollanam-do and Kyungsangbuk-do. The large-sized discount stores have expanded their locations to the over-crowded apartment complexes in new towns, located in the Metropolitan Region, and the large provincial cities, unlike the suburban locations in the USA. Therefore we needed to give attention to the locational relations in retail facilities between Seoul & the Metropolitan Region and rural settlement areas. In the USA, urban areas grew quickly with the development of the automobile in the 1920s, and the location of stores changed from a dispersed style centering around rural areas to a centralized one in urban areas. There is an accelerated growth for suburban areas, which have grown rapidly since 1950. As the membership warehouse clubs were introduced in the 1970s, the decentralization of location was more intensified. On the other hand, inner cities were revitalized by rearranging existing facilities to cope with suburban areas. And the location-free virtual retailing & TV shopping are also growing every year. 4. In view of the above, the continuous and desirable development devices in Korean retail trade are summarized as follows: First, the countermeasures against economies of scale, increase in retailing sales, and rise of a employment percentage in retailing are in need. Second, a scheme of lowering the proportion of food retail sales, and increasing a ratio of durable goods sales need to be worked out. Third, the original ideas are needed to apply positively information, communication and technology to retailing, to graft the traditional types on modem ones based on the social culture. Fourth, strategies are needed to strengthen the competitiveness of our retail trade through cooperation and chains of smaller retailers, the large enterprises participating in the distribution industry. Fifth, in order to realize the above, the retail industry, the administration, and the academic world should support the retail segment with concern and a practical strategy plan.

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