SQL Vs NOSQL

Amazing Essays
Not Only SQL
(NOSQL)

In this paper I will use comparisons to help distinguish what is NOSQL. We will talk about NOSQL vs SQL. Document, Graph, or Key-value and wide column Models of NOSQL. We will touch on Schema and end with a condensed comparison of SQL and NOSQL. In short, a brief overview of not only NOSQL but also its opposing and conjoining systems, and their pro’s and con’s.
To really understand these comparisons, you need to have an Idea of what JavaScript and JSON are in addition to the LAMP and MEAN stacks. The term LAMP referrers to (Linux, Apache, MySQL (SQL), PHP). The LAMP stack is a common stack of open source and free languages. This stack uses Linux as the operating system Apache as the server, MQSQL as the Database and PHP
…show more content…
JSON stands for: JavaScript Serialized Object Notation. It is a minimal format for structuring data, and was created for use in JavaScript to pass around small bits of data. “JSON is the data structure of the Web. It 's a simple data format that allows programmers to store and communicate sets of values, lists, and key-value mappings across systems.” Ok so NOSQL is a database system that does not use the traditional tables columns and rows. It uses one of the outlined Data Models above. For comparison we are using Mongo DB, a popular NOSQL option, which uses the Document Model, whose format is similar to JSON, which we have now defined.
In addition to Document NOSQl databases, there are also Graph, Key-value and wide column Models. These each are a topic to wide to discuss here but we will touch briefly on each.
• Graph databases use embedded aggregates, like other NOSQL databases. Graphs are capable of manipulating large amounts of data. Graphs work by using two type of records, Nodes and Relationships, these intern have properties. The best way to visualize this is to think of an Entity relation diagram, with labeling between the entities describing the relationships.
• Wide column databases is an exception to the rows and columns rules. The data her eis stored in rows with an associated key, and they are ordered by column, however the difference here is that each row can have different columns. Theses columns can be made into super columns which are
…show more content…
These models do vary between different kinds Berkely Db and Couchbase are a few to mention.
Aside from the aforementioned items above, these databases continue to differ from one another. RBDMS like MYSQL is great for a variety of different applications. It is proven to be a viable database structure. The problems start with RBDMS when there are errors in the design of the database, or growth into larger data occurs. This requires you to continually upgrade the server space to accommodate the growing data. This does not mean, however, that every database should or could be a NOSQL type. While NOSQL has the ability to perform data calls at a very fast speed, very strong write speeds on large amounts of data, it offers only a few capabilities to preform ad-hoc queries, it has may different Document types and is skill heavy.
The condensed take away is this. “The right tool for the right job”- . There are many attributes that each type of database, SQL vs NOSQL, has. RBDMS has been the standard for many years (even replaced NOSQL at one point) and will not be going away. Not every application can use NOSQL to its potential, again noting on the skill requirement referencing load balancing and cluster

Related Documents

  • Decent Essays

    Django Case Study

    • 1057 Words
    • 5 Pages

    Answer: Django should be used for web development because of following reasons: • It allows to divide code module into logical groups to make it flexible to change. • To easy the website administration, it provides auto-generated web admin module. • It provides pre-packaged API for common user tasks. • It enables to define what should be URL for given function. • It enables to separate business logic from the…

    • 1057 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    Instead, I utilized the “http.server” library in python (http.server--HTTP Servers, 2016). The class to handle HTTP requests was only a few lines of code which could easily be expanded to fit my needs. I focused mainly on the “do_post” function, as all requests were done via POST in HTTP. In addition to the communications, the command and control server would also need to keep track of clients and take command input from the user running the server. To handle commands, I created a simple while loop that prompts for input until the “exit” command is given.…

    • 2049 Words
    • 9 Pages
    Decent Essays
  • Decent Essays

    By modifying the various input values and then viewing the source code, one can gain a great deal of information on CSS column layouts. In the IBDjohn template generator, a user can enter such things as color, size, width and others into any form that leads to generation of an entire template. Once the user completes the last layout for the design, he or she can copy and paste the HTML -CSS code in order to get instant answers. In this format, there are five variables involved, each relating to different parts and settings of the web page. The first variable is Basic Settings, which includes font color, size and style as well as the border color.…

    • 1887 Words
    • 8 Pages
    Decent Essays
  • Decent Essays

    Web Crawler Case Study

    • 1327 Words
    • 6 Pages

    Hefty growth of the web, results in large index size which is not approving to find the intended focused resources. Therefore Focused crawler is indispensable to cope with this problem. The prospective applications of focused crawler are in finding linkage or relationship, locating most relevant sites, which forms learning basis for human. The following section shows the architecture of focused crawler which contains following important functional blocks, [i] Classifier: makes relevance judgments on pages crawled to decide on expanding links found in these pages. [ii] Distiller: The measure of centrality of crawled pages can also be determined.…

    • 1327 Words
    • 6 Pages
    Decent Essays
  • Decent Essays

    Teradata Case Study

    • 999 Words
    • 4 Pages

    Teradata's Defined Warehouse includes three major sections  Teradata Workload Management  Teradata Database Secure Zones  Teradata Data Lab 5. Language choice You have an option to choose your favourite language which you think will handle the type of questions at its best. You can select Java, Perl, Ruby, Python, R or any other language script installed in your system to run custom…

    • 999 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    Examples Of SQL Injection

    • 820 Words
    • 4 Pages

    • Accessing the databases to find and modify security settings so as to have administrative rights. • Using the administrative rights to perform functions such as accessing and stealing private data, deleting or modifying data in the database. Example of an SQL Injection in a login page When a user submits the credentials, the web application uses them in an SQL query which is then sent to the database for execution. If the submitted username and password are valid, the use gains access, and denied if invalid. Assume the username is ‘user1’ and password is ‘pass123’, the web application will send the below SQL query to the database for verification.…

    • 820 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    Kelly's Salon Case Study

    • 1186 Words
    • 5 Pages

    Because SaaS is a web-based solution, configuration will be done by an IT expert on HTTPS to allow uses authenticate data transfer location. Subsequently, this kind of configuration guarantees data integrity and privacy important aspects of Kelly’s saloon. Alternatively, the system might be configured on PostgreSQL, which directly backs up data to the servers. d. Testing Testing of SaaS integrates different techniques such as Agile that accelerates the procedure. SaaS has an automated vendor that offers testing services.…

    • 1186 Words
    • 5 Pages
    Decent Essays
  • Decent Essays

    Many reasons to handle data is to keep information of something important which may improve a work that you are involve. In the following paragraphs, I will talk about general information of RDBMS and I will discuss and evaluate alternatives Relational Database Management Systems and the advantages and disadvantages that each…

    • 987 Words
    • 4 Pages
    Decent Essays
  • Decent Essays

    End-Of-Chapter Quiz

    • 680 Words
    • 3 Pages

    Correct answer Data A predefined formula that performs calculations by using specific values, called arguments. Correct answer Functions The arrangement of arguments in a function. Correct answer Syntax A group of three, four, or five small graphic images that make your data visually easier to interpret. Correct answer Icon sets An image of an active window on your computer that you can insert into a worksheet. Correct answer Screenshot 2) Bringing data in from an external data source is known as: (1 point) Correct answer Importing 3) This is stored in columns and contains a specific type of data such as name, employee number, or social security number.…

    • 680 Words
    • 3 Pages
    Decent Essays
  • Decent Essays

    Midori Case Study

    • 1833 Words
    • 7 Pages

    Microkernels are very easily maintained than monolithic kernels. There is a drawback that is the large number of system calls and context switches might slow down the system because they generate more overhead than other plain function calls. It allows remaining implementation of OS like normal application…

    • 1833 Words
    • 7 Pages
    Decent Essays