MULTISERVER
COMMUNICATION IN DISTRIBUTED EXECUTIVE DATABASE
ABSTRACT
A DBMS is a set of software
programs that controls the organization,
storage,
management, and retrieval of data in a database. DBMSs
are categorized according to their data structures or types. The DBMS accepts
requests for data from an application program and instructs the operating
system to transfer the appropriate data. The queries and
responses must be submitted and received according to a format that conforms to
one or more applicable protocols. When a DBMS is used, information systems can be changed much more
easily as the organization's information requirements change. New categories of
data can be added to the database without disruption to the existing system.
Database servers are computers that hold the
actual databases and run only the DBMS and related software. Database servers
are usually multiprocessor computers, with generous memory and RAID disk arrays used for
stable storage. Hardware database accelerators, connected to one or more
servers via a high-speed channel, are also used in large volume transaction
processing environments. DBMSs are found at the heart of most database applications. DBMSs may be built
around a custom multitasking kernel with built-in networking
support, but modern DBMSs typically rely on a standard operating
system to provide these functions
SYSTEM ANALYSIS
6.1 EXISTING SYSTEM
- Management of a distributed environment is a
complex task because there are several features of database systems such
as transaction management, concurrency control, security, backup and
recovery as well as query optimization and access path selection which can
be all synchronized.
- Increase storage requirements because
multiple copies of data can be found in different locations.
6.2 PROPOSED SYSTEM
- Data is located close to users fostering
better communications.
- Users work with a subset of whole data
increasing the performance of the solution due to faster delivery of data.
- Data can be processed in several locations
increasing the performance of the solution.
- Workload balance between the underlying
systems.
- Increase the availability because in a
distributed environment, we don't have a single-point of failure.
Hardware Requirements:
Processor
: Pentium 4
Processor
Speed : 2.40GHz
RAM : 512 MB
Hard
Disk : 80GB
Software Requirements:
Environment :
Visual studio .NET 2005
.NET Framework :
VERSION 2.0
Language : Visual Basic.NET
Operating System :
WINDOWS 2000/XP
Back
End : SQL SERVER-2000
No comments:
Post a Comment