• 한국디지털정책학회:학술대회논문집
• /
• 2003.12a
• /
• pp.263-273
• /
• 2003

Recognizing the importance of the database query optimization design methods, we implemented mobile database with mobile program (J2ME) which is a useful database procedures. In doing so, we emphasize the logical query optimization which brings mobile database to performance improvement. The research implies that the suggested mobile program (J2ME) would contribute to the realization of the efficient mobile database as the related technology develops in the future.

• 한국경영정보학회:학술대회논문집
• /
• 2008.06a
• /
• pp.620-627
• /
• 2008

In this paper, recognizing the importance of the database query optimization design methods, we implemented mobile database with mobile program (J2ME) which is a useful database procedures. In doing so, we emphasize the logical query optimization which brings mobile database to performance improvement. The research implies that the suggested mobile program (J2ME) would contribute to the realization of the efficient mobile database as the related technology develops in the future.

• Proceedings of the Korean Geotechical Society Conference
• /
• 2010.09a
• /
• pp.1282-1288
• /
• 2010

In this study, Site Investigation Program of cut slope is developed using related techniques and experience got from practical application of Inventory Survey Program of cut slope in work for last 4 years. The Site Investigation Program is designed to can be loaded to the Mobile PC for convenience of carrying in filed, convenience of data input and revision, application of diverse programs, convenience of confirming data and facility of establishment of real-time database system using wireless communication like Inventory Survey Program. Also, for connection with Inventory Survey Program, it has a same work process and can establish real-time database system of almost data obtained in filed using stability analysis tool loaded in this program. Application of this developed program is expected to be an opportunity that can contribute to development of slope investigation and database system area using IT techniques.

• Genomics & Informatics
• /
• v.7 no.3
• /
• pp.175-177
• /
• 2009

We have developed WinBioDBs with Windows interfaces, which include importing modules and searching interfaces for 10 major public databases such as GenBank, PIR, SwissProt, Pathway, EPD, ENZYME, REBASE, Prosite, Blocks, and Pfam. User databases can be constructed with searching results of queries and their entries can be edited. The program is a stand-alone database searching program on Windows PC. Database update features are supported by importing raw database files and indexing after downloading them. Users can adjust their own searching environments and report format and construct their own projects consisting of a combination of a local databases. WinBioDBs are implemented with VC++ and its database is based on MySQL.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2005.06a
• /
• pp.118-122
• /
• 2005

Data mining is the process of autonomously extracting useful information or knowledge from large data stores or sets. For analyzing data of manufacturing processes obtained from database using data mining, source data should be collected form production process and transformed to appropriate form. To extract those data from database, a computer program should be made for each database. This paper presents a program to extract easily data form database in industry. The advantage of this program is that user can extract data from all types of database and database table and interface with Teamcenter Manufacturing.

• Proceedings of the Korean Geotechical Society Conference
• /
• 2008.03a
• /
• pp.813-820
• /
• 2008

We have developed inventory database program which is available in the mobile PC. The mobile PC is convenient in terms of portability, data input, modification, practicality of various program and data confirmation in site. By utilizing the inventory database program in mobile PC, we are able to complete database in site. Then, database is converted into the Hangul document and Excel worksheet. Also, based on the above procedure, effective management and utilization of inventory on cut-slope can be achieved.

• Publications of The Korean Astronomical Society
• /
• v.21 no.1
• /
• pp.1-9
• /
• 2006

An archiving system designed to enable documenting database of astronomical images, with functions of search and download, is being developed by Korean Astronomical Data Center(KADC) of Korea Astronomy and Space Science Institute(KASI). The system consists of three PCs for web server, database server, and system management server. The search program for the web environment is operated in the web server. In the management server, several utility program we developed are installed: input program for the database, program for transfer from fits to jpg files, program for data recovery and management, and programs for statistics and connect management. The collected data would be sorted out by the system manager to input into the database. The online input is possible in an observatory where the data is produced. We applied the content management system(CMS) module for the database management. On the basic of CMS module, we set up a management system for the whole life cycle of metadata from creation and collection to storage and deletion of the data. For the search function, we employed a technique to extract indices from the metadata. In addition, MySQL is adopted for DBMS. We currently display about 2,700 and 25,000 photographs for astronomical phenomena and astronomical objects on the data, respectively.

• Proceedings of the Korean Society for Bioinformatics Conference
• /
• 2001.10a
• /
• pp.11-28
• /
• 2001

The Korean functional Genomics Project focuses on stomach and liver cancers. Specimens collected by six hospital teams are used in BNA microarray experiments. Experimental conditions, spot measurement data, and the associated clinical information are stored in a relational database. Microarray database schema was developed based on EBI's ArrayExpress. A diagrammatic representation of the schema is used to help navigate over marty tables in the database. Field description, table-to-table relationship, and other database features are also stored in the database and these are used by a PERL interface program to generate web-based input forms on the fly. As such, it is rather simple to modify the database definition and implement controlled vocabularies. This PERL program is a general-purpose utility which can be used for inputting and updating data in relational databases. It supports file upload and user-supplied filters of uploaded data. Joining related tables is implemented using JavaScripts, allowing this step to be deferred to a later stage. This feature alleviates the pain of inputting data into a multi-table database and promotes collaborative data input among several teams. Pathological finding, clinical laboratory parameters, demographical information, and environmental factors are also collected and stored in a separate database. The same PERL program facilitated developing this database and its user-interface.

• Proceedings of the KSR Conference
• /
• 2007.11a
• /
• pp.1586-1589
• /
• 2007

A prototype high-speed train system, Hanvit-350, has been developed in Korea since 1996. The train has reached the maximum speed of 352.4km/h during a test run on December 2004. It is presently undergoing various tests to stabilize its performance and to secure reliability. Until now, around 420 runs have been conducted and accumulates 190,000km trial run. The test database management program is developed using existing analysis program, LabVIEW and database program, Microsoft-SQL. The test database management program is used to analysis of test results and will be used to find out the correlation characteristics between parameters.

• Journal of the Korean Dietetic Association
• /
• v.5 no.1
• /
• pp.100-115
• /
• 1999

With the growing number of nutrient calculation software packages on the market, there are need to compare each programs. Since each program use different nutrient databases, the result of calculation may be different in value. In this study, we use three(A, B, C) most popular program package to compare the result of nutrient calculation. For the analysis, 24hour recall data from 97 preschool children, 66 university students and 95 aged persons were used. For the calculation if subjects gave the complete recipe, recipes from the subjects were used. Otherwise, recipe from the program database were used. Common 15 nutrients of which all program can give results, are analyzed and compared for mean nutrient intake and nutrient intake for food groups. Ten nutrients among 15 nutrients which have RDA were analyzed for % of RDA and the distribution of RDA. Mean nutrient intake of Fe, vitamin A, Na were statistically different among results of the calculation using three programs(p<0.001). The distribution of Fe, vitamin A and vitamin $B_2$, niacin were statistically different among three results of the calculation using three program(p<0.001, p<0.05). Nutrient intakes of food groups were statistically different in cereal and products, bean and products, vegetables, fruits, fishes and shellfishes, milk and products, beverages, and seasonings(p<0.0001). It is hard to say that the difference among three program are coming from the difference from nutrient database or recipe database in this study. With these result, we conclude that it is necessary to evaluate nutrient database and recipe database as the foremost consideration in selecting nutrient calculation software. Those differences should be considered when interpreting results, comparing results with other studies, and when developing treatment plans in the clinical settings.