Why is “database optimization” important? An increasing number of companies are using NOSQL to complement traditional RDBs to handle exponentially growing data, such as real-time analytics while holding large amounts of data.
So far we have used a database called RDBMS. The internal data structure was normalized, and it was necessary to refer to several master tables to display one screen.
A database called NOSQL, on the other hand, allows you to design the information you need in one shot. By adding the number of servers, you will be able to flexibly deal with the increase in data volume and traffic.
Pros of NOSQL
- Can take the data storage format optimized for the application
- Can store data without defining data type
- Performance can be easily improved by adding more servers
Cons
- Data integrity needs to be considered in design
Case
Industry: Automobile manufacturing
Overview: Raw data from IoT devices is stored in a large-capacity database, Azure Table Storage. For inquiries from the system, data is aggregated and processed by the regular startup of Azure Function to create Json data optimized for the display format. By saving to the Cosmos database that can store flexible data, the inquiry screen has been improved so that the necessary information can be referenced almost in an instant.