Your company wants to track whether someone is present in a meeting room reserved for a scheduled meeting.
There are 1000 meeting rooms across 5 offices on 3 continents.
Each room is equipped with a motion sensor that reports its status every second.
The data from the motion detector includes only a sensor ID and several different discrete items of information.
Analysts will use this data, together with information about account owners and office locations.
Which database type should you use?
Click on the arrows to vote for the correct answer
A. B. C. D.B.
Relational databases were not designed to cope with the scale and agility challenges that face modern applications, nor were they built to take advantage of the commodity storage and processing power available today.
NoSQL fits well for: -> Developers are working with applications that create massive volumes of new, rapidly changing data types " structured, semi-structured, unstructured and polymorphic data.
Incorrect Answers: D: The Blobstore API allows your application to serve data objects, called blobs, that are much larger than the size allowed for objects in the Datastore service.
Blobs are useful for serving large files, such as video or image files, and for allowing users to upload large data files.
https://www.mongodb.com/nosql-explainedBased on the provided scenario, the recommended database type would be NoSQL. Here are the reasons why:
Scalability: The system needs to track data from 1000 meeting rooms, which generates a large amount of data every second. With such a large scale of data, a NoSQL database can handle data more efficiently than a relational database, which has a fixed schema and requires expensive scaling operations.
Flexibility: NoSQL databases can accommodate a wide variety of data types, including unstructured and semi-structured data, which is well-suited to the motion detector data that contains sensor IDs and different types of information. Moreover, NoSQL databases allow for easy updates to the data schema, making them adaptable to evolving data requirements.
High availability: The system requires 24/7 availability for detecting and tracking room occupancy in real-time. NoSQL databases are designed to be highly available, with built-in replication and failover mechanisms.
Performance: NoSQL databases are optimized for high-performance, low-latency data processing, making them ideal for real-time analytics and data processing.
In summary, NoSQL databases are better suited for the scenario described in the question, due to their scalability, flexibility, high availability, and performance characteristics.