Assignment task: Based on research and the knowledge you have attained thus far in this class, compose an informative executive-level report examining the potential adoption of a non-relational database system for the Northwind Traders organization. Northwind Traders currently leverages an online transactional processing (OLTP) relational database for maintaining sales transactions and company processes. As the company has expanded, senior level management has recognized the OLTP system is not best suited for the burgeoning data mining and analytical work needed to help keep the company competitive. Northwind leadership also wants to integrate data from external resources for business analyses. You have been tasked to evaluate non-relational database systems that may be suitable for evolving Northwind data analytic processes.
From your research, offer details covering three reasons to implement a non-relational database system at Northwind. Also, discern between effective and ineffective non-relational database options for the Northwind organization. Use examples to make your points. Be sure to examine and describe the common non-relational database approaches listed below, cover when they should be used, and for what type of data.
1. NoSQL databases
- Document Store
- Key-Value Data Store
- BigTable/Wide-Column Store
- Object Store
- Graph Store
- Multi-Model
2. Reporting and analytical databases
- Big Data
- Datamart
- Online Analytical Processing (OLAP)
After that, select two non-relational database system options and summarize two use cases, each, in place today where non-relational databases are used to effectively analyze data. Provide high-level requirements and specifications for the adoption and implementation of the non-relational database systems. Compare and contrast the non-relational options with the current Northwind OLTP database. To access an aid for comparison, download the Northwind OLTP database design diagram.