+1(316)4441378

+44-141-628-6690

CIS 515 Discussion Response To Student

CIS 515 Discussion post responses.

Respond to the colleagues posts regarding:

Having an adequate data model to serve specific business needs of an organization is important. Evaluate the need for denormalization within an organization. Provide at least three examples that prove denormalization is useful to data consumers.

Using a data-modeling checklist can help database developers design efficient data repositories. Suggest at least two possible scenarios that could take place if one of the steps in the data-modeling checklist (table 6.7 in Chapter 6 of the textbook) is missed.

JMs post states the following:

Denormalization is a technique used on a previously-managed database to enhance performance. The concept behind the process is to arrange redundant data where technicians think it will be of assistance the most (Bendel, et al., 2015). The process utilizes additional characteristics in an already-designed table, add extra tables, or even develop conditions of prevailing tables. The goal overall is to reduce the running time of select queries by allowing accessibility of information (Bendel, et al., 2015). Demoralization is useful for data consumers in different ways. Firstly, it maintains history; as data can transform and fluctuate with time, the storage of values that were valid before is important enough. Secondly, the query performance improves; at times, multiple tables and variables may be required to support information needed (Bendel, et al., 2015). Thirdly, it speeds up reporting.

If one of the steps in the data-modeling checklist is missed, the first possible scenario will be a confused state of mind; the professional carrying out the data analysis will become unsure and uncertain about the results, especially if the data tables are incorrect. The second scenario may involve inaccurate derivation of data queries and patterns (Bendel, et al., 2015). If any of the steps from the checklist is missed, the analyst is not going to be able to streamline the information in a suitable manner. Since the process is initiated with the efficient use of analytical resources, any mismanagement of the steps can imbalance the end goal. As the tables are formed in a sequential manner, their data entry and calculation procedures will ultimately be affected resulting in ineffective and wrongful results. Suitable planning can also improvise performance mechanisms for the data modeling.

References

Bendel, P., Czech, M., Koeth, O. C., & Stolze, K. (2015). U.S. Patent No. 9,020,910. Washington, DC: U.S. Patent and Trademark Office.

RRs post states the following:

I would choose the Routing Information Protocol (RIP) for a Small Office/Home Office (SOHO). RIP is a protocol that routers can use to exchange network topology information. It is characterized as an interior gateway protocol, and is typically used in small to medium-sized networks (What is a, n.d.). RIP is also easy to configure and use, and is well known and widely used.

If I had to work in a company, I would choose the Open Shortest Path First protocol (OSPF) as my preferred protocol. Mainly because the Internet Engineering Task Force (IETF) designed OSPF to be a scalable, efficient, and quickly converging routing protocol. Overall, the protocol helps ease the pain of network administration and troubleshooting (Heaton, 2000).

A transmission medium is a physical path between the transmitter and the receiver. In other words, it is the channel through which data is sent from one place to another. I would use the Shielded Twisted Pair (STP) if I were a large company that had multiple campuses.  STP is used in fast-data-rate Ethernet and in voice and data channels of telephone lines. Advantages include better performance at a higher data rate, eliminates crosstalk, and is comparatively faster than other mediums (Type of Transmission, n.d.).

References:

What is a Routing Information Protocol (RIP) and how does it work with my managed switch? (n.d.). Retrieved from https://kb.netgear.com/21661/What-is-a-Routing-Information-Protocol-RIP-and-how-does-it-work-with-my-managed-switch

Heaton, W. (2000). Get IT Done: OSPF boasts enterprise benefits. Retrieved from https://www.techrepublic.com/article/get-it-done-ospf-boasts-enterprise-benefits/

Type of Transmission Media. (n.d.). Retrieved from https://www.geeksforgeeks.org/types-transmission-media/

 

You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.

 

Latest completed orders:

# topic title discipline academic level pages delivered
6
Writer's choice
Business
University
2
1 hour 32 min
7
Wise Approach to
Philosophy
College
2
2 hours 19 min
8
1980's and 1990
History
College
3
2 hours 20 min
9
pick the best topic
Finance
School
2
2 hours 27 min
10
finance for leisure
Finance
University
12
2 hours 36 min
[order_calculator]