Data Management
What does the term 'quantitative data' refer to?
Data in numerical form.
What does the term 'qualitative data' refer to?
Data different than numerical form.
What does the term 'continuous data' refer to?
Any value from the specified range.
What does the term 'discrete data' refer to?
Any one of the specified discrete numerical values.
What is the difference between ordinal data and nominal data?
Unlike nominal data, categories are in certain orders in ordinal data.
How can data be collected explicitly?
Through questionnaires, votes, etc.
How can data be collected implicitly?
Tracking user behaviors, keeping click through rate of a web site are some of the ways of implicitly collecting data.
What does the definition 'the development, execution and supervision of plans, policies, programs and practices that control, protect, deliver and enhance the value of data and information assets' refer to?
Data management.
What does the term 'metadata' refer to?
Data about other data.
What does the term 'masterdata' refer to?
Data that describes core entities for an enterprise such as customers, assets, employees and so on.
What purpose does 'data management system' serve?
It allows creating, defining and manipulating of databases.
What are the main steps for designing a database?
Requirement collection and analysis, conceptual design, logical design, and physical design.
How does 'Entity-Relationship Model' represent data?
It represents data as entities, attributes and relationships.
In logical database design ER and enhanced ER concepts are mapped into relational schemas. What are the steps of mapping ER models into relational design?
Mapping of strong entity types, mapping of weak entity types, mapping 1:1 binary relationship types, mapping of 1:N or N:1 binary relationship types, mapping of N:M binary relationship type, and mapping n-ary relationship types.
What is referrred to as a process of extracting interesting and useful information from huge amount of data which can be from structured and unstructured sources?
Knowledge discovery.
What are the steps of knowledge discovery from data?
Data collection, data processing, data warehousing, tasking relevant data, data mining, pattern evaluation, and visualization.
What are the techniques used to preprocess data?
Data cleaning, data integration, data transformation, data reduction, and discretization and generating concept hierarchies.
What does the term 'data cleaning' refer to?
Data cleaning includes processes of filling missing values, correcting inconsistencies, identifying outliers and getting rid of them.
What is a a data warehouse?
A data warehouse is a data store for data from multiple data sources.
What is 'data mining'?
Data mining can be referred as extracting data patterns from huge amount of data.