Why would you want to use homomorphic encryption on the backend db? If the database is entirely opaque, just use text files since the entire point of a database is negated.
For your specific case of summing up values in a numeric column of a database, homomorphic encryption is indeed applicable. If you encrypt each value in the column using a homomorphic encryption scheme, you can then sum these encrypted values. The result of this operation will be an encrypted value that, when decrypted, will reveal the sum of the original plaintext values. ypes of Homomorphic Encryption
There are mainly three types of homomorphic encryption:
Partial Homomorphic Encryption (PHE): Allows only one type of operation (either addition or multiplication) an unlimited number of times. An example is RSA.
Somewhat Homomorphic Encryption (SHE): Allows both addition and multiplication, but only a limited number of times.
Fully Homomorphic Encryption (FHE): Enables both addition and multiplication on encrypted data an unlimited number of times. This is the most versatile form but also the most computationally intensive."