• Title/Summary/Keyword: Materialized View

Search Result 80, Processing Time 0.027 seconds

Efficient Management of Statistical Information of Keywords on E-Catalogs (전자 카탈로그에 대한 효율적인 색인어 통계 정보 관리 방법)

  • Lee, Dong-Joo;Hwang, In-Beom;Lee, Sang-Goo
    • The Journal of Society for e-Business Studies
    • /
    • v.14 no.4
    • /
    • pp.1-17
    • /
    • 2009
  • E-Catalogs which describe products or services are one of the most important data for the electronic commerce. E-Catalogs are created, updated, and removed in order to keep up-to-date information in e-Catalog database. However, when the number of catalogs increases, information integrity is violated by the several reasons like catalog duplication and abnormal classification. Catalog search, duplication checking, and automatic classification are important functions to utilize e-Catalogs and keep the integrity of e-Catalog database. To implement these functions, probabilistic models that use statistics of index words extracted from e-Catalogs had been suggested and the feasibility of the methods had been shown in several papers. However, even though these functions are used together in the e-Catalog management system, there has not been enough consideration about how to share common data used for each function and how to effectively manage statistics of index words. In this paper, we suggest a method to implement these three functions by using simple SQL supported by relational database management system. In addition, we use materialized views to reduce the load for implementing an application that manages statistics of index words. This brings the efficiency of managing statistics of index words by putting database management systems optimize statistics updating. We showed that our method is feasible to implement three functions and effective to manage statistics of index words with empirical evaluation.

  • PDF

Design and Implementation of Process Management Model applying Agent Technology (헬스케어 홈 서비스를 위한 데이터베이스 및 응용 서비스 구현)

  • Lee, Chung-Sub;Jeong, Chang-Won;Joo, Su-Chong
    • Journal of Internet Computing and Services
    • /
    • v.8 no.1
    • /
    • pp.57-70
    • /
    • 2007
  • This paper is to construct a healthcare database using information obtained from healthcare home environments, and use this one for healthcare home services, Especially, our researching focus in this paper is how to design healthcare database scheme and how to use this constructed database on the Framework for Supporting Healthcare Integrated Service(FSHIS) we developed previously. Healthcare information is designed to database schemes in accordance to the specific save types of the data collected from various typed-sensors. The healthcare database constructed by using this information for the purpose of healthcare home services is divided into the base information with real schemes and the context based information with view schemes. Firstly, the base information includes low data obtained from physical sensors relevant to locations, healths, environments, and the personnel healthy profiles. The other is the context based information that is produced and fused by using the based information. This context based information might be got via various view schemes according to healthcare application services. Finally, for verifying the practical use of healthcare database constructed in this paper, Via interconnecting this database to our FSHIS, we show an example of healthcare home monitoring service using information (basic and context based information), emergency call, home appliance control, and so on needed from living activity area for elderly living alone.

  • PDF

Success Factors in Effecting Cultural Change in Organizations: A Case Study (조직 문화 변화의 성공 요소에 관한 연구 - KM을 변화 플랫폼으로 적용한 기업 사례를 중심으로 -)

  • Roh, Jeong-Ran
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.44 no.2
    • /
    • pp.427-445
    • /
    • 2010
  • In our knowledge-based society, a corporation's main growth engine consists of its unique core competences and how these are organized rather than materialized competitive advantage. Intangible factors such as creative organizational culture, learning capability, brands, marketing ability and technology are notable examples of such core competencies. To ensure constant development of a corporation, it is important to understand the environment in which these factors operate. Drawing on literature research, this paper looks at organizational culture and change, and employees' attitudes and resistance factors to such change. To strengthen the explanation of this study the Korea Asset Management Corporation was used as a case study. From the point of view of information science, knowledge has been viewed as that which is found in books and databases. Such "knowledge" is storable, passive and unchangeable. However, more recently it is seen by many researchers that this approach is limited in that it ignores the knowledge that "sits" in human "bodyminds" and organizations. Such knowledge forms the backbone of organizational culture and should be considered in any meaningful study of information.

A Design and Implementation of Virtual Grid for Reducing Frequency of Continuous Query on LBSNS (LBSNS에서 연속 질의 빈도 감소를 위한 가상그리드 기법의 설계 및 구현)

  • Lee, Eun-Sik;Cho, Dae-Soo
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.16 no.4
    • /
    • pp.752-758
    • /
    • 2012
  • SNS(Social Networking Services) is oneline service that enable users to construct human network through their relation on web, such as following relation, friend relation, and etc. Recently, owing to the advent of digital devices (smart phone, tablet PC) which embedded GPS some applications which provide services with spatial relevance and social relevance have been released. Such an online service is called LBSNS. It is required to use spatial filtering so as to build the LBSNS system that enable users to subscribe information of interesting area. For spatial filtering, user and tweet attaches location information which divide into static property presenting fixed area and dynamic property presenting user's area changed along the moving user. In the case of using a location information including dynamic property, Continuous query occurred from the moving user causes the problem in server. In this paper, we propose spatial filtering algorithm using Virtual Grid for reducing frequency of query, and conclude that frequency of query on using Virtual Grid is 93% decreased than frequency of query on not using Virtual Grid.

An Aesthetic Review on the Traditional Active Sports Wear Design - Focusing on Korean Wrestling Uniform- (전통 국기복 디자인에 관한 미학적 고찰 -씨름복을 중심으로-)

  • Yun, Eul-Yo;Park, Sun-Kyung
    • Archives of design research
    • /
    • v.18 no.3 s.61
    • /
    • pp.105-116
    • /
    • 2005
  • Focusing on costume research to set image of Korean wrestling that has potential power as a traditional and cultural item, the purpose of this research is to systemize Korean wrestling uniform and offer suggestions regarding visualization, and to carry out basic ground research to develop Korean wrestling uniform design. For the basic part, I compared world wrestling and Korean wrestling in an effort to learn more about the history of wrestling uniform along with its transitional changes. And for the practical part, I studied the criterion of the current wresting and its uniform, and classified the aesthetic points of Korean wresting uniform into four categories in the view point of design ground research: tradition and uniqueness, usability and compatibility, symbolism and ornamentation, variety and unification. It is concluded that the most important part in designing Korean wrestling uniform lie in how to consistently visualize it based on the above mentioned aesthetic points. As the theoretical research on aesthetic parts of Korean wrestling uniform, this research finds its meaning in suggesting guideline for design concept and development while planning traditional and cultural costume design which will be materialized in the follow-up research.

  • PDF

Incremental Maintenance of Horizontal Views Using a PIVOT Operation and a Differential File in Relational DBMSs (관계형 데이터베이스에서 PIVOT 연산과 차등 파일을 이용한 수평 뷰의 점진적인 관리)

  • Shin, Sung-Hyun;Kim, Jin-Ho;Moon, Yang-Sae;Kim, Sang-Wook
    • 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.

Development of BIM Templates for Vest-Pocket Park Landscape Design (소공원의 조경설계를 위한 BIM 템플릿 개발)

  • Seo, Young-hoon;Kim, Dong-pil;Moon, Ho-Gyeong
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.44 no.1
    • /
    • pp.40-50
    • /
    • 2016
  • A BIM, which is being applied actively to the construction and civil construction industries, is a technology that can maximize efficiency of various sectors from initial planning and design, construction, and maintenance, to demolition; however, it is in the introductory phase in the field of domestic landscaping. In order to introduce and promote BIM in the field of landscape design, this study developed a prototype of a library and template and analyzed the performance of trial application. For the development of a prototype, annotations and types were analyzed from floor plans of existing small parks, and components of landscape template were deduced. Based on this, play facilities, pergola, and benches were madeintofamily and templates, making automatic design possible. In addition, annotations and tags that are often used in landscape design were made, and a 3D view was materialized through visibility/graphic reassignment. As for tables and quantities, boundary stone table, mounding table, summary sheet of quantities, table of contents, and summary sheet of packaging quantities were grouped and connected with floor plans; regarding landscaping trees, classification criteria and name of trees that are suitable for domestic situations were applied. A landscape template was created to enable the library file format(rfa) that can be mounted on a building with BIM programs. As for problems that arose after the trial application of the prepared template, some CAD files could not be imported; also, while writing tables, the basis of calculation could not be made automatically. Regarding this, it is thought that functions of a BIM program and template need improvement.

Techniques of XML Query Caching on the Web (웹에서의 XML 질의 캐쉬 기법)

  • Park, Dae-Sung;Kang, Hyun-Chul
    • The Journal of Society for e-Business Studies
    • /
    • v.11 no.1
    • /
    • pp.1-23
    • /
    • 2006
  • As data on the Web is more and more in XML due to proliferation of Web applications such as e-Commerce, it is strongly required to rapidly process XML queries. One of such techniques is XML query caching. For frequently submitted queries, their results could be cached in order to guarantee fast response for the same queries. In this paper, we propose techniques for XML query performance improvement whereby the set of node identifiers(NIS) for an XML query is cached. NIS is most commonly employed as a format of XML query result,, consisting of the identifiers of the XML elements that comprise the query result. With NIS, it is suitable to meet the Web applications data retrieval requirements because reconstruction and/or modification of query results and integration of multiple query results can be efficiently done. Incremental refresh of NIS against its source updates can also be efficiently done. When the query result is requested in XML, however, materialization of NIS is needed by retrieving the source XML elements through their identifiers. In this paper, we consider three different types of NISs. proposing the algorithms of their creation, materialization, and incremental refresh. All of them were implemented using an RDBMS. Through a detailed set of performance experiments, we showed the efficiency of the proposed XML query caching techniques.

  • PDF

Interplays among Public Opinion, Public Policy and Discourse: Case Study about the Discursive Structure and Media Politics Surrounding the Fiscal Soundness Policy (재정건전성 담론 해체하기: 미디어담론에 내포된 프레임 구조와 변화를 중심으로)

  • Kang, Kuk-Jin;Kim, Sung-Hae
    • Korean journal of communication and information
    • /
    • v.63
    • /
    • pp.5-25
    • /
    • 2013
  • Korean society suffers from severe divisions represented by bi-polarization and collapse of the middle class. Intensive demanding on expanding social welfare budget has emerged in accordance with such a dramatic shift. Social consensus moving toward well-financed welfare policy, however, happens to meet political opposition supported by the discourse of fiscal soundness. This paper thus pays particular attention to deciphering the discursive structure in way of understanding how discourses bring public policy into play. For this purpose, news articles about fiscal soundness collected from 8 national newspapers have been analyzed in terms of frame, attitude, perspective and world view. Research results show, first of all, that there exist persistent competition between two frames identified as 'reduced tax with fiscal discipline' and 'increased tax with welfare money.' While the 'reduced tax' frame favors in maintaining tax cut at the expense of welfare budjet, the frame of 'increased tax' supports such arguments as the flexible employment of fiscal soundness and prosperity of national community helped by widening tax revenues. Also did these frames include a number of sub-frames like welfare populism, partisan politics, trickle down effect, tax bonanza for the rich, universal welfare and market over-reactions in order to bolster its logical authority. Media's active taking a part in penetrating supportive frames in line with political stance was found as well. Taking into account both the discursive structure upheld by frames and politics materialized by the media, the authors argue that public policies should be considered more as discourse than fixed reality. Shedding additional light on understanding the interplay among public opinion, policies and media discourse is of another importance for further study.

  • PDF

The organization of Shin ChaeHo's Doksasillon and reorganization of the Nation history (신채호의 「독사신론」의 구성과 '민족사'의 재구)

  • Choi, Soo-Ja
    • (The)Study of the Eastern Classic
    • /
    • no.36
    • /
    • pp.203-228
    • /
    • 2009
  • ChaeHo Shin's major interests were in the ancient history, among other periods of the Korean history. Shin's depiction of history is characterized by having nation in the heart of history, whose tendency of nationalism was purposefully strong. In general, the nationalism of those times was emphasizing a 'strong' nation, just as in the case of Shin's theory, and at the same time stood for the theory of social evolution with a view to raising the nation in the front line of history. The nationalism, in association with the theory of social evolution, ended up having a propensity that criticizes imperialism on the one hand, and envies it on the other. This inclination is literally shown in Doksasillon (A New Guide to Reading History), which is ChaeHo Shin's research on the ancient history. Doksasillon is a historical essay that was published serially in 50 installments from August 27th through December 13th in 1908. Unlike the existing views in the late 1900s on the ancient history, among other ages of the Korean history, Doksasillon can be called a treatise with a focus on nation. Doksasillon is an incomplete study which can be divided into two parts, introduction and ancient times that is the first volume. It, nevertheless, shows the aspect of a powerful nation activist who tried to surmount the life-and-death crisis of nation by 'recalling' the nation in the period of the late-Joseon and the Korean empire in 1908 and 'rediscovering' the territory. It also reflects a slice of a historian's anguish that attempted to cope with the national crisis by virtue of the 'power' of history. It is ChaeHo Shin who 'rediscovered' the Buyeo tribe as the mainstream of the ancient history of Korea, and recomposed and materialized the ancient history. Shin chose the 'Buyeo tribe' as a principal race, and used it as a representative of the Korean nation in the ancient era, which was because Buyeo and Goguryeo were the strongest. The emphasis laid on the powerful nation in the history of Korea well reflects the efforts of a powerful nation activist in the age of the late-Joseon, and on the other hand, it shows how nationalism came to be formed in Korea. ChaeHo Shin is regarded as a person who lived in the age in which nationalism, which underscores the homogeneity of a nation, had to be stressed as a sole weapon for a nation who was left behind in modernization and whose rights were disseized. Dosasillon shows a process of reconstructing the history of DanKun and the Buyeo tribe and unearthing a hero who was valued as a savior of the nation, which was the reason that ChaeHo Shin wrote a history.