Page 170 - DCAP609_CLOUD_COMPUTING

Unit 11: Collaborating on Database Storage and Sharing Files

Objectives Notes

After studying this unit, you will be able to:

Discuss Web-based database management
Explain Web-based databases
Describe the cloud storage
Explain online file-storage and sharing services

Describe online bookmarking services

Introduction

A collection of information organized in such a way that a computer program can quickly select
desired pieces of data.
Traditional databases are organized by fields, records, and files. A field is a single piece of
information; a record is one complete set of fields; and a file is a collection of records. For
example, a telephone book is analogous to a file. It contains a list of records, each of which
consists of three fields: name, address, and telephone number.
An alternative concept in database design is known as Hypertext. In a Hypertext database, any
object, whether it be a piece of text, a picture, or a film, can be linked to any other object.
Hypertext databases are particularly useful for organizing large amounts of disparate
information, but they are not designed for numerical analysis.

To access information from a database, you need a Database Management System (DBMS). This
is a collection of programs that enables you to enter, organize, and select data in a database.

11.1 Understanding Database Management

A database accessible to clients from the cloud and delivered to users on demand via the Internet
from a cloud database provider’s servers. Also referred to as Database-as-a-Service (DBaaS),
cloud databases can use cloud computing to achieve optimized scaling, high availability, multi-
tenancy and effective resource allocation.

11.1.1 How Databases Work?

Data and applications are stored on a hard drive or a series of hard drives and other media.

All of this storage is managed by the operating system.
The operating system, Windows in this case, handles all of the low level tasks associated
with running applications as well as managing storage.
SQL Server runs on top of Windows. SQL Server is actually dozens of modules (separate
pieces of software). Each module is called when needed. The process is so seamless we are
seldom aware of it.

The diagram has been simplified to show only the query processor and security. The
query processor translates SQL into a form of code the other server modules can use.

LOVELY PROFESSIONAL UNIVERSITY 165