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