21-DBM - CSE265: System Admin. 2006-04-10 Database...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
CSE265: System Admin. 2006-04-10 Database Management Chad Hogg
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Why Use A Database? Efficient storage of lots of data Reliable access by many people simultaneously Representation of relationships between data Tight access controls for data Ability to enforce consistency of data
Background image of page 2
What Is DB Admin? Providing the service of a database Installation / Configuration Periodic Maintenance Performance Tuning Providing services in a database Creation Of Internal Functions Schema Design Consistency Checks Typically, job of separate Database Administrator (DBA)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Types Of Databases Flat Files /etc/passwd, /etc/crontab, /etc/fstab Spreadsheets Hierarchical / Network Databases Object-Relational Databases Oracle PostgreSQL MySQL Microsoft SQL Server Microsoft Access Microsoft Visual FoxPro
Background image of page 4
Types Of Databases (2) Flat Files are useful for storing local users but inefficient for lots of data. Spreadsheets can only represent some types of data relationships. Hierarchical and Network databases are outdated technology. For our purposes, we can ignore MS systems For Windows installation, SQL Server is a viable alternative.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Types Of Databases (3) Largest commercial marketshare on Linux Fully-featured Extensive Support Very Expensive
Background image of page 6
Types Of Databases (4) Very popular LAMP Few features Optimized For Speed Good Support Free (as in beer)
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Types Of Databases (5) Fairly popular Most features Good Support Free (as in speech) Standards Compliant
Background image of page 8
PostgreSQL Conf. (1)
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 22

21-DBM - CSE265: System Admin. 2006-04-10 Database...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online