This site is 100% ad supported. Please add an exception to adblock for this site.

APNM403 GOOD

Terms

undefined, object
copy deck
Presentation, Interface, Server, Middleware, Core Processing
The layered services
Application Programming Interface
What API stands for
mom
Technology that facilitates communication between distributed components
Many to Many
A term used to describe that more than one record in one table may have more than one corresponding record in a related table
data, metadata, metamodel
The three components of the information integration architecutre
isolated
What we term transactions that do not expose theri intermediate results to the system.
technical
________ integration architecture is least difficult to control security
servers
Data, Database, Application, .NET, Enterprise Javabean, CORBA, Portal, Business Rules, File, Data Warehouse are all kinds of what
Message Oriented Middleware
What MOM stands for
Channel
The term used to describe the connection between distributed components of the client\server model
Enterprise Information System
What EIS stands for
Consistency
What the C in ACID stands for
null
A character used by Database Management Systems that consumes no channel capacity in distributed transactions.
b2bi
The integration of components or parts of the IT architectures of two or more collaborating enterprises
cohesion
The logical agreement or uniformity that is present in an artifact; SOAI takes advantage of high levels of this when distributing frameworks.
Manatee
The animal that Stephen most closes relates to
Primary Key
One or more fields in a record that uniquely identifies records in that table.
Cardinality
The term used to describe the number of related records one record may have
Network
A record storage model that avoids having to return to the root of the structure to find each record.
randbetween()
The command for getting a random number between two specific values in Excel
TRD
A diagram showing the physical structure of the data being managed.
rand()
The command for getting a random number between 0 and 1 in Excel
Tables
What MS Access delivers to clients when linked remote Access data is requested.
normalization
The process by which optimal data structures are derived for Relational Database Management Systems.
Record
A set of attributes about one single occurrence of an entity
ACID
The set of properties that ensure database transactions go smoothly
Consistency
The characteristic of data that is protected by strong referential integrity enforcement.
&
The symbol that concatenates two or more items in Excel
ERD
A diagram showing the logical relationship of the data within the problem domain
RDC
The thing issued when getting data from a remote server and processing it on the client.
SOAI
An integration strategy that depends heavily on object-oriented technologies.
Instance
A record contains data about one single _______ of an entity.
physical
TRD and _____ model are the same
latency
the characteristic of data that determines how current the information needs to be
Usability
What the U in FURPS stands for
Horizontal
The kind of fragmentation that exists when taking an entire record
participation
The term used to describe whether both records in two related tables have to exist
TPMON
Middleware that preserves transaction integrity.
index()
The command for getting a specific item from a named range in Excel
Entity
Something about which information is needed or desired.
Isolation
What the I in ACID stands for
Frontline Information System
What FIS stands for
Work Group System
What WG stands for
logical
ERD and _____ model are the same
Entity Relationship Diagram
What ERD stands for
System
an integrated set of components, collaborating to achieve a desired result
Call Level Interface
What CLI stands for
Distributed
The type of information processing system that uses a network to connect geographically separate components.
Metadata
Data about data - the specification for the data structure
Throughput
A measure of network utilization, or precent of channel bandwidth used during a transaction.
fieldsize
The number of bytes in a character field, or the number of digits in a numerical one.
IT Infrastructure
Collectively, the components of the information-processing system that support business activities.
Warehouse
A database that contains copies of data found in other databases, usually at some level of aggregation.
Foreign Key
One or more fields in a record that uniquely identifies records in another table.
record
What is a row in a relational database
Relational
A relational storage model that is made of tables comprised of records which have common fields.
datatype
The data specification that defines the type of data to be stored in a field
Access
Microsoft's personal relational database management system
third
The Normal Form in which all non-key fields are related only to all parts of the primary key
Security
The hardest thing to control in IT infrastructures that exploit POAI
field
Storage location for data about one attribute of one single occurrence of an entity
API
The "doorway" through which remote process are accessed.
Management Information System
What MIS stands for
Decision Support System
What DSS stands for
MIS
an application category that is uniquely designed to give summaries of historical data
Database Transaction Processing System
What DBTP stands for
Enterprise Application Integration
What EAI stands for
Create Read Update Delete
What CRUD stands for
Artificial Key
One or more fields in a record that uniquely identifies records in that table, but that have no meaning outside of the Application Processing Logic.
Technical Integration Architecture
the information technology componetns that support the information needs of an enterprise's business systems - data, application programs, client workstations, network, and middleware
Processes
The things BPIOAI makes available to distributed clients.
Durability
What the D in ACID stands for
CLI
The doorway through which remote databases are accessed
Supportability
What the S in FURPS stands for
hierarchical
A data management model in which data is stored in records linked in a "tree".
Fragmentation
The act of distributing parts of a table.
Enterprise Resource Planning System
What ERP stands for
Atomicity
What the A in ACID stands for
Domain
The legal values a field can contain
EAI
The integration of components in an enterprise's internal IT architecture
bottom up
The method of deriving data structures where the necessary data is identified first, then related attributes in entities is collected, and then relationships between entities are defined.
Mandatory
A term used to describe relationships in which a Record in one Table must have a corresponding Record in a related Table.
Middleware
Any technology that facilitates the reliable execution of a distributed transaction
proper()
The command for converting text into a correct format in Excel
Vertical
A type of application intergration in which customized solutions are devised forentire industries.
entities
When designing a database structure look at the _____ first
Integration
The creation of a whole from it's parts
"BIG HOMO" PORTER
The gay author of the Value Chain model who is a flaming homosexual
method
A piece of a process that may be distributed and invoked by clients as needed
Laying Eggs
How Stephen reproduces
Layered Services
Presentation, Interface, Server, Middleware, and Core Processing are all what
DBTP
The application category that exhibits the highest demand for transaction process monitoring
RPC
What is executed when data is sent to a remote sever for processing.
Vertical
The kind of fragmentation that exists when taking an entire field
RMI
The thing issued to a remote serer when information can be produced primarily from data within that remote servers domain.
Performance
What the P in FURPS stands for
Broker
A component in a system that manages the passing of transaction requests to distributed servers, and results to distributed clients
Portal
What the "P" in POAI stands for.
Table Relationship Diagram
What TRD stands for
ODBC
Microsoft's data-oriented protocol for connecting heterogenous databases.
IOAI
An integration strategy in which the data used in an enterprise is stored once and made available to all clients that need to use it.
Reliability
What the R in FURPS stands for
Functionality
What the F in FURPS stands for
Coupling
The degree to which two things are dependent upon each other, the Relational Data Model facilitates low levels of this.
point to point
Middleware that facilitates connections between known participants.
Remote Process Call
What RPC stands for
relationships
The metamodel is also known as the _______
Information
data in context
Remote Data Call
What RDC stands for
queues
The devices used by MOM to support asynchronous connections
SQL
The most common protocol for connecting Oracle to other distributed relational database management system.
synchronous
The type of middleware that prevents processing until the server responds to that request
top down
The method of deriving data structures where you start with entities, assign attributes to the most appropriate entities and then define relationships between the entities
Remote Method Invocation
What RMI stands for

Deck Info

114

permalink