How much of data, structured data, is available in the world? How much data my company is handling? Kilo Byte – 103. Mega Byte – 106, Giga Byte – 109, Tera Byte – 1012, Peta Byte – 1015,, Exa Byte – 1018, Zetta Byte – 1021, Yotta Byte – 1024, … The digital data base is growing in a mind boggling way! Designing these databases is not a joke, is it not?
The recent outburst of Business Intelligence applications use in enterprises, and the way enterprises are getting helped by collecting, analyzing, warehousing and mining data is watched with great curiosity in the knowledge industry. Of all the Business Intelligence subjects we have seen, Data Warehousing is the largest in market size. In addition to the data itself, the technologies, tools, methodologies, hardware, software, storage systems are constituent to this. Let’s see some data warehousing concepts.
Relational database is rooted in theory of normalization, where in both the physical and the logical data are separate. The advantage of RDBMS is that it gives a lot of flexibility in terms of storage of the data. The data can be stored physically and the output given to the user will not be affected.
Relational database is considered a group of two dimensional tables known as relations. Every table consists of rows known as tuples and columns known as domains. The relationship among both tables are made with one column of one table, having the same meaning in the other table, it does not refer to having same value.
The Microsoft SQL based server is a type of relational database management system. The basic query language is the Transact – SQL, which is the implementation of the ISO/ANSI standard SQL (Structured Query Language) used by both Sybase and Microsoft.
The Microsoft SQL server makes use of the variant of the SQL called as the T-SQL, which is implementation of the SQL-92. The T (Transact)-SQL chiefly adds the additional syntax for usage in the stored procedure and affects the language of the transaction support.
One of the biggest challenges that any organization or a business faces is of storage and management of data. The data could be anything and pertaining to anyone – it could be the employee records, sales records, the invoicing details, etc. Computers came across as a boon, to these organizations as it could systematically organize the data and gave the desired outputs required too.