Such an architecture provides the DBMS extra security as it is not exposed to the End User directly. Most DBMS vendors provide ODBC drivers for their DBMS. Generally such a setup is used for local application development, where programmers communicate directly with the database for quick response.ĭatabase Architecture is logically of two types:Ģ-tier DBMS architecture includes an Application layer between the user and the DBMS, which is responsible to communicate the user's request to the database management system and then send the response from the DBMS to the user.Īn application interface known as ODBC(Open Database Connectivity) provides an API that allow client side program to call the DBMS. A Database Management system can be centralised(all the data stored at one location), decentralised(multiple copies of database at different locations) or hierarchical, depending upon its architecture.ġ-tier DBMS architecture also exist, this is when the database is directly available to the user for using it to store data. ER Model: Generalization and SpecializationĪ Database Management system is not always directly available for users and applications to access and store data in it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |