Outline Class Survey IT360: Applied Database Systems Why Databases - PDF document

Outline � Class Survey IT360: Applied Database Systems � Why Databases (DB)? � This Class? � Admin Dr. Cr � iniceanu � Entity-Relationship Model www.cs.usna.edu/~adina/teaching/it360/ spring2009 Database Systems ICE: The Mid Store � How does Wal-Mart manage its 200 TB � Create a system to keep track of inventory data warehouse? � What is the database technology behind eBay’s website? � How do you build an Oracle 9i, MySQL or Microsoft SQL Server database? 1

Problems What is a Database? � Changes to data - Data model � A very large, integrated collection of data � “on the fly” queries � Models real-world enterprise. � Entities (e.g., students, courses) � Data inconsistencies � Relationships � Security of information (views) � A Database Management System (DBMS) � Performance is a software package designed to store � Partial processing and manage databases. � Concurrency Why Use a DBMS? Why Study Databases? � Data independence and efficient access � Used everywhere � Universities (MIDS), military, enterprises � Reduced application development time � Datasets increasing in diversity and volume. � Data integrity and security � Digital libraries, interactive video, Facebook, � Performance and scalability YouTube, Google � ... need for DBMS exploding � Concurrent data access � DBMS encompasses most of CS � Recovery from system crashes � OS, languages, theory, data mining, multimedia, logic 2

Best Jobs! IT Analyst Course Topics Course Goals � Database design � Explain the main advantages of modern database management systems over file systems. � Relational model � Design, create, and query relational databases to satisfy � SQL user requirements. � Normalization � Design, build and deploy database-backed applications with dynamic website front-end. � Database administration � Implement data access control mechanisms for database � PHP and application security. � MySQL � Analyze the ethical issues and responsibilities related to � Transaction Processing records management Create applications that USE a Database Management System � Data Storage and Indexing 3

Things We Will NOT Cover Success in IT360 � Lecture – stay engaged � Relational algebra and calculus � Take notes – provided slides are not enough! � Implementation of index structures � Exams closed-book – but open-note! � Ask & answer questions � Query evaluation and optimization � Make the most of in-class lab time � Read lab in advance How to BUILD a Database Management System � Think before you start typing � Don’t stay stuck! � Don’t fall behind � Finish lab early and leave time for reading � See me for help and/or talk to friends � Course material builds on itself and gets more complex Academic Integrity - Honor Resources � Collaboration on labs/ hws is allowed, but � Lecture slides / your notes submitted work should be your own � Cite any assistance, from any sources � PHP and MySQL Web Development by L. � Collaboration on projects, quizzes and Welling and L. Thomson exams is prohibited � http://www.cs.usna.edu/academics/honor. � Database Processing by David Kroenke htm � Database Management Systems by R. Ramakrishnan and J. Gehrke 4