• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.21 no.2
• /
• pp.333-338
• /
• 2017

Recently, because of the mobile device generalization tendency, a lot of new mobile applications which need mobile database on mobile devices appear. SQLite, Realm, etc. are representative mobile databases, and they are the database engines which are suitable for small devices that have large resource restriction and are used a lot in mobile devices based on Linux. These engines are open source programs and have advantages which are lighter weight and faster speed than general purpose databases. This paper focuses on the performance experiments and analysis of SQLite, which is front runner in mobile database fields. Considering the target mobile environments, the test is performed at Linux environment. And this paper implements performance test program and performs performance experiment of SQLite database to test search efficiency. The experiment is processed by comparison with the results of a Oracle database working out at the same environment.

• Journal of Korean Institute of Industrial Engineers
• /
• v.39 no.2
• /
• pp.119-128
• /
• 2013

Most internet users utilize internet portal search engines, such as Naver, Daum and Google nowadays. But since the results of internet portal search engines are based on universal criteria (e.g. search frequency by region or country), they do not consider personal interests. Namely, current search engines do not provide exact search results for homonym or polysemy because they try to serve universal users. In order to solve this problem, this research determines keyword importance and weight value for each individual search characteristics by collecting and analyzing customized keyword at external database. The customized keyword weight values are integrated with search engine results (e.g. PageRank), and the search ranks are rearranged. Using 50 web pages of Goolge search results for experiment and 6 web pages for customized keyword collection, the new customized search results are proved to be 90% match. Our personalization approach is not the way that users enter preference directly, but the way that system automatically collects and analyzes personal information and then reflects them for customized search results.

• Journal of the Korean housing association
• /
• v.11 no.1
• /
• pp.151-158
• /
• 2000

The purpose of this study is to analyze systematically the characteristics and types of contemporary houses and to offer information concerning houses based on web database. This study deals with single-unit Korean houses designed by modern architects, which appeared in architectural periodicals and books published since 1990. This study sets three analysis criteria : general characteristics, morphological characteristics and functional characteristics of houses. Also, the web database including analysis contents is constructed to attain various information of the houses and results. The process of constructing the web database and the search method for house information retrieval are described. It is concluded that contemporary houses show various aspects of their plans in certain specific types. By using web database we obtained various analysis on house plan. This study investigated practicality of web database in architecture, interior design and house studies, and the types of contemporary house plans are revealed as well.

• Genomics & Informatics
• /
• v.7 no.4
• /
• pp.212-216
• /
• 2009

WebChemDB is an integrated chemical database retrieval system that provides access to over 8 million publicly available chemical structures, including related information on their biological activities and direct links to other public chemical resources, such as PubChem, ChEBI, and DrugBank. The data are publicly available over the web, using two-dimensional (2D) and three-dimensional (3D) structure retrieval systems with various filters and molecular descriptors. The web services API also provides researchers with functionalities to programmatically manipulate, search, and analyze the data.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.14 no.1
• /
• pp.393-401
• /
• 2013

Most traditional databases exploit record-oriented storage model where the attributes of a record are placed contiguously in hard disk to achieve high performance writes. However, for search-mostly datawarehouse systems, column-oriented storage has become a proper model because of its superior read performance. Today, flash memory is largely recognized as the preferred storage media for high-speed database systems. In this paper, we introduce fast column-oriented database model and then propose a new column-aware index management scheme for the high-speed column-oriented datawarehouse system. Our index management scheme which is based on enhanced $B^+$-Tree achieves high search performance by embedded flash index and unused space compression in internal and leaf nodes. Based on the results of the performance evaluation, we conclude that our index management scheme outperforms the traditional scheme in the respect of the search throughput and response time.

• Proceedings of the Korea Contents Association Conference
• /
• 2006.05a
• /
• pp.125-127
• /
• 2006

A number of museums and related parties have tangible heritage data and those data are collected by different types and formats. In these days, there are no service which connect each others so if a user wants to search a data, user have to log on certain homepage and search data. In general relational database systems have used for tangible heritage but sometime there is no ontology information for such relational database system. Therefore, for efficient searching of tangible heritage, we need a method which is extracting ontology information from relational database system. And we need a method which makes alignment between local ontologies extracted from relational database system and global ontology which has global information of tangible heritage. In this paper, we propose a system which can search tangible heritage efficiently using a method of extracting ontology from RDBMS and a method of aligning between local ontology and global ontology.

• Journal of the Korea Society of Computer and Information
• /
• v.20 no.1
• /
• pp.185-195
• /
• 2015

During hospital peak times of outpatients, an effective mechanism that informs the newly receipted patient information to corresponding medical departments is lacking in current hospital reception systems. Since every department repeatedly searches entire patient reception database in sequential manner to acquire its reception information, this is a significant performance degradation factor in hospital information system. To improve hospital reception system efficiency, we developed two web socket based systems, a primary key transmitting batch system and a reception information transmitting real time system. The former reduced database access time compared to sequential search system as well as kept search time low regardless of receipted patient number. The latter effectively reduced waiting list updating time in request/response patient reception system by eliminating database access.

• 한국HCI학회:학술대회논문집
• /
• 2008.02b
• /
• pp.304-309
• /
• 2008

The development in information technology allowed most of the information around us into digital information, in other words, a database. The innovation increased the accessibility and helped this society change into an informational age. However, there is a shortcoming of this open source as the users have difficulty in assorting the information that s/he needs and realizing if the information provided is important. Therefore, the need for search engine has risen in such a way to increase the accessibility and facilitation of information provided to the users through searching the necessary information in the database by an easy and accurate way. This study aims to increase the utilization of search engine through relationship analysis between purpose of user and interface design factors of search engine. Also, it intends to propose design guidelines for search engine interface design in order to increase user satisfaction and usability. This study categorized and correlated the relationships of the purpose in using the search engine and types of search engine interfaces. This study explicates the critical properties in designing each search engine interface according to the purpose of the users in using them. Also, this study proposes recommendations for appropriate design guidelines for search engine interface and effective advertisement use through properties of interface and their importance. The search engine interface suggested from the result provides interface that allows efficient search for desired information and embrace a variety in users, eventually increasing the usability in search engine.

• International Journal of Internet, Broadcasting and Communication
• /
• v.10 no.2
• /
• pp.31-38
• /
• 2018

As the use of open source databases grows, so does need to evaluate, the performance of search queries for these databases. This paper compares the search query performance of SQL-based open source databases with commercial databases through experiments. The targets are MySql, MariaDB, and MS-SQL Server. In this study, the execution time of various types of search queries are measured. Also, search query performance was experimented according to change of index and number of tuples. Experimental results show that SQL-based open source databases have the potential to replace commercial databases when indexes are used and the number of tuples is not very large.

• The Journal of Society for e-Business Studies
• /
• v.13 no.4
• /
• pp.111-124
• /
• 2008

The development in information technology allowed most of the information around us into digital information, in other words, a database. The innovation increased the accessibility and helped this society change into an informational age. However, there is a shortcoming of this open source as the users have difficulty in assorting the information that s/he needs and realizing if the information provided is important. Therefore, the need for search engine has risen in such a way to increase the accessibility and facilitation of information provided to the users through searching the necessary information in the database by an easy and accurate way. This aim of study should propose the important design attribute to increase the utilization of search engine through relationship analysis between purpose of user and interface design factors of search engine. In other words, these attributes, as design guideline, could apply to the search engine interface design considering of user's search goal. For this, the purpose in using the search engine and types of search engine interfaces were categorized and correlated the relationships. The search engine interface suggested from the result provides interface that allows efficient search for desired information and embrace a variety in users, eventually increasing the usability in search engine.