• 정보보호학회논문지
• /
• 제27권2호
• /
• pp.223-232
• /
• 2017

Microsoft SQL Server의 데이터 복구와 관련된 그간의 연구는 삭제된 레코드가 트랜잭션 로그에 존재하는 경우를 바탕으로 복원하는 방법이 주를 이루었다. 그러나 관련 트랜잭션 로그가 존재하지 않거나 물리 데이터베이스 파일이 Server와 연결되어 있지 않은 경우 적용하기 곤란한 한계가 있었다. 그러므로 범죄 과정에서 용의자가 delete 외 다른 이벤트를 이용하여 삭제할 가능성이 있기 때문에 이에 대한 삭제된 레코드의 잔존을 확인하여 복구 가능성을 확인해볼 필요가 있다. 이 논문에서는 Microsoft SQL Server 물리 데이터베이스 파일의 구조를 기초로 데이터 삭제가 수행되는 delete, truncate, drop 이벤트에 따른 Page 할당정보 유지 여부, 미할당 삭제데이터 존재 여부, 페이지 내 행오프셋 배열 정보의 변화를 실험하여 최종적으로 디지털포렌식 조사 시 관리도구 이용 가능성 및 데이터 복구 가능성을 확인하였다.

• 정보보호학회논문지
• /
• 제28권4호
• /
• pp.859-868
• /
• 2018

데이터베이스의 삭제된 데이터 복구와 관련된 그간의 연구는 삭제된 레코드가 트랜잭션 로그에 존재하는 경우이거나 데이터베이스 원본을 물리적 방식으로 수집하여 삭제 데이터의 탐지와 복구를 진행하는 방식이 주를 이루었다. 그러나 트랜잭션 로그가 존재하지 않거나 증거수집 현장에서 물리적 방식의 원본수집이 불가능한 경우 즉, 데이터베이스 서버 정지로 인해 피압수인이 업무상 손실 또는 권리침해를 이유로 거부하는 경우에는 적용하기 곤란한 한계가 있었다. 그러므로 증거수집 현장의 제약을 대비하기 위해 다양한 수집 방식을 살펴보고 이에 따른 삭제된 레코드의 복구 가능성에 대해서 확인해볼 필요가 있다. 이 논문에서는 Microsoft SQL Server 데이터베이스를 대상으로 하는 디지털포렌식 조사 시 원본 수집의 논리적 물리적 방식별로 수집된 원본 파일 내 삭제된 데이터의 잔존 여부를 실험하여 각 수집 방식에 따른 데이터 복구 가능성을 확인하였다.

• 한국정보시스템학회지:정보시스템연구
• /
• 제11권1호
• /
• pp.175-198
• /
• 2002

This paper is to develop a security module for electronic approval systems. Electronic documents are created, transmitted and saved in the company's intranet computer network. Transmitting electronic documents, however, brings us a security problem. Communications among various computer systems are exposed to many security threats. Those threats are eavesdropping, repudiation, replay back etc. The main purpose of this paper is to develop a module which provides the security of electronic documents while they are passed from one place to another This paper applies Multi-Level security to the electronic approval system that guarantees security of electronic documents from many threats. Multi-Level security controls the access to the documents by granting security level to subject users and object electronic documents. To prevent possible replay back attacks, this paper also uses one time password to the system. The security module is composed of client program and server one. The module was developed using Microsoft Visual Basic 6.0 and Microsoft SQL Server 7.0. The code uses Richard Bondi's WCCO(Wiley CryptoAPI COM Objects) library functions which enables Visual Basic to access Microsoft CryptoAPI.

• 한국멀티미디어학회논문지
• /
• 제16권12호
• /
• pp.1446-1453
• /
• 2013

In order to develop ECM system, there are a number of methodologies. Adopting Microsoft's solution and methodology is one of them. ECM has a large number of users to save the documentations in various types of multimedia data. So, managing multimedia database is very critical in ECM. Therefore the unit and integration test to evaluate the performance can detect the flaws of the system early on, and it has to be enables to reflect the user's requirements thru the user acceptance test. In this paper, we are discussing how to optimize the SQL database before the ECM system is built and used in the real situation thru unit and integration tests.

• 대한의용생체공학회:학술대회논문집
• /
• 대한의용생체공학회 1993년도 추계학술대회
• /
• pp.71-73
• /
• 1993

We are developed out-patient order communication system using server/client architecture. We used Microsoft SQL server for relational database and Visual basic language for client. The configuration of system hardware is 486 DX servers and 200 node 486/SX PC and 10 base T network.

• 시스템엔지니어링학술지
• /
• 제6권1호
• /
• pp.61-68
• /
• 2010

Generally EPC management system was simply management concept through the normal S/W. Our LNG Plant R&D Center wanted to the excellent management system from the S/W. So We developed the R&D management S/W and EPC management S/W Built in the Microsoft Project Server. Our system made to the customer Requirements. It was just User Interface protocol. But User Interface has more Weak position, because it makes from the MS Project Servers. Ms Projector server make easy to treat the project on the WBS. EPC parts mixed WBS and normally Ms SQL Database. It has very complicated Structures. Now We planed to make the general Database and Ms Project Server, It' means to the S/W Developer and Schedule Manager ability. We will successfully integrate R&D management system and EPC system and other softwares.

• 한국정밀공학회:학술대회논문집
• /
• 한국정밀공학회 2005년도 춘계학술대회 논문집
• /
• pp.191-194
• /
• 2005

Over the past decade, changes in product development processes and increased consumer demands have dramatically influenced engineering working practices and targets. The information technology revolution has made its appearance concurrent to this relentless escalation in product engineering requirement. It has offered hopes for improved productivity despite these increasing demands. The wide availability of personal computing power, virtually inexhaustible sources of information and an abundance of computerized engineering tools have created great expectations. Knowledge information modeling system and database were developed using ASP and Microsoft SQL 2000 Server to share the DB that can be utilized to process on the web.

• 한국경영과학회:학술대회논문집
• /
• 대한산업공학회/한국경영과학회 2004년도 춘계공동학술대회 논문집
• /
• pp.39-43
• /
• 2004

A research shows that a new category of software, Collaborative Product Commerce (CPC), is now emerging, allowing discrete manufacturers to once again distinguish themselves on their products and innovations. CPC permits discrete manufacturers to significantly improve the core processes around the management functions associated with the complete product life cycle that are the basis of their existence. As a way to develop computing tools of CPC to support a design process of product, a web-based design supporting system was constructed in the paper. The system consists of C-Product system and Net Meeting Communication system to improve communications between designers and persons for verification of design. The product data files of C-Product system were designed by Pro/Engineer and converted to 3D Viewer format for being used in the web browser. Also, Net Meeting Communication system and Database were developed using ASP and Microsoft SQL 2000 Server to share diverse files that can be utilized to design on the web in real time.

• 한국정보시스템학회지:정보시스템연구
• /
• 제10권1호
• /
• pp.5-25
• /
• 2001

The main purpose of this paper is to develop a Delphi Decision Support System based on the web, which can improve the conventional Delphi method. Among major drawbacks of the conventional Delphi methods are cost and efforts to distribute and collect the questionnaire by the regular mail and the tardiness in collecting, categorizing, analyzing, and reporting the result of the questionnaire. With the proposed Delphi Decision Support System, the moderator sends the e-mail to invite the member of panels so that they may visit the homepage of the Delphi Decision Support System. When the panelists input their opinions about the issues, the Delphi Decision Support System analyzes the inputs and reports the result without delay. To implement the Delphi Decision Support System, we integrated Microsoft SQL Server 6.5, jdbcKona/MS SQLServer 4 JDBC driver, and Java Development Kit 1.2

• 한국정밀공학회:학술대회논문집
• /
• 한국정밀공학회 2006년도 춘계학술대회 논문집
• /
• pp.623-624
• /
• 2006

Over the past decade, changes in product development processes and increased consumer demands have dramatically influenced engineering working practices and targets. The information technology revolution has made its appearance concurrent to this relentless escalation in product engineering requirement. It has offered hopes for improved productivity despite these increasing demands. The wide availability of personal computing power, virtually inexhaustible sources of information and an abundance of computerized engineering tools have created great expectations. CAPP (Computer Aided Process Planning) Expert system and database were developed using VB.NET and Microsoft SQL 2000 Server.