Database Systems Big Data Database Systems Big Data

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data ● Content ● Access ● Logical structure ● Physical organization ● Archiving ● Security

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data ● Selecting ● Projecting ● Joining ● Linking

Database Systems & Big Data

Database Systems & Big Data Quality of information Quality of decision Accessible Accurate Complete Economical Flexible Relevant Reliable Secure Simple Timely Verifiable

Database Systems & Big Data Cleansing ≠ Validation Crosschecking Standardization St. , St, st Street

Database Systems & Big Data

Database Systems & Big Data SQL ACID (atomicity, consistency, isolation, durability) Schema

Database Systems & Big Data

Database Systems & Big Data SQL PL/SQL T-SQL

Database Systems & Big Data Enormous Complex DBMS are incapable of dealing Volume, velocity, and variety

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data Marts Data Lakes

Database Systems & Big Data ACID again & CAP No. SQL RDBMS

Database Systems & Big Data No. SQL BASE No. SQL DB Types Key value Stores — Riak, Voldemort, and Redis Wide Column Stores — Cassandra and HBase. Document databases — Mongo. DB Graph databases — Neo 4 J and Hyper. Graph. DB.

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data Hadoop Open-source framework Stores & processes large data sets Map. Reduce & HDFS Hadoop cluster may have 1000 s of servers

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data Hadoop Map. Reduce Java based program & tech. Map & reduce tasks Split, map, shuffle, and reduce phases

Database Systems & Big Data

Database Systems & Big Data

Database Systems & Big Data