Database Reference
In-Depth Information
For business analytics and reporting, normal SQL Server tools can be used in the cloud,
such as
SQL Server Reporting Services
(
SSRS
); there is reporting on the SQL database
that normally comes with the SQL Server as well as Hadoop. The SQL reporting can be to
the off-premise in similar manner to the on-premise SQL reporting with SSRS. In the off-
premise cloud, there are additional Azure management tools that can be used.
However, working with SQL Server is for medium-size data in the cloud. There is also
Big Data. One might ask, why know Hadoop with NSB? Just as NSB works with SQL
Server today in many solutions, working with NSB with Hadoop in a databus solution will
be the future for moving large data.
Hadoop processes large data and assumes that the data is in BLOBs. It processes data in
parallel by running logic across multiple parallel machines by MapReduce jobs. By pro-
cessing large chunks independently using
Hadoop Distributed File System
(
HDFS
), Ha-
doop also has its own SQL-like query language called Apache Hive Interface (see
ht-
tp://hive.apache.org/
). For non-SQL-like query languages, there is the Pig Latin Hadoop
language called Apache Pig (see
http://pig.apache.org/
).
HDInsight is Microsoft's 100 percent compatible distribution of Hadoop that is managed
in Azure or on the Windows Server, as shown in the following screenshot:
Other than adding a SQL database, we can add three other types of storage:
• A table storage that is based on a key-value No-SQL table format
• A
Binary Large Object
(
BLOB
) storage for binary storage, such as video files
