• Proceedings of the KSRS Conference
• /
• 2003.11a
• /
• pp.499-501
• /
• 2003

As semiconductor memory becomes cheaper, the memory capacity of computer system is increasing. Therefore computer system has sufficient memory for a plentiful spatial data. With emerging spatial application required high performance, this paper presents a GIS database system in main memory. Memory residence can provide both functionality and performance for a database management system. This paper describes design of DBMS for storing, querying, managing and analyzing for spatial and non-spatial data in main-memory. This memory resident GIS DBMS supports SQL for spatial query, spatial data model, spatial index and interface for GIS tool or applications.

• The Journal of Information Systems
• /
• v.19 no.4
• /
• pp.25-49
• /
• 2010

As companies introduced ERP (Enterprise Resource Planning) systems since the middle of 1990s, the databases of the companies has become centralized and gigantic. The companies are now developing data-mining based applications on those centralized and gigantic databases for knowledge management. Almost of them are using $Pro^*C$/C++, a embedded SQL programming language, and it's because the $Pro^*C$/C++ is independent of platforms and also fast. However, they suffer from difficulties in development and maintenance due to the characteristics of corporate databases which have intrinsically large number of tables and fields. The purpose of this research is to design and implement a methodology which makes it easier to develop and maintain embedded SQL applications based on relational databases. Firstly, this article analyzes the syntax of $Pro^*C$/C++ and addresses the concept of repetition and duplication which causes the difficulties in development and maintenance of corporate information systems. Then, this article suggests a management architecture of source codes and databases in which a preprocessor generates $Pro^*C$/C++ source codes by referring a DB table specification, which would solve the problem of repetition and duplication. Moreover, this article also suggests another architecture of DB administration in which the preprocessor generates DB administration commands by referring the same table specification, which would solve the problem of repetition and duplication again. The preprocessor, named $PrePro^*C$, has been developed under the UNIX command-line prompt environment to preprocess $Pro^*C$/C++ source codes and SQL administration commands, and is under update to be used in another DB interface environment like ODBC and JDBC, too.

• The Journal of Korean Institute of Communications and Information Sciences
• /
• v.31 no.4B
• /
• pp.285-290
• /
• 2006

Various aspects should be taken into account while developing a distributed architecture based on a multi-tier model or an enterprise architecture. Among those, the separation of role between page designer and page developer, defining entity which is used for database connection and transaction processing are very much important. In this paper, we presented DONSL(Data Server of Non SQL query) architecture to solve these problems applying web tier object modelling. This architecture solves the above problems by simplifying tiers coupling and removing DAO(Data Access Object) and entity from programming logic. We concentrate upon these three parts. One is about how to develop the DAO not concerning the entity modification, another is automatic transaction processing technique including SQL generation and the other is how to use the AET/MET(Automated/Manual Execute d Transaction) effectively.

• Journal of the Korean Association of Geographic Information Studies
• /
• v.7 no.3
• /
• pp.35-47
• /
• 2004

Telematics and LBS is one of rapidly emerged technology domains. In order to efficiently construct them, moving object technology which manages huge volume of real-time location data is required. Especially, the query which obtains special sorts of information closely related to the detailed applications is required in order to effectively retrieve and analyze the location data for moving object in logistics domain. It has also complex query structure comparing to the conventional database query. The approach using the standard database query language, like SQL, can be considered as an effective alternative choice. In this paper, we not only propose a new query language, entitled as MOQL based on SQL, for the query processing of the vehicle monitoring and control in e-Logistics but also design and implement the query processor.

• The KIPS Transactions:PartD
• /
• v.15D no.4
• /
• pp.549-556
• /
• 2008

Web-based Enterprise Intranet System is developed Object-oriented programming language and data management is constructed using RDBMS. Between Object-oriented programming language and RDBMS bring about "Object-Relational Impedance Mismatch" due to heterogeneous paradigm. To solve this kinds of problems commonly use the ORM Framework that it is converting data between incompatible type systems in databases and object-oriented programming languages, uses complex mapping metadata. It causes difficult to develop and maintain because of inflexible in changes. This paper proposed persistence framework that solve the existing complexity of ORM framework and has more flexible in evolution of database table. This persistence framework is unnecessary meta information that connecting with entity of database table and the objects, it offers users convenience of maintenance and it allows far more flexible and affordable systems to be built because of automatically code generation. The result of testing based on the proposed persistence framework with Hibernate, iBATIS, It is similar response time with iBATIS and it has more about three times faster than Hibernate. But iBATIS has problems of mass data processing.

• Proceedings of the Korean Information Science Society Conference
• /
• 2010.06d
• /
• pp.77-80
• /
• 2010

최근 개인정보 및 민감한 데이터에 대한 불법적인 접근 및 유출로 인하여 사회적 문제를 야기하고, 이에 따른 경제적인 파급효과와 함께 개인정보 및 민감한 데이터에 대한 보안에 대한 관심이 더욱 증가하고 있다. 또한 법령상으로도 개인의 주민등록번호, 계좌번호, 패스워드 등 개인정보가 포함된 DB에 대하여 데이터를 암호화하여 저장, 관리하도록 규정하고있다. 본 논문에서 공개 데이터베이스인 MySQL에서 이러한 개인정보 및 민감한 데이터에 대한 암호화를 통하여 데이터를 저장, 관리하는데 있어서 데이터의 속성에 따라 적절한 암호화 기법을 사용함으로써 암호화를 통한 데이터보호와 함께 속도 등의 성능상의 오버헤드와 운영, 관리상의 효율을 높이기 위하여 지원하는 암호화 기법에 대하여 알아보고, 암호화 기법별로 성능을 시험하여 데이터의 속성에 따른 최적의 암호화 방식의 적용에 대한 방안을 제시한다.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2017.11a
• /
• pp.698-701
• /
• 2017

데이터베이스는 자료의 검색과 갱신의 효율화를 위해 논리적으로 연관된 여러 자료의 집합체로 만드는 것을 의미한다. 인터넷과 하드웨어의 발달로 관리해야 할 자료의 양이 많아 지고 있으며, 이를 쉽게 관리 하기위해 데이터베이스는 나날이 발전하고 있다. 본 논문에서는 데이터베이스의 역사, 종류, 데이터 베이스 언어 현황과 그 중 SQL 언어의 명령어와 이를 쉽게 사용 할 수 있도록 돕는 변환 프로그램 실험 결과를 보고한다.

• ETRI Journal
• /
• v.24 no.3
• /
• pp.226-238
• /
• 2002

A spatial object changes its states over time. However, existing spatial and temporal database systems cannot fully manage time-varying data with both spatial and non-spatial attributes. To overcome this limitation, we present a framework for spatio-temporal databases that can manage all time-varying historical information and integrate spatial and temporal relationship operators into the select statement in SQL3. For the purpose of our framework, we define three referencing macros and a history aggregate operator and classify the existing spatial and temporal relationship operators into three groups: exclusively spatial relationship operators, exclusively temporal relationship operators, and spatio-temporal common relationship operators. Finally, we believe the integration of spatial and temporal relationship operators into SQL3 will provide a useful framework for the history management of time-varying spatial objects in a uniform manner.

• Proceedings of the Korea Contents Association Conference
• /
• 2019.05a
• /
• pp.459-460
• /
• 2019

최근 데이터베이스에서 다루는 데이터의 크기가 커짐에 따라 SQL DB 대신 NoSQL DB의 사용이 증가하고 있다. 이런 변화에 따라 NoSQL과 저장장치에 대한 벤치마킹 및 분석을 통한 저장장치 성능 최적화 및 성능 평가 방법 개선이 필요하다. 본 논문에서는 기존 벤치마킹 툴의 조작 불편함을 해소하기 위해서 사용자의 편의성을 고려한 간편한 벤치마킹 시스템 GUI를 설계한다. 시각화 툴을 활용하여 벤치마킹 결과의 분석을 용이하게 할 수 있는 환경을 제공해준다.

• Proceedings of the Korean Society of Computer Information Conference
• /
• 2019.07a
• /
• pp.45-48
• /
• 2019

파이썬 플라스크와 MySQL데이터베이스를 이용한 스마트콘텐츠에서의 효율적인 클라우드 접속기술에 관한 효율적인 방법을 제시한다. 또한 스마트콘텐츠 제작단계에서 와이파이 혹은 블루투스를 이용한 클라우드 인터넷 접속시의 오류최소화를 위한 견고한 하우징제작을 위해 어도비 일러스트레이터를 이용한 표준화된 레이져커팅 방법도 제시한다. 이는 향후 4차 산업혁명시기에 필수적인 지능적이고 다이너믹한 특성을 갖는 스마트콘텐츠 제작과정에서의 시행착오를 줄여줄 것이며, 이를 통해 다양한 아이디어의 스마트콘텐츠가 양산될 수 있는 계기가 될 것으로 생각한다. 제시한 방안의 타당성을 검증하기 위해 실제로 구축한 가장 효율적인 스마트콘텐츠의 제각과정과 그 결과를 보인다.