Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database Systems > Week 2 > Flashcards

Week 2 Flashcards

1
Q

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

A
  1. teleprocessing
  2. file-server
  3. client-server
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

sebutkan 4 structures dari oracle logical database?

A
  1. tablespaces
  2. schemas
  3. data blocks
  4. extents/segments
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

IaaS (infrastructure as a Service)

A 
managed by organization:
Applications
Data
Runtime
Middleware
Operating System
managed by provider:
Virtualization
Servers
Storage
Networking
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

PaaS (Platform as a Service)

A

managed by organization:
Applications
Data

managed by provider:
Runtime
Middleware
Operating System
Virtualization
Servers
Storage
Networking
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

SaaS (Software as a service)

A 
managed by provider:
Applications
Data
Runtime
Middleware
Operating System
Virtualization
Servers
Storage
Networking
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Packaged Software?

A 
Managed by organization:
Applications
Data
Runtime
Middleware
Operating System
Virtualization
Servers
Storage
Networking
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

Database Systems (12 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions