Range of Database Approach.

Range of Database Approach.

In database approach the range of database application of from single user to multi user database . Generally we have seven database approaches. These are

Personal Database approach: Personal database approach is designed to support to store and to maintain the personal information. It can access by one user only. In general we can store personal database in personal computers like laptops, cellular phones etc. We have major problem with personal database approach that is it does not allow sharing of the data i.e. the personal database is  working based on the stand-alone mode.

Eg:

Work group database approach: In work group database approach , consists 20-25 members those team of people will develop a database of an organization . The work group database is designed to support to maintain database by a group of people.

            Work group database provides data sharing  . In general work group database in LAN  group network  where database is available in one system  this system is known as database Server .Database server is connected with 10 or more than 10 users .This type of architecture  is known as one type of client/server architecture . Work group databases are sold to database vendors those vendors again sold to different customers and users.

Eg.

Departmental database approach: Departmental database approach is designed to support to maintain departmental wise activities in an organization. It consist department information , procedures and functions.

            In departmental database consist 50-100 persons to perform a task. In an organization contain its department  database server in an organization . The department database are connected to maintain from the main server to connect the database departmental database server , distributed the information to department and users . This technology is called as two tier database architecture.

Eg:

Enterprise database approach: Enterprise database  approach is designed to support to maintain organization database . It not only control the organizational database but also making decisions to support the database . It perform all the activities of an organization. The education of enterprise database approach two major departments these are

1. Enterprise Resource Planning System (ERPS)
2. Data warehousing .

ERPS is developed from MRP(Material Requirement  Planning ) system .These system contains some functions such as how to distribute the data to entire organization and how to control the flow of data in an  enterprise / organization .In  an enterprise database we have entire organization database or information and historical information about the organization and collaboration organization information such enterprise database organization is known as data ware housing.

Eg:

Internet: Using Internet  protocols to establish  connection  and  access company data or information by any person or user  who may have or may not have relation with that organization is known as Internet.

Eg: To access data by external person or user who are related to other company is known as internet. i.e. Any student can access the data of certain University or Organization  is called Internet process.

Intranet: Using Internet  protocols to establish  connection  and  access company data or information by limited  persons or users  who are related  with that organization is known as Intranet.

Eg: To access data by staff and students etc  who are related to the same  company is known as intranet. i.e. Any student and staff  can access the data of certain University or Organization  is called Intranet process.

Extranet:Using Internet  protocols to establish  connection  and  access company data or information by company directors, customers, dealers and legal advisers etc who have a  relation with that organization is known as Extranet.

Eg: In Hyderabad .We have  our University, Our college is in Nizamabad and Our college is affiliated  or related to that University . Every University have their own database for maintaining the university

Our college is connected with  university database through internet in order to retrieve college rules and regulations this concept is known as Extranet.