SQL and NoSQL Databases - PART 4

-

To read previous related articles.

Hadoop Eco System Installation - PART 1 




Hadoop Introduction & Terminologies - PART 2



 Big Data Hadoop Eco System handles both SQL and NoSQL databases based on the data source and business application. 
SQL Database
What is SQL database?
SQL stands for Structured Query Language. SQL lets you access and manipulate databases.

Where it is needed?
SQL is important because of the following main reasons -
a. SQL helps you to find the needed information or data easily.
b. SQL is a query language, not a programming language. You can easily write commands almost same as you write English.
c. It quickly stores and gets data from the database quickly. SQL is used for the query, insert, collect and manages data from the database.

d. Almost every database system will need SQL for further processing.

Popular SQL Databases 
MYSQL
Oracle
PostgreSQL
IBM Informix
You can learn more about SQL by reading the various articles listed below:

  1. Introduction To DBMS
  2. SQL For Beginners - Introduction
  3. SQL For Beginners - SELECT Statement
  4. SQL For Beginners - WHERE Clause
  5. SQL For Beginners - Operators
  6. SQL For Beginners - LIKE And IN Clause
  7. SQL For Beginners - DDL Statements
  8. SQL For Beginners - DML Statements
  9. SQL For Beginners - DCL Statements
  10. SQL For Beginners: NULL Values
  11. SQL For Beginners - Aliases
  12. SQL For Beginners: Joins
  13. Top Keyword in SQL

NoSQL Database
What is NoSQL?
NoSQL stand for (Not Only SQL). The term NoSQL was introduced by Strozzi in 1998, it was again reintroduced by Eric Evans in an event organized to discuss the open source distributed databases.

Why NoSQL?
Relational databases like MYSQL, Oracle, IBM Informix etc. have been extensively utilized in the business applications. RDMS can handle only the relational and transactional data. The recent need of web application, e-commerce business applications and social networks were brought the unstructured data based on their needs and business context. This has changed the landscape for data management using NoSQL.  

Characteristics 
NoSQL databases do not use a relational model instead it uses <key, value> pair (schema less model). 
They run well on clusters or distributed file system.
They are open sources

Popular NoSQL Databases
Learn MongoDB
Cassandra
Couch DB

Learn more about wide range of NoSQL Databases

In Hadoop eco system both HBase (is for NoSQL databases) and HDFS (Batch Processing) are the widely used open source framework's for big-data warehouse and processing. Both HDFS and HBase are capable of processing structured, semi-structured as well as un-structured data.
 ‘Stay Tuned for More to Learn’


Comments

Post a Comment

Popular posts from this blog

Krishna University Workshop - Pre Workshop Materials

-
Flashback Recorder Manual https://docs.google.com/document/d/1KgcLS3__tn-6IqAokTHmm1woTOrAhVg_67hbE_7UZlw/edit?usp=sharing Flipped Learning https://www.youtube.com/watch?v=cXe_fUOJIEA&t=331s Course Design Using Web 2.0 https://www.youtube.com/watch?v=0cIl4Am1L0o&t=634s How Mind-Map Helps Learning? https://www.youtube.com/watch?v=vGwD20lbPh4&t=123s How Cognitive Load Theory Helps in Effective Presentation? https://www.youtube.com/watch?v=eh5G7cYdO4Q&t=49s YouTube Channel Link https://www.youtube.com/channel/UCVWJTqAEKFxxaifbXJZ_dqg/videos Blog Articles Electronic Circuit Simulation https://educationforempowerment.blogspot.com/2018/09/electronic-circuit-simulation.html Learn Chemistry with Animations and Simulation Softwares https://educationforempowerment.blogspot.com/2018/08/learning-chemistry-with-animations-and.html Learn Physics with Visuals and Applications - Becomes Meanigful!! https://educationf...
Read more

Hadoop Introduction & Terminologies - PART 2

-
Image
Please refer the previous article for continuity. Click here for the link. https://educationforempowerment.blogspot.com/2018/11/hadoop-eco-systems-part-1.html Fundamentals The foundation of Big Data & Hadoop Eco System lays on Distributed Operating System, Distributed File System, Data Structures and Database Management System. A distributed system is a model in which components on networked computers communicate and coordinate their actions by passing messages.  How does a distributed System Work? Single machine having multiple I/O channels and each channel is cable to stream the data 100MB's. In recent times, distributed systems have been replaced by Hadoop. Hadoop is used to overcome the shortfalls  of distributed systems like high chances of system failure, limited bandwidth and high programming complexity. Hadoop Hadoop is  framework that allows distributed processing of large datasets across clusters of computers using single programming ...
Read more

Loyola Academy Day 1 Recordings

-
LOYOLA Academy - Day 1 Online Workshop Material https://youtu.be/YqzMBhkHmGA Prezi Link https://prezi.com/view/nbSMLXtD1DGrQsR8LIsg/ Google Sheet Link  - List of Software and Tool (more than 100 software) https://docs.google.com/spreadsheets/d/1-ZWuw2lKjmsAKw4Y1GKvWF8aiVxEZrhcDszfi_NKLpc/edit?usp=sharing Flashback Recorder Manual https://docs.google.com/document/d/1KgcLS3__tn-6IqAokTHmm1woTOrAhVg_67hbE_7UZlw/edit?usp=sharing Flipped Learning https://www.youtube.com/watch?v=cXe_fUOJIEA&t=331s Course Design Using Web 2.0 https://www.youtube.com/watch?v=0cIl4Am1L0o&t=634s How Mind-Map Helps Learning? https://www.youtube.com/watch?v=vGwD20lbPh4&t=123s How Cognitive Load Theory Helps in Effective Presentation? https://www.youtube.com/watch?v=eh5G7cYdO4Q&t=49s YouTube Channel Link https://www.youtube.com/channel/UCVWJTqAEKFxxaifbXJZ_dqg/videos Blog Articles Electronic Circuit Simulation https://educat...
Read more