Rational Database
What is a rational database
A database that stores data in the form of connected tables.
What is an entity-relationship diagram?
A diagram that shows the different data elements and how they are related.
What is big data?
A buzzword that refers to vast amounts of data.
What is a record (rows)?
A set of fields that all pertain to the same thing.
What is a linking table?
Links two tables together to prevent unnecessary redundancy.
Is there a specific amount of data needed to be called big data?
No
What is a field (columns)?
Represent some characteristic of the thing.
If you wanted to access demographic and economic data to conduct market research, what database would you use?
The United States Census Bureau
What are some of then issues with big data?
-How should the data be stored?
-How do data from various sources integrate with one an other?
-How are data retrieved and disseminated?
What is a primary key?
A unique identifier such as a student ID.
What is data analytics?
The use of available data through statistical analysis to make business related decisions.
What is a NAS model?
A network attached to storage uses a series of file servers that can easily expand to grow capacity and high speed connections.
What is a foreign key?
Fields that reference a primary key in a related table.
What does E/T/L process stand for?
Extract, Transform, and Load.
What is a DAS model?
A centralized data storage system that allows for faster access, but limits scalability.