• Journal of the Korea Institute of Information Security & Cryptology
• /
• v.27 no.2
• /
• pp.223-232
• /
• 2017

Previous research on data recovery in Microsoft SQL Server has focused on restoring data based on in the transaction log that might have deleted records exist. However, there was a limit that was not applicable if the related transaction log did not exist or the physical database file was not connected to Server. Since the suspect in the crime scene may delete the data records using a different deletion statements besides "delete", we need to check the remaining data and a recovery possibility of the deleted record. In this paper, we examined the changes "Page Allocation information" of the table, "Unallocation deleted data", "Row Offset Array" in the page according to "delete", "truncate" and "drop" events. Finally it confirmed the possibility of data recovery and availability of management tools in Microsoft SQL Server digital forensic investigation.

• Journal of the Korea Institute of Information Security & Cryptology
• /
• v.28 no.4
• /
• pp.859-868
• /
• 2018

Previous research related to recovering deleted data in database has been mainly based on transaction logs or detecting and recovering data using original source files by physical collection method. However there was a limit to apply if the transaction log does not exist in the server or it is not possible to collect the original source file because a database server owner does not permit stopping the database server because of their business loss or infringement at the scene. Therefore it is necessary to examine various collection methods and check the recoverability of the deleted data in order to handling the constraints of evidence collection situation. In this paper we have checked an experiment that the recoverability of deleted data in the original database source according to logical and physical collection methods on digital forensic investigation of Microsoft SQL Server database.

• The Journal of Information Systems
• /
• v.11 no.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.

• Journal of Korea Multimedia Society
• /
• v.16 no.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.

• Proceedings of the KOSOMBE Conference
• /
• v.1993 no.11
• /
• 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.

• Journal of the Korean Society of Systems Engineering
• /
• v.6 no.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.

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2005.06a
• /
• 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.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2004.05a
• /
• 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.

• The Journal of Information Systems
• /
• v.10 no.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

• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2006.05a
• /
• 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.