Database Management 2 Flashcards
What does data dictionary show
characteristic of field
What does a query show
tables
fields
selection criteria
What is the goal of business intelligence
improve decision making
What are the activities of business intelligence
access to data
consolidate
analyse
What are the tools to conduct BI?
data warehouse and data marts
multidimensional data analysis
data mining
utilising web interfaces to databases
What does a data warehouse store?
current historical
data
How is a data mart related to a data warehouse?
subset
Who uses data marts?
specific population of users
Data in data warehouse can be access but not
altered
Where does data warehouse consolidate and standardise its data from?
systems
operational and transactional databse
Why is data mart only used for specific users?
highly focused
isolated
What is multidimensional data analysis known as
OLAP
online analytical processing
What does data mining seek to find?
relationship
patterns
trends
How are the relationship patterns and trends in data mining displayed?
query
report
Why is OLAP multidimensional?
view data
different ways
multiple dimensions
What is the goal of data mining?
predict future behaviour
What is predicting using data mining techniques also known as?
predictive analysis
Who do firms make information available to using the web
customers
partners
Why are web interfaces used to present information
familiarity
savings from redesigning and rebuilding
What are non-relational databases known as
NoSQL
database in the cloud
What are teh advantages of NoSQL?
flexible data model
scaling
large data sets
why are there NoSQL now?
data volumes high
workload for web high
cloud
What kinds of companies is cloud database suited for
web-focused startup
SME
What is the characteristic of big data
unstructured/ semi
dfferent sources
What are examples of big data
tweets
What are examples of NoSQL?
Amazon DB
Oracle NoSQL
What does big data offer better compared to normal data?
more patterns
anomalies
insights
How does big data pose as a challenge compared to normal data?
new technologies and tools
make sense through questions
expensive
What are the capabilities of a DBMS
data definition
data dictionary
querying
reporting
What does querying and reporting do with the data?
manipulation
What is the data manipulation language known as
SQL
structured query language
What does data definition specify in the database?
structure of content
What does the data dictionary store?
definition
characteristics
of data element
How does a data dictionary store definitions
automated
manual
