Results 1 to 11 of 11
  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
    133

    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
    734
    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
    175
    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
    Posts
    84
    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
    46
    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: 92
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
    70
    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
    Feb 2019
    Posts
    1,587
    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.

  11. #11
    Registered User
    Join Date
    Apr 2019
    Posts
    16
    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/

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.