Page 1 of 2 12 LastLast
Results 1 to 15 of 21
  1. #1
    Registered User
    Join Date
    Jan 2019
    Posts
    7

    What is the difference between NoSQL and MySql?

    Hello,
    I am new to DBA and want to know about the difference between NoSQL and MySQL.

  2. #2
    Registered User
    Join Date
    Nov 2016
    Posts
    134

    Difference Between NoSQL and MySQL

    1. NoSQL is Non-Relational Database and MySQL is Relational Database.
    2. NoSQL is document or value based and MySQl is table based.
    3. NoSQL is Unstructured and MySQL is Structured.
    4. NoSQL have non-defining data but MySQL have defined data.
    5. NoSQL is not good for complex queries and MySQL is easy to implement in complex queries.

  3. #3
    Registered User
    Join Date
    Jun 2018
    Posts
    1,416
    NoSQL: Not Only SQL, or Non-relational. NoSQL database was designed for the needs of faster, more scalable and more responsive than traditional relational database due to the simpler data structure.

    MySQL: an open-source relational database management system (RDBMS), also the most popular one.

  4. #4
    Registered User
    Join Date
    May 2018
    Posts
    172
    NoSQL: Not Only SQL, or Non-relational. NoSQL database was designed for the needs of faster, more scalable and more responsive than traditional relational database due to the simpler data structure.

    MySQL: an open-source relational database management system (RDBMS), also the most popular one.

  5. #5
    Registered User
    Join Date
    Oct 2012
    Location
    New Jersey
    Posts
    97
    NoSQL is an approach to database design that can accomodate a wide variety of data models, including key-value, document, columnar and graph formats. NoSQL, which stand for "not only SQL," is an alternative to traditional relational databases in which data is placed in tables and data schema is carefully designed before the database is built. NoSQL databases are especially useful for working with large sets of distributed data.

  6. #6
    Registered User
    Join Date
    Nov 2018
    Posts
    45
    NoSQL is a database technology different from MySQL, primarily because it doesn't involve the Structured Query Language. The argument about “SQL vs. NoSQL” is the comparison of relational vs. non-relational databases. ... The points below highlight some of the biggest advantages and disadvantages of NoSQL.

  7. #7
    Registered User
    Join Date
    Sep 2018
    Posts
    20
    Quote Originally Posted by nishaguthe View Post
    Hello,
    I am new to DBA and want to know about the difference between NoSQL and MySQL.
    Hello, let me just show you a brief difference between these 2 notions. Since you're a beginner, let me explain from the very beginning.
    SQL is a programming language used in databases, to be more specific – MySQL, SQL Server, SQLite databases. An honestly speaking, it is quite widespread nowadays.


    I also put a very easy explanation about the difference between no and my SQL.

    Name:  MySQL-vs-NoSQL.jpeg
Views: 595
Size:  34.9 KB

    I would highly recommend to read this article as well - http://blog.qatestlab.com/2019/02/26...n-programmers/. It will help you to understand the very basics of SQL.

  8. #8
    Registered User
    Join Date
    Dec 2018
    Location
    51/1, Lalbagh Cross Road, Dhaka-1211
    Posts
    77
    NoSQL has wonderful schema for unstructured data and data can be document-oriented, column-oriented, or graph-based. You can create documents without having to first define their structure and each document has its own unique structure.

    While MySQL is an established database available for all major platforms, including Linus, Windows, Mac and Solaris. It also has connectors for almost all programming languages like Ruby, C++, C#, Java, Perl, Python and PHP and not limited to SQL query language.

  9. #9
    SQL vs NoSQL: High-Level Differences. SQL databases are primarily called as Relational Databases (RDBMS); whereas NoSQL database are primarily called as non-relational or distributed database.SQL databases have predefined schema whereas NoSQL databases have dynamic schema for unstructured data

  10. #10
    Registered User
    Join Date
    Apr 2019
    Posts
    83
    1.MySQL is Relational Database and NoSQL is Non-Relational Database
    2.MySQl is table based and NoSQL is document or value based
    3.The detailed database model is required before database creation in MySQL whereas no detailed modeling is required in the case of NoSQL database types.

    for more detailing about mySQL and NoSQL you can refer this:https://www.educba.com/mysql-vs-nosql/

  11. #11
    Registered User
    Join Date
    Mar 2019
    Location
    Ahmedabad
    Posts
    180
    MySQL

    MySQL development project has made its source code available under the terms of GNU General Public License, also under a variety of proprietary agreements. Initially, MySQL was owned and sponsored by a Swedish company called MySQL AB, now owned by Oracle Corporation.
    MySQL is relational in nature since all the data is stored in different tables and relations are established using primary keys or other keys known as foreign keys.
    MySQL is fast, easy to use a relational database that is being utilized by big and small businesses equally well. There are a plethora of reasons behind the popularity of relational databases like MySQL. It is a very powerful program in its own right, by handling a large subset of the functionality of the most expensive and powerful database packages.

    NoSQL

    A data structure used by the NoSQL database is vastly different from those used in a relational database. Some operations are faster in NoSQL than relational databases like MySQL. Data structures used by NoSQL databases can also be viewed as more flexible and scalable than relational databases.
    A primary reason for this different data structure could be driven by the simplicity of design, simpler horizontal scaling to clusters of machines and more control over availability.
    NoSQL databases are primarily used in big data and real-time web applications. These types of databases gain a surge in their popularity in the early twenty-first century. A primary reason for this sudden surge can say to be triggered by companies such as Facebook, Amazon, and Google.

  12. #12
    Registered User
    Join Date
    Oct 2020
    Location
    India
    Posts
    1
    Parameter SQL NOSQL
    Definition SQL databases are primarily called RDBMS or Relational Databases NoSQL databases are primarily called as Non-relational or distributed database
    Design for Traditional RDBMS uses SQL syntax and queries to analyze and get the data for further insights. They are used for OLAP systems. NoSQL database system consists of various kind of database technologies. These databases were developed in response to the demands presented for the development of the modern application.
    Query Language Structured query language (SQL) No declarative query language
    Type SQL databases are table based databases NoSQL databases can be document based, key-value pairs, graph databases
    Schema SQL databases have a predefined schema NoSQL databases use dynamic schema for unstructured data.
    Ability to scale SQL databases are vertically scalable NoSQL databases are horizontally scalable
    Examples Oracle, Postgres, and MS-SQL. MongoDB, Redis, , Neo4j, Cassandra, Hbase.
    Best suited for An ideal choice for the complex query intensive environment. It is not good fit complex queries.
    Hierarchical data storage SQL databases are not suitable for hierarchical data storage. More suitable for the hierarchical data store as it supports key-value pair method.
    Variations One type with minor variations. Many different types which include key-value stores, document databases, and graph databases.
    Development Year It was developed in the 1970s to deal with issues with flat file storage Developed in the late 2000s to overcome issues and limitations of SQL databases.
    Open-source A mix of open-source like Postgres & MySQL, and commercial like Oracle Database. Open-source
    Consistency It should be configured for strong consistency. It depends on DBMS as some offers strong consistency like MongoDB, whereas others offer only offers eventual consistency, like Cassandra.
    Best Used for RDBMS database is the right option for solving ACID problems. NoSQL is a best used for solving data availability problems
    Importance It should be used when data validity is super important Use when it's more important to have fast data than correct data
    Best option When you need to support dynamic queries Use when you need to scale based on changing requirements
    Hardware Specialized DB hardware (Oracle Exadata, etc.) Commodity hardware
    Network Highly available network (Infiniband, Fabric Path, etc.) Commodity network (Ethernet, etc.)
    Storage Type Highly Available Storage (SAN, RAID, etc.) Commodity drives storage (standard HDDs, JBOD)
    Best features Cross-platform support, Secure and free Easy to use, High performance, and Flexible tool.
    Top Companies Using Hootsuite, CircleCI, Gauges Airbnb, Uber, Kickstarter
    Average salary The average salary for any professional SQL Developer is $84,328 per year in the U.S.A. The average salary for "NoSQL developer" ranges from approximately $72,174 per year
    ACID vs. BASE Model ACID( Atomicity, Consistency, Isolation, and Durability) is a standard for RDBMS Base ( Basically Available, Soft state, Eventually Consistent) is a model of many NoSQL systems

  13. #13
    Senior Member
    Join Date
    Aug 2020
    Posts
    1,517
    NoSQL - a catch-all term for databases that stray from the relational database model (graph DBs, document DBs, key-value stores, etc.) MySQL - an RDBMS (Relational Database Management System) - a program that knows what to do with relational data, and can accept SQL, build a program that does what you said, and return the results.

  14. #14
    Registered User mikecowell's Avatar
    Join Date
    Apr 2019
    Location
    London
    Posts
    262

    MVNO Consulting

    MySQL is a relational database that is based on tabular design whereas NoSQL is non-relational in nature with its document-based design. ... MySQL is being used with a standard query language called SQL whereas NoSQL like databases misses a standard query language.

  15. #15
    Junior Member
    Join Date
    Jul 2020
    Posts
    17
    MySQL is relational in nature since all the data is stored in different tables and relations are established using primary keys or other keys known as foreign keys.
    A data structure used by the NoSQL database is vastly different from those used in a relational database. Some operations are faster in NoSQL than relational databases like MySQL. Data structures used by NoSQL databases can also be viewed as more flexible and scalable than relational databases.

Page 1 of 2 12 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

  Find Web Hosting      
  Shared Web Hosting UNIX & Linux Web Hosting Windows Web Hosting Adult Web Hosting
  ASP ASP.NET Web Hosting Reseller Web Hosting VPS Web Hosting Managed Web Hosting
  Cloud Web Hosting Dedicated Server E-commerce Web Hosting Cheap Web Hosting


Premium Partners:


Visit forums.thewebhostbiz.com: to discuss the web hosting business, buy and sell websites and domain names, and discuss current web hosting tools and software.