CryptDB is a system designed to protect the confidentiality of data in SQL databases by executing queries over encrypted data. It addresses two main threats: a curious database administrator (DBA) and an adversary who gains control over the application and DBMS servers. CryptDB uses SQL-aware encryption schemes, adjustable query-based encryption, and chaining encryption keys to user passwords to ensure that only authorized users can access their data. The system minimizes the amount of confidential information revealed to the DBMS server while maintaining efficient query execution. CryptDB has been evaluated on real-world applications, showing low overhead and strong security guarantees. The system supports various encryption types, including random, deterministic, order-preserving, homomorphic, and join encryption, each tailored to specific query operations. CryptDB also includes features like adjustable onion layers, training mode, and performance optimizations to enhance security and efficiency.CryptDB is a system designed to protect the confidentiality of data in SQL databases by executing queries over encrypted data. It addresses two main threats: a curious database administrator (DBA) and an adversary who gains control over the application and DBMS servers. CryptDB uses SQL-aware encryption schemes, adjustable query-based encryption, and chaining encryption keys to user passwords to ensure that only authorized users can access their data. The system minimizes the amount of confidential information revealed to the DBMS server while maintaining efficient query execution. CryptDB has been evaluated on real-world applications, showing low overhead and strong security guarantees. The system supports various encryption types, including random, deterministic, order-preserving, homomorphic, and join encryption, each tailored to specific query operations. CryptDB also includes features like adjustable onion layers, training mode, and performance optimizations to enhance security and efficiency.