Securing Higher Grades Costing Your Pocket? Book Your Course help Tutor at The Lowest Price Now!

Get Instant Course Help

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://g.csail.mit.edu/cryptdb 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…
Course Help Features
Course Help Services
QR Code Course Help
elearningfeeds