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…
Assignment Help Features
- 24 x 7 Availability
- Plagiarism Free
- Trained and Certified Experts.
- Deadline Guaranteed
- Privacy Guaranteed
- Assignment Help Reward
- Online help for all project.
- Service for everyone
- Online Tutoring
- Free download.
- Free study help whitepapers
Assignment Help Services
- Assignment Help
- Homework Help
- Writing Help
- Academic Writing Assistance
- Editing Services
- Plagiarism Checker Online
- Proofreading
- Research Writing Help
- Services
Calculator