Database Reference
In-Depth Information
The chapter continued with a brief discussion of the object-relational and object-oriented
databasemodels.Hereyoulearnedthatthesemodelsemergedostensiblyasameanstodeal
with advanced database applications, and that they each incorporate various object-orien-
ted elements and characteristics.
Finally, we closed the chapter with a brief discussion of data warehouses and accessing
dataviatheInternet.Youlearnedthatdatawarehousesareusedtoconsolidateandintegrate
data from heterogeneous sources and that the possibility of truly using them has only re-
centlybecomemoreviableandpractical.Next,youlearnedthatXMLisacommontoolfor
assembling data across relational and nonrelational data sources and that there is an ever-
growing movement to store and manage data “in the cloud.” You should now understand
that relational databases are likely to be used for quite some time, despite the great impact
the Internet has had on the way organizations use databases.
In the next chapter, we'll discuss why you should be concerned with database design and
why theory is important. We'll also cover the objectives and advantages of good design.
Review Questions
1 . Name the two main types of databases in use today.
2 . What type of data does an analytical database store?
3 . True or False: An operational database is used primarily in online transaction pro-
cessing (OLTP) scenarios.
4 . What two data models were commonly used in the days before the relational data-
base model?
5 . Describe a parent/child relationship.
6 . What is a set structure?
7 . Name one of the branches of mathematics on which the relational model is based.
8 . How does a relational database store data?
9 . Name the three types of relationships in a relational database.
10 . How do you retrieve data in a relational database?
11 . State two advantages of a relational database.
12 . What is a relational database management system?
13 . What is the premise behind the object-relational model?
14 . What is the purpose of a data warehouse?
Search WWH ::




Custom Search