DBMS architecture (2- tier & 3-tier architecture)

DBMS Architecture

The design of a Database Management System highly depends on its architecture. It can be centralized or decentralized or hierarchical. DBMS architecture can be seen as single tier or multi tier. n-tier architecture divides the whole system into related but independent n modules, which can be independently modified, altered, changed or replaced.

3-Level architecture in DBMS (Traditional model)

3 Level architecture: 

It was two organisation ANSINC & SPARCE in 1972 proposed three level architecture: 

• External or View level 
• Conceptual or Logical Level 
• Internal or Physical Level  

DBMS overview, RDBMS v/s DBMS, File system & DBMS

What is Database?

A Database is a collection of coherent meaningful data today, typically in a digital form, so that its content can easily be accessed managed & updated. 

The example of postal address would generally contain:

• Building name
• Street name 
• Flat No. 
• City 
• State 
• Pin code 
• Country etc. Thus the address book is a database and the postal address in the book, is the data that fills the database.

What is DBMS?

Transaction Management in advance DBMS with properties of transaction & transition state diagram.

TRANSACTION MANAGEMENT

Transaction

A transaction is a unit of a program execution that accesses and possibly modifies various data objects (tupples, relations).

A transaction is a Logical unit of database processing that includes one or more access operations (read -retrieval,      write - insert or update, delete).

Informatica Power center & Power mart?

Power Center: It is used by large organizations to handle larger volumes of data. We can configure multiple servers. If one server goes down then it automatically switches on to another server.

Informatica Power center installation in all windows XP,7,8

 How to install Informatica? How to create Repository & Integration Services?

 Before we start the SETUP being run we have some very important settings to be done, 

First we have to create a couple of environment variables on our computer, 

this can be done by right clicking on to My Computer and select ‘Properties’.

Informatica Architecture

Informatica Architecture

Informatica Architecture is divided into two components: 1. Server Components -->Server Components in Informatica are: a. Repository Server b. Informatica Server