Relational And Non Relational Database Model Essay

2 Literature Review Many theories have been written to clearly explain the concept of relational and non-relational databases. Although those literature hightligted varieties of significant theories, this review will attempt to establish a clear meaning of relational and non-relational database Concept, NoSQL data model, ACID and Base properties, CAP Theorem and Scalability. Furthermore, it will attempt to critically evaluate structured and unstructured data, elucidate on the strength and weakness of relational and NoSQL databases and give an overview of the benchmarks used to evaluate the reliability and performance of databases. 2.1 Relational and Non-Relational Database Concept The relational database model was invented in 1970, by Edgar Ted Codd, a Mathematician at IBM’s San Jose Research Lab in California, United States of America. At the time, nobody realized that Codd’s theories would spark a technological database revolution. Until 1970, a database stored large volume of data using hierarchical data model that was difficult to navigate and lacks flexibility [8]. Today, the benefits brought to us by relational database model are enormous. Ted Codd in his paper titled A Relational Model of Data for Large Shared Data Banks†, he created and visualize the concepts for organizing and accessing data that is embodied in the relational database, he proposed that data should be structured according to principles based on identified relations [9]. In order to eliminate dataShow MoreRelatedDocument Based Data Modeling Technique And Relational Technique1230 Words   |  5 PagesJanu Barot Database System Midterm Exam Document based data modeling technique and relational technique In todays era, the volume of data we manage has developed to terabytes. As the volume of data continues developing, the sorts of data produced by applications get to be wealthier than some time recently. Subsequently, traditional relational databases are tested to catch, visualize, seek, share, break down, and store data. We find many difficulties in managing bigRead MoreRelational Databases For An Efficient Data Management And Retrieval Of Data1032 Words   |  5 Pagesan issue due to the growing need in business and academia. To resolve these issues a number of databases models have been created. Relational databases allow data storage, retrieval and manipulation using a standard Structured Query Language (SQL). Until now, relational databases were an optimal enterprise storage choice. However, with an increase in growth of stored and analyzed data, relational databases have displayed a variety of limitations. The limitations of scalability, storage and efficiencyRead MoreA Video Rental Store977 Words   |  4 Pagesbusiness and hence they can no longer keep up their customer database, inventory management, and daily sales monitoring with their current information management system. As their hired computer system consultant, I immediately recommended switching over to a computer based Point of Sale (POS) system to record sales. The next phase of upgrades will be to integrate the sales system with a database. The decision on what type of database to employ heavily depends on the scale of the business, plansRead MoreMicrosoft Vs. Multi File Database1594 Words   |  7 Pagesdifferent database technologies. Each technology offers its own pros and cons and below is a look at of the most common technologies. Single- vs. multi-file databases A notable different between technologies can be whether they are single-file or a multi-file database. Single-file database Single-file database is the simplest database structure, as it consists of unified information, which can often be used and accessed in a pre-determined manner. Complexity in a single-file database is not commonplaceRead MoreSql Vs. Relational Databases956 Words   |  4 PagesTo SQL or Not to SQL Relational databases play a major role in making many apps and programs work. They provide an easy way to store large amounts of data in a consistent, non duplicating, and maintainable way to be used by developers for analytical or software use (Advantages of a relational database, n.d.). However, more and more applications and companies with a tremendous amount of data such as search engines, social networks, and e-commerce sites have been requiring a level of speed and scalabilityRead MoreDescribing Storing Data from Dbms1240 Words   |  5 Pages (Traditional Models) Introduction A computer database relies upon software to organize the storage of data. This software is known as a database management system (DBMS). Database management systems are categorized according to the database model that they support. The model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managingRead MoreKey Features Of The Database Management System1035 Words   |  5 Pagesof the database management system MongoDB. Day-to-day information is growing in gigantic amount. Generated information include predominant information and it will have to be analyzed for gathering essential expertise. On the whole, relational databases are used so as to system the data. These, ways works successfully for small amount of knowledge. What if the data is very tremendous? To avoid this problems Mongo databases are introduced. MongoDB is a cross-platfo rm document-oriented database. ClassifiedRead MoreTradeoffs Between Relational and Object-Oriented Database Management Systems1149 Words   |  5 PagesDiscuss the tradeoffs between relational and object-oriented database management systems 1) Stating Position The object oriented DBMS is superior to the relational database on some specific counts, primarily because it can satisfy the complex demands of the market today better than the any other. Secondly while the relational data base stores data as tables, the object model stores data as objects and creates associations. This can create a multiple set of attributes for each object such thatRead MoreInformation Technology : The Future Of Database Management Systems1183 Words   |  5 Pages The Future of Database Management Systems The American National Science Foundation perceives five recent technologies as instrumental in the shaping of the future database management systems: †¢ massive computing power, for examples, supercomputers (Bancilhon, et al.) †¢ massive storage capacity, for example, optical storage (Bancilhon, et al.) †¢ far reaching sensor technology (Bancilhon, et al.) †¢ powerful personal workstations (Bancilhon, et al.) †¢ neural nets (Bancilhon, et al.) It is evident thatRead MoreDatabase And Unstructured Data Of A Business Perspective1001 Words   |  5 Pagesmore on exploring semi structured and unstructured data that is generated through social media activities, personal media information and geo location data. NoSQL database is a type of database that provides a means for storage and retrieval of structured, unstructured and semi-structured data. This is different from relational databases which uses the tabular relation. From a business perspective, considering the NoSQL is said to have a considerable advantage over the others. More importantly, since