1 / 12

Database Classifications

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.

nolcha
Download Presentation

Database Classifications

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Classifications CIS 10, Group #1 May27, 2006 C.X. A.L. L.H. A.V. L.C.

  2. 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

  3. 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.

  4. 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.

  5. 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

  6. 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

  7. Special News online…

  8. CENTRALIZED vs. DISTRIBUTED DATABASE SYSTEMS Centralized database system: CIS 10 NEWS ONLINE A database is located in its entirety on a single computer.

  9. 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

  10. 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

  11. Conclusion • Database systems • Classified in a variety of manners. CIS 10TV

  12. The End... Cast: C.X. A.L. L.H. A.V. L.C.

More Related