Assignment 07

Name : Umar Ali
Roll Number : 522
Class # : BS (CS) – 6th

Semester
Assignment # : 07
Submitted to : Sir Tariq
Subject : “CS-512 Distributed

Database”
What is Database Server:
Definition – Database server refers to combination of hardware and software where
they are used to run the database, as per the context. As software, a database server
works as back end portion for database applications that is following old client server
model. This back-end portion is known as “Instance”.
Database server likes as dedicated server that helps to offer database services, and
this type of server run database management software. Database server works
similar to client-server network model because it delivers all information which is
sought by client systems.
Many large scale organizations use the database servers because they need lot of data
regular basis. If those organizations implement client server architecture where
all clients require process data with frequently, then database server associated with
it, and they work together with more efficiently. Few companies hire file server for
storing and process data, then database server is best option compare to file server.
Types of Database Server:
There are different types of database server, and they are also known as
“Database Management System” or “Database Server Software.”
Examples of Database Server-
SAP HANA
It is developed by SAP SE, and it has ability to manage SAP and non SAP data. It can
support OLTP, OLAP, and SQL. It can interface with large number of other types of
applications.
DB2
This is designed by IBM,m and it has NoSQL abilities. It is capable to read JSON and
XML types of files. Primary objective of designing of this database system, to be used
on IBM’s iSeries server, as well as it can also support to Linux, UNIX, and Windows
platforms.
SolarWinds Database Performance Analyzer-

This is best database management software tool because it helps to perform of SQL
query performance in analysis, tuning, and monitoring. It can also support to cross
platform like as UNIX, Linux, and Windows.
Microsoft SQL Server-

This server was introduced in 1989, and its latest update was released in 2016.
Several languages are used for writing it like as Assembly, C, Linux, C++. It can
support of Linux and Windows operating systems. It allows various users to use
same database at once.
Informix-
This database management system is introduced by IBM, and it is written by C, C++,
and Assembly languages. It has latest updated version is 12.10.xC7.
Its hardware does not need more space and maintenance time, as well as containing
data every time.
Microsoft Access-
It depends only Microsoft Windows, and it has latest updated version is
16.0.4229.1024. This database management system is cost effective, so it is used for
E-Commerce websites.
Function and Working of Database Server-

Database server is a high performing computer system that helps to provide another
computer along with services related for accessing as well as retrieving data from
database side. “Front End” is run on the local machines which are operated by users
for getting access permission to database server, and “Back End” is run on database
server itself that is accessed by remote shell. After retrieving information from
database, it is outputted to user requesting data.
Centralized Database SYSTEMS:

The centralized database system consists of a single processor together with its
associated data storage devices and other peripherals. It is physically confined to a single
location. Data can be accessed from the multiple sites with the use of a computer network
while the database is maintained at the central site.
There are a number of ways to set up the centralized database. Multiple
programming languages are well suited to database building and companies can
also purchase databasing software rather than developing their own. Users may
have a number of ways to access material, and the database can be set up with
varying security levels to allow for more access controls. Information
technology staff maintain the database with various operations to keep it orderly
and address early signs of problems like viral infections. They can also change
access levels on request and administer the security system.
Advantages:
One advantage of the centralized database is the ability to
access all the information in one location. Searches of the database can be fast
because the search engine does not need to check multiple locations to return
results. Information may also be easier to organize in a single location. In a database
upgrade to handle more information, servers can be added to the database site easily,
and the company will not have to balance the needs of a distributed database.
A centralized database can also be easier to physically secure. It can be enclosed in a
variety of ways to protect it from theft, sabotage, fire, and other issues. It is also
possible to set up an extremely robust computer security system to prevent
unauthorized access. For extremely sensitive databases, the computers may not be
connected to a network, and users will have to physically enter the database location
to pull information. This may be used with some government computers that contain
high-security information.
Disadvantages:
• When the central site computer or database system goes down, then every one (users) is
blocked from using the system until the system comes back.
• Communication costs from the terminals to the central site can be expensive.

Assignment 07

Uploaded by

Copyright:

Available Formats

Assignment 07

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Assignment 07

Uploaded by

Copyright:

Available Formats

Name : Umar Ali

Roll Number : 522

Class # : BS (CS) – 6th

Submitted to : Sir Tariq

Subject : “CS-512 Distributed

Examples of Database Server-

SolarWinds Database Performance Analyzer-

Microsoft SQL Server-

Function and Working of Database Server-

Centralized Database SYSTEMS:

You might also like