system design approach

• designwithmodels
•  

hibernate

• n+1 read problem
• problem of granularity
• domain model
• coarse grained class vs fine grained class
• 
  

rdbms issues

• index
• materialized view
• query optimization
• how to read query execution plan?
• joins esp hash
• performance tuning
• partitioning
• pre-joined indexes
• buffer
• latching problem
• filter in join
• join order
• algebra
• statistics
• graph theory
•  

performance

• use memcache or redis to cache the following
• city/state/country
• zipcode
• qualication types
• job types
• 
  

Representing address

• how-to-design-the-database-schema-representing-address-elegantly
• Use first solution, If a country does not has any states, just add a dummy state (same as country name). Cache the data of city, state, country (which are not likely to be changes but frequently needed) in database (Query cache) or in server (using APC/memcached etc). Once cached, you wont need many joins thus making queries faster
•  the previous solution is related to the information given in the link
• best-practices-for-storing-postal-addresses-in-a-database-rdbms
• make address an entity and store it in a cache like redis or memcache
•  

Spring Boot doubts

• disabling embedded tomcat server
• can we disable it 
• how to configure it?
• how to know the server being used ie pivotal or embedded tomcat or outside tomcat?
• how to monitor ports which are being used?
• use the following command at command prompt to show the port number in use
• netstat -anp | find "port 8080"  is not working
•  

debugging a spring boot application

• indepth knowledge of build tool like maven and gradle
• indepth knowledge of logging
• indepth knowledge of server ie tomcat etc
• indepth knowledge of browser 
• indepth knowledge of  cache and how to clean it and disabling it
•