120 likes | 237 Vues
Database Classifications. CIS 10, Group #1 May 27 , 2006 C . X . A . L . L . H . A.V. L . C. Introduction. Introduction. I. Single-User vs. Multi-user Systems II. Client- Server Systems III. N- Tier Database Systems IV. Centralized vs.
E N D
Database Classifications CIS 10, Group #1 May27, 2006 C.X. A.L. L.H. A.V. L.C.
Introduction Introduction I. Single-User vs. Multi-user Systems II. Client- Server Systems III. N- Tier Database Systems IV. Centralized vs. Distributed Database Systems V. In- Memory Database
I. Single-User vs. Multiuser Systems Single-user: • Located on a PC and accessed by one user. • Widely used for personal applications and very small businesses. Multiuser: • Accessed via a network because two or more users try to access and modify the same data at the same time. • Some type of database locking must be used to prevent users from making conflicting changes.
II. Client-Server Systems • Has both clients and at least one server. • The client is called the front end and database server is called the back end which contain database itself and it processes the commands coming from the front-end client PCs.
II. Client-Server Systems • Lower hardware cost and scalability • PCs are easier to use and much less expensive than larger computers. • Can add a new server or more power to give extra capacity • The most common type of database system
N- TIER MODEL(The middleware section can be one or more programs stored on one or more computers) 2- TIER MODEL III. N-Tier Database Systems
CENTRALIZED vs. DISTRIBUTED DATABASE SYSTEMS Centralized database system: CIS 10 NEWS ONLINE A database is located in its entirety on a single computer.
Distributed database system:The data is divided among several computers connected via a network. The data is logicallyviewed as belonging to a single database. The data can be accessed by any authorized user through the network. CIS 10 NEWS ONLINE
IN-MEMORY DATABASES(IMDBs) • Databases that are designed to hold all data in the main memory of the computer, rather than on disk. • Perform dramatically faster than disk-based databases. • Used both in high-end systems (e-commerce applications) and in small-footprint (set-top boxes). Notice: remember to back up data or to store the data periodically on a non-volatile medium. Giving You CIS 10 News Giving You Power in Your Life
Conclusion • Database systems • Classified in a variety of manners. CIS 10TV
The End... Cast: C.X. A.L. L.H. A.V. L.C.