Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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",128.33.23.198, "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. 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server Query Performance Tuning

Authors: Sajal Dam, Grant Fritchey

4th Edition

1430267429, 9781430267423

More Books

Students also viewed these Databases questions

Question

(2) How much recognition do people gain for doing a good job?

Answered: 1 week ago