Week 2 Flashcards Preview

Database Systems > Week 2 > Flashcards

Flashcards in Week 2 Deck (27)
Loading flashcards...
1
Q

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

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

Benefits of Cloud computing?

A
  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
Q

Risks of cloud computing?

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

Cloud-computing service models?

A
  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
Q

Major components of a DBMS?

A
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.
  1. Query Processor
    Query processor transforms queries into a series of low-level instructions directed by database manager.
  2. 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.
  3. Database Manager (DM)
    DM interfaced with user-submitted application programs and queries.
  4. Catalog Manager
    catalog manager manages access to and maintainsthe system catalog.
  5. File Manager
    file manager manipulates the underlying storage files and manages the allocation of storage space on disk.
6
Q

Components of database manager?

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

sebutkan 4 structures dari oracle logical database?

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

IaaS (infrastructure as a Service)

A
managed by organization:
Applications
Data
Runtime
Middleware
Operating System
managed by provider:
Virtualization
Servers
Storage
Networking
9
Q

PaaS (Platform as a Service)

A

managed by organization:
Applications
Data

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

SaaS (Software as a service)

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

Packaged Software?

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

Cloud Computing adalah?

A

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
Q

Key characteristics of Cloud Computing?

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

Service-Oriented Architectures (SOA)

A

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
Q

Web Services adalah?

A

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
Q

Middleware adalah?

A
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
Q

Characteristics of Teleprocessing?

A
  1. One computer with a single CPU and a number of terminals

2. Processing performed within the same physical computer

18
Q

Characteristics of File-Server?

A
  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
Q

Traditional Two-Tier Client-Server?

A
  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
Q

Three-Tier Client-Server?

A

Advantages:

  1. ‘Thin’ client, requiring less expensive hardware
  2. application maintenance centralized
  3. easier to modify or replace one tier without affecting others.
21
Q

n-Tier Client-Server?

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

Transaction Processing Monitors (TPM)

A
  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
Q

Web services approach uses accepted technologies and standards:

A
  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
Q

Distributed database?

A

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

25
Q

Distributed DBMS?

A

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

26
Q

Characteristics of DDBMS?

A
  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
Q

Data warehousing?

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