Databases Lecture Notes PDF
Document Details
Uploaded by HarmlessFallingAction
Leeds Beckett University
Tags
Summary
These lecture notes cover fundamental concepts in databases, including database systems, design, implementation, and access. Topics like the Entity Relationship Diagram (ERD) and NoSQL databases are also briefly covered. This document also shows diagrams demonstrating databases, the role of different elements in a database, and different visualisations and data analytics tools. There is also a note section about databases and their characteristics.
Full Transcript
Databases Databases Technology Role Design Implementation Access Characteristics Support Databases Technology Role Design Implementation Access Characteristics...
Databases Databases Technology Role Design Implementation Access Characteristics Support Databases Technology Role Design Implementation Access Characteristics Support Database systems Business, enterprises, web enabled For example oracle, apex – demo With SQL Your modules: Fundamentals of databases, Database Systems A Database A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques (Wikipedia, 2020). ERDs, SQL, web enabled front end Entity- Relationship Model, the relationship is by PK/FK Multi user, good security, performance, support, accessibility Online Transaction processing system No SQL For large data, model is different Document, key value wide column Demo (video) We will meet this dbs, but not much, they are a part of the data science solution E.g. Mongodb, Cassandra, Hadoop https://www.youtube.com/watch?v=UFVFIKduXpo (16min) https://www.youtube.com/watch?v=1Pn8K6IDjO4 (4min) Oracle – an Entity, Relationship Diagram Star schema database This is for a data warehouse, and used in decision support system. It uses facts (measures) and dimensions – similar to the OLAP in pivot tables Star schema database We will meet as part of data warehouse, as a solution for storing data to support a decision support system: Advanced Databases Excel Speadsheets, however the worksheets link to each other – actually by PK/FK Access – is an ER database, with little security, not mutli user Tools for Data Analytics and visualisation Tableau R Matlab Knime Rapid Miner * We will meet this in a number of modules, and more! Note As with Hoovers, databases are often know by their brand name – oracle, MySQL, SQL Server, DB2 It is the role in business that these dbs support that is important. The characteristics of that role will lead to the choice of database SQL – the universal language to access/manipulate data https://towardsdatascience.com/the-most- in-demand-skills-for-data-scientists- 4a4a8db896db Thank you Questions, comments, reflections?
