Ísis Santos Costa’s Reviews > The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling > Status Update

p. 542
21 • Big Data Analytics (cont.)
↳ Recommended Best Practices for Big Data (cont.)

... ↳ Data Governance Best Practices for Big Data
... ... ↳ There is No Such Thing as Big Data Governance
... ... ↳ Dimensionalize the Data before Applying Governance
... ... ↳ Privacy is the Most Important Governance Perspective
... ... ↳ Don't Choose Big Data over Governance

p. 540
21 • Big Data Analytics (cont.)
↳ Recommended Best Practices for Big Data (cont.)

... ↳ Data Modeling Best Practices for Big Data (cont.)
(...)
... ... ↳ Declare Structure at Analysis Time
... ... ↳ Load Data as Simple Name-Value Pairs
... ... ↳ Rapidly Prototype Using Data Virtualization

p. 540
21 • Big Data Analytics (cont.)
↳ Recommended Best Practices for Big Data (cont.)

... ↳ Data Modeling Best Practices for Big Data
... ... ↳ Think Dimensionally
... ... ↳ Integrate Separate Data Sources with Conformed Dimensions
... ... ↳ Anchor Dimensions with Durable Surrogate Keys
... ... ↳ Expect to Integrate Structured and Unstructured Data
... ... ↳ Use Slowly Changing Dimensions

p. 537
21 • Big Data Analytics (cont.)
↳ Recommended Best Practices for Big Data (cont.)

... ↳ Architecture Best Practices for Big Data (cont.)

Data Highway
➤ Raw Source ➤ Real Time Cache ➤ Business Activity Cache ➤ Top Line Cache ➤ DW and Long Time Series (Daily, Periodic, Annual)

p. 537
21 • Big Data Analytics (cont.)
↳ Recommended Best Practices for Big Data (cont.)

... ↳ Architecture Best Practices for Big Data (cont.)
(...)
... ... ↳ Avoid Boundary Crashes
... ... ↳ Move Prototypes to a Private Cloud
... ... ↳ Strive for Performance Improvements
... ... ↳ Monitor Compute Resources
... ... ↳ Exploit In-Database Analytics

p. 537
21 • Big Data Analytics (cont.)
↳ Recommended Best Practices for Big Data (cont.)

... ↳ Architecture Best Practices for Big Data
... ... ↳ Plan a Data Highway
... ... ↳ Build a Fact Extractor from Big Data
... ... ↳ Build Comprehensive Ecosystems
... ... ↳ Plan for Data Quality
... ... ↳ Add Value to Data as Soon as Possible
... ... ↳ Implement Backflow to Earlier Caches
... ... ↳ Implement Streaming Data

p. 533
21 • Big Data Analytics (cont.)
↳ Recommended Best Practices for Big Data
... ↳ Management Best Practices for Big Data
... ... ↳ Structure Big Data Environments Around Analytics
... ... ↳ Delay Building Legacy Environments
... ... ↳ Build from Sandbox Results
... ... ↳ Try Simple Applications First

p. 530
21 • Big Data Analytics (cont.)
↳ Big Data Overview (cont.)
Use Cases (cont.)
➤ Loan risk analysis and insurance policy underwriting
➤ Customer churn analysis

... ↳ Extended RDBMS Architecture
... ↳ MapReduce/Hadoop Architecture
... ↳ Comparison of Big Data Architectures

p. 530
21 • Big Data Analytics (cont.)
↳ Big Data Overview (cont.)
Use Cases (cont.)
➤ Smart utility meters
➤ Building sensors
➤ Satellite image comparison
➤ CAT scan comparison
➤ Financial account fraud detection and intervention
➤ Computer system hacking detection and intervention
➤ Online game gesture tracking
➤ Big science data analysis
➤ Generic name-value pair analysis

p. 530
21 • Big Data Analytics
↳ Big Data Overview
Use Cases
➤ Search ranking
➤ Ad tracking
➤ Location and proximity tracking
➤ Causal factor discovery
➤ Social CRM
➤ Document similarity testing
➤ Genomics analysis
➤ Cohort group discovery
➤ In-flight aircraft status