Session 5

Question 1

What are the main problems with the Traditional File Environment ?

Answer 1

• Files maintained separately by different departments
• Data redundancy
• Data inconsistency
• Program-data dependence
• Lack of flexibility
• Poor security
• Lack of data sharing and availability

Question 2

What is a relational DBMS ?

Answer 2

• Represent data as two-dimensional tables

- Each table contains data on entity and attributes

Question 3

What is the new type of database created by social media and GAFA ?

Answer 3

“No SQL”
Non-relational databases that scale out better than other database.

No strict schema

Question 4

What are the characteristics of Non-relational databases: “No S Q L” ?

Answer 4

– More flexible data model
– Data sets stored across distributed machines
– Easier to scale
– Handle large volumes of unstructured and structured data

Question 5

What are the characteristics of Databases in the cloud

Answer 5

– Appeal to start-ups, smaller businesses
– Amazon Relational Database Service, Microsoft S Q L Azure
– Private clouds

Question 6

What is Big Data ?

Answer 6

Massive sets of unstructured/semi-structured data
from web traffic, social media, sensors, and so on

Videos youtube (World economic forum & SAP)

Question 7

What is the name of the tool which use to analyze big data ?

Answer 7

We use Business Intelligence Infrastructure to analyze big data.

Question 8

What is the use of a data warehouse ?

Answer 8

A data warehouse = – Stores current and historical data from many core
operational transaction systems
– Consolidates and standardizes information for use across
enterprise, but data cannot be altered
– Provides analysis and reporting tools

Question 9

What is a data marts ?

Answer 9

• Subset of data warehouse

- Typically focus on single subject or line of business

Question 10

What is Hadoop ?

Answer 10

Hadoop is a kind of software which allows us to analyze the data by using a simple computer

Question 11

With new technology we can process all the data in the same time

Answer 11

BII 3

Question 12

What is IoT ?

Answer 12

IoT = Internet of Things

Question 13

uii

Answer 13

Operational Data can put directly into the Data Warehouse because they are clearly structured

Question 14

What is OLAP ?

Answer 14

Online Analytical Processing
Supports multidimensional data analysis
-Viewing data using multiple dimensions
- Each aspect of information ( product, pricing, cost, region, time period) is different dimension
- Example : How many washers sold in the East in June compared with other regions
OLAP enables rapid, online answers to ad hoc queries.

Question 15

What is Data Mining ?

Answer 15

Video youtube Data mining creative learning
Finds hidden patterns, relationships in datasets
- Example: customer buying patterns
Infers rules to predict future behavior
Types of information obtainable from data mining:
- Associations
- sequences
- classifications
- clustering
- forecasting

Question 16

For what is use Data Mining ?

Answer 16

• Fraud detection
• Card Marketing
• Cardholder & Profitability

Question 17

What must do a firm before creating a new database in place ?

Answer 17

Before new database is in place, a firm must:
– Identify and correct faulty data
– Establish better routines for editing data once database in
operation

Question 18

What is data quality audit ?

Answer 18

Data quality audit is a structured survey of the accuracy and level of completeness of the data in an information.

Question 19

What is Data cleansing ?

Answer 19

Data cleansing consists of activities for detecting and correcting data in a database that are incorrect, incomplete, improperly formatted or redundant.