cs174a-HW1-part1-solutions

cs174a-HW1-part1-solutions - CS174A Fundamentals of...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CS174A – Fundamentals of Database Systems (Winter 2007) Homework #1 Solutions 1. Key differences in maintaining data in DBMS vs. File systems are: DBMS File System Data Independence Database provides an abstract view of the data to applications/users. Details such as representation of data, storage system etc. is hidden from the application/user accessing the data Programs/users accessing the data have to know about the underlying representation and storage mechanisms. Special programs must be written to answer a particular question about the data. Efficient Data Access DBMS uses specialized techniques (hidden from the user) to store and retrieve data efficiently even if the data is stored on external devices. We can easily have databases that utilize more than 4GB memory on a 32- bit architecture system. All the data needs to be in memory to refer to it. 32-bit computer systems cannot access more than 4 GB data for a given program. Storage and retrieval details are not hidden from the
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

cs174a-HW1-part1-solutions - CS174A Fundamentals of...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online