Database Management System
Addressing Metrics for Benchmarking cloud computing
Review the requirements information you developed for your Good Foods grocery store cloud-based project. Good Foods wants to know the differences in performance metrics between the internal benchmarks of its current system and the external benchmarks of the cloud-based services you have reviewed.
Consider that the company currently connects all systems, stores, and employees over LANs (at each corporate site and store), VPNs (for remote access as needed), and a WAN (for access to organization-wide applications and services). It runs Windows Server 2008 R2 Enterprise on 10 operational servers and Microsoft 8 on 3,000 workstations (including desktops and laptops) for employees.
Each of the Windows Server 2008 Enterprise systems has two AMD processors, 32 GB of RAM, and optical hard drives. Each of the Microsoft 8 systems has a single Intel processor, 4 GB of RAM, and optical hard drives.
To complete this assignment, identify in a spreadsheet the differences between the Good Foods servers and workstations and the cloud-based services provided by at least two of the vendors you have reviewed for the organization. Include statistics for the following metrics:
Hardware
- CPU computing power
- Memory bandwidth
Storage
- Input/Output operations per second (IOPS)
Networking
- Bandwidth
Then, in a minimum of 4 pages, include the following information:
- Summarize the performance results from your internal benchmark findings.
- Identify which vendor(s) may be a fit for the Good Foods company, based on the company’s current needs. Address processing speed, load testing practices, service consistency, and data availability and reliability in your review. Justify your recommendation.
- Review and describe at least 2 reputable benchmarking tools you would recommend to Good Foods to use when evaluating the performance of its cloud-based services. Justify your recommendation by the value the tool would provide the company looking to assess its cloud-based solutions in the future.
Use APA formatting style (title page, references page, and in-text citations). For more information about APA formatting.
Networking
Regional Gardens Ltd is a company that runs number related gardening enterprises. It has a large display garden that it opens for public inspection a number of times in a year. The company also owns Regional Garden’s Nursery which sells plants and garden supplies to the public. The company also owns Regional Garden Planners which is a small company that provide garden advice; design and consultancy services.Regional Gardens Ltd has a small data centre at its main site at Bathurst where the company’s servers and data storage is located. The company has the following server infrastructure:
- 2x Active Directory domain controllers on Windows Server 2008 R2, (2 x Xeon 3.6GHz, 8GB RAM, 140GB HDD);
- 3 x SQL Server 2003 database servers on Windows Server 2003 (2 x Xeon 2.8 GHz, 4 GB RAM, 250 GB RAID-5 array);
- 1 x Exchange 2007 Email Server on Windows Server 2008 R2 (2 x Xeon 3.6GHz, 8GB RAM, 250GB RAID-1 array);
- 4 x Windows Server 2003 File and Print Servers (2x Xeon 2.8GHz, 4GB RAM, 250GB RAID-1 array);
- 2 x Red Hat Enterprise 5 Linux Server running Apache and TomCat (2x Xeon 2.8GHz, 16GB RAM, 140GB HDD).
The company has some 150 staff, which includes management, administrative staff, nursery and Regional Garden Planner’s staff. The company has a range of different types of relatively old personal computers, which run Windows XP, to connect to the company data centres. These computers will need to be updated in the near future.The directors of the Regional Gardens Ltd are concerned about the increasing costs of power and cooling to operate their data centre and they are investigating whether they should employ a Virtualisation technology in their data centre. They are also considering whether they should use Virtualisation to provide an updated desktop environment to their staff.You are to consider how to implement a virtual infrastructure for the company and prepare a report for the directors of Regional Garden’s Ltd. Your report should include:
- A one page executive summary that describes the main points of your report. (10 Marks)
- A description of proposed virtual infrastructure for the data centre including which virtual technology is recommended and the reasons for that recommendation. (40 Marks)
- A description of how virtual applications and desktops or both will be delivered to the user’s desktops. (10 Marks)
- A description of how you will provide disaster recovery in this infrastructure. (20 Marks)
- A discussion of the information security changes required in this environment and the steps required monitoring and controlling these changes. (20 Marks)
Choose an IT/IS technology company and analyse, discuss and present their technological innovation:
• The core business activity and the role of innovation in their value proposition.
• How innovation is making this business different than competitors?
• Research and development and its relationship with the organisation’s innovation.
• What factors affected the firm’s innovation success? Is their innovation a “science-push” or “demand-push”?
• What’s the firm’s innovation category? What type of innovation is proposed by the firm? Explain the innovation type from different aspects of innovation type.
• Study the firm’s technology S-Curve. What is the stage of this business on the S-Curve? • How successful the firm has been in utilizing innovation in their own advantage?
Learning Outcomes Assessed
The following course learning outcomes are assessed by completing this assessment:
a) Discuss the fundamental concepts of computer and data networks
b) Explain how protocols are used to link computer networks and manage data traffic
Assessment Details
All work submitted must be authored by the student submitting the work or where
material from other sources is included it must be referenced using APA referencing.
Students found to have plagiarised will be dealt with according to university
regulations.
Networking Questions
Note: Please Give a brief explanation on each of your answer.
1. How many packets are in a TCP handshake? Please list the 3 packets
2. Can you explain stateful firewall?
3. What protocol does ping use?
4. What is the difference between ARP table and MAC table?
5. Is area 0 required in OSPF?
6. Is it OK or NOT OKAY for an OSPF device to be in a 2-way neighbor state?
7. What is the difference between active FTP and passive FTP?
8. Traceroute is a program that can be used to determine how many router hops there are between the source and the destination. Windows uses ICMP while Unix uses UDP. What mechanism is used to provide the router hop count?
9. When a packet passes through a router, what fields in the Ethernet frame of packet are changed?
10. Assume that we have an Ethernet switch with 48 ports. All ports are in the same VLAN. Nothing special is configured on the switch. If we connect a network packet sniffer to a random port on the switch and start capturing packets, what will we see?
11. When trying to ping Google DNS server (8.8.8.8) from a PC, what would be the destination MAC address and destination IP address of the ICMP packet?
- (Multiple Choice – Choose two)
- MAC address of Google DNS server
- MAC address of switch
- MAC address of default gateway
- IP address of Google DNS server
- IP address of default gateway
- IP address of ISP.
- (Follow up question) How does the PC learn the destination MAC address of (candidate selection from above (Either A, B, or C))?
12. (Similar to Q11) Explain how ARP would work if a PC wants to communicate with www.google.com
13. What is the difference between a Layer 2 Switch and a Layer 3 switch?
14. What are access ports and trunk ports?
15. What differences do you see on the frames that egress an access port and the trunk port?
16. Explain in details the way any 2 PCs would communicate with each other if they belong to
a) the same VLAN
b) different VLANs.
Assume that the switch has just started and then the PCs are trying to communicate with each other. Explain the lookups that are performed on the switch.
17. I have a TCP application that wants to send a packet of size 4500 bytes across a segment which has an MTU of 1500. how many fragments would be generated?
18. (Bonus Question) What is the difference between fragmentation and segmentation.
Task 1: Free Space Propagation and Path Loss (7%)
In a free space wireless propagation environment, transmit power between a transmitter and receiver usually decreases due to free space path loss denoted as (dB) and can be expressed as a function of distance between transmitter and receiver. Your task is calculate and plot the path loss (dB) for a distance and carrier frequency = 100, 300 and 1000 MHz. Assuming that the transmit power is 50 watts, you can calculate and plot the received power as a function of distance (as given above) for the carrier frequencies given above. You can assume transmit and receive antennas gains are the same, i.e. .
Deliverable: You are required to plot path loss (dB) as a function of distance for each carrier frequency, so you will have three curves in the plot. You also need to plot received power as a function of distance for each carrier frequency, so you will have three curves of the received power. You need to submit your executable GNU Octave code along with the plots in a single Word file.
Task 2: Research Project (8%)
- You are working as Network Design Engineer with local service provider and your manager has asked you to propose the design for the below cellular architecture shown in Figure 1. In your design provide the following information with reasons; Base station sites locations, Antenna specification (such as antenna shape, height, gains etc), mention the type of the area considering the cell size (such as suburban, metropolitan, rural etc) and justify you design. Note that the numbers within each cell are representing the traffic density in Erlang. (6 marks)
- Looking at the Figure 1 below, justify the design of this cellular network with appropriate reasoning? (2 marks)