Database Management 2 Flashcards
(34 cards)
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
