A Report On Relational Databases - 923 Words

NoSQL was created in the response to relational databases not being able to handle the scale and changing challenges of modern applications, they also cannot take advantage of the cheap, easy storage abilities and also the processing power accessible now. NoSQL includes a variety of different technologies that were developed in response to the surge of data stored by users, objects and products. They were also developed to contend with the rising frequency that the data is accessed and the performance and processing needs. [7] NoSQL databases can be set into different categories such as †¢ Document databases - Document databases pair each key with a complex data structure known as a document. Documents can contain many different†¦show more content†¦The architecture used by NoSQL databases allows for the databases to be scaled efficiently rather than the more strict architecture found in relational databases. Pros and Cons When comparing the benefits to downfalls of both SQL and NoSQL, there are 6 areas which need to be looked at. These are how the systems allow for querying, how transactions are carried out, the consistency the systems offer, how saleable they are, also how easily managed the systems are and finally the schemas which are used by the systems. SQL based databases support a ever expanding set of languages for queries, as well as the a massive number of filters, sorting options, projections and index queries. NoSQL on the other hand allows for all this as well but does not have the more powerful aggregation options which are available to SQL based databases. Transactions allow for changes to be made to databases and atomicity ensures that these changes are done entirely. Having atomically made changes guaranties that these changes are never done partially, this is important because without it multiple users could make transactions relating to the same data and be working with different result causing data to be lost or new data being created, some NoSQL platforms do not support transactions but most SQL platforms do. Following the atomicity of the transactions consistency is also a big part of both types of platforms. MySQLShow MoreRelatedWhat Is A Relational Database. â€Å"A Relational Database Is1173 Words   |  5 PagesWhat is a Relational Database â€Å"A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. It was invented by E.F. Codd in 1970.† (TechTarget, 2006) A simpler definition of a relational database is a self-describing group of related tables. There are three ways to modify a table. We can insert a record, delete one, or update a recordRead MoreAnalysis Memorandum1532 Words   |  7 Pagesanalysis memorandum proposing the use of Microsoft Access databases within our Security Division’s infrastructure. Many security managers are relying heavily on the use of Microsoft Excel spreadsheets in order to keep track of their personnel, security violations, inspection programs and training. While spreadsheets are effective means for complex calculations they are also limited in that they basically fall short in showing the relational qualitie s of security data in relationship to particularRead MoreAcs Assignment 2, University of Winnipeg Essay1448 Words   |  6 Pagesway of organizing data on disk. b) 10 Convert the one table in the previous question to a relational database design. Fill each table in your design with data from the previous question such that no information is lost. Show how your design satisfies the criteria for being a relational database, and why it is better to store data on disk in this way rather than all in one table. c) 7 What is database management system? What steps would the hospital ward need to take to prepare its data toRead MoreThe Features Of A Relational Database1585 Words   |  7 Pages P1 - Explain the features of a relational database. This is to be shown as a report or presentation and must discuss the following. †¢ Features: entities; attributes; relationships; †¢ Entities: primary keys, foreign keys; referential integrity; attributes; †¢ Attributes: field properties e.g. data types, size, validation rules †¢ Relationships: one-to-many; one-to-one; many-to-many Relational database – This is a database that contains more than one table of which are linked using key fieldsRead MoreBtec1256 Words   |  6 PagesLearner Registration No. Assessor Name LEI13160876 Soory Abbassi 15/10/13 Hand-in Date Submitted On 15/10/13 18/03/14 Qualification and Programme Number Unit Number and Title BTEC Extended Diploma In IT (QCF): Level 3 Unit 18: Database Design Assignment Title Assignment 1 No. 1 of 2 Whole or Part of Unit? Whole /Part Grade for Whole Unit Deadlines: If you do not meet the deadlines for handing in your assignments you may not have your work marked. This could resultRead MoreWhat Is A Relational Database?1043 Words   |  5 Pagestechnical support staff in the exact way. The company are more comfortable to have a centralised IT-Based support system that is able to track, monitor and report on the improvement of problems acknowledged by users through the two sites normally improving the IT support service. What is a Relational Database? Relation database is a database model in which information is stored in separate tables stored in a linked relationship in a table with rows and columns. Each table has a record which isRead MoreWhat A Database Is, Features Of A Relational Database, And The Benefits Of Relational Databases1659 Words   |  7 PagesIntroduction: In this report I am going to explain what a database is, features of a relational database, and the benefits of a relational database, purpose of primary keys and how they are used to build relationships, and I am also going to focus on, what are foreign keys and how they are been used, explain referential integrity and finally, how to apply referential integrity. I am also going to backed up my views and opinions with the valid references. Assessment introduction Iain’s Co is aRead MoreDad (Data Analysis and Design)1117 Words   |  5 Pagesof Database system. Date given : 10th May 2010 Date to be submitted : 20th July 2010 Lecturer : Mr. T. Shanakr Rational The objective of this assignment is to assure that the students have gained the relevant knowledge according to the outcomes specified in the syllabus. Assessment requirements to meet learning outcomes 1. Understand data models and database technology 2. Design a relational database to meet user requirements Read MoreThe Features Of A Relational Database1406 Words   |  6 PagesP1 Explain the features of a relational database. Introduction: A company called Ian’s Co currently employs a team of IT technicians to manage their IT infrastructure and also support the IT users. Also quite recently the company has taken over a similar but a smaller company which is also employs technical support staff in the same way. What is a relational database? Firstly a relational database contains a set of tables which basically are linked collectively by the relationships between theRead MoreTechnical Guide : Database And Database Essay1551 Words   |  7 PagesTechnical guide Database It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. It is a structured set of data held in a computer, especially one that is accessible in various ways. A database is a collection of information that is organized so