CMSI 486: Welcome to Week 15

This Week's Class Agenda

weiveR maxE laniF :keeW llA

Topics we've covered:

• What *is* a database? Is it necessary? Where did they come from?
• Advantages and disadvantages
• Relational Algebra
• Select, project, rename, joins, union, cross product
• Database Keys
• Primary key, foreign key, candidate key, composite key
• ANSI SPARC model: three layer view, who uses what, advantages and disadvantages
• Entities, Attributes, and Relations
• Schemas, Data Definition Language [DDL], Data Manipulation Language [DML]
• Cardinality and Arity
• Entity-Relationship Diagrams [ERDs]
• Entities, Attributes, multi-valued attributes, derived attributes, primary key indication, relations, weak entities
• ACID: Atomicity, Consistency, Isolation, and Durability
• CRUD: Create, Retrieve, Update, Delete
• Normalization: normal forms, what are the steps, which are most used
• Transaction processing
• Locking
• Indexing
• NoSQL: where did it come from, what were the four reasons for avoiding the use of SQL?
• Common types of NoSQL databases: key-value store, document store, graphs
• Key-value stores: [InfinityDB, Oracle NoSQL, Redis], associative array; simplest of non-trivial
• Document stores: [MongoDB, CouchDB, PostGreSQL's HStore], data items as documents; encoding schemes such as JSON, BSON, XML, YAML; has unique key; has API for accessing data; organized by collections; no standardized schema; collections of objects
• Graph stores: [Neo4J, OrientDB], nodes and relationships, properties and labels; based on graph theory; has API for accessing data; focus on storing relationships rather than entities
• Mongo
• Scaling up/out
• Mongo storage hierarchy
• mongo good / mongo bad
• mongo syntax
• Neo4J
• Four parts
• Use cases
• Graphs good / graphs bad
• ASCII art and Cypher query language
• Big data: three reasons why it's difficult
• Four attributes of a data warehouse
• Five problems faced when constructing a data warehouse
• Operational vs. Informational systems
• Top-down vs. bottom-up approach
• ETL – Extract, Transform, Load
• Three-tiered architecture
• Why denormalizations
• Star schema – fact table, dimension tables, properties
• Tools for data mining: OLAP flavors
• Data Security, typical issues
• Policies, enforcement
• Scanning tools
• Types of security controls
• Client Server

Coming Up Next ...

THE FINAL EXAM: WEDNESDAY, DEC 11, 2019 AT 08:00

Thanks for a great class, and I hope you have learned some interesting and useful information!

Best of luck to all of you, now and in the future!!