Manjunath Ram Venkat

Welcome to my Blog… On PowerPivot, SQL Server 2012, Business Intelligence, MSBI


3 Comments

Difference between SQL Server and Oracle and Mysql and IBM DB2 and MS access

I was very enthusiastic at some point of time to create my own database but the biggest hurdle as in this case and for anything for that matter was “I did not start”. Anyways I want to thank myself for having not started this. Because some how I sensed that I may get a chance to know about most of the databases in future.

So Eventually I could come across the databases in the order on how I could learn them MS Access 2.0, 97,2000,2003,2007,2010, SQL Server (2000,2005, 2008 R2, 2012(In-Process at the time of writing this Post)), Oracle, MySQL, IBM DB2.

So I had developed an Internal document with comparison of all these databases with respect to various aspects such as The Operating System,Fundamental of RDBMS,Interface,Data Size Limits,Database Capabilities,Data Types,Other Objects,Partitioning,Access Control Functionalities, Functions, Comparison Operator, Case Sensitive, Pattern Matching,  Identity Column,Comment,Characters,Concatenation,Date Specifier and Keyword.

Feel Free to download the Comparison spread sheet from clicking the link below.

Databases_Comparison_By_ManjunathRV

Please let me know if there are any changes required.

Good Luck. Cheers.

Advertisements


Leave a comment

Excel Vs PowerPivot Difference in Sizes of Files

This is the First Blog in my life.

Well I must be using Excel 97 since 1998, when I was in my 10th Grade, Since then I always wondered, why would Excel need so many columns, is there some one in the world who is really going to use so many columns.

Around 2002, when I first came across DBMS, and started creating tables, felt why should I Set Datatype for each field cant Database analyse the Data and assign the database itself.  However in this regard Excel was quite compromising for some extent.  Then I learnt the difference between file Database and Server database around 2004.

Now Especially given the fact that many Databases would themselves restrain providing on an average 1024 columns.

And our Gentleman Spreadsheet Excel 2010 Started giving 16,384 Columns.

Now in 2011, when I first saw the SuperMan PowerPivot, My god He started storing Millions of records with some Mega Bytes.

Then somewhere I happened to read that PowerPivot, Stores its Data in columnar fashion  which is why it takes lesser space than that of MS Excel.

Ok, I thought let me see would Excel also have that behavior, I prepared two Excel Files

1. Only One Row with Values Filled in each Cell, So I could fill from 1 to 16,384. And Saved it. (Saving the Values in Columnar Fashion)

2. Only One Column with Values 1 to 16,384. (Saving the Values in regular Fashion as Rows).

Guess what First Excel File

So there is a difference on 32 KB, for Just One Column with Limited text in it.

Now I got the secret behind PowerPivot File Storage Magic.