Architecture of database|draw the architecture of database|What is the architecture of database?expl
More Videos links :-
• What is Database Users & Database users ty...
• What is Data Independency in DBMS ? Data i...
• What is Schema & Instance in database ? डे...
• Which are the drawbacks difficult of File ...
• Database Data Model |What is Data Model in...
• DBMS|Database Language|What is Database La...
• Data Dictionary | DATA DICTIONARY | जानिए ...
• Database Data Abstraction Definition & Thr...
• Database Management system 2nd videowith d...
• Purpose of DBMS | About DBMS another detai...
• DBMS is System Software for creating & man...
---------------------------------
What Is Database
Architecture?
''''''''''''''''''''''''''''''''''''''
Database architecture uses programming
languages to design a particular type of
software for businesses or organizations. A
postsecondary education is typically required
for employment in this discipline. Read on to
learn more about database architecture,
including career options in the field. Schools
offering Database Administration degrees can
also be found in these popular choices .
Definition
'''''''''''''''''''''
Database architecture focuses on the design,
development, implementation and maintenance
of computer programs that store and organize
information for businesses, agencies and
institutions. A database architect develops and
implements software to meet the needs of
users. Several types of databases, including
relational or multimedia, may be created.
Additionally, database architects may use one
of several languages to create databases,
such as structured query language (SQL). You
might be familiar with Oracle and Microsoft
Access, which are two common database
programs.
Important Facts About Database
Architecture
Similar
Occupations
Computer network architect,
computer systems analyst,
web developer, information
security analyst, computer
programmer
Key Skills Communication, detail
oriented, interpersonal,
problem-solving, and
analytical skills
Work
Environment
Typically full-time, long hours
On-the-Job
Training
Available at software
companies, typically for
college-aged students
____----------------____
Database architecture can be 2-tier or 3
tier architecture based on how users are
connected to the database to get their
request done. They can either directly
connect to the database or their request
is received by intermediary layer, which
synthesizes the request and then it sends
to database.
2-tier Architecture
In 2-tier architecture, application program
directly interacts with the database. There
will not be any user interface or the user
involved with database interaction.
Imagine a front end application of School,
where we need to display the reports of
all the students who are opted for
different subjects. In this case, the
application will directly interact with the
database and retreive all required data.
Here no inputs from the user are required.
This involves 2-tier architecture of the
database.
Let us consider another example of two
tier architecture. Consider a railway ticket
reservation system. How does this work?
Imagine a person is reserving the ticket
from Delhi to Goa on particular day. At
the same time another person in some
other place of Delhi is also reserving the
ticket to Goa on the same day for the
same train. Now there is a requirement
for two tickets, but for different persons.
What will reservation system do? It takes
the request from both of them, and
queues the requests entered by each of
them. Here the request entered to
application layer and request is sent to
database layer. Once the request is
processed in database, the result is sent
back to application layer for the user.
Advantages of 2-tier
Architecture
Easy to understand as it directly
communicates with the database.
Requested data can be retrieved very
quickly, when there is less number of
users.
Easy to modify – any changes required,
directly requests can be sent to
database
Easy to maintain – When there are
multiple requests, it will be handled in a
queue and there will not be any chaos.
Disadvantages of 2-tier
architecture:
It would be time consuming, when
there is huge number of users. All the
requests will be queued and handed
one after another. Hence it will not
respond to multiple users at the same
time.
This architecture would little cost
effective.
3-tier Architecture
3-tier architecture is the most widely
used database architecture. It can be
viewed as below.
Presentation layer / User layer is the
layer where user uses the database. He
does not have any knowledge about
underlying database. He simply
interacts with the database as though
he has all data in front of him. You can
imagine this layer as a registration
form where you will be inputting your
details. Did you ever guessed, after
pressing ‘submit’ button where the
data goes? No right? You just know
that your details are saved. This is the
presentation layer where all the details
from the user are taken, sent to the
next layer for processing.
Application layer is the underlying
program which is responsible for saving
the details that you have entered, and
retrieving your details to show up in the
page. This layer has all the business
logics like validation, calculations and
manipulation