Overview of NoSQL database #DOTC

Overview of NoSQL database #DOTC_Mdb

Overview of NO SQL Database.

Hello Everyone,

Today we will discuss about NO SQL database which is very popular nowadays. Before NOSQL database go through my previous blog for other IT related topics. As we know SQL follows RDBMS but NoSQL database not follows RDBMS concept. NOSQL means "not only SQL" are non tabular, and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. NOSQL provide flexible schemas and scale easily with large amounts of data and high user loads. In present day, as we are handling huge amount of data, data being organized and well-structured actually creates a problem, especially at extremely large volumes.

Structured approach of RDBMS database like SQL slows down performance as data volume or size gets bigger and it is also not scalable to meet the needs of Big Data. So NoSQL was conceived as a completely different framework of databases that allows for high-performance, agile processing of information at a much bigger scale. This is the database well-adapted to the high demands of big data. Version of NoSQL runs the database MongoDB, which stores unstructured data. This means that you don’t need to know in advance exactly what kind of data you’ll be collecting and storing. You can collect a lot more data of different kinds and can access and analyze data much faster.NoSQL is centered on the concept of distributed databases, where unstructured data may be stored across multiple processing nodes, and often across multiple servers.

Benefits of NOSQL database :

Handle large volumes of data at high speed with a scale-out architecture.

Store unstuctured, semi-structured, or structured data.

Take full advantage of the cloud to deliver zero downtime.

Enable easy updates to schemas and fields.

Developer friendly.

SQL vs NOSQL

1. SQL is relational database whereas NOSQL are non relational database

2. SQL databases are vertically scalable, NoSQL databases are horizontally scalable.

3. SQL databases uses structured query language and have a predefined schema whereas NoSQL databases have dynamic schemas for unstructured data.

4. SQL databases are better for multi-row transactions whereas NoSQL are better for unstructured data like documents.

5. SQL databases are mainly table based, while NoSQL databases stores document, key-value, graph or wide-column stores.

This is the overview of NOSQL database and nowadays NOSQL database highly used where data is big , but SQL databases provide great benefits for transnational data whose structure doesn't change frequently and where data integrity is paramount. It's also best for fast analytical queries. NoSQL databases provide much more flexibility and scalability, which lends itself to rapid development and iteration.

In big industry still SQL is used as it follows RDBMS concept and uses databases like Oracle, Sybase, DB2 etc whereas NON SQL uses Mongo Database which provide more flexibility, but still SQL and PL/SQL mostly uses in Banking and telecom domain.

Please go through this blog and let me know if you have any doubts. Blogs related to SQL , PL/SQL and other IT related topics you can explore it in my archive folder. In next blog I will come up with next interesting topic.

Thanks.

SQL and Classification of SQL in Oracle Database #Diksha Oracle Training Centre

SQL and Classification of SQL in Oracle Database. SQL is Structured Query Language , which is used for storing, manipulating and retrieving data stored in a relational database .SQL is the standard language for RDBMS. All the Relational Database Management Systems (RDMS) like Oracle, MySQL, Sybase, Informix, IBM DB2 and Microsoft SQL Server use SQL as their standard database language. Oracle is one of the more secured database as compared to other databases. Importance of SQL : SQL and PL/SQL is a backend process where all data is stored and retrieved in GUI which created either by any programming languages like Java, C++, PHP etc. so we need to have very secure database so that there will be no impact for users. SQL allows users to access data in the relational database management systems. SQL is used to communicate with a database.SQL and PL/SQL allows users to create and drop databases tables , views , stored procedures , functions , packages , trigger etc. SQL allows

Materialized View uses and Benefits in Database #DOTC_Mdb

Materialized View uses and Benefits in Database. Hello Everyone, Today we will discuss about Materialized view as it’s play important role in database. We already discussed about Simple Views and complex views in my previous blog. Before Materialized view go through my previous blog which related to simple view. https://dheeraj60.blogspot.com/2020/05/benefits-of-creating-and-using-view-in.html As we know View is not a database object and not like table which is stored in database, but view can be created from base table a view is an SQL statement that’s stored in the database. This statement, or view, has a name.A view looks and acts a lot like a table. It has columns and rows, and can be included in SELECT queries just like a table. In other word we can say View is a virtual/logical table which is basically used for security purpose. Let’s understand about Materialized view : A materialized view is a view that stores the results of the view’s query. Whenever you query the ma

Diksha IT Training Centre

Search This Blog