Big Data, Data Warehouses, and Business Intelligence Systems - Database Processing: Fundamentals, Design, and Implementation - page 567

www.ourcompany.com

Figure 12-31
The Cloud Computing
Environment

Hosted Email Server

Customer Computer

Our
company
as
perceived
by our
customers

Hosted Web Server

Customer Notebook
Computer

Hosted Database Server

Customer Tablet

Hosted E-Commerce Server

Of particular interest in AWS are the EC2 service , which provides complete virtual serv-
ers, the DynamoDB database service , which provides a NoSQL data store (discussed later in
this chapter), and the RDS (Relational DBMS Service) , which provides online instances of
Microsoft SQL Server, Oracle Database, and MySQL database services.
At this point, we will use RDS to illustrate how we can use online database services similar
to what we have been doing in this topic. We have created one RDS instance of SQL Server
Express (it is actually SQL Server 2012 Express) named kamssqlex01 . Although hosted by AWS,
if we connect to this DB instance with normal SQL Server management tools, it will appear to
us just like any other SQL Server instance we are running.
Figure 12-32 illustrates this by showing the kamssqlex01 database instance in the
Microsoft SQL Server Management Studio. We have created and populated the VRG database

Figure 12-32
The kamssqlex01 SQL
Server 2012 Express DB
Instance in the SQL Server
Management Studio

The kamssqlex01 DB
instance is Microsoft
SQL Server 2012
Express at AWS

The VRG database
showing the tables

An example SQL
query and results