INFO20003 Database Systems
Dr Renata Borovica-Gajic
Lecture 01
What are Database Systems?
Copyright By PowCoder代写 加微信 powcoder
INFO20003 Database Systems
Data vs Information
– known facts stored and recorded
– can include: text, numbers, dates, plus images, sound, video, and other complex objects
• Information
– Datapresentedincontext(canbesummariseddata)
– Datathathasbeenprocessedincreasingtheusersknowledge
• Data vs Information
– Data is known and available; Information is processed and more useful
Baker, . Doyle, Joan E. Finkle, . Lewis, . McFerran, Debra R. Sisneros, Michael
324917628 476193248 548429344 551742186 409723145 392416582
INFO20003 Database Systems © University of Melbourne 2
Information: data in context
Database Systems Assignment 4 Marks Semester 3 2014
Student Name
Student ID
Doyle, Joan E.
Finkle, .
McFerran, Debra R.
Sisneros, Michael
INFO20003 Database Systems © University of Melbourne 3
Information: Summarisation!
INFO20003 Database Systems © University of Melbourne 4
Metadata – Data about data
• Can include:
– structure, rules, constraints
• Why do we need Metadata?
– Consistency – Meaning
• We generate a data dictionary as part of the analysis of system requirements
Description
Tutorial number
Student name
INFO20003 Database Systems © University of Melbourne 5
What is a “database” ?
a large, integrated, structured collection of data
• Usually intended to model some real-world enterprise
• Example: a university
– Entities … such as courses, students, professors – Relationships … such as enrollment, teaching
INFO20003 Database Systems
© University of Melbourne 6
What Is a Database System?
A Database Management System (DBMS) is a software system designed to store, manage, and facilitate access to databases.
INFO20003 Database Systems
© University of Melbourne 7
File Processing Systems
• What are the problems you can see with this?
• (Diagram adapted from Hoffer p. 42)
INFO20003 Database Systems © University of Melbourne 8
What’s Wrong Here?
• Program-data dependence
– If the file structure changes, so does the program
– What if you change data structure for one program
• Duplication of data
– wasteful, inefficient, loss of data integrity
• Limited data sharing
– data tied to application, hard/slow to create adhoc reports
• Lengthy development times
– application has to do low level data management, figure out file format each time
• Excessive program maintenance
– up to 80% of development time in traditional file based organisations is for maintenance
INFO20003 Database Systems © University of Melbourne 9
Database Systems as Solution
Manage data in a structured way
Many models (hierarchical, network, etc), but relational
dominant since ~1980
• Relational Model
–Rows & Columns forming Relations –Keys & Foreign Keys to link Relations
53666 Carnatic101 5
53666 Reggae203 5.5
53650 Topology112 6 53666 History105 5
53666 Jones
53688 Smith
53650 Smith 19 4.8
18 5.4 18 4.2
INFO20003 Database Systems © University of Melbourne 10
Database Advantages
• Data independence
– separation of data and program, application logic – central data repository, central management
• Minimal data redundancy
– redundancy can be controlled (normalization)
• Improved data consistency
– single store: no disagreements, update problems, less storage space
• Improved data sharing
– data is shared, a corporate resource, not a necessity for an application – external users can be allowed access
– multiple views of data, arbitrary views of data
• Reduced program maintenance
– data structure can change without application data changing
• Novel ad hoc data access ‘without programming’ – SQL
INFO20003 Database Systems © University of Melbourne 11
What’s Examinable?
• Difference between Data and Information
• Being able to discuss the advantages of Databases vs File
Processing Systems
INFO20003 Database Systems © University of Melbourne 12
Next Lecture
• The database system lifecycle
– With a focus on the design stage
• Conceptual design
• Logical design
• Physical design
INFO20003 Database Systems © University of Melbourne 13
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com