In the realm of database security, how do cryptographic techniques such as homomorphic encryption contribute to ensuring confidentiality and privacy of sensitive data, and what challenges and advancements exist in the practical implementation of such methods within database systems?