Database Reference
In-Depth Information
Table 1.1
Windows Azure SQL Database Components
Components
Descriptions
Database
SQL Database
It is used for storing, processing, and
securing data. It includes tools for the
management of relational and XML data.
Reporting Services
Reporting Services is used for developing,
managing, and deploying tabular, matrix,
and graphical reports.
Data Access
Data Access is used by database
applications for moving, copying, and
transforming data in and out of databases.
Management Tools
SQL Server
Management Studio
SSMS is an integrated environment used
to access, conigure, manage, administer,
and develop components of SQL
Database.
Security Management
It provides tools for coniguring access to
database servers, databases, and database
roles.
Deployment
Management
It deploys the databases and database
applications from the on-premises SQL
Server to the cloud.
Connectivity
Components
This tool provides the database accessing
tools for managing the communication
between clients and servers.
Database Server
SQL Database Server
It hosts databases, manages database
log-ins, establishes connections, speciies
database locations, and sets up irewalls.
Databases
: As shown in Figure 1.1, there are some databases in SQL Server. he data stored in a
database are systematically arranged so that they can be retrieved with some kind of query language.
Database professionals can use the tools provided by a DBMS to manage and analyze the data stored
in a database. Each database consists of objects such as tables, views, and stored procedures.
Tables
: As shown in Figure 1.2, in a database, the data are stored in tables. he data related
to the same subject are stored in the same table. A table is constructed with columns and rows.
Each column represents an attribute that is used to describe the subject. For example, the column
LastName in Figure 1.2 is the attribute used to describe the subject STUDENT. Here, the table
STUDENT is one of the tables created in the database Class_Registration. Normally, a database
contains multiple tables, each related to a subject with its information stored in the database.
Views
: Similar to a table, a view is also a database object. It collects data from tables. Sometimes,
a database application may need data from multiple tables. Instead of searching these data during
an operation, the data are often preselected and stored in a database object called a view, as shown
in Figure 1.3. A view serves as intermediate storage between tables and database applications.
Using views can improve the performance and security.
