1. InfluxDB :
InfluxDB is a time-series database and is known for its high availability and storage. It was developed by InfluxData in 2013. It is open-source licensed software and is widely used in retrieval of time series data. It is used in real-time analytics and monitoring of data. It does partitioning by sharding. InfluxDB is implemented in Go language. InfluxDB is easy to use and has high scalability.
2. Microsoft Access :
Microsoft Access is a relational database and was given by Microsoft in 1992. It is implemented in C++ language. It has a commercial license. It is a combination of back end relational DBMS and a GUI front end. It supports the Windows operating system. It stores data on the Access Jet Database Engine. Microsoft Access is designed to have multiple users working in the same DB files along with the various safety precautions items to help protect the data such as record-level locking. The database created in Access is saved with a .mdb extension.
Difference between InfluxDB and Microsoft Access :
|1.||InfluxDB is a Time-Series database model.||Microsoft Access is a relational database model (RDBMS).|
|2.||InfluxDB was developed by InfluxData in 2013.||Microsoft Access was developed by Microsoft in 1992.|
|3.||In InfluxDB partitioning is done by sharding.||In Microsoft Access partitioning is not done by sharding.|
|4.||It has open-source license.||It is a commercial software.|
|5.||It is implemented in Go language.||It is implemented in C++ language.|
|6.||It is used for retrieval of time series data.||It is a combination of back end relational DBMS and a GUI front end.|
|7.||It supports operating systems like Linux and OS X .||It supports Windows operating system.|
|8.||In terms of ranking it is considered lower than Microsoft Access.||It is considered better than InfluxDB in terms of ranking.|
|9.||It has Server-side scripts.||It has does not have Server-side scripts.|
|10.||It does not have ACID as its working principle.||It has ACID as its working principle.|