• Proceedings of the Korean Institute of Intelligent Systems Conference
• /
• 2003.09a
• /
• pp.551-554
• /
• 2003

Aggregate operator which belongs to query operations are important in specialized systems such as geographic information system(GIS) and spatial database system. Most of data describing objects in the real world are characterized by space and time attributes. Till now, however, works on aggregate operations have only dealt with spatial or temporal aspect of object. The current demand of aggregate operations relates to spatiotemporal data which are contained both spatial and temporal data concurrently. Therefore, work on spatiotemporal operations is focused on database area. In this paper, we propose spatiotemporal aggregate functions that operate on spatiotemporal data. Above all, we support spatiotemporal aggregate functions on the basis of three dimensional spatiotemporal models that are defined with the linear one dimensional temporal domain. The proposed algorithms are evaluated through some implementation results. We are sure that the achievement of our work is useful and efficient.

• Journal of Pharmaceutical Investigation
• /
• v.38 no.6
• /
• pp.429-432
• /
• 2008

Drug delivery systems (DDS) have entered mainstream in the pharmaceutical industry in the recent years. Major pharmaceutical companies as well as small or medium-sized biotechnology companies are developing various DDS-based products. We have established Drug Delivery System Company Database, which is an online searchable database of companies that develop DDS-based products and technologies or supply formulations and/or materials. Company summary, products and key technologies are listed in the database. DDS technology fields also include administration routes and indications of drugs. DDS terminologies, Statistical analysis, Useful Links, Glossary and Comments pages are also provided.

• Journal of the Korean Dietetic Association
• /
• v.8 no.4
• /
• pp.387-397
• /
• 2002

Foodservice information systems management practices were assessed in hospital foodservice operations. A total of 46 dietetic departments were responded for the study and their practices of foodservice information systems were analyzed. The respondents were questioned about general characteristics of respondents as well as hospital foodservices implementation status of information systems. Statistical data analysis was completed using the SPSS package program for descriptive analysis, factor analysis, t-test and ANOVA test. 43.2% of total respondents gained informations by benchmarking of other hospital foodservice operations, but 7.8% gained through career education. They expected the enhanced efficiency of their tasks through implementing information systems. Based on factor analysis, information systems were divided into 6 management areas such as database management, meal management, nutrition management, purchasing management, production management and foodservice management. The average implementing scores were : database management 3.77, meal management 3.26, nutrition management 3.52, purchasing management 3.26, production management 2.73 and foodservice management 3.70 (score 1 indicates very poor and score 5 is very good). Among database management areas, standard recipe database and food item specifications database build-up scores(3.91) were relatively very high, but meal assessment and foodservice management reporting scores(2.43) were very low. The results suggest that it is necessary to build up automated foodservice management reporting system for the improvement of efficiency and productivity of operational tasks.

• Proceedings of the Korea Database Society Conference
• /
• 1994.09a
• /
• pp.49-69
• /
• 1994

A client/server system has become the computing architecture for the business organization which seeks competitive edges. Technically, a client/server system places application processing close to the user and thus increases performance. This paper's two primary goals are (i) to present a performance model for client/server database systems and (ii) to demonstrate analytically the effectiveness of client/server computing in comparison with other computing architectures via an illustrative example. The model is most likely to be used as a practical performance guide for client/server computing.

• The Bulletin of The Korean Astronomical Society
• /
• v.41 no.2
• /
• pp.53.2-53.2
• /
• 2016

We present our experiences with open-source spatio-temporal database systems for managing and analyzing big astronomical data acquired by wide-field time-domain sky surveys. Considering performance, cost, difficulty, and scalability of the database systems, we conduct comparison studies of open-source spatio-temporal databases such as GeoMesa and PostGIS that are already being used for handling big geographical data. Our experiments include ingesting, indexing, and querying millions or billions of astronomical spatio-temporal data. We choose the public VVV (VISTA Variables in the Via Lactea) catalogs of billions measurements for hundreds of millions objects as the test data. We discuss issues of how these spatio-temporal database systems can be adopted in the astronomy community.

• Journal of the Korean Institute of Illuminating and Electrical Installation Engineers
• /
• v.23 no.11
• /
• pp.44-51
• /
• 2009

A variety of Urban Rail Transit (URT) systems have been operating and they have different technology bases, causing a lot of difficulties in taking measures against trouble, training, upgrading, interoperability and so on. As such, a standardization project has been carried out to solve the problems by setting up the national standards for URT systems. A common database was built to provide the integrated engineering environment to the community of URT project. This paper discusses the design of the database and how it can be utilized in the successful promotion of the project. The products of the projects are stored into the database with traceability management to be referred to by other new URT projects for reusing and sharing the acquired knowledge through cross organizations.

• Journal of Korea Society of Industrial Information Systems
• /
• v.13 no.5
• /
• pp.1-6
• /
• 2008

Database Administrators (DBA) play a role in designing and maintaining database systems. It is one of the Information Technology (IT) jobs in high demand and is important in developing and maintaining Information Systems (IS). Little research has been conducted on the skill requirements for a DBA. By collecting and analyzing job ads posted on the websites of Fortune 500 companies, we investigated the skill requirements needed for today's DBA.

• Journal of Korean Institute of Industrial Engineers
• /
• v.28 no.4
• /
• pp.435-442
• /
• 2002

It is difficult to access and share design data among heterogeneous CAD systems. Usually, different CAD systems exchange the design data using a neutral format such as IGES or STEP. A prototype CAD system which uses a geometric kernel and a commercial database management system has been implemented. The prototype system used the Open Cascade geometric kernel and the commercial object-oriented database ObjectStore. STEP provides the database schema. The database can be accessed from commercial CAD systems such as SolidWorks or Unigraphics. The data access module from a commercial CAD system is developed with the CAD system's native API, ObjectStore API functions, and ActiveX.

• Journal of Electrical Engineering and information Science
• /
• v.2 no.5
• /
• pp.89-99
• /
• 1997

The application for real-time database systems must satisfy timing constraints. Typically the timing constraints are expressed in the form of deadlines which are represented by priorities to e used by schedulers. In any real-time applications, since the system maintains sensitive information to be shared by multiple users with different levels of security clearance, security is another important requirement. As more advanced database systems are being used in applications that need to support timeliness while managing sensitive information, protocols that satisfy both requirements need to be developed. In this appear, we proposed a new priority-driven secure multiversion locking (PSMVL) protocol for real-time secure database systems. The schedules produced by PSMVL are proven to e one-copy serializable. We have also shown tat the protocol eliminates covert channels and priority inversions. The details of the protocol, including the compatibility matrix and the version selection algorithms are presented. the results of the performance comparisons of our protocol with other protocols are described.

• Korean Management Science Review
• /
• v.20 no.2
• /
• pp.1-16
• /
• 2003

Previous research on data extraction and integration for data warehousing has concentrated mainly on the relational DBMS or partly on the object-oriented DBMS. Mostly, it describes issues related with the change data (deltas) capture and the incremental update by using the triggering technique of active database systems. But, little attention has been paid to data extraction approaches from other types of source systems like hierarchical DBMS, etc. and from source systems without triggering capability. This paper argues, from the practical point of view, that we need to consider not only the types of information sources and capabilities of ETT tools but also other factors of source systems such as operational characteristics (i.e., whether they support DBMS log, user log or no log, timestamp), and DBMS characteristics (i.e., whether they have the triggering capability or not, etc), in order to find out appropriate data extraction techniques that could be applied to different source systems. Having applied several different data extraction techniques (e.g., DBMS log, user log, triggering, timestamp-based extraction, file comparison) to S bank's source systems (e.g., IMS, DB2, ORACLE, and SAM file), we discovered that data extraction techniques available in a commercial ETT tool do not completely support data extraction from the DBMS log of IMS system. For such IMS systems, a new date extraction technique is proposed which first creates Index database and then updates the data warehouse using the Index database. We illustrates this technique using an example application.