Thursday, August 1, 2024

DATABASES IN EDGE COMPUTING AND IOT

 

DATABASES IN EDGE COMPUTING   AND IOT



An insight into the databases which are suitable for IOT and Edge computing, a comprehensive summarisation. 



Databases in Edge Computing and IoT

Introduction:

Edge Computing and IoT (Internet of Things) systems often generate and process massive amounts of data at the edge of the network, close to where the data is being generated rather than relying on centralized cloud servers. This approach has several benefits including reduced latency, bandwidth optimization, and improved data privacy. Selecting the right database for these systems is crucial for optimizing performance and ensuring reliability.  Below images gives a glimpse of subject being discussed.

A typical example of an IoT application The key features of IoT systems...  | Download Scientific Diagram

Convergence of IoT architecture and data analytics: an illustration |  Download Scientific Diagram

*All credits to the original creator of the above diagrams, they are fetched from google search for illustration purpose.

Comparative Analysis of Available Databases:

When evaluating databases for Edge Computing and IoT applications, it's important to understand the strengths and weaknesses of each type. This table provides a comparison of several commonly used databases, including some that are open-source and Apache-licensed, considering their type, pros, cons, and typical use cases.

Considerations for Choosing the Right Database

Choosing the right database involves various considerations to ensure it meets the application's requirements and constraints. The following table outlines key considerations including data model, scalability, latency, performance, resource constraints, and more, especially for open-source solutions like Apache Cassandra, ScyllaDB, YugabyteDB, TiDB, and Apache Druid.

Outcomes/Expectations from Such a Database

Every edge computing and IoT system has certain expectations from the database it uses. This section describes the outcomes you should expect, such as low latency, high write throughput, efficient data storage, scalability, data integrity, and reliability. Opting for an open-source or Apache-licensed database should still deliver the same expectations and outcomes regarding performance, scalability, and manageability.

Suitable Databases for Edge Computing and IoT Use Cases

Incorporating ScyllaDB, YugabyteDB, TiDB, and other open-source databases provides a comprehensive view of the options available for different IoT and edge computing scenarios. This section outlines which databases are most suitable for specific use cases, along with a brief explanation of why those databases are a perfect fit for the given scenarios.

Conclusion

Choosing the right database for Edge Computing and IoT applications is a critical decision that can significantly impact performance, reliability, scalability, and overall system efficiency. By considering a range of options from lightweight embedded databases like SQLite to highly scalable distributed databases like Apache Cassandra, ScyllaDB, YugabyteDB, TiDB, and Apache Druid, you can ensure you select the best-fit solution for your specific needs. Each database comes with its own set of strengths and potential trade-offs, and understanding these will help you make an informed choice that aligns with your project's goals and constraints.






No comments:

Post a Comment

DIVERSE DATABASE IMPLEMENTATION TOPOLOGIES: Multi-Model and Polyglot Persistence Databases

  DIVERSE DATABASE IMPLEMENTATION TOPOLOGIES.  Multi-Model and Polyglot Persistence Databases Multi-Model and Polyglot Persistence Databases...