Exam 2

Exam #2 will cover chapters 5, 6, 8, and 9 from the Stair book and related online lectures.

The following topics should be given extra attention:

ODBC: Ensures that softwares can be used with any compliant database; exports, imports, or links tables between different applications
Hierarchy of data: Formed by bits, character, fields, records, files, and databases
Data modeling techniques: Building databases requires 2 types of designs; Logical Design, Physical Design
DBMS (Database Management Systems) Programs used as an interface between a database and application programs or a database and user Types- Flat file, Single user, Multiple users
Data mining : An information-analysis tool that involves the automated discovery of patterns and relaionships in a data warehouse; supports data analysis and decision making
Data marts: A subject of data warehouse devoted to specific purposes of functional business areas
Transaction processing
Transaction processing activities
OLTP (Online Transaction Processing): Processed immediately, without the delay of accumulating transactions into a batch
OLAP (Online Analytical Processing): Supports data analyssis and decision making; top-down, query-driven data analysis; must be very knowledgeable of the data and its business context
synchronous vs. asynchronous: – Synchronous: the receiver gets the message instantaneously; Asynchronous: the receiver gets the message some period of time after it is sent
data transfers
telecommunications: Electronic transmission of signals for communications via telephone, radio, television, etc.
modems: A device that translates data from digital to analog and analog to digital
multiplexers: Allow several telecommunications signals to be transmitted over a single communications medium at the same time
front-end processors:Special-purpose computers that manage communications to and from a computer system; connects a midrange or mainframe to hundreds or thousands of communication lines
common carriers: Local Exchange Carrier (LEC)- Public phone company, Competitive Local Exchange Carrier (CLEC)- compete with LEC's, Long-Distance Carrier- Sprint, MCI
topology: Logical model that describes how networks are structured or configured
LAN types
OSI model
B2B (Business to Business)-Sell global to manufacturers at low cost
C2B (Consumer to Business)- Customers interact directly with organization, conveniant, and comparison shopping
C2C (Consumer to Consumer)-Individuals one as buyer and other as seller, mainly done on the web
ecommerce
Web site traffic analysis: Proccesses and analyzes data from the web log file to provide useful information to improve web site performance
smart cards, debit cards, credit cards
biometrics
steps required to complete a transactions: Data collection, data editing, data correction, data manipulation, data storage, and document production
different types of TPS systems
shipment planning/execution,
LAN vs. WAN,
Network operating systems,
sale configuration systems: Ensures that the products and services ordered are sufficient to accomplish the customer's objectives and will work well together
Batch Processing vs. OLTP: Batch Processing business transactions are accumulated over a period of time and prepared for processing as a single batch and OLTP is processed immediately
data redundancy/data integrity…