How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

For LogicPro Only** Weekly tasks or assignments (Individual

Customer Question

For LogicPro Only**Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.
Your first task at Big Data Datacenter is to show some simple proof of concept types of activities. You will need Perl for the proof of concept activities, so you should download it if it is not already installed on your system. It can be downloaded here.
Management is eager to see how Perl can connect and interact with databases and common gateway interface (CGI) applications.
For the database connection, you will need to download and install the database interface driver (DBI) and show the following using the Big_Data_Servers_Table.xlsx as your guide:
A connection to a database
A query from the database that returns all of the servers that have status of production
An insert into the database that adds a new server to the table with ("PERLBD4",, "Development")
An update to the database that changes PERLDB2 from development status to production status
A delete on the database that removes the record information for PERLDB1 because it is no longer in service
For the CGI test, you should connect to the same data source and return the following:
The number of rows in the Big_Data_Servers_Table.xlsx
A query that shows all of the production servers
Use the attached spreadsheet as your guide. Your database and CGI tasks should reflect the actions against the spreadsheet as if it were a table in a database.
You can optionally download and install a small database and load it with the data from the spreadsheet. A simple, lightweight database will do, such as one of the following:
Option 1
Option 2
Complete the following:
Provide a 2-paragraph summary on how you might use DBI and CGI to manage and report on information in a database.
Share the syntax that is required to perform the DBI and CGI tasks. Simply cut and paste the Perl commands that you are using into a Word document.
Pick 3 system commands and provide the following:
A brief description of the command and why you might use it
How you will invoke the commands through Perl and why (System, Exec or Backtick)
Sample code showing how you would use the command
Your work on connecting to a database has not gone unnoticed. There is a growing interest to see better reporting, and Perl may be the answer. Create a table in your database with the attached spreadsheet as your guide, and generate the following reports:
Find all servers with CPU utilization above (>) 90%.
Find the average memory usage for all servers.
Show the server with the most memory utilization.
Show the server with the least amount of disk free.
Big Data Datacenter was impressed with your previous examples of system commands and is now looking at the project from a more strategic approach. The team is looking at you to show the big picture and explain how everything will work together. The requirement is an analysis on the following:
Identify modules from CPAN that can support a graphical user interface (GUI), network protocol, and database adapters. In your analysis, demonstrate how these modules will make interacting with the system more human-friendly in support of maintaining servers in the data center.
Describe how you will practically interact with CPAN to install the modules that you have identified.
Provide the syntax to create your own custom module that lends itself to being reused. Because the company is focused on managing servers, you might consider a module based on the following examples, but you are free to create your own:
Executes system commands to retrieve system metrics like CPU utilization
Reads information from a flat file and then inserts into a database
Connects to a database and retrieves reporting information
Submitted: 3 months ago.
Category: Homework
Expert:  LogicPro replied 3 months ago.

My apologies, I am out of ideas and opting out for other Professionals to answer. Please wait. You will be notified by email as soon as any Professional joins you.

I greatly appreciate the request and would be happy to help you with your other questions though.

Thank you for your patience.

Customer: replied 3 months ago.
Ok thank you
Customer: replied 3 months ago.
If it was the amount of work I was willing to give a nice tip...