The Relational Database Model

Question: Describe the motivation, theory and technology behind . Compare and contrast this with the standard Relational Database Model that has been discussed during the topic. In doing so, discuss the benefits and drawbacks of both approaches and when it is appropriate to use each approach. Answer: has been the NOSQL which is a database system that is able to highly optimize the data for the retrieval and for handling all the appending operations. This is mainly to work for the record storage and the key value stores in reduced time flexibility which is compared to the full SQL systems. (Nance et al., 2013). These have been applied with the use that requires a huge quantity of the data where the same attributes could be used for the capture on the single machine. It is important when the data can be structured easily without any use of the NoSQL. There have been production system which evaluates the underlying techniques of NoSQL, with the query possibility, concurrency control, partitioning and the replication of the different opportunities. The Relational Database Model discussed has been SQL. SQL stands for the Structured Query Language which lets you properly access and handle the manipulation of the database with the ANSI standard. The execution of the queries against the database with the retrieval of the data, to insert, update, delete, and create new database records. This will help in handling the creation of new tables in the database which can be stored easily through the procedures in the database through the proper views and the permissions on the tables, procedures and the views. (Padhy et al., 2011). For the Relational Database Management System, there have been opportunities of the relational model which directs to store the data with the different fields or the records in the row or the column form. Benefits and drawbacks of both approaches NoSQL has no schema where the data structure is not through the explicit schema where a particular database knows about it. The client can store the data which adheres to the predefined structure. This is mainly for the built in of a large storage which is generally used by the websites like Google and Amazon. They also allow the horizontal scaling where there have been additional machine to the cluster without any downtime. (Cattell, 2011). SQL (Structured Query Language) has been designed for the management of the data which is related to handling the data definition language and the different functions. There have been occurrence of the same row multiple times with the employed queries in the LIMIT cause. The SQL language includes the different clauses, expressions, predicates, queries and the statements for a proper flow of the program. (Mohan, 2013). When it is appropriate to use each approach. NoSQL does not need the querying technology that has been used in the RDBMS for SQL. It has a better capacity for the compression of the data as it generally make use of the sparse rows. This is not mainly for the ACID transaction and is not considered to be the open source as well as it does not give the adequate controlled access. (McCreary et al., 2013). The SQL is users for describing the desired data for the planning, optimization and proper performance of all the physical operations which are important for the retrieval of data. This includes the JOIN option with the specification of the rules for the joining of tables. Reference Nance, C., Losser, T., Iype, R. and Harmon, G., 2013, March. Nosql vs rdbms-why there is room for both. InProceedings of the Southern Association for Information Systems Conference(pp. 111-116). Padhy, R.P., Patra, M.R. and Satapathy, S.C., 2011. RDBMS to NoSQL: Reviewing some next-generation non-relational databases.International Journal of Advanced Engineering Science and Technologies,11(1), pp.15-30. Cattell, R., 2011. Scalable SQL and NoSQL data stores.ACM SIGMOD Record,39(4), pp.12-27. Mohan, C., 2013, March. History repeats itself: sensible and NonsenSQL aspects of the NoSQL hoopla. InProceedings of the 16th International Conference on Extending Database Technology(pp. 11-16). ACM. McCreary, D. and Kelly, A., 2013. Making sense of NoSQL.Greenwich, Conn.: Manning Publications.