Week 2 Flashcards Preview

Database Systems > Week 2 > Flashcards

Flashcards in Week 2 Deck (27):
1

common architectures that are used to implement multi-user DBMS?

1. teleprocessing
2. file-server
3. client-server

2

Benefits of Cloud computing?

1. cost-reduction
2. scalability/agility
3. improved security
4. improved reliability
5. access to new technologies
6. faster development
7. large scale prototyping
8. more flexible working practices
9. increased competitiveness

3

Risks of cloud computing?

1. network dependency
2. system dependency
3. cloud provider dependency
4. lack of control
5. lack of information on processing transparency

4

Cloud-computing service models?

1. software as a Service (SaaS):
- software and data hosted on cloud
2. Platform as a Service (PaaS):
- allows creation of web applications without buying/maintaining the software and underlying infrastructure
3. Infrastructure as a Service (IaaS):
- provider offer servers, storage, network and OS to consumers in a single bundle and billed according to usage.

5

Major components of a DBMS?

1. DML Preprocessor
this module converts DML Statements embedded in an application program into standard function calls in the host language. DML Preprocessor must interact with Query Processor to generate the appropriate code.

2. Query Processor
Query processor transforms queries into a series of low-level instructions directed by database manager.

3. DDL Compiler
DDL Compiler converts DDL statements into a set of tables containing metadata. These tables are then stored in the system catalog while control information is stored in data file headers.

4. Database Manager (DM)
DM interfaced with user-submitted application programs and queries.

5. Catalog Manager
catalog manager manages access to and maintainsthe system catalog.

6. File Manager
file manager manipulates the underlying storage files and manages the allocation of storage space on disk.

6

Components of database manager?

1. authorization control
2. command processor
3. integrity checker
4. query optimizer
5. transaction manager
6. recovery manager
7. buffer manager
8. scheduler

7

sebutkan 4 structures dari oracle logical database?

1. tablespaces
2. schemas
3. data blocks
4. extents/segments

8

IaaS (infrastructure as a Service)

managed by organization:
Applications
Data
Runtime
Middleware
Operating System

managed by provider:
Virtualization
Servers
Storage
Networking

9

PaaS (Platform as a Service)

managed by organization:
Applications
Data

managed by provider:
Runtime
Middleware
Operating System
Virtualization
Servers
Storage
Networking

10

SaaS (Software as a service)

managed by organization:
-

managed by provider:
Applications
Data
Runtime
Middleware
Operating System
Virtualization
Servers
Storage
Networking

11

Packaged Software?

Managed by organization:
Applications
Data
Runtime
Middleware
Operating System
Virtualization
Servers
Storage
Networking

12

Cloud Computing adalah?

a model for enabling ubiquitous, convenient, on-demand network access to a shared pool of configurable computing resources that can be rapidly provisioned and released with minimal management effort or service provider interaction

13

Key characteristics of Cloud Computing?

1. On-demand self-service
2. Broad network access
3. resource pooling
4. rapid elasticity
5. measured service

14

Service-Oriented Architectures (SOA)

SOA adalah architecture for building applications that implement business processesas sets of services.
- Loosely coupled and autonomous services
- published at a granularity relevant to the service consumer

15

Web Services adalah?

Web services adalah software system designed to support interoperable machine-to-web service machine interaction over a network. web services share business logic, data, and processes through a programmatic interface accross a network.

16

Middleware adalah?

middleware is a generic term used to describe software that mediates with other software.
6 main types:
1. asynchronous Remote Procedure Call (RPC)
2. synchronous RPC
3. Publish/subscribe
4. message-oriented middle (MOM)
5. object-request broker (ORB)
6. SQL-oriented data access

17

Characteristics of Teleprocessing?

1. One computer with a single CPU and a number of terminals
2. Processing performed within the same physical computer

18

Characteristics of File-Server?

1. connected to several workstations across a network
2. Database resides on file-server
3. DBMS and applications run on each workstation
4. the processing is distributed, typically a local area network (LAN)

Disadvantages:
1. Significant network traffic
2. copy of DBMS on each workstation
3. Concurrency, recovery and integrity control more complex

19

Traditional Two-Tier Client-Server?

1. Client (tier 1) manages user interface and runs applications.
2. Server (tier 2) holds database and DBMS

Advantages:
1. wider access to existing databases
2. increased performance
3. increased consistency

20

Three-Tier Client-Server?

Advantages:
1. 'Thin' client, requiring less expensive hardware
2. application maintenance centralized
3. easier to modify or replace one tier without affecting others.

21

n-Tier Client-Server?

1. three-tier architecture can be expanded to n tiers, with additional tiers providing more flexibility and scalability

22

Transaction Processing Monitors (TPM)

1. Controls data transfer between clients/servers
2. Provides a consistent environment for online transaction processing (OLTP)

Significant advantages:
1. transaction routing
2. managing distributed transactions
3. load balancing
4. funneling
5. increased reliability

23

Web services approach uses accepted technologies and standards:

1. XML (extensible Markup Language)
2. SOAP (Simple Object Access Protocol): communication protocol for exchanging structured information over the Internet based on XML.
3. WSDL (Web Services Description Language): protocol based on XML used to describe and locate a web service

24

Distributed database?

logically interrelated collection of shared data physically distributed over a computer network

25

Distributed DBMS?

software system that permits the management of the distributed database and makes the distribution transparent to user

26

Characteristics of DDBMS?

1. Collection of logically related shared data
2. data split into fragments
3. fragments may be replicated
4. fragments / replicas are allocated to sites
5. sites are linked by a communications network
6. data at each site is controlled by DBMS
7. DBMS handles local apps autonomously
8. Each DBMS is one or more global app

27

Data warehousing?

1. Consolidated / integrated view of corporate data
2. drawn from disparate operational data sources
3. subject-oriented, integrated, time-variant and nonvolatile