Brainscape's Knowledge GenomeTM

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


See full index

Middleware > prova > Flashcards

prova Flashcards

1
Q
  • What are the 3 conceptual layers?
A

presentation layer, application layer, resource manager layer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  • Pros and cons TOP-down approach?
A

pro: focus on high level goals, addresses functional and non-functional requirements
con: can only be applied if the IS is developed from scratch

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  • Explain bottom-up approach:
A

1 - define access channels and client platforms
2 - examine existing resources and their functionality (RM layer)
3 - wrap existing resources, integrate them into consistent interface (AL layer)
4) adapt output of AL for client (P layer)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  • why is bottom-up a good approach?
A

Design focuses on integration/reuse of existing (legacy) systems/applications. It is not an advantage to use it, but a necessity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q
  • Name the 4 distribution alternatives (understand them all):
A

transaction as unit of distribution, application as unit of distribution, db operation as unit of distribtuion, middleware controls distribution

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

transaction as unit of distribution pros and cons:

A

pro: simple and easy solution. works in heterogeneous environments
cons: inflexible, limited scope, transaction restricted to single node

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

application as unit of distribution. Pros and cons:

A

pros: locaIIty processing. Supports application reuse.
cons: inflexibility regarding data access operations. Complex program model. db access operations cannot reach across multiple nodes\

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

db operation as unit of distribution. Pros and cons:

A

pro: high flexible for data access
con: increase communication onverhead, program model complexity

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

middleware controls distribution:

A

pros: high flexible data access,simple and powerful programing model
cons: increased communication overhead, schema integration required

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
  • what are the five components of CORBA ?
A

transactional client, transactional server, recoverable server, object request broker, transactional service (OTS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q
  • in the corba, which components receive prepare command?
A

transactional service (OTS) and recoverable server

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q
  • what are the 3 approaches for coupling database and programming language?
A

static embedded sql, dynamic embedded sql, and call level interface CLI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q
  • why is SQLJ binary portable?
A

java is a platform independent language. The use of SQLJ-precompiler/translator avoids DBMS-SPECIFIC precompiler technology. Therefore, compiled SQLJ application is portable.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q
  • which coupling database approach jdbc uses?
A

CLI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q
  • Which approaches sqlj uses?
A

embedded sql with binary portability

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q
  • which approach uses early query compilation and is vendor-specific?
A

static-embedded sql

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q
  • explain how the components of db-gw support access to multiple database at the same time:
A

the Driver Manager manages interactions between Applications and Drivers and it is capable of realize n:m-relationship between application and drivers. It loads the drivers for the multiple databases and it maps the data sources to the drivers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q
  • PROS call-level interface (cli) static, and dynamic sql
A

pros: avoids vendor-specific pre-compiler (binary portable program)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q
  • PROS AND CONS static embedded sql (early query compilation)
A

pro: performance
con: vendor specific pre-compiler. Code resulting from pre-compiler is not portable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q
  • CONS dynamic embedded sql (late query compilation)
A

con: vendor specific pre-compiler. Code resulting from pre-compiler is not portable

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q
  • explain the difference between orthogonal persistence and independence persistence
A 
in orthogonal persistence the persistence is independent of data type, class. Instances of the same class may be transient or persistent.
Independence persistence, also known as transparent persistence, the code operating on transient and persistent objects is basicaly the same. There is no impact on the client object when interacting with persistent objects. There is no special codign for implementing persistence.
22
Q
  • what are the 2 peristent components for entity beans?
A

Bean Manager Persistence (BMP)

CMP

23
Q
  • which mechanism requires developers to write the code for the database access call?
A

Bean manager persistence - BMP

24
Q
  • WSDL - which sub-element contains the address of the service’s location?
A

endpoint

25
Q
  • WSDL - which subelement refers to the protocol for message transport?
A

binding

26
Q
  • WSDL - what XML standard is used to specify the type element?
A

XMLSchema

27
Q
  • WSDL - what are the protocols that can be used with SOAP?
A

SOAP is transport independent. Any protocol: HTTP, HTTPS, SMTP…

28
Q
  • what are the elements of a SOAP message?
A

root element:Envelop

sub elements: fault, header, and body elements

29
Q
  • which element is mandatory to exist in a SOAP message
A

body element

30
Q
  • WHAT are the 4 techniques to manage sessions?
A

HTTP authentication, cookies, hiding fields in forms, URL enconding

31
Q
  • describe pros and cons from the 4 techniques to manage session:
A

hiding fields in form: pro: supported by every browser and browser configuration. con: increase complexity of the application and the response time suffers.
http authentication: adv: automatically supported by browsers and web-servers. cons: user registration and authentication before every session
cookies: adv.: automatically included in web server interaction by the browser. disadv: it can be disabled by the browser
url encoding: adv: supported by all browsers and configurations. disadv: realization is complex. personalized url is not user friendly.

32
Q
  • name advantages and disadvantages of asynchronous transaction processing compared to synchronous single transaction:
A

advantages of asynchronous: If the server is down or a connection error occurs, the client can keep processing and putting messages on the queue. it is easier to implement load balance. It’s possible to create a prioritization of the requests
disadvantages: requests may not be directly authorized and executed. The server response can take more time to return to client.

33
Q

Question: Sometimes we lazy replication with a very long delay practiced (eg 8h). Describe a scenario where did makes sense .

A

?

34
Q
  • name 3 approaches to realize change data capture:
A

snapshot, log based, trigger based, audit columns

35
Q
  • CUPID schema-element named AvgRoomPricePerNight. Name and perform the 4 steps to normalize it:
A

tokenize: avg room price per night
expand: average room price per night
eliminate: average room price night
tagging: average (static) room (hotel) price (money) night (time)

36
Q
  • SCHEMA INTEGRATION: name the four properties that a integrated schema should have and describe how it can be violated
A

minimal, complete, correct, intelligible

37
Q
  • why ACID is too strict for a complex workflow? what are the alternatives to support transactions in workflow?
A

only appropriate for individual activities or restricted subset of activities (atomic spheres)

38
Q
  • describe the schema reference architecture for the federated DBMS:
A

external schema, federated schema, export schema, component schema, local schema

39
Q

Name the 6 types of heterogeneity and explain them:

A

Technological heterogeneity, data model heterogeneity, schematic heterogeneity, structural heterogeneity, syntatic heterogeneity, semantic heterogeneity

40
Q

Pick ONE appropriate distribution alternative (1..4) for each approach of unit of distribution: DataBase Gateway, Web-Service, Federated DBMS, RMI/RPC, TP Monitor

A

db gw: db operation
federated dbms: middleware as unit of distribution
TP Monitor: middleware controlling distribution
RMI/RPC - application as unit of distribution
Corba: application as unit of distribution
web-service: application as unit of distribution

41
Q

Name 3 database gateways coupling approaches and say if each of them: code or binary compatible, early or late compiled

A

Static embedded sql (early compiled, source compatible)
dynamic embedded sql (late compiled, source compatible)
call level interface (CLI) (late compiled e binary compatible)

42
Q

Single-master lazy-replication scheme with 1 master and 2 slaves is used
Name advantages and disadvantages

A

Adv: If a connection error occurs or if a slave is down, the master still works. As it uses a master with 2 slaves, it avoids conflicts.
disadvantages: data in replicas may be not updated. Therefore, if updated data is required, you cannot use the slaves as a source to read data.

43
Q

Name 3 advantages and disadvantages of CLI

A

Adv: Portability, uniform data access, flexibility
disadv: performance and increases application complexity.

44
Q

in which states of the Entity_beans life cycle is persistent state managed by entity manager?

A

Managed and removed

45
Q

pessimistic locking

A

requires long read locks to avoid lost updates

46
Q

optimistic locking

A

Does do not guarantee consistent reads, inconsistencies may arises if entities are not protected by a version attribute.

47
Q

Application Server

Name 2 approaches to achieve scalability in terms of processes

A
  • scaling up a server system (caching
    and resource pooling)
  • scaling out by adding more machines
48
Q

application server: Give two examples of pooling

A

stateless bean pooling, DB connection pooling

49
Q

Name and explain an approach that helps scaling stateful session beans

A

Passivation, the bean state is saved on disk so the bean in the memory can be reused by another client

50
Q

Web Service Coordination: What component services are offered by a coordination service?

A

activation service, registration service, and coordination protocols.

Middleware (15 decks)

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