Send the link below via email or IMCopy
Present to your audienceStart 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
Database I introduction
Transcript of Database I introduction
• Access control
– Concurrency control
– 1000’s of queries and/or updates per second
– 99.99999% End Users
naive or parametric end users
Casual end users
sophisticated end users
Operation and maintenance
Tuning and optimization
Database-system designers and implementers Examiner
email: email@example.com, phone: 471 1154, room: 1321, ITC building 1, floor 3
email: firstname.lastname@example.org, phone: 471 6345 , room 1354, ITC building 1, floor 3
email: email@example.com, phone: 471 2846, room 1319, ITC building 1, floor 3
email: firstname.lastname@example.org, phone: 471 3155, room 1310, ITC building 1, floor 3
email: email@example.com, phone: 471 1051, room 1316, ITC building 1, floor 3
email: firstname.lastname@example.org, 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
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
Relational model and relational algebra
ER-to-relational mapping and Normalization
Transactions, Concurrency control
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
Trees Network model
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:
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: