JPA

• Optimistic-locking
• Pessimistic-locking

---

RDBMS

• Sharding data partitioning

  https://docs.oracle.com/en/database/oracle/oracle-database/19/shard/oracle-sharding-architecture-and-concepts1.html#GUID-9C13DCC4-0018-4049-94D8-70F518008504 [good oracle sharding docs must read]

  https://aws.amazon.com/blogs/database/sharding-with-amazon-relational-database-service/

  https://www.digitalocean.com/community/tutorials/understanding-database-sharding

  https://medium.com/must-know-computer-science/system-design-sharding-data-partitioning-b7201596aafa

  https://medium.com/slalom-build/optimistically-locking-your-spring-boot-web-services-187662eb8a91

  https://www.baeldung.com/jpa-optimistic-locking

• Partitioning types

  https://dev.mysql.com/doc/mysql-partitioning-excerpt/5.7/en/partitioning-types.html

• Indexing

  https://www.freecodecamp.org/news/database-indexing-at-a-glance-bb50809d48bd/

  https://medium.com/must-know-computer-science/system-design-indexes-f6ad3de9925d

• Transaction management :- good doc:

  https://docs.oracle.com/cd/B19306_01/server.102/b14220/consist.htm#i5702

---

Oracle:

lock management :

http://www.dba-oracle.com/t_locked_rows_user_locks.htm

http://www.dba-oracle.com/t_row_locks_vs_table_locks.htm

http://www.dba-oracle.com/t_deadlock.htm