Data + Databases

Traditional databases were only for ___ and ___ info

numerical, text

Modern databases can support ___ and ____ info

dense, real-time

big data

large amounts of data spread between many computers

NoSQL

Not only SQL, modern database that can handle structured + semi-structured big data

data

facts with implicit meaning

database

collections of data

mini-world/universe of discourse

reflection of the real world

A university’s gradebook, student list, professor list, section list, etc collectively make up the university’s ____

mini-world

database management system (DBMS)

creates and manages a database

What are the 4 main functions of a database management system

• Defining

• Construction

• Manipulating

• Sharing

A DBMS ensuring a student’s name is processed as a string is an example of DBMS ____

defining

database system

database + DMBS

What are the 5 main actors on the scene of DBMS?

• DB admin

• DB designer

• end user

• system analyst

• app developers

What are the 3 main workers behind the scene of DBMS

• DBMS system designer and implementor

• tool developer

• operator and maintenence team

mini-world relationships are ____

one-way

meta data

descriptions of the data itself for self-description

data abstraction

reading constructs of the data over the internal details

admin commands are an example of DBMS ____

data view

object persistence

programmer doesn’t need to manually maintain objects after runtime

how does DBMS provide faster search?

indexing (through trees or hashing)

DBMS ensuring a student can only have one major in a database is an example of ___

referential integrity

DBMS automatically assigning the honor student marker to students with a 3.5 or higher GPA is an example of ____

infering data

DBMS really shines in e-commerce systems because of ____

real-time decision making

An implemented DBMS fosters new applications to be ___ and ___

flexible, easily formed

hierarchal/network database model

rigid model that required sweeping overhauls for new data

E Codd relational model

model known for quicker queries

OOP DBMS model

model known for real time computation

A system used for archiving the temperature of Fullerton during November by the New York Times would/would not benefit from implementing DBMS

Would not benefit because collected data is simple and static

Canvas uses a DBMS such that both students and teachers can access the site, but have differing UIs for the two users types. This is an example of DBMS

multi-user handling

normalization

all instances of data is the same across all users

denormalization

controlling redundancy by condensing data into a single source