Vocabulary - Word Group 1

Word Group : Abbreviated Communication

NO
Word
Meaning
Sentence
1
Abridge
1.     Shorten without loosing any sense
2.     Curtail a right or privilege
An abridged text of his speech
2
Compendium
Collection of concise but detail information of particular subject
An invaluable compendium of useful information about particular language
3
Cursory
Hasty and therefore not thorough or detailed
A cursory glance at the figures
4
Curtail
Reduce in extent or quantity
Civil liberties were further curtailed
5
Syllabus
1.     The subjects in a course of study or teaching.
2.     A summary of points
There is not time to cover whole syllabus
6
Synopsis
A brief summary or general survey of something
A synopsis of the insurance cover provided is summarised below
7
Terse
Sparing the use of words; abrupt.
Laconic or succinct
He issued a terse warning.



Posted by No comments:
Labels: , , , ,

SQL vs NOSQL

Sr No
SQL
NOSQL
1
SQL databases provide store of related data tables
NOSQL databases store JSON-like filed value pair documents
2
SQL tables create a strict data template, so it’s difficult to make mistakes
NoSQL is more flexible. It can store any data anywhere which leads to consistency issues.
3
SQL has schema information such as primary keys, indexes and relationships.
In NoSQL data can be added anywhere anytime. There is no need to specify document design. NOSQL generally adds id value automatically to each document.
4
When data requirement is clear SQL is more suitable
When data requirement is not clear NOSQL is more suitable
         
5
SQL enforces data integrity rules using foreign key constraints
Ideally one documents has all the information.
6
SQL transactions ensure that either all operations are successful or failed.
Updating document is atomic. But there are no transaction equivalent of updating multiple documents
7
SQL is lightweight declarative language

For example :

INSERT INTO book (
  `ISBN`, `title`, `author`
)
VALUES (
  '9780992461256',
  'Full Stack JavaScript',
  'Colin Ihrig & Adam Bretz'
);
UPDATE book
SET price = 19.99
WHERE ISBN = '9780992461256'
NOSQL queries are JSON-like.

For example :

db.book.insert({
  ISBN: "9780992461256",
  title: "Full Stack JavaScript",
  author: "Colin Ihrig & Adam Bretz"
});










db.book.update(
  { ISBN: '9780992461256' },
  { $set: { price: 19.99 } }
);
9
A well-designed SQL database will almost certainly perform better than a badly designed NoSQL equivalent and vice versa.
Generally NOSQL is faster than SQL
10
To distribute load on multiple servers is tricky in SQL
Very easy to scale
11
SQL faces less issues as compared to NOSQL
System admins has less experience to NOSQL databases which lead to security or system problems.
12
Where to use SQL:

  1. Data requirement is known
  2. Data integrity is essential
Where to use NOSQL:

 1. Evolving data requirement
  2. Speed and scalability is imperative


Posted by 1 comment:
Labels:
Subscribe to: Posts (Atom)