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…
