One question that may be frequently asked during an interview is that how you ensure data consistence between cache and database in an application. In this post, I will introduce some possible solutions and their drawbacks. While some of them… Read More
database transaction acid
A few days ago, I encountered the term ‘ACID’ when reading one article about database. I summarized the term in this post after searching it using google, so that it can be referenced later. Atomicity Transactions are often composed of… Read More
normal form for database table
The below normal forms should be enforced when the table of a database is designed. First Normal Form: A table is not in first normal form if it stores multiple values for a piece of information. Action: If a table… Read More