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

db1-vt13-intro

Database Design I - 1DL300; Introduction
by

Sobhan Badiozamany

on 21 January 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of db1-vt13-intro

DATABASE DESIGN I 1DL300 Spring 2013 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
Thanh Truong
thanh.truong@it.uu.se, phone: 471 6345, room 1354, ITC building 1, floor 3
Andrej Andrejev
andrej.andrejev@it.uu.se, phone: 471 7345, room 1306, ITC building 1, floor 3
Lars Melander
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). Sobhan Badiozamany
Silvia Stefanova 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. Personnel Three assignments [plus possibly a shorter terminology based one]
The assignment home page is here: https://www.it.uu.se/edu/course/homepage/dbastekn/ht12/dbt1-ht2012-assignments.html
Form groups of 2 individuals in Studentportalen.
Have already done some of the assignments from previous years?
You can skip what you have done.
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.
The written exam will have a combination of tasks to solve and technical terminology to explain. Examination 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.
all labs need sign-up, sign up sheets will be posted before labs.
Read instructions before going to labs. Assignments practicality [1] 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: Database Systems, 6th Edition, Pearson, 2010:
Elmasri, R. & Navathe, S. B.
Databasteknik, Studentlitteratur, 2005:
Padron-McCarthy, T. & Risch, T.

Both books are available at Akademibokhandeln. L14 Feedback on study questions, general questions L1 Intro to database terminology
L2 ER modeling
L3 ER example
L4 Relational model
L5 normalization
L6 Normalization example Assignment 1 computer lab L7 Relational algebra
L8 SQL query language
L9 SQL [continued] Assignment 2 computer lab #1 L10 Database programming
L11 Transactions and concurrency control Assignment 2 computer lab #2 L12 Recovery Assignment 3 computer lab Lx Guest lecture
L13 Introduction to physical DB design Prepare/bring USB sticks. ER modeling & Normalization
Conceptual DB Design exercise, no computer is really needed. JDBC API access to RDBMS
More SQL queries Cloud-based presentation tool with a ...
Presentations are always accessible through Prezi web site, but,
You can also download them and play them offline (outside the browser).
iPhone/iPad free Prezi viewer.
Good for explaining ideas in a lecture, but not necessarily good in studying for the exam.
Downside: The PDF files generated from Prezi are images, no text search possible.
Generally, you will need to read the book if you need more detailed information. The whole database system is on a USB stick.
Each group is given a flash disk, and yes, you can keep it.
Required for:
Assignments 2 and 3.
Interactive lectures in SQL.
Installation takes 30-40 minutes, do it before labs/lectures. Prezi! zooming user interface. portable MySQL. Literature and resources Course home page:
https://www.it.uu.se/edu/course/homepage/dbastekn/vt13/ Extending a previously designed database
Implementation in SQL Respect the deadlines:
Soft deadlines: approx. one week after each lab.
The hard deadline is 27th March, After which:
Submissions (and re-submissions) are not considered.
To get unfinished assignments corrected, Students need to re-register to the next course instance.
Each group will be assigned a course assistant before the first lab.
Respect your assistant's office hours. [They are your virtual deadlines] Bring USB sticks. Assignments practicality [2]
Full transcript