[دانه کولانه]

NoSQL Tutorial آموزش نو اس کیو ال

A comprehensive look at the NoSQL database.

Some months ago I had a discussion with NoSQL creator, Carlo Strozzi, regarding the databases.

I should admit, I am an SQL fan! It's hot having the same language, no matter which platform or database
engine is used. He underlined the fact that most SQL engines lack of flexibility and waste system resources
(memory and disk space) because of their multi-platform environment (such as Oracle, DB2, Informix, etc.).

He suggested I have a look at the white paper that inspired him: ``The UNIX Shell As a Fourth Generation
Language'' by Evan Schaffer (evan@rsw.com) and Mike Wolf (wolf@hyperion.com).

Quoting from the above paper:

... almost all [database systems] are software prisons that you must get into and leave the power
of UNIX behind. [...] The resulting database systems are large, complex programs which
degrade total system performance, especially when they are run in a multi-user environment.
[...] UNIX provides hundreds of programs that can be piped together to easily perform almost
any function imaginable. Nothing comes close to providing the functions that come standard
with UNIX.

The UNIX file structure is the fastest and most readily-available database engine ever built: directories may be
viewed as catalogs and tables as plain ASCII files. Commands are common UNIX utilities, such as grep, sed
and awk. Nothing should be reinvented.

NoSQL was born with these ideas in mind: getting the most from the UNIX system, using some commands
that glue together various standard tools. Although NoSQL is a good database system, this is not a panacea for
all you problems. If you have to deal with a 10 gigabytes table that must be updated each second from various
clients, NoSQL doesn't work for you since it lacks of performance on very big tables, and on frequent updates
you must be in real time. For this case, I suggest you use a stronger solution based on Oracle, DB2 or such
packages on a Linux cluster, AS/400 or mainframes.

However, if you have a web site containing much information and more reading occurs than writing, you will
be surprised how fast is it. NoSQL (pronounced noseequel, as the author suggests) derives most of its code
from the RDB database developed at RAND Organization, but more commands have been built in order to
accomplish more tasks.

Installing NoSQL

ادامه را در فایل پی دی اف زیر دانلود کنید
http://www.gpaterno.com/publications...L_Tutorial.pdf