Show some simple proof of concept types of activities
Course:- Database Management System
Reference No.:- EM131395714

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Database Management System

Accessing External Sources

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- http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
• Option 2- https://dev.mysql.com/downloads/

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.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Database Management System) Materials
Design an Relational Model (RM) model of a database (DB) that will be useful for each of the chosen enterprises and Implement the 2 enterprise relational DBs using either MySQ
Marge's Crafts sells work by local artists at her small store in Burnsville. Customers pay for their purchases at the time sale. Commercial customers, purchasing over 10 ite
Ascertain the need for a robust network infrastructure to support strategic initiatives related to BI within an organization of your choice. Moreover, analyze the main reaso
The rooms are cleaned by Maids. The IT should keep track of the Maids and whichcleaned what room and when. Maids get paid by check based on the number of rooms each cleaned
Discuss connections, similarities, shared issues, discrepancies, possible combinations of problems and techniques from the three papers, etc. Whatever you consider relevant,
You want to authorize your secretary to ?re people (you will probably tell him whom to ?re, but you want to be able to delegate thistask), to check on who is an employee, and
How data will be output from the system? Develop a plan for data organization, storage, updating, and retrieval. A list of tasks or activities needed for implementing the prop
Create a provider database and related reports and queries to capture contact information for potential PC componentproviders that might be used to purchase the equipment yo