-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy patharticle-sql.html
More file actions
155 lines (146 loc) · 9.94 KB
/
article-sql.html
File metadata and controls
155 lines (146 loc) · 9.94 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.13.1/css/all.css" integrity="sha384-xxzQGERXS00kBmZW/6qxqJPyxW3UR0BPsL4c8ILaIWXva5kFi7TxkIIaMiKtqV1Q" crossorigin="anonymous">
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" media="screen and (max-width: 1000px)" href="css/mobile.css">
<link rel="stylesheet" media="screen and (min-width: 1001px)" href="css/widescreen.css">
<link rel="apple-touch-icon" sizes="180x180" href="/apple-touch-icon.png">
<link rel="icon" type="image/png" sizes="32x32" href="/favicon-32x32.png">
<link rel="icon" type="image/png" sizes="16x16" href="/favicon-16x16.png">
<link rel="manifest" href="/site.webmanifest">
<title>technovera | SQL</title>
</head>
<body>
<nav id="nav">
<div class="nav-container">
<img src="img/logo.png" alt="newsgrid logo" class="logo">
<img src="img/logo-dark.png" alt="newsgrid logo" class="logo-dark">
<div class="social">
<a href="https://facebook.com" target="blank"><i class="fab fa-facebook fa-2x"></i></a>
<a href="https://twitter.com" target="blank"><i class="fab fa-twitter fa-2x"></i></a>
<a href="https://instagram.com" target="blank"><i class="fab fa-instagram fa-2x"></i></a>
<a href="https://youtube.com" target="blank"><i class="fab fa-youtube fa-2x"></i></a>
</div>
<ul>
<li><a href="index.html">Home</a></li>
<li><a href="about.html">About</a></li>
</ul>
</div>
</nav>
<section class="article-header">
<div id="article-sql">
</div>
</section>
<section id="article" class="">
<div class="container max-width">
<article class="card">
<div class="">
<h1 class="l-heading">
SQL vs NoSQL Databases: What’s The Difference?
</h1>
<div class="meta">
<small>
<i class="fas fa-user"> Written By Dinesh July 20, 2020</i>
</small>
<div class="category category-api">API</div>
</div>
<h2 class="m-heading mt-1">What is SQL?</h2>
<p>SQL (Structured Query Language) is a programming language that is used to manage data in relational databases. Relational databases use relations (typically called tables) to store data and then match that data by using common characteristics within the dataset. Some common relational database management systems that use SQL are Oracle, Sybase, Microsoft SQL Server, Access, and Ingres.</p>
<p>Cobb’s breakthrough paper describes a database where objects could be constructed and queried using something he called SQL, structured query language. He used SQL to create both data (in objects called tables) and the schema for that data, which describes fields in columns. A single record in a SQL database is called a row.</p>
</div>
<div>
<h2 class="m-heading">What is NoSQL?</h2>
<p>A NoSQL database, on the other hand, is self-describing, so does not require a schema. Nor does it enforce relations between tables in all cases. All its documents are JSON documents, which are complete entities that one can readily read and understand. NoSQL refers to high-performance, non-relational databases that utilize a wide variety of data models. These databases are highly recognized for their ease-of-use, scalable performance, strong resilience, and wide availability. NoSQL database examples include MongoDB, MarkLogic, Couchbase, CloudDB, and Amazon’s Dynamo DB.</p>
</div>
<div>
<h2 class="m-heading">Major Differences
</h2>
<p class="">There are many differences between SQL and NoSQL, all of which are important to understand when making a decision about what might be the best data management system for your organization. These include differences in:</p>
<ul class="article-list">
<li>Language</li>
<li>Scalability</li>
<li>Community</li>
<li>Structure</li>
</ul>
</div>
<div>
<h2 class="m-heading">The Language</h2>
<p>
One of the major differences between SQL relational and NoSQL non-relational databases is the language. As mentioned, SQL databases use Structured Query Language for defining and manipulating data. This allows SQL to be extremely versatile and widely-used — however, it also makes it more restrictive. SQL requires that you use predefined schemas to determine the structure of your data before you even begin to work with it. Your data must also follow the same structure as well, which can entail significant upfront preparation along with careful execution.
</p>
<p>A NoSQL database features a dynamic schema for unstructured data and the data can be stored in many different ways, whether it be graph-based, document-oriented, column-oriented, or organized as a KeyValue store. This extreme flexibility allows you to create documents without first having to carefully plan and define their structure, add fields as you go, and vary the syntax from database to database. It also allows you to give each document its own unique structure, providing you with more freedom overall.
</p>
</div>
<div>
<h2 class="m-heading">Efficiency and Normalization</h2>
<p>
One thing that Oracle stressed was the relationship between objects. They said that all data should be normalized. This means no data should be stored twice. So instead of putting, for example, the school address in every student record, it would be better to maintain a school table and store the address there. NoSQL databases have gotten rid of this constraint, to a certain degree.
</p>
<p>Disk space was expensive in the 1970s and so was memory, so normalization made sense. But it can take some time to do a joint operation to bring together a record that is stored in different tables into one logical unit. It also requires the overhead of maintaining index files and writing to those as data is added or deleted</p>
<p>
NoSQL databases say all that does not matter as disk space and memory are cheap. Proponents of that say it is okay to, regarding the aforementioned case, put the school address in with the student. This speeds data retrieval time and makes coding easier.
</p>
</div>
<div>
<h2 class="m-heading">Conclusion</h2>
<p>No matter what field you are in, choosing the correct database for your organization is an important decision. NoSQL databases are quickly becoming a major part of the database landscape today, and they are proving to be a real game-changer in the IT arena. They have numerous benefits, including lower cost, open-source availability, and easier scalability, which makes NoSQL an appealing option for anyone thinking about integrating in Big Data. They are a young technology, however, which makes them slightly more volatile.</p>
<p>On the other hand, SQL databases have proven themselves for over 40 years and use long-established standards that are well defined. They have a huge community of experts behind them, and the opportunity for collaboration is limitless.</p>
<p>Overall, the decision of using SQL versus NoSQL for business is not entirely black and white; it requires some comparing and contrasting to determine which database best fits your specific needs. With the proper amount of research and preparation, however, you will ensure that the database you choose provides an efficient and streamlined management system for your organization.</p>
</div>
</div>
</section>
<!-- footer -->
<footer id="footer" class="pt-1">
<div class="container footer-container">
<div>
<img src="img/logo.png" alt="logo light" class="footer-logo">
<img src="img/logo-dark.png" alt="logo dark" class="footer-logo-dark">
<p>technovera is a leading technology media property, dedicated to obsessively profiling web technologies tech news.</p>
</div>
<div>
<h3>EMAIL NEWSLETTER</h3>
<p>Sign Up to our Newletter for latest new and more awesome content!</p>
<form name="contact" action="POST" data-netlify="true">
<input type="email" name="email" placeholder="Enter Email" id="email">
<input class="btn btn-primary subscribe" type="submit" value="Subscribe">
</form>
</div>
<div>
<h3>CATEGORIES</h3>
<ul class="list">
<li><a href="#"><i class="fas fa-chevron-right"></i> React</a></li>
<li><a href="#"><i class="fas fa-chevron-right"></i> JavaScript</a></li>
<li><a href="#"><i class="fas fa-chevron-right"></i> Angular</a></li>
<li><a href="#"><i class="fas fa-chevron-right"></i> Mern</a></li>
</ul>
</div>
<div>
<h3>Follow Us On</h3>
<div class="social">
<a href="https://facebook.com" target="blank"><i class="fab fa-facebook fa-2x"></i></a>
<a href="https://twitter.com" target="blank"><i class="fab fa-twitter fa-2x"></i></a>
<a href="https://linkedin.com" target="blank"><i class="fab fa-linkedin fa-2x"></i></a>
<a href="https://instagram.com" target="blank"><i class="fab fa-instagram fa-2x"></i></a>
<a href="https://youtube.com" target="blank"><i class="fab fa-youtube fa-2x"></i></a>
</div>
</div>
<div>
<p>Copyright © 2020, All Rights Reserved</p>
</div>
</div>
</footer>
<script>
var headerBg = document.getElementById('article-sql');
window.addEventListener('scroll', function(){
headerBg.style.opacity = 1 - +window.pageYOffset/550+'';
headerBg.style.top = +window.pageYOffset+'px';
headerBg.style.backgroundPositionY = - +window.pageYOffset/2+'px';
});
</script>
<script src="https://cdn.jsdelivr.net/npm/darkmode-js@1.5.6/lib/darkmode-js.min.js"></script>
<script src="js/dark-mode.js"></script>
</body>
</html>