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.
JM’s 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.
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.
RR’s 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 help’s 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.).
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/