• Journal of KIISE:Software and Applications
• /
• v.26 no.10
• /
• pp.1156-1166
• /
• 1999

의사결정 시스템은 전사적인 의사결정과 전략적 정보수집을 위해 거대한 량의 정보를 빠른 시간내에 제공할 것을 요구한다. 데이타 웨어하우스는 이러한 정보를 신속히 제공하기 위해 여러 지역 데이타베이스로부터 필요한 정보를 사전에 추출하고 가공 및 통합하여 별도의 저장공간에 저장한다. 일반적으로, 웨어하우스 내의 정보는 지역 데이타베이스에 저장된 정보에 대한 실체화된 뷰로서 간주하며 지역 데이타의 변경에 따라 일관성을 유지하도록 반영해야 한다. 본 논문에서는 일관성을 유지하기 위해 정보 공유가 가능한 데이타 웨어하우스 시스템의 구조와 비-보상 실체 뷰 관리 기법을 제안한다. 본 논문에서 제안한 데이타 웨어하우스 시스템의 구조는 지역 데이타베이스에서 추출된 정보를 관리하는 별도의 지역 정보 관리자를 두어 뷰 관리자들 간의 정보 공유가 가능하게 한다. 비-보상 실체 뷰 관리 기법은 지역 데이타 변경 사건에 따른 뷰 관리 시 다른 사건에 의해 영향을 받지 않도록 하기 때문에 기본의 사전 보상이나 나중 보상 기법과는 달리 추가적인 질의 처리를 요구하지 않는 기법이다.Abstract A decision support system(DSS) commonly requires fast access to tremendous volume of information. A data warehouse is a database storing the information that is extracted, filtered and integrated from several relevant local databases to reply upon aggregated queries. The information stored in the data warehouse can be regarded as materialized views. The materialized view has to be modified according to the change of the corresponding local databases to preserve the data consistency. In this paper, we propose a data warehousing system architecture allowing information sharing (DAWINS), and a non-compensating materialized view maintenance algorithm(NCA). DAWINS architecture allows relevant information to be shared by individual view managers with local data manager for each local database. Unlikely to the pre- or post-compensating algorithms, which are required to remove the effects of some events to other view in the process of view maintenance, NCA does not require any additional query processing, since a local data manager in DAWINS already maintains the effects of update events occurring in local systems.

• Spatial Information Research
• /
• v.15 no.3
• /
• pp.189-202
• /
• 2007

As applications of GIS technology have grown in local governments, the wider and integrated use of spatial information is demanded more than before. Particularly because 70-80% of administrative information in local governments are related spatial, it becomes a key issue to connect and integrate non-spatial information with spatial information for more advanced use of GIS applications in local governments. The purpose of this study is to establish an advanced Implementation model by analyzing obstacles in existing GIS applications and suggesting implementation strategies. The strategy, as an important part of the model, includes efficient information sharing, establishment of commonly usable GIS Database, architectural improvement for Enterprise GIS in terms of database and system implementation, standardization far the model, and establishment of spatial infrastructure in the local governments. The study concludes that administrative collaboration in a horizontal and vertical perspective has a highest priority for the implementation of the model.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.15 no.1
• /
• pp.343-364
• /
• 2021

In the 5G era, the communication networks tend to be ultra-densified, which will improve the accuracy of indoor positioning and further improve the quality of positioning service. In this study, we propose an indoor three-dimensional (3D) dynamic reconstruction fingerprint matching algorithm (DSR-FP) in a 5G ultra-dense network. The first step of the algorithm is to construct a local fingerprint matrix having low-rank characteristics using partial fingerprint data, and then reconstruct the local matrix as a complete fingerprint library using the FPCA reconstruction algorithm. In the second step of the algorithm, a dynamic base station matching strategy is used to screen out the best quality service base stations and multiple sub-optimal service base stations. Then, the fingerprints of the other base station numbers are eliminated from the fingerprint database to simplify the fingerprint database. Finally, the 3D estimated coordinates of the point to be located are obtained through the K-nearest neighbor matching algorithm. The analysis of the simulation results demonstrates that the average relative error between the reconstructed fingerprint database by the DSR-FP algorithm and the original fingerprint database is 1.21%, indicating that the accuracy of the reconstruction fingerprint database is high, and the influence of the location error can be ignored. The positioning error of the DSR-FP algorithm is less than 0.31 m. Furthermore, at the same signal-to-noise ratio, the positioning error of the DSR-FP algorithm is lesser than that of the traditional fingerprint matching algorithm, while its positioning accuracy is higher.

• Journal of Agricultural Extension & Community Development
• /
• v.16 no.1
• /
• pp.21-49
• /
• 2009

There is a wide range of agreement for reorganization of administrative units. It is expected that regionalization of city governments and city-county consolidation would contribute to enhance efficiency of extension services and weaken citizen accessibility, responsiveness, and participation. Therefore, it is suggested that branch office of extension center should be provided to the isolated rural areas in order to maintain the appropriate level of services. Also, the relationship and linkage between the national/regional government and local extension centers should be reshaped by making current linkage system such as monthly Provincial Meeting and central-local association more effective. Establishment of agricultural database of each local region is needed to strengthen local extension center's role. Finally, extension service agency needs to consider to expand its function from the traditional extension services to a variety of 'rural issues.'

• Proceedings of the Korean Society for Quality Management Conference
• /
• 2004.04a
• /
• pp.556-563
• /
• 2004

For the activation of the Sanhakyeon Consortium, the role of local universities is critical. It is necessary for the university professionals to bring forth detailed alternative plans to upgrade the technological power of the inferior local small & medium enterprises. This means that the local self-governing bodies must database local universities and professional personnel. As a result, the professionals that are needed by enterprises must be designated to those businesses. Also, the regional small and medium enterprises must develop research personnel to enhance their power of technology. To make this possible, the participating companies of Sanhakyeon Consortium should support the students who are participating in the Consortium with research funds, and also should consider how these students can work for those companies after graduation. Finally, the local self-governing bodies must support Sanhak's cooperative research on locally specialized Industries, by forming a technology-human power network between local universities and small Sl medium enterprises.

• Genomics & Informatics
• /
• v.6 no.2
• /
• pp.95-97
• /
• 2008

Many bioinformatics sites have managed local bio-databases, including major databases such as GenBank and PIR with update load. We have developed several programs to monitor the update status of these databases and to FTP them automatically. These programs can be used for maintaining local bio-databases as recent versions and providing up-to-date databases through FTP sites. Currently, the program serves major bio-databases and will extend to accommodate many more bio-databases.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.9 no.5
• /
• pp.1132-1141
• /
• 2005

We must have a schema conflict resolution method for integrating local schema on content integration and management system. But The Past method is inconsistent and depends on local and global databases. In this paper, we propose the management method of schema confilct using XML that can represent and interchange the structual information of schema.

• Proceedings of the IEEK Conference
• /
• 2000.07b
• /
• pp.735-738
• /
• 2000

The most important issue in database security is correct concurrency control under the restrictive security policy. The goal of secure transaction management is to keep security and provide many concurrent users with the high availability of database. In this paper, we consider the security environment of multidatabase system with replicated data. The read-from relationship in the existed serializability is improper in security environment. So, we define new read-from relationship and propose new secure 1-copy quasi-seriailzability by utilizing this relationship and display some examples. This security environment requires both the existed local autonomy and the security autonomy as newly defined restriction. To solve covert channel problem is the most difficult issue in developing secure scheduling scheme. The proposed secure 1-copy quasi-serializability is very proper for global transactions in that this serializability not violates security autonomy and prevents covert channel between global transactions.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.24 no.64
• /
• pp.1-20
• /
• 2001

In distributed databases, file replication and workload allocation are important design issues. This paper solves these two issues simultaneously, The primary objective is to minimize the system response time that consists of local processing and communication overhead on a local area network. Workload (query transactions) is assigned among any sites in proportion to the remaining file request service rate of the each server The problem is presented in the form of a nonlinear integer programming model. The problem is proved to be NP-complete and thus an efficient heuristic is developed by employing its special structure. To illustrate its effectiveness, it is shown that the proposed heuristic is based on the heuristic of a non-redundant allocation that was provided to be effective. The model and heuristics are likely to provide more effective distributed database designs.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2004.05b
• /
• pp.370-373
• /
• 2004

We must have management method of schema conflict for integrating local schema on content integration and management system. But The past method is inconsistent and depends on local and global databases. In this paper, we propose the management method of schema confilct using XML that can represent and interchange the structual information of schema