Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Database I introduction

Autumn 2012
by

Sobhan Badiozamany

on 30 October 2012

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Database I introduction

DATABASE DESIGN I 1DL300 Autumn 2012 Databases are everywhere Many actors are involved in a database Course organization What makes databases so widespread? • Persistent storage
• Access control
• Multi-user
– Concurrency control
• Efficient
– 1000’s of queries and/or updates per second
• Reliable
– 99.99999% End Users
naive or parametric end users
Casual end users
sophisticated end users
Standalone users
Database designers
Database administrators
Operation and maintenance
Tuning and optimization
Database-system designers and implementers Examiner
Kjell Orsborn
email: kjell.orsborn@it.uu.se, phone: 471 1154, room: 1321, ITC building 1, floor 3
Lecturers
Sobhan Badiozamany
email: sobhan.badiozamany@it.uu.se, phone: 471 6345 , room 1354, ITC building 1, floor 3
Silvia Stefanova
email: silvia.stefanova@it.uu.se, phone: 471 2846, room 1319, ITC building 1, floor 3
Course assistants
Minpeng Zhu
email: minpeng.zhu@it.uu.se, phone: 471 3155, room 1310, ITC building 1, floor 3
Cheng Xu
email: cheng.xu@it.uu.se, phone: 471 1051, room 1316, ITC building 1, floor 3
Lars Melander
email: lars.melander@it.uu.se, phone: 471 7345, room 1306, ITC building 1, floor 3 Imagine an ATM (Automated Teller Machine) . . . DB1 DB2 Outline of a database system A database (DB) is a more or less well-organized collection of related data.
The information in a database . . .
represents information within some subarea of “the reality”, that is, objects, characteristics and relationships between objects
is logically connected through the intended meaning
has been organized for a specific group of users and applications A database management system (DBMS) is one (or several) program that provides functionality for users to develop, use, and maintain a database.

Thus, a DBMS is a general software system for defining, populating (constructing), manipulating and sharing databases for different types of applications.

Also supports protection (system and security) and maintenance to evolve the system. Database management system
A database system consists of . . .
the physical database (instance)
a database management system
one or several database languages
means for communicating with the database
one or several application program(s) A database system makes simple and efficient manipulation of large data sets possible. The term DB can refer to both the content and to the system (the answer to this ambiguity is governed by the context). Kjell Orsborn (examiner)
Sobhan Badiozamany (lecturer)
Silvia Stefanova (lecturer) All questions regarding registration is handled on Studentportalen, by the Student Office, or by your study counselor. None of us can handle any such administrative issues. Personell Three assignments
The assignment home page is here: https://www.it.uu.se/edu/course/homepage/dbastekn/ht12/dbt1-ht2012-assignments.html
Form groups of 3 individuals
Respect deadlines:
Soft deadlines: approx. one week after each lab.
The hard deadline is13th January, After which:
Submissions (and re-submissions) are not considered.
Students need to re-register to the next course instance.
The written exam
Don’t forget to sign up for it.
To pass the course, you need to pass the exam and all three assignments.
Have already done some of the assignments from previous years?
You can skip what you have done. Examination General rules:
A written report is expected for each assignment.
Attendance to labs are highly recommended.
Progress will be reflected in Studentportalen.
Always keep signed assignment papers as a proof that you have passed an assignment.
The assignments :
1-ER modeling & Normalization
-Conceptual DB Design exercise, no computer is really needed.
2-SQL in RDBMS
-There are two lab occasions, please Sign up!
3-JDBC API access to RDBMS
-There are two lab occasions, please Sign up!
Assignments 2 and 3 are set up using a “portable” version of MySQL.
The whole database system is on a USB stick.
Each group is given a flash disk, and yes, you can keep it
Installation takes 30-40 minutes, do it before labs. Assignments LECTURES:
Course intro - overview of db technology
DB terminology
ER-modeling
Relational model and relational algebra
ER-to-relational mapping and Normalization
SQL
Transactions, Concurrency control
Recovery techniques
Intro to storage and index structures Preliminary course contents Tip DB is like a huge iceberg What is a database? When you make a phone call When you are shopping When you Google 1960 1980 Historical Development of Database Technology Relational model based systems 1970 1990 1997 Early Database Applications Object-relational DBMS Object oriented DBMS Hierarchical
(IMS)
Trees Network model
(CODASYL)
Graph (e.g. ORACLE)
Tables (e.g. ObjectStore)
OO data structures (e.g. SQL:99)
Object model • Support massive data volumes
– Google processes about 24 petabytes of data per day. • Easier to implement and maintain
– Physical data independence
– High-level declarative query language Applications supported by databases are:
Literature:
Elmasri, R. & Navathe, S. B.: Fundamentals of Databases, 6th Edition, Addison-Wesley, 2010 (available e.g. at Akademibokhandeln).
Padron-McCarthy, T. & Risch, T.: Databasteknik, Studentlitteratur, 2005 (available e.g. at Akademibokhandeln).
Course home page:
https://www.it.uu.se/edu/course/homepage/dbastekn/ht12/
Full transcript