Articles Read in June

Reading time ~1 minute

Articles read in June 2013

  1. A Visual Explanation of SQL Joins. > it explains how INNER JOIN and OUTER JOIN work in a visualized way.
  2. 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.
  3. 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.