A central source of data that have been cleaned, transformed, and cataloged so that they can be used for business analysis, market research, and decision support is called a ___DATAWAREHOUSE____________.

Notes:

A data warehouse stores data that have been extracted from the various operational, external, and other databases of an organization. It is a central source of the data that have been cleaned, transformed, and cataloged so that they can be used by managers and other business professionals for data mining, online analytical processing, and other forms of business analysis, market research, and decision support

pg 207

All the following describe a VPN except: _______________________________

NOTES:

A virtual private network is a secure network that uses the Internet as its main backbone network but relies on network firewalls, encryption, and other security features of its Internet and intranet connections and those of participating organizations.

VPN in which network routers serve as firewalls to screen Internet traffic between two companies.

Using this approach, we can “create” a private network without incurring the high cost of a separate proprietary connection scheme. Let’s look at a real-world example about the use of VPN to secure remote and wireless access to sensitive data.

Applications that use the Internet and Internet-based technologies are typically less expensive to __(DOM)- develop,operate, and maintain_____________ than traditional systems.

Notes: p 242

Substantial cost savings can arise because applications that use the Internet and Internet-based technologies (like intranets and ex-tranets) are typically less expensive to develop, operate, and maintain than traditional systems.

In a(n) ___HIEARCHIAL____________ database structure, all of the relationships among records are one-to-many, because each data element is related to only one element above it.

A group of related records is a data file, or a ___TABLE____________.

The _Application ______________ layer in an OSI model provides communications services for end users.

Metcalfe's law states that: the usefulness, or utility, of a network equals the square of the number of users.

VoIP works by digitizing a voice signal, chopping it into __PACKETS________, and then sending them over a company's computer network or the Internet, much like data or email.

Notes:

Often referred to as voice over IP or VoIP, this ap- proach makes use of a packet-based (or switched) network to carry voice calls, instead of the traditional circuit-switched network. In simpler terms, VoIP allows a person to function as if he or she were directly connected to a regular telephone network even when at home or in a remote office.

In an OSI model, the ____NETWORK___________ layer does the routing and forwarding.

Notes:

The Open Systems Interconnection (OSI) model is a standard description or “reference model” for how messages should be transmitted between any two points in a telecom-munications network.

P 267

Layer 3: The network layer. This layer handles the routing of the data (sending it in the right direction to the right destination on outgoing transmissions and receiving incoming transmissions at the packet level). The network layer does routing and forwarding.

P. 268

The ___ hypermedia ____________ database structure is considered one of the key technologies of a new generation of Web-based applications.

From .. WHERE

The basic form of a SQL query is: SELECT … FROM...WHERE

Notes: pg 215

SQL QUERIES. SQL (pronounced “see quill”), or Structured Query Language, is an international standard query language found in many DBMS packages. In most cases, SQL is the language structure used to “ask a question” that the DBMS will retrieve the data to answer. The basic form of a SQL query is: SELECT . . . FROM . . . WHERE . . .

Telecommunications-based business applications can help a company overcome all of the following barriers to business success except:

Notes: pg. 237

Figure 6.4 illustrates how telecommunications-based business applications can help a company overcome geographic, time, cost, and structural barriers to business success.

A communications medium that consists of one or more central wires surrounded by thick insulation is called _COAXIAL______________ cable.

BOTES: P. 257

Coaxial cable consists of a sturdy copper or aluminum wire wrapped with spacers to insulate and protect it. The cable’s cover and insulation minimize interference and dis- tortion of the signals the cable carries.

A(n) ___PROTOCOL____________ is a standard set of rules and procedures for the control of communication in a network.

P. 267

A protocol is a standard set of rules and procedures for the control of communications in a network.