• 제목/요약/키워드: Database management systems

검색결과 1,024건 처리시간 0.026초

SQL/XML의 출판 함수를 이용한 관계 데이터의 XML 뷰 정의 및 처리 (Defining and Processing XML View of Relational Data with Publication Functions of SQL/XML)

  • 이상욱;김진;강현철
    • Journal of Information Technology Applications and Management
    • /
    • 제16권4호
    • /
    • pp.245-261
    • /
    • 2009
  • Since XML emerged as a standard for data exchange on the web, it has been widely used for applications like e-Commerce, CRM, and BI. However, it is common that most of business data is stored in relational database systems, and it is expected that business data management would still be centered around the relational database systems. As such, the technique of viewing relational data as XML and processing XML queries against it is required. To meet such a need, in the SQL/XML standard, the functions to publish relational data as XML are provided. In this paper, we propose the techniques of providing an XML view of relational data defined by an SQL/XML statement in DTD(Document Type Definition), and of processing XPath queries against the XML view by translating them into SQL/XML statements, and describe the validation of such techniques through implementation and tests.

  • PDF

반복 조인(Join)을 이용한 관계형 논리 부품구성표(BOM) 데이타 베이스 설계와 그 효용성 분석 (Design and Effectiveness Analysis of Relational Logical BOM (Bill Of Material) Database using Repeated Join)

  • 이경우;정기원
    • Asia pacific journal of information systems
    • /
    • 제2권1호
    • /
    • pp.57-76
    • /
    • 1992
  • Material Requirement Planning(MRP) has been the most widely implemented large scale production management system in the manufacturing industry. Computerization of MRP systems involves, in general, Bill Of Material(BOM) explosion algolithms which usually takes heavy computation time. In order to improve the effectiveness of the MRP systems, we propose to build a logical BOM database in advance, which reflects the Join operations for the BOM explosion. It reduces the response time for the BOM indented explosion. It reduces the MRP processing time. It also increased main memory utilization.

  • PDF

조직적 특성에 따른 정보시스템 주요관리이슈의 선택에 관한 연구 (An Investigation on Organizational Characteristics Influences on Information Systems Issues in the Korean Firms)

  • 한재민;문태수;박희찬
    • Asia pacific journal of information systems
    • /
    • 제5권2호
    • /
    • pp.51-78
    • /
    • 1995
  • This paper suggests a contingent perspective for analyzing information systems issues of the Korean firms. The contingent perspective includes such corporate characteristics as industry, organizational size, strategy, and value-added application function. This research surveyed 119 corporations in manufacturing, banking, distribution, and construction industries. Among those samples 104 data of corporate IS managers turned out to be statistically valid. As a result, those issues are ranked as the most urgent and important IS issues: strategic IS planning, system integration, application of database, process standardization, and network planning and implementation. Furthermore, factor analysis says that thirty issues to be surveyed are to be grouped into seven factors such as IS planning, user/education, database, applications of IT, system management, distributed computing technology, and network applications. It also found through Pearson correlation and ANOVA that organizational characteristics highly influences the IS issues the corporations face.

  • PDF

메타 정보검색 에이전트 시스템을 위한 다중플랫폼의 데이터베이스 재구조화에 관한 연구 (A Study on the Restructure of Multi-Platform Databases for MIRAS)

  • 신창훈;류병무
    • Asia pacific journal of information systems
    • /
    • 제13권1호
    • /
    • pp.47-72
    • /
    • 2003
  • It is important to retrieve information that a user requires on the web. The web is an open system. The amount of information is increasing rapidly. While each of information was compiled into the database piece at a single platform in the past, it is now compiled into complicated structure at a multi-platform. Restructuring the multi-platform database is needed to efficiently retrieve information. MIRAS(Meta Information Retrieval Agent System) has a multi-platform database on web. This study applies the classification of the existent site's categories to restructure the database systematically. The empirical analysis shows that the suggested method is effective for information retrieval and multi-platform database restructuring. This study helps users to save on time-cost of searching information.

정보시스템 전략적 계획을 위한 컴퓨터지원 통계적 접근방법 (A Computer-Aided Statistical Approach to Strategic Information Systems Planning)

  • 김진수;황철언
    • Asia pacific journal of information systems
    • /
    • 제4권2호
    • /
    • pp.188-213
    • /
    • 1994
  • Strategic information systems planning (SISP) remains a critical issue of many organizations and also the top IS concern of chief executives. Therefore, researchers have investigated SISP practices and tried to improve a methodology. Among the various issues of SISP, systematically determining subject database groupings and fully automating the processes are important aspects. This study presents an alternate methodology using a statistical technique, a variable clustering approach, and systematic rules for determining database groupings, which can be fully automated. This methodology provides a strong theoritical justification as well as systematic and simple criteria for database groupings, enhanced interpretability of the output, and would be easy to include in CASE software application.

  • PDF

전자 상거래 시스템에서의 지연된 정보 동기화 방법 (Delayed Information Synchronization in e-Commerce Systems)

  • 이동주;연종흠;이상구
    • 한국데이타베이스학회:학술대회논문집
    • /
    • 한국데이타베이스학회 2008년도 연합학회학술대회
    • /
    • pp.349-357
    • /
    • 2008
  • 전자 상거래에서 이용되는 전자카탈로그 정보는 다양한 이유에 의해서 중복 저장되기도 하는데, 이는 멀티데이터베이스 시스템에서의 글로벌 트랜잭션 보장 문제를 야기한다. 본 논문에서는 하나의 시스템에서만 카탈로그의 변경이 발생하고 변경 정보가 전파되는 특별한 상황에서의 동기화 문제 해결을 위한 로그 작성 및 관리 방법을 제안한다. 이를 만족하여 구현된 동기화 모듈은 지연된 동기화를 보장함을 보이고, 실제 환경에서 구현된 예를 통해서 제안한 방법이 유용함을 보인다.

  • PDF

셀프 생성 알고리즘을 사용한 프락시 서버를 기반으로 한 클라우드 서비스를 위한 키 관리 시스템 (A Key Management System for Cloud Services Based on Proxy Server Using Self-Creating Algorithm)

  • 성순화;윤청
    • 정보과학회 논문지
    • /
    • 제43권9호
    • /
    • pp.1052-1059
    • /
    • 2016
  • 클라우드 컴퓨팅 시스템의 주요 역할은 신뢰받지 않은 클라우드 서버의 데이터베이스 실행이 키 관리의 복잡성을 요구하기 때문에 중요한 이슈가 되고 있다. 본 연구는 키 실행을 최소화하는 셀프 프락시 서버를 사용한 키 관리 시스템을 제안하고, 사용자가 암호화된 데이터베이스에 질의할 때 데이터 소유자가 관련키에 직접적으로 관여하지 않는 셀프 생성 알고리즘을 생성하여 클라우드 서비스 성능을 개선한다. 셀프 프락시 서버는 클라우드 키 서버에 문제가 발생했을 때와 효율적인 클라우드 키 관리를 위하여, 이를 대신한 분산 서버로서 능동적이고 자율적인 키 관리를 지원한다. 따라서 제안한 키 관리 시스템은 클라우드 서버 데이터베이스의 기밀성 지원으로 안전한 클라우드 서비스를 제공한다.

수리온 체계개발에서의 시스템엔지니어링 적용사례 (Application of Systems Engineering in SURION R&D Project)

  • 김진훈;이동욱
    • 시스템엔지니어링학술지
    • /
    • 제10권1호
    • /
    • pp.81-86
    • /
    • 2014
  • Systems Engineering application focused on requirement definition and management for SURION System Development Project is described in this paper. To perform the development process effectively based on systems engineering processes; Requirements Definition, Design Review, Configuration Management, Quality Assurance, Data Management, are applied in this project. In this processes, the Stakeholder's Requirements are transferred to Specifications verified with design reviews, prototyping inspections, and integration tests. All engineering data, especially verification plan & results are recorded, and traced to each requirements of system specification in Surion database. Therefore, it could be assured that all requirements of specification are evaluated and verified successfully in Surion Project.