synopsis for database interface, Study Guides, Projects, Research of Computer Engineering and Programming

Download synopsis for database interface and more Study Guides, Projects, Research Computer Engineering and Programming in PDF only on Docsity!

Synopsis of

Multi - Database

server Interface

ABSTRACT

Database systems play a vital role in storing and retrieving the data. Our Project aims at designing a common database interface that provides a common environment of access for different database servers. Applying this interface, we can access different databases using a single visual interface, without bothering about their individual interfaces and without being expert in Sql queries. The aim of developing interface is to make an interactive common tool for database SQL SERVER, ORACLE, MS ACCESS etc. with a query builder support that helps the users generate a sql query based on the options selected. The common interface provides access to users based on the valid credentials. When access is granted, the user can use the interface for accessing data of respective database, the user has logged in. Further we develop our interface as web based application in order to make the interface network based , and preventing extra burden of installation on different machines.

Objectives of the Proposed System

• Common Interface :

The proposed system has the common interface for all database servers that

makes the database server access easy.

• Visual interface:

The interface developed is graphical and user friendly that makes it easy to use

for users.

• Inbuilt query generator:

This feature, allows the users to generate the sql queries by following the

wizard options without being an sql expert;

• Save/retrieve query wizard :

We can save the commonly used queries and retrieve the saved queries for future

reference.

• Object browser : This tool is used to design open , modify the various objects(tables, views) graphically in the database server without writing queries.

QUERY EXECUTION PROCESS

METHODOLOGY USED

The spiral model is a software development process combining elements of both design and prototyping-in-stages, in an effort to combine advantages of top-down and bottom-up concepts. Also known as the spiral life cycle model (or spiral development), it is a systems development method (SDM) used in project development. This model combines the features of the prototyping and the waterfall model. The working of the model is described in the diagram below.

Starting at the center, each turn around the spiral goes through several task regions.

• Determine the objectives, alternatives, and constraints on the new iteration.
• Evaluate alternatives and identify and resolve risk issues.
• Develop and verify the product for this iteration.
• Plan the next iteration.

REQUIREMENTS

HARDWARE REQUIRED

CLIENT SYSTEM:

1. Processor Pentium IV or higher.
2. (^) 511GB of RAM or more.
3. 50GB Hard Disk or more.
4. Network Adapter or Modem.
5. Keyboard & Mouse. SERVER SYSTEM:

• Core 2 duo Processor or Above.
• RAM (at least) 1GB.
• LAN Card (Speed) 100mbps
• Hard Disk (120 GB).

• Keyboard & Mouse.

- The interface can be made to create tables and databases graphically.