• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.16 no.11
• /
• pp.2418-2423
• /
• 2012

A smart phone which is one of the new IT technologies can be viable on various enterprise applications since it provides easily information and services. Especially, a smart phone can request queries to a server which finds massive data for decision making and receive the results of the queries from the server. However, a smart phone has a drawback that its battery is consumed easily due to the 4G communication. In this paper, we propose mobile views in order to reduce the easy consumption of a battery on mobile client-server environment. The proposed mobile view scheme reduces the number of communication which is leading to power consumption using materialized views for processing queries. We also classify the methods to control the consistency of the mobile view as the sources of the view are changed and present the cost of each method based on the cost model of battery consumption.

• Journal of Internet Computing and Services
• /
• v.6 no.4
• /
• pp.59-73
• /
• 2005

Caching query results and reusing them in processing of subsequent queries is an important query optimization technique. Materialized view and view indexing are the representative examples of such a technique. The two schemes had received much attention for relational databases, and have been investigated for XML data since XML emerged as the standard for data exchange on the Web. In XML view indexing, XML view xv which is the result of an XML query is represented as an XML view index(XVI), a structure containing the identifiers of xv's underlying XML elements as well as the information on xv. Since XVI for xv stores just the identifiers of the XML elements not the elements themselves, when xv is requested, its XVI should be materialized against xv's underlying XML documents. In this paper, we address the problem of integrating an XML view index management system with an RDBMS based XML storage system. The proposed system was implemented in Java on Windows 2000 Server with each of two different commercial RDBMSs, and used in evaluating performance improvement through XML view indexing as well as its overheads. The experimental results revealed that XML view indexing was very effective with an RDBMS based XML storage system while its overhead was negligible.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.7 no.6
• /
• pp.1269-1275
• /
• 2003

This paper addresses several issues on data caching and consistency of cached data in order to process client's queries efficiently in client/server environments. For the purpose, first of all, materialized spatial views are adapted in a client side for data caching, which is called client views. Also, an incremental update scheme using derivation relationships is applied to keep cached data of clients consistent with the rest of server databases. Materialized views support efficient query processing in a client side, however, it is difficult to keep consistent their contents by the update of a server database. In this paper, we devise cost functions on query execution and view maintenance based the cost of spatial operators so as to process client's queries efficiently. When request the client's query, in our query processing scheme, the server determines whether or not materialize it as a view due to evaluation using the related cost functions. Since the scheme supports a hybrid approach based on both view materialization and re-execution, hence, it should improve query execution times in client/server environments.

• The KIPS Transactions:PartD
• /
• v.11D no.2
• /
• pp.325-338
• /
• 2004

A data warehouse stores information that is collected from multiple, heterogeneous information sources for the purpose of complex querying and analysis. Information in the warehouse is typically stored In the form of materialized views, which represent pre-computed portions of frequently asked queries. One of the most important tasks of designing a warehouse is the selection of materialized views to be maintained in the warehouse. The goal is to select a set of views so that the total query response time over all queries can be minimized while a limited amount of time for maintaining the views is given(maintenance-cost view selection problem). In this paper, we propose an efficient solution to the maintenance-cost view selection problem using a genetic algorithm for computing a near-optimal set of views. Specifically, we explore the maintenance-cost view selection problem in the context of OR view graphs. We show that our approach represents a dramatic improvement in terms of time complexity over existing search-based approaches that use heuristics. Our analysis shows that the algorithm consistently yields a solution that only has an additional 10% of query cost of over the optimal query cost while at the same time exhibits an impressive performance of only a linear increase in execution time. We have implemented a prototype version of our algorithm that is used to evaluate our approach.

• The Transactions of the Korea Information Processing Society
• /
• v.1 no.1
• /
• pp.1-13
• /
• 1994

The Temporal Database Management Testbed supports valid and transaction time. In this paper, we discuss the design and implementation of a testbed of a temporal database management system in main memory. The testbed consists of a syntactic analyzer, a semantic analyzer, a code generator, and an interpreter. The syntactic analyzer builds a parse tree from a temporal query. The semantic analyzer then checks it for correctness against the system catalog. The code generator builds an execution tree termed ann update network. We employ an incremental view materialization for the execution tree. After building the execution tree, the interpreter activates each node of the execution tree. Also, the indexing structure and the concurrency control are discussed in the testbed.

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

• Journal of the Korean Institute of Electrical and Electronic Material Engineers
• /
• v.23 no.9
• /
• pp.708-713
• /
• 2010

In this research a ring light was developed so that a partial shadowless shooting for the patient's affected area at the medical treatment room and surgical operation room using high luminance light emitting diode (LED) for which attention is being paid as new lighting parts for medical purpose. LED which was applied to the development used high luminance three color LED for full color for which various color materialization and the adjustment of radiation intensity are possible and we can get white light in order to emphasize the delicate expression for generic tone of shooting object, strong highlight, simple shadow and three dimensional effect at the time of close-up shadowless shooting of the affected area. And at the time of design of ring light, the characteristics of LED and the loss of light at the time of penetrating light diffusion PC were considered so that intensity of illumination for over 150 lx can be obtained. The result of measurement of the intensity of illumination of the ring light that was developed revealed that maximum intensity of illumination of 225.7 lx was obtained, while smoke index was measured to be maximum 78 Ra in the case of Red(50%) Green(100%) and Blue LED(60%). We could confirm that response speed was also very fast as 1.72 ms.

• Korean Journal of Construction Engineering and Management
• /
• v.2 no.1 s.5
• /
• pp.78-87
• /
• 2001

Recently many construction claims related to the ommission and discrepancy of design document are alleged since 1998 and various dispute resolution methods are appeared. But many contractors alleged claims are not satisfied with the result because of not sufficiently reflecting construction practice. The purpose of this study is to analyze the liability of contract privity from the view point of the contract related law and to analyze the claims and claim factor, and to suggest construction contract practice in the public project. The construction claims related to the design document may be minimized, through (1) the accumulation and retrieval of standard forms by owners' type, (2) the usage of specified specification considering project characteristics, (3) the materialization of detail subsurface design and various contract method in heavy engineering construction.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.13 no.7
• /
• pp.1272-1278
• /
• 2009

The present paper is purposeful that I compare the materialization method of the filter of UIR and SIR, then make two filters of different methods, so both are useful. The structure of the method of UIR is simple, so it is used a commercial point of view that the client gets the characteristics what he wants. However, the needs of companies when compared to the same standards, a little more cheaply in price, a little smaller in size, better performance characteristics are expected. In this regard, the method of SIR is smaller than UIR in size, but it shows the similar characteristics of UIR, so it is expected that holds a dominant position in competitive power. In this paper, based on these conditions, I compared the methods of SIR and UIR after the design and production. The standards are Insertion Loss is less than 0.8dB, Return Loss is above 20.0dB, and the Ripple is within 0.3dB. The center frequency is settled 881.5MHzband that TX Band is used by CDMA(SKT). I compared in the same conditions in Bandwidth 25.0MHz.