MySQL Assignment Question

LAB Work

1. Choose your favorite SQL Server e.g. MySQL Enterprise (trial download should be possible) or MS SQL Server Express

  • Generate a simple and large database (e.g. by using benchmarking tools)
  • Try column level encryption and see how data looks like after encryption (Create a table with an encrypted column, issue an insert statement, then issue a select statement)
  • Try to insert encrypted values to the table
  • See the added the rows/columns (select * …)
  • What are the possible encryption algorithms supported in your selected DBMS?
  • Try to compare full database encryption to column-level encryption in terms of performance, e.g. run simple select statements on the large database you generated…

Questions to think about:

  • What are the vulnerabilities (attack vectors) you could have with this approach?
  • Can you get the plain text from encrypted data in a way?
  • What difference do you see between one algorithm (e.g. AES) and another algorithm of your choice?

2. CryptDB

Download and Install CryptDB:

  • Works on Ubuntu 12.04, 13.04

git clone -b public git:// Follow the instructions for setup (may take some time) Tasks

  • Try to execute the queries in file “demoqueries”
  • Try to find/run a query that is not supported (try to see UNIMPLEMENTED EXCEPTION or others…)

Questions to think about:

  • Would you use this in a production environment?
  • What are the concerns you would have if you do so?

3. Compare the performance of CryptDB with your selected DBM (MSSQL or MySQL) for a certain DB

  • Think of a scenario where you have multiple queries to the DBMS
  • Select queries: try to see how CryptDB and your DBMS performs compared to each other
  • By using benchmarking tool of your choice try to compare the performance of various queries on bulk data…
Improve Your Grades with Custom Writing Help
Homework Help
Writing Help
Editing Services
Plagiarism check
Proofreading services
Research Project help
Custom writing services
E learning blogs

Disclaimer : The study tools and academic assistance/guidance through online tutoring sessions provided by AssignmentHelp.Net is to help and enable students to compete academically. The website does not provide ghostwriting services and has ZERO TOLERANCE towards misuse of the services. In case any user is found misusing our services, the user's account will be immediately terminated.