Code 2 Learn

Indexes in Teradata

2013-04-20T14:21:00.001+05:30

Teradata as we all know is a Relational Database Management System (RDBMS) for the world's largest commercial databases. It is the market leader in Data Warehousing. Its architecture is so designed that it takes advantage of the concept of parallelism. Almost every Database has what we know as KEY i.e. Primary Key, Foreign Key etc defined while implementing the DDL of a table. But in

Google plus for companies, soon allowed the nicknames

2013-03-20T10:52:00.001+05:30

In anticipation of the company profiles + Google opens up to nickname Google has announced that on your social network will soon be possible to sign up using nicknames or pseudonyms, a step towards the company profiles on Google plus. The social network Google Plus still under the spotlight, after the announcements (more or less truthful) about

QuickSort Algorithm Tutorial

2013-02-11T11:44:00.001+05:30

We have already done tutorial on Merge Sort and a tutorial on Heap Sort (Array Based) with both having a time complexity of O(n*log n). Here is another algorithm which has a time complexity of O(n*log n) and it's called QuickSort. QuickSort as we all know has a similar approach to Merge Sort i.e. it uses Divide-and-Conquer recursive algorithm to sort the values. The difference being is it's

Binary Search Tree (BST) Algorithm Tutorial

2013-02-10T17:51:00.002+05:30

Earlier we had a tutorial on Binary Seach Tree Basics, which you can check for refreshing the knowledge about it. Today we will be taking a look on BST algorithm and implementing it using Java. Binary Search Tree is node based binary tree data structure with the following properties: * The Left subtree contains the nodes with keys less than the node's key. * The Right subtree contains the

Data Warehouse Design Approaches

2013-01-06T23:30:00.000+05:30

In our previous posts we have got to learn about Data Warehousing Objects, different kinds of Data Warehouse schemas and Data Warehouse Basics. Now it time we learn about how to build or design a Data Warehouse. Designing or Building of a Data Warehouse can be done following either one of the approaches. These approaches are notably known as: * The Top-Down Approach * The Bottom-Up