Database Structures, Languages, and Architectures
Assignment Overview
Database systems are experiencing rapid change. Databases are handling structured data at the heart of operations in firms, vendor and customer order systems, financials, inventory management, and manufacturing. Data is being processed by enterprise software connected to back-end databases such as the Oracle product. Also with sensor data and social media data, firms need to be able to handle Big Data using tools such as Apache Hadoop. Streaming big data requires a new approach to data management while maintaining the existing structured database for enterprise systems.
Review the following two videos and then produce a comparison of the management issues associated with traditional data management and with Big Data Management. Discuss the future of data management for large firms and the implications for IT management.
Data warehouses, data lakes, and the cloud from LinkedIn Learning
Intro to databases and their types from LinkedIn Learning
Why Open Source (2023). Google Open Source
Case Assignment
When you have read through the articles and related material and thought about it carefully, please compose a paper on the following topic:
· Compare the management issues associated with traditional data management and with big data management. Include data warehousing and Hadoop in your discussion. Also discuss the applications for these systems and future trends.
Your paper should be between three and five pages, not including cover sheet and references.
Assignment Expectations
Length: Follow the number of pages required in the assignment excluding cover page and references. Each page should have about 300 words.
Your assignment will be evaluated according to the Rubric.
You are required to make effective and appropriate use of in-text citations to the assigned readings and other source material to support your arguments. Please use the Trident Introduction to APA guide for proper formatting and style.
Module 1 – Resources
Database Structures, Languages, and Architectures
Required Reading
Database Foundations: Intro to Databases from LinkedIn Learning
What is a database? from LinkedIn Learning
Case Assignment
Data warehouses, data lakes, and the cloud from LinkedIn Learning
Intro to databases and their types from LinkedIn Learning
SLP Assignment
Introduction to Dax https://docs.microsoft.com/en-us/power-bi/guided-learning/introductiontodax
Power BI Data Modeling with DAX from LinkedIn Learning
Discussion
Learning Cloud Computing: Core Concepts form LinkedIn Learning
Optional Reading
These additional lectures in the Carnegie Mellon Database Course are optional:
CMU Database Group. (2021, September 8). 03 – Database Storage I (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/YeNF3pJwLKw?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 14). 04 – Database Storage II (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/ZJJwJ-auby8?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 15). 05 – Buffer pools (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/Moz2AgC9hG4?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 21). 06 – Hash tables (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/f71kc4osCyM?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 23). 07 – Tree Indexes (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/6cxBfOc9MBs?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, September 29). 08 – Index concurrency control (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/jcqGSehrMGU?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, October 2). 09 – Sorting & aggregations (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/0nOBUnPF7mE?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, October 2). 10 – Join algorithms (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/yko1mAQUjTA?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, November 4). 18 – Multi-version concurrency control (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/QXWf1sgwvSs?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, November 16). 21 – Introduction to distributed databases (CMU intro to database systems / Fall 2021) . YouTube. https://youtu.be/h838F6i8f_4?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, November 4). 18 – Multi-version concurrency control (CMU intro to database systems / Fall 2021). YouTube. https://youtu.be/QXWf1sgwvSs?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
CMU Database Group. (2021, November 16). 21 – Introduction to distributed databases (CMU intro to database systems / Fall 2021). YouTube. https://youtu.be/h838F6i8f_4?list=PLSE8ODhjZXjZaHA6QcxDfJ0SIWBzQFKEG
The post Database Structures, Languages, and Architectures appeared first on Study Bloom.