Answer to Question #163988 in Databases | SQL | Oracle | MS Access for Farah

Question

development team is developing a special purpose application for some organization. The data is very large but relatively static. Data loss is an acceptable risk. Multiple users are accessing the application at the same time. File system and database system are two approaches which can be used to store data. Being a database expert, you are approached by the Team manager to help them in deciding which of the above mentioned data storage system will be more suitable for current scenario.

Suggest the storage system considering the above mentioned scenario with solid reasoning.

Answer 1

If multiple user accessing the database then the suitable database server is SQL server, Oracle and MySQL are designed to deal with multiple concurrent users, while access the file, it is always single-user.

Database servers we use as per the requirement of the database storage.

• Cassandra:This is developed by the Facebook, in this NoSQL database is now managed by the Apache Foundation.
• HBase: This is used for the non-relational data-store for Hadoop.
• MongoDB: It is designed to support humongous databases.
• Neo4j: It is world's leading graph database.