by Nikhil M
Data insights are reliant on speed, accuracy, and display. BDB Platform excels in all the three aspects as it can load vast amount of data at unbelievable speed with at most accuracy and represent it as stunning visuals immediately unleashing actionable insights.
BDB has applied the following set of standard optimization protocols to achieve a mind-blowing speed of less than 5 seconds in visualizing data consisting of millions of data records.
The commencing step in this process was to know data. A better understanding of data helped us in segregating the fact tables spanning several million records into various aggregated tables. We loaded millions of records in the fact table at regular intervals.
We created aggregated tables using SQL functionalities and normalized them accordingly, which were used to fetch data using backend queries in our Dashboard Designer tool reducing the overall query load-time.
The caching mechanism of BDB Platform helped in loading only the required metrics and removing the unwanted service calls which helped the dashboard with overall load time.
The proximity of the server is one factor that could help us gain the required speed in data loading. The closeness of the server to the user location could reduce latency by aiding in the faster response time. Thus, keeping the server closer to the client location is always an advantage.
BDB Platform’s customized configuration helped in allotting CPU memory of the nodes dynamically based on its usage that enabled us to achieve a quicker response time of the dashboard.