GIS-based Market Analysis and Sales Management System : The Case of a Telecommunication Company (시장분석 및 영업관리 역량 강화를 위한 통신사의 GIS 적용 사례)
-
- Journal of Intelligence and Information Systems
- /
- v.17 no.2
- /
- pp.61-75
- /
- 2011
A Geographic Information System(GIS) is a system that captures, stores, analyzes, manages and presents data with reference to geographic location data. In the later 1990s and earlier 2000s it was limitedly used in government sectors such as public utility management, urban planning, landscape architecture, and environmental contamination control. However, a growing number of open-source packages running on a range of operating systems enabled many private enterprises to explore the concept of viewing GIS-based sales and customer data over their own computer monitors. K telecommunication company has dominated the Korean telecommunication market by providing diverse services, such as high-speed internet, PSTN(Public Switched Telephone Network), VOLP (Voice Over Internet Protocol), and IPTV(Internet Protocol Television). Even though the telecommunication market in Korea is huge, the competition between major services providers is growing more fierce than ever before. Service providers struggled to acquire as many new customers as possible, attempted to cross sell more products to their regular customers, and made more efforts on retaining the best customers by offering unprecedented benefits. Most service providers including K telecommunication company tried to adopt the concept of customer relationship management(CRM), and analyze customer's demographic and transactional data statistically in order to understand their customer's behavior. However, managing customer information has still remained at the basic level, and the quality and the quantity of customer data were not enough not only to understand the customers but also to design a strategy for marketing and sales. For example, the currently used 3,074 legal regional divisions, which are originally defined by the government, were too broad to calculate sub-regional customer's service subscription and cancellation ratio. Additional external data such as house size, house price, and household demographics are also needed to measure sales potential. Furthermore, making tables and reports were time consuming and they were insufficient to make a clear judgment about the market situation. In 2009, this company needed a dramatic shift in the way marketing and sales activities, and finally developed a dedicated GIS_based market analysis and sales management system. This system made huge improvement in the efficiency with which the company was able to manage and organize all customer and sales related information, and access to those information easily and visually. After the GIS information system was developed, and applied to marketing and sales activities at the corporate level, the company was reported to increase sales and market share substantially. This was due to the fact that by analyzing past market and sales initiatives, creating sales potential, and targeting key markets, the system could make suggestions and enable the company to focus its resources on the demographics most likely to respond to the promotion. This paper reviews subjective and unclear marketing and sales activities that K telecommunication company operated, and introduces the whole process of developing the GIS information system. The process consists of the following 5 modules : (1) Customer profile cleansing and standardization, (2) Internal/External DB enrichment, (3) Segmentation of 3,074 legal regions into 46,590 sub_regions called blocks, (4) GIS data mart design, and (5) GIS system construction. The objective of this case study is to emphasize the need of GIS system and how it works in the private enterprises by reviewing the development process of the K company's market analysis and sales management system. We hope that this paper suggest valuable guideline to companies that consider introducing or constructing a GIS information system.
This study presents an application of hydro-mechanical coupled Particle Flow Code 3D (PFC3D) to simulation of fluid injection induced fault slip experiment conducted in Mont Terri Switzerland as a part of a task in an international research project DECOVALEX-2019. We also aimed as identifying the current limitations of the modelling method and issues for further development. A fluid flow algorithm was developed and implemented in a 3D pore-pipe network model in a 3D bonded particle assembly using PFC3D v5, and was applied to Mont Terri Step 2 minor fault activation experiment. The simulated results showed that the injected fluid migrates through the permeable fault zone and induces fault deformation, demonstrating a full hydro-mechanical coupled behavior. The simulated results were, however, partially matching with the field measurement. The simulated pressure build-up at the monitoring location showed linear and progressive increase, whereas the field measurement showed an abrupt increase associated with the fault slip We conclude that such difference between the modelling and the field test is due to the structure of the fault in the model which was represented as a combination of damage zone and core fractures. The modelled fault is likely larger in size than the real fault in Mont Terri site. Therefore, the modelled fault allows several path ways of fluid flow from the injection location to the pressure monitoring location, leading to smooth pressure build-up at the monitoring location while the injection pressure increases, and an early start of pressure decay even before the injection pressure reaches the maximum. We also conclude that the clay filling in the real fault could have acted as a fluid barrier which may have resulted in formation of fluid over-pressurization locally in the fault. Unlike the pressure result, the simulated fault deformations were matching with the field measurements. A better way of modelling a heterogeneous clay-filled fault structure with a narrow zone should be studied further to improve the applicability of the modelling method to fluid injection induced fault activation.
This research explored the relationship between the water quality issue of Wolji Pond (Anapji Pond) with the maintenance of the channel flow circulation system. The water supply and drainage system closely related to the circulation system of pond has been reviewed, rather than the existing water supply and drainage system that has been analyzed in previous studies. As a result of reviewing the water supply system, it has been learned that the water supply system on the southeastern shore of Wolji Pond, being the current water supply hole, has been connected to the east side garden facility (landscaping stone, curved waterway, storage facility of water) between the north and south fence and the waterway. This separate facility group seems to have been a subject of the investigation of the eastern side of Wolji Pond, with the landscaping stones having been identified in the 1920's survey drawings. The water supply facility on the southeastern shore, being the suspected water supply hole, seems to have some connection with the granite waterway remaining on the building site of Imhaejeon (臨海殿) on the southern side of Wolji Pond. It is inferred that it provides clean water, seeing that the slope towards the southwestern shore of Wolji Pond becomes lower, the landscaping stones have been placed in the filter area, and it is present in the 1920's survey drawings and the water supply hole survey drawing of 1975. The water drainage facility on the northern shore is composed of five stages. The functions of the wooden waterway and the rectangular stone water catchment facility seem not to be only for the water drainage of Wolji Pond. In light of the points that there are wood plugs in the wooden waterway and that there is a water catchment facility in the final stage, it is judged that the water of Balcheon Stream (撥川) may be charged in reverse according to this setup. Namely, the water could enter and exit in either direction in the water drainage facility on the northern shore It also seems that the supply to the wooden waterway could be opened and shut through the water catchment facility of rectangular stone group as well. The water drainage facility on the western shore is very similar to the water drainage facility on the northern shore, so it is difficult to avoid the belief that it existed during the Silla Dynasty, or it has been produced by imitating the water drainage facility on the northern shore at some future point in time. It seems to have functioned as the water drainage facility for the supply of agricultural water during the Joseon Dynasty. The water supply and drainage facilities in Wolji Pond have been understood as a systematized distribution network that has been intertwined organically with the facility of Donggung Palace, which was the center of the Silla capital. Water has been supplied to each facility group, including Wolji Pond, through this structure; it includes the drainage system connecting to the Namcheon River (南川) through the Balcheon Stream, which was an important canal of the capital center.
As the importance of big data and related technologies continues to grow in the industry, it has become highlighted to visualize results of processing and analyzing big data. Visualization of data delivers people effectiveness and clarity for understanding the result of analyzing. By the way, visualization has a role as the GUI (Graphical User Interface) that supports communications between people and analysis systems. Usually to make development and maintenance easier, these GUI parts should be loosely coupled from the parts of processing and analyzing data. And also to implement a loosely coupled architecture, it is necessary to adopt design patterns such as MVC (Model-View-Controller) which is designed for minimizing coupling between UI part and data processing part. On the other hand, big data can be classified as structured data and unstructured data. The visualization of structured data is relatively easy to unstructured data. For all that, as it has been spread out that the people utilize and analyze unstructured data, they usually develop the visualization system only for each project to overcome the limitation traditional visualization system for structured data. Furthermore, for text data which covers a huge part of unstructured data, visualization of data is more difficult. It results from the complexity of technology for analyzing text data as like linguistic analysis, text mining, social network analysis, and so on. And also those technologies are not standardized. This situation makes it more difficult to reuse the visualization system of a project to other projects. We assume that the reason is lack of commonality design of visualization system considering to expanse it to other system. In our research, we suggest a common information model for visualizing text data and propose a comprehensive and reusable framework, TexVizu, for visualizing text data. At first, we survey representative researches in text visualization era. And also we identify common elements for text visualization and common patterns among various cases of its. And then we review and analyze elements and patterns with three different viewpoints as structural viewpoint, interactive viewpoint, and semantic viewpoint. And then we design an integrated model of text data which represent elements for visualization. The structural viewpoint is for identifying structural element from various text documents as like title, author, body, and so on. The interactive viewpoint is for identifying the types of relations and interactions between text documents as like post, comment, reply and so on. The semantic viewpoint is for identifying semantic elements which extracted from analyzing text data linguistically and are represented as tags for classifying types of entity as like people, place or location, time, event and so on. After then we extract and choose common requirements for visualizing text data. The requirements are categorized as four types which are structure information, content information, relation information, trend information. Each type of requirements comprised with required visualization techniques, data and goal (what to know). These requirements are common and key requirement for design a framework which keep that a visualization system are loosely coupled from data processing or analyzing system. Finally we designed a common text visualization framework, TexVizu which is reusable and expansible for various visualization projects by collaborating with various Text Data Loader and Analytical Text Data Visualizer via common interfaces as like ITextDataLoader and IATDProvider. And also TexVisu is comprised with Analytical Text Data Model, Analytical Text Data Storage and Analytical Text Data Controller. In this framework, external components are the specifications of required interfaces for collaborating with this framework. As an experiment, we also adopt this framework into two text visualization systems as like a social opinion mining system and an online news analysis system.
Transportation enterprises should maintain constant and qualitative operation. Thus, in short period, transportation enterprises don't change supply in accordance with demand. In the result, transportation enterprises don't reduce operation in spite of management deficit at will. In freight transportation type, less-than-truckload(LTL) has more relation with above transportation feature than truckload(TL) does. Because freight transportation supply of TL is more flexible than that of LTL in correspondence of freight transportation demand. Relating to above mention, it appears that shortage of road and freight terminal of LTL is larger than that of TL. Especially in road and freight terminal comparison, shortage of freight terminal is larger than that of road. Shortage of road is the largest in 1990, and improved after-ward. But shortage of freight terminal is serious lately. So freight terminal needs more expansion than road, and shows better investment condition than road. Freight terminal expansion brings road expansion in LTL, on the contrary, freight terminal expansion substitutes freight terminal for road in TL. In transportation revenue, freight terminal's contribution to LTL is larger than that to TL. However, when we adjust quasi-fixed factor - road and freight terminal - to optimal level in the long run, in TL, diseconomies of scale becomes large, but in LTL, economies of scale becomes large. Consequently, it is necessary for TL to make counterplans to activate management of small size enterprises and owner drivers. And LTL should make use of economies of scale by solving the problem, such as nonprofit route, excess of rental freight handling of office, insufficiency of freight terminal, shortage of driver, and unpreparedness of freight insurance.
This work proposes a 13b 100MS/s 45nm CMOS ADC with a high dynamic performance for IF-domain high-speed signal processing systems based on a four-step pipeline architecture to optimize operating specifications. The SHA employs a wideband high-speed sampling network properly to process high-frequency input signals exceeding a sampling frequency. The SHA and MDACs adopt a two-stage amplifier with a gain-boosting technique to obtain the required high DC gain and the wide signal-swing range, while the amplifier and bias circuits use the same unit-size devices repeatedly to minimize device mismatch. Furthermore, a separate analog power supply voltage for on-chip current and voltage references minimizes performance degradation caused by the undesired noise and interference from adjacent functional blocks during high-speed operation. The proposed ADC occupies an active die area of
Korea is rapidly becoming an aging society as much as it takes the first place among OECD countries, and as the life expectancy of Korea gradually increases, the proportion of the elders in society increases. Accordingly, the happiness of the elders is contributed to the overall social atmosphere and happiness, however, the lower quality of life of the elders due to physical, psychological and social changes can be developed into social problems such as depression and rising suicide rate. As a result, there is a social interest in improving the quality of life and satisfaction of the elders, and the senior citizen center is receiving renewed attention as a form of welfare facility that can play a pivotal role in the social activities of the elders. In recent years, efforts to improve the environment of the senior citizen center have been made due to the growing role of it, however, there is a controversy over whether the quality of the indoor environment is user-friendly or not due to the limitations of material resources and human resources. It is considered that the quality of the color environment should be improved in the senior citizen center in the way that the color environment is not only an indoor environmental factor which gives high psychological and mental effects to users but also a way to improve the environmental satisfaction at the lowest cost. Previous studies on the facilities related to the elders have been actively carried out, but they were very sporadic and there was very little information about the color environment in the related laws or in the guideline presented by cities. It is necessary to integrate guidelines that are scattered within a comprehensive range without any specific target in order to grasp the current status of the color environment and to properly evaluate it. In addition, considering that the senior citizen center is an important leisure facility for the elders that functions in a residential area with a nationwide network, the results of this study are expected to contribute to the environmental improvement of existing senior citizen center which will be activated in the future by enabling the improvement of psychological satisfaction of the elders.
In terms of understanding the water cycle and efficient water resource management, the importance of soil moisture has been highlighted. However, in Korea, the lack of qualified in-situ soil moisture data results in very limited utility. Even if satellite-based data are applied, the absence of ground reference data makes objective evaluation and correction difficult. The cosmic-ray neutron probe (CRNP) can play a key role in producing data for satellite data calibration. The installation of CRNP is non-invasive, minimizing damage to the soil and vegetation environment, and has the advantage of having a spatial representative for the intermediate scale. These characteristics are advantageous to establish an observation network in Korea which has lots of mountainous areas with dense vegetation. Therefore, this study was conducted to evaluate the applicability of the CRNP soil moisture observatory in Korea as part of the establishment of a Korean cOsmic-ray Soil Moisture Observing System (KOSMOS). The CRNP observation station was installed with the Gunup-ri observation station, considering the ease of securing power and installation sites and the efficient use of other hydro-meteorological factors. In order to evaluate the CRNP soil moisture data, 12 additional in-situ soil moisture sensors were installed, and spatial representativeness was evaluated through a temporal stability analysis. The neutrons generated by CRNP were found to be about 1,087 counts per hour on average, which was lower than that of the Solmacheon observation station, indicating that the Hongcheon observation station has a more humid environment. Soil moisture was estimated through neutron correction and early-stage calibration of the observed neutron data. The CRNP soil moisture data showed a high correlation with r=0.82 and high accuracy with root mean square error=0.02 m3/m3 in validation with in-situ data, even in a short calibration period. It is expected that higher quality soil moisture data production with greater accuracy will be possible after recalibration with the accumulation of annual data reflecting seasonal patterns. These results, together with previous studies that verified the excellence of CRNP soil moisture data, suggest that high-quality soil moisture data can be produced when constructing KOSMOS.
The wall shear stress in the vicinity of end-to end anastomoses under steady flow conditions was measured using a flush-mounted hot-film anemometer(FMHFA) probe. The experimental measurements were in good agreement with numerical results except in flow with low Reynolds numbers. The wall shear stress increased proximal to the anastomosis in flow from the Penrose tubing (simulating an artery) to the PTFE: graft. In flow from the PTFE graft to the Penrose tubing, low wall shear stress was observed distal to the anastomosis. Abnormal distributions of wall shear stress in the vicinity of the anastomosis, resulting from the compliance mismatch between the graft and the host artery, might be an important factor of ANFH formation and the graft failure. The present study suggests a correlation between regions of the low wall shear stress and the development of anastomotic neointimal fibrous hyperplasia(ANPH) in end-to-end anastomoses. 30523 T00401030523 ^x Air pressure decay(APD) rate and ultrafiltration rate(UFR) tests were performed on new and saline rinsed dialyzers as well as those roused in patients several times. C-DAK 4000 (Cordis Dow) and CF IS-11 (Baxter Travenol) reused dialyzers obtained from the dialysis clinic were used in the present study. The new dialyzers exhibited a relatively flat APD, whereas saline rinsed and reused dialyzers showed considerable amount of decay. C-DAH dialyzers had a larger APD(11.70
The wall shear stress in the vicinity of end-to end anastomoses under steady flow conditions was measured using a flush-mounted hot-film anemometer(FMHFA) probe. The experimental measurements were in good agreement with numerical results except in flow with low Reynolds numbers. The wall shear stress increased proximal to the anastomosis in flow from the Penrose tubing (simulating an artery) to the PTFE: graft. In flow from the PTFE graft to the Penrose tubing, low wall shear stress was observed distal to the anastomosis. Abnormal distributions of wall shear stress in the vicinity of the anastomosis, resulting from the compliance mismatch between the graft and the host artery, might be an important factor of ANFH formation and the graft failure. The present study suggests a correlation between regions of the low wall shear stress and the development of anastomotic neointimal fibrous hyperplasia(ANPH) in end-to-end anastomoses. 30523 T00401030523 ^x Air pressure decay(APD) rate and ultrafiltration rate(UFR) tests were performed on new and saline rinsed dialyzers as well as those roused in patients several times. C-DAK 4000 (Cordis Dow) and CF IS-11 (Baxter Travenol) reused dialyzers obtained from the dialysis clinic were used in the present study. The new dialyzers exhibited a relatively flat APD, whereas saline rinsed and reused dialyzers showed considerable amount of decay. C-DAH dialyzers had a larger APD(11.70