Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Data Management Concepts > Chapter 8 > Flashcards

Chapter 8 Flashcards

(56 cards)

Start Studying
1
Q

What are the Client/Server architectures?

A
  • Networked computing model
  • Processes distributed between clients and servers
  • Client-Workstation (PC, smartphone, tablet) that requests and uses a service
  • Server - Powerful computer (PC/mini/mainframe) that provides a service
  • For DBMS, server is a database server
  • For the Internet, server is a web server
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What are the three application logics in Client/Server systems?

A
  • Presentation Logic
  • Processing Logic
  • Storage Logic
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What are the components of Presentation Logic?

A
  • Input - Keyboard/mouse

Output - Montior/Printer

* This is the GUI Interface *

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the components of Processing Logic?

A
  • I/O processing
  • Business Rules
  • Data Management

* These are Procedures, functions, and programs *

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the components of Storage Logic?

A
  • Data storage/retrieval

*This is DBMS activities*

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is application partitioning?

A
  • Placing portions of the application code in different locations (client vs. server) after it is written.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What are the advatages of application partitioning?

A
  • Improved performance
  • Improved interoperability
  • Balanced workloads
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Two-tier client-server environments example

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Where can processing logic be in a two-tier client-server environment?

A
  • Client (Fat client)
  • Server (thin client)
  • Both (distributed environment
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Three-tier and n-tier client-server environments example

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Where is the processing logic in a three-tier and n-tier client server environment?

A
  • At the application server or Web server
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

In a two-tier database server architectures what is the Client worksation responsible for?

A
  • Presentation logic
  • Data processing logic
  • Business rules logic
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does the server perform in a two-tier database server architecture?

A

All data storage, access, and processing.

  • Typically called a database server

*DBMS is only a server*

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Database server architecture (two-tier architecture) example

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What are the characteristics of two-tier client/server systems?

A
  • Departmental in scope (few users)
  • Not mission-critical
  • Low transaction volumes
  • Common programming languages are Java, VB .NET, C#
  • Interface database via middleware, APIs
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is middleware?

A

Software that allows an application to interoperate with other software without requiring user to understand and code low-level operations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What is an Application Program Interface (API)?

A

Routines that an application uses to direct the performance of procedures by the computer’s operating system.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What are the common database APIs?

A

ODBC, ADO .NET, JDBC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What are the steps for using databases via middleware APIs?

A
  1. Identify and register a database driver.
  2. Open a connection to a database.
  3. Execute a query against the database.
  4. Process the results of the query.
  5. Repeat steps 3-4 as necessary.
  6. Close the connection to the database.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What are the components of a three-tier architecture?

A
  • Client - (GUI interface (I/O processing)) - Browser or Mobile App to access
  • Application server - (Business Rules) - Web Server

Database Server - Data storage - DBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

What is a Thin Client?

A
  • PC just for user interface and a little application processing. Limited or no data storage (sometimes no hard drive)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Generic three-tier architecture example

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

What is a thin client?

Study These Flashcards
A

An application where the client accessing the application primarily provides the user interfaces and some application processing, usually with no or limited local data storage.

24
Q

What is a thin client application?

Study These Flashcards
A

A web browser and the 3-tier architecture involves a Web application.

25
A database-enabled intranet/Internet environment example
26
What are the components of a web application?
- Database Server - Web Server - Application server - Web browser
27
What is the purpose of the database server in a web application?
It hosts the DBMS example: Oracle, SQL Server, Informix, MS Access, MySql
28
What is the purpose of the web server in a web application?
It receives and responds to browser requests using HTTP protocol example: Apache, Internet Information Services (IIS)
29
What is the purpose of the applicatino server in a web application?
The software buidling blocks for creating dynamic web sites example: MS ASP .NET framework, Java EE, ColdFusion, PHP
30
What is the purpose of the Web browser in a web application?
Client programs that sends web requests and receives web pages example: Internet Explorer, Firefox, Safari, Google Chrome
31
What programming languages are used for creating web pages?
- **Hypertext Markup Language (HTML)** - markup language specific for web pages - **Standard Generalized Markup Language (SGML)** - markup language standard - **Extensible Markup Language (XML)** - markup language allowing customized tags - **XHTML** - XML-compliant extension of HTML - **JavaScript/VBScript** - scripting languages that enable interactivity in HTML documents - **XSL and XSLT** - XMS style sheet and transformation to HTML
32
What are static page requests?
.htm or .html requests handled by the Web Server
33
What are dynamic page requests?
- .jsp, .aspx, and .php requests are routed to the application server - Server-side processing by JSP servlet (Java), ASP .NET application (C# or VB), ColdFusion, or PHP - Database access via JDBC, ADO .NET, or other database middleware
34
Example of information flow in a three-tier architecture
35
What are considerations in 3-tier applications?
- **Stored Procedures -** Code logic embedded in DBMS; Improve performance, but propriertary. - **Transactions -** Involve many database updates; Either all must succeed, or none should occur. **- Database connections -** Maintaining an open connection is resource-intensive; Use of connection pooling
36
What are the advantages of stored procedures?
- Performance improves for compiled SQL statements - Reduced network traffic - Improved security - Improved data integrity - Thinner clients
37
What are some of the disadvantages of Stored procedures?
- Programming takes more time - Proprietary, so algorithms are not portable
38
What are the benefits of three-tier architectures?
- Scalability - Technological flexibility - Long-term cost reduction - Better match of systems to business needs - Improved customer service - Competetive advantage - Reduced risk
39
What is cloud computing?
A model for creating ubiquitous, convenient, on-demand access to network services.
40
What are the characteristics of cloud computing?
- On-demand - Broad network access - Resource pooling - Rapid elasticity - Measured service
41
What are the types of cloud computing?
- Infrastucture-as-a-service (IaaS) - Platform-as-a-service (PaaS) - Software-as-a-Service (SaaS)
42
What is Extensible Markup Language (XML)?
A text based markup language (like HTML) - It uses elements, tags, attributes - It includes document type declarations (DTDs), XML schemas, comments, and entity references
43
What revolutionizes the way data is exchanged over the Internet?
XML (Extensible Markup Language)
44
What are four common options for storing XML documents?
- Store XML data in a relational database by shredding the XML document - Store entire XML document in a large field (BLOB or CLOB) - Store the XML document using special XML columns - Store the XML document using a native XML database (non-relational)
45
What does XPath do?
One of a set of XML technologies supporting XQuery development, locating data in XML documents
46
What is XQuery?
An XML transformation language that allows applications to query both relational databases and XML data
47
What is Extensible Stylesheet Language Transformation (XSLT)?
A language used to transform complex XML documents and also used to create HTML pages from XML documents.
48
What can translate a single XML document into both standard HTML and WAP/WML for cell phones without the necessity for two different pages?
Extensible Stylesheet Language Transformation (XSLT)
49
What is a set of emerging XML-based standards that define protocols for automatic communication between software programs over the web?
Web Services
50
What is a standard for creating a distributed registry of Web services?
Universal Description, Discovery, and Integration (UDDI)
51
What is an XML-based grammar for describing a Web Service and specifying its public interface?
Web Services Description Language (WSDL)
52
What is an XML-based communication protocol for sending messages between applications over the Internet?
Simple Object Access Protocol (SOAP)
53
Web Service protocol stack example
54
What is service oriented architecture (SOA)?
A collection of services that communicate with each other, usually by passing data or coordinating a business activity.
55
What is a new paradigm for IT application development, based mostly on Web service?
Service Oriented Architecture (SOA)
56
What are the benefits of Service Oriented Architecture (SOA)?
- Loosely coupled, highly interoperable components - Leads to flexibility and shorter development time

Data Management Concepts (12 decks)

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