DEVELOPMENT OF A DATABASE MANAGEMENT SYSTEM FOR SMALL AND MEDIUM SIZED ...

DEVELOPMENT OF A DATABASE MANAGEMENT SYSTEM FOR SMALL AND MEDIUM SIZED ENTERPRISES

A THESIS SUBMITTED TO THE GRADUATE SCHOOL OF NATURAL AND APPLIED SCIENCES

OF MIDDLE EAST TECHNICAL UNIVERSITY

BY

?DEM AFAK

IN PARTIAL FULFILMENT OF THE REQUIREMENTS FOR

THE DEGREE OF MASTER OF SCIENCE IN

MECHANICAL ENGINEERING

APRIL 2005

Approval of the Graduate School of Natural and Applied Sciences

Prof. Dr. Canan ?ZGEN Director

I certify that this thesis satisfies all the requirement as a thesis for the degree of Master of Science.

Prof. Dr. Kemal DER Head of Department

This is to certify that we have read this thesis and that in our opinion it is fully adequate, in scope and quality, as a thesis for the degree of Ma ster of Science.

Examining Committee Members

Prof. Dr. S. Engin KILI? Supervisor

Prof. Dr. Metin AKK?K

(METU,ME)

Prof. Dr. S. Engin KILI? Prof. Dr. ?mer ANLAAN

(METU,ME) (T?BTAK)

Prof. Dr. Mustafa G?KLER Assoc.Prof. Dr.Tayyar EN

(METU,ME) (METU,IE)

I hereby, declare that all information in this document has been obtained and presented in accordance with academic rules and ethical conduct. I also declare that, as required by these rules and conduct, I have fully cited and referenced all material and results that are not original to this work.

?idem afak

iii

ABSTRACT

DEVELOPMENT OF A DATABASE MANAGEMENT SYSTEM FOR SMALL AND MEDIUM SIZED ENTERPRISES

afak, ?idem M. Sc., Department of Mechanical Engineering

Supervisor: Prof. Dr. S. Engin Kili?

April 2005, 132 pages

Databases and database technology have become an essential component of everyday life in modern society. As databases are widely used in every organization with a computer system, control of data resources and management of data are very important. Database Management System (DBMS) is the most significant tool developed to serve multiple users in a database environment consisting of programs that enable users to create and maintain a database. Windows Distributed Internet Applications (DNA) architecture describes a framework of building software technologies together in an integrated web and client-server model of computing.

This thesis focuses on development of a general database management system, for small and medium sized manufacturing enterprises, by using Windows DNA technology. Defining, constructing and manipulating institutional, commercial and operational data of the company is the main frame of the work. And also by integrating "Optimization" and "Agent" system components which were previously developed in Middle East Technical University, Mechanical Engineering Department, Computer Integrated Manufacturing Laboratory (METUCIM) into the SME DBMS, a unified information system is developed.

iv

"Optimization" system was developed in order to calculate optimum cutting conditions for turning and milling operations. "Agent" system was implemented to control and send work orders to the available manufacturing cell in METUCIM. The components of these systems are redesigned to share a unique database together with the newly developed "SME Information System" application program in order to control data redundancy and to provide data sharing and data integrity.

Keywords: Database Management System, Windows DNA, Data Redundancy, Data Sharing, Data Integrity

v

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download