Reporting and analytical databases

 

 

 

watch the Unit 10 videos covering facets associated with non-relational database systems.

Navigate to the Academic Tools area of this course and select Library then Required Readings to access your texts and videos.

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.

NoSQL databases
Document Store
Key-Value Data Store
BigTable/Wide-Column Store
Object Store
Graph Store
Multi-Model
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.

Sample Solution

Advanced analytics and rapid query response times are features of analytical databases that have been optimized. Additionally, they are generally columnar databases that can efficiently write and read data to and from hard disk storage to reduce the time it takes to process a query. They are also more scalable than traditional databases. Column-based storage, in-memory loading of compressed data, and the capacity to search data across various properties are all hallmarks of analytical databases. For severe analytical workloads, analytical database software performs up to 1,000 times quicker than an operational database. It is designed to quickly evaluate huge amounts of data.

ld not work if people were driven by the desire to acquire more power and wealth as they would not be content staying in one place without the ability to move up. Plato writes about an ideal society while also recognizing that what he believes is the natural instinct of man will never allow that society to happen.

Thomas Aquinas is also an idealist. Aquinas states that “Granted that the world is ruled by Divine Providence…the whole community of the universe is governed by Divine Reason.” (ST, I-II, 91.1). He explains the concept of eternal law wherein power is given divinely. He goes on to say “the very idea of the government of things in God the Ruler of the universe, has the nature of a law. And since Divine Reason’s conception of things is not subject to time but is eternal, according to Prov. viii, 23…this kind of law must be called eternal.” (Ibid.). It is through eternal law that God can govern his subjects. As humans have free will, they stray the perfect governance of God and follow natural law. Natural law is just the way in which humans interpret and follow eternal law. This theology is idealist as it is unrealistic that humans will follow the natural law perfectly and strive to do good and avoid evil. He also states that political society is created to meet the needs of human nature rather than by human’s own ingenuity.

Machiavelli is more of a realist as he sees the world through a pessimistic view. He sees people as self-interested and calculating rather than what people ought to be. He speaks frankly about the downfalls of mankind and their He writes about how one should go about getting and maintaining power in the realm of greedy self-interested individuals. Like Plato, he argues that “a wise man ought always to follow the paths beaten by great men” (41) or in other words, only some are suited to lead. Similarly, to Plato, Machiavelli believed in lying for the sake of the greater cause. While Plato wrote about the noble lie, Machiavelli states that a good prince has the five qualities: mercy, faithfulness, humanity, religiosity, and uprightness. He goes on to say that the prince did not necessarily need to meet these criteria he just needed to “appear to have them.” He is essentially saying that lying is ok if it is for the greater good.

Machiavelli speaks very bluntly about the nature of man and what is needed to be successful and while this may seem pessimistic, it is much more realistic than the philosophers that came before him. His pessimistic but also realistic pint of view is evident when he says “Here a question arises: whether it is better to be loved than feared, or the reverse. The answer is, of course, that it would be best to be both loved and feared. But since the two rarely come together, anyone compelled to choose will find greater secu

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.