I still remember the first time when I was introduced to the two buzz words, OLTP and OLAP; I found it very confusing. It was around 7 years back during my university days. But now, it’s a very simple concept for me. Through this post, I’ll try to make it simpler for all.
OLAP stands for Online Analytical Processing and is used for data analysis and not data processing.
OLTP stands for Online transaction processing and is primarily used for data processing and not for data analysis.
OLTP is for running the business and OLAP is for…
As monolithic systems become too large to deal with, many enterprises are drawn to breaking them down into the microservices architectural style. It is a worthwhile journey, but not an easy one.
Monolithic could work if your goal is to just create a small application for in-house functions, such as back-office tasks. It’d be quicker and easier to develop, and if you keep the app lite or skim in terms of features, it’ll be easy to maintain as well. The latter point is especially key if your company only has a small team of developers.
But if you expect your…
Last week, I was thinking of how to inspire/encourage a kid to understand coding and my conclusion at the end confirms that it’s really a very difficult task overall.
I thought of something different — let’s play a game and explain the working of a game to the kid with a live demo. To achieve this, I quickly wrote a python program to play text-based snake and ladder game in the terminal.
Any advance python concept is not used in this code. However, it is a fun thing to do for a beginner in order to learn how to use…
Stupid implementation of the deleteAll() method
The server showed a great latency issue while running deleteAll operation with Spring Boot JPA -> Service becomes unresponsive.
The spring boot JPA uses a SELECT * in its deleteAll method as the default implementation. It was reading all rows and then executing the delete method on all of them individually.
Couldn’t a simple implementation of the “delete from [table name]” have sufficed?
At a high scale, It’s better to write your own queries with hibernate.
JPA is good for quick/fast development but if you are building for scale better not use it. (gradually…
Availability is generally calculated based on how long service was unavailable over some period. Assuming no planned downtime, the table below indicates how much downtime is permitted to reach a given availability level.
Using an aggregate unavailability metric (i.e., “X% of all operations failed”) is more useful than focusing on outage lengths for services that may be partially available — for instance, due to having multiple replicas, only some of which are unavailable — and for services whose load varies over the course of a day or week rather than remaining constant.
2. Python Django
Having any 3–4 in your projects will set you apart from other candidates:
Where Data Structures are used in the real world?
Let’s see it with some examples
- Graphs are very interesting Data Structures and my personal favorite.
- You have seen the friend suggestions on Facebook. Haven’t you?
- So basically they are fetched using graphs based on the distance/degree from you.
- Similarly in LinkedIn you can see the 1st, 2nd, 3rd connections.
(All the depth levels — level order traversal)
- the one more interesting example is Dependency Injection Library/packages
- so a Graph is created for all the dependencies and each instance of classes created in…
Once you are financially secure, there is no difference in the quality of life between you and the richest person on earth. You both have limited time on earth. A sandwich is a sandwich whether a billionaire eats or you do.
Money is nothing but a piece of paper or a number on your phone. Real life is in relationships.
Work on something you love, become financially secure, have good food, enjoy your relationships, take care of your parents and find a bigger purpose to help others. That’s all there is to life.
Time is the real currency of life, not money. If you are young, you are far richer than an old billionaire walking the earth.
Sooner you figure this out, the happier you will be.
Below are the few commands to do a quick check and to monitor the server.
Check for the RAM usage
Check for the disk usage
df -h <path>
Check for the iNode usage
- if there are disk read and writes happening, this can be a bottleneck.
df -ih <path>
Check for the heap memory usage
Identify the xmx min and max in case of java application
Check for the running application
Check for the context switching
Check count of java thread
ls /proc/$(pidof java)/task/ | wc -l
To get the number of threads…
When I look at a complex bit of SQL Code, this is what I do.
First, if it is an update or delete, I add code (if it isn’t there and commented out) to make it a select. Never try an update or delete for the first time without seeing the results in a select first. If it is an update, I make sure the select shows the current value and what I will be setting it to in order to make sure that I’m getting the desired result.
Understanding the joins is critical to understanding complex SQL. For every…