Articles read in June 2013
- A Visual Explanation of SQL Joins.
it explains how INNER JOIN and OUTER JOIN work in a visualized way.
- Difference between clustered index and non-clustered index.
A clustered index is like a dictionary, where all words are sorted in alphabetical order in the entire book. A non-clustered index is like an index in the last pages of a book, where keywords are sorted and contain the page number to the material of the book for faster reference.
- What is SOA.
SOA is supposed to solve this(hundreds of separate apps that are insufficiently integrated) by designing every app from the ground up to publish its services in a standardized, cross-platfrom manner so that other apps can access the data and don’t have to duplicate it.