Databases

SQL is an ANSI (American National Standards Institute) standard. SQL stands for Structured Query Language. This language is used to access / communicate with a database. A database is an organised collection of data usually in digital form. Though SQL was originally developed by IBM, and first made commercial by Relational Systems (now part of Oracle), almost all database software vendors support SQL while adding their own SQL extensions.

Continue reading →

The relational database (RDBMS) is known to us. But, today, non-relational, “cloud,” or “NoSQL” databases are gaining mindshare as an alternative model for database management. In this article, we’ll look at the key aspects of these non-relational NoSQL databases.

RDBMS

As we saw in the Expertstown article on Oracle Basics, there are definite advantages of going in for relational database management system. Some of the best known RDBMS are:

Continue reading →

Simply put, unstructured data is something that is not available in our company’s databases like SQL (see SQL basics), Oracle (see Oracle basics), etc., so called structured RDBMS. Business Intelligence cannot afford to take in to account only structured data. One of the estimates predicts that the digital world has more than 80% of Unstructured Data. And so, it is important to look at the value residing in the unstructured data.

Continue reading →

In the earlier Expertstown articles, we have explained about Data Warehousing and Data Warehousing concepts in brief. We see that over a period of two decades, Data Warehousing has thrived in enterprises well. We can see that data warehousing is also evolving fast as other enterprise technologies. In line with web 2.0, enterprise 2.0 etc., this can be termed as data-warehouse 2.0 or DW 2.0.

Continue reading →

How much of data, structured data, is available in the world? How much data my company is handling? Kilo Byte – 10³. Mega Byte – 10⁶, Giga Byte – 10⁹, Tera Byte – 10¹², Peta Byte – 10^15,, Exa Byte – 10^18, Zetta Byte – 10^21, Yotta Byte – 10^24, … The digital data base is growing in a mind boggling way! Designing these databases is not a joke, is it not?

Continue reading →