Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
148 Cards in this Set
- Front
- Back
Programs or instructions that tell the computer hardware what to do.
|
Software
|
|
Kernel
|
The heart of the OS
Ties all parts of the OS together |
|
What does the operating system do?
(8) |
Controls Hardware
Provides user interface Hardware Independence Manage System Memory Manage Processing Tasks Network Capability Controls access to system resources Manage Files |
|
OS Controls the hardware:
(3) |
Accept keyboard inputs
Store and retrieves data on disks Sends data to output devices |
|
OS User Interface
|
Command-Based Interfaces (Dos screen)
Graphical User Interface (GUI's) - windows screen |
|
___ ___ used to connect the application software to the operating software
Importance? |
Application Program Interface
(API) -software needs to be able to run on different hardware - like older machines |
|
The __ knows exactly where data is stored in memory
|
Operating System
|
|
____: swaps data in memory
|
Multi-tasking
|
|
___ ___: Allocates space on hard drive to help RAM
|
Virtual Memory
|
|
OS allocates computer resources to deal with...
|
all tasks
|
|
Multiple users can simultaneously use the resources of a single processor
|
Time-Sharing
|
|
The ability to handle an increased number of concurrent users.
Especially important for servers and mainframes. |
Scalability
|
|
OS can help users connect to, setup, and control ___
|
networks
|
|
OS keeps track of files in ___ ___
|
secondary storage
Creation, deletion, movie, and copying, etc. |
|
Difference between Command based interface and graphical user interface (GUI)
|
Command based requires user to give txt commands
GUI uses icons and menus |
|
Microsoft PC Operating System Characteristics:
|
MS-Dos
Windows Does not manage memory/resources well |
|
Apple Mac OS X characteristics:
|
Advanced GUI
Great at Multi-tasking Lots of Multimedia and communication capabilities |
|
Linux characteristics:
|
Many distributions available
created in 1991 by student in Finland Open Source Strong Security Powers Web-servers, and embedded systems (mobile phones, appliances, tivo) |
|
Windows Server is a ___ operating system with what characteristics: (2)
|
Workgroup
Can manage more amounts of data More secure/reliable |
|
Unix is a ___ operating system with what characteristics: (2)
|
Workgroup
Multitasking, multiuser, manages networks often used on mainframes, midrange, and PC's. |
|
_______ is a ___ operating system with what characteristics
|
Red Hat Linux
Workgroup Make money using open source Networking OS Inexpensive, runs on standard hardware, powerful, stable, and secure |
|
Windows Embedded is used for:
|
Cell phones, digital cameras, automobiles, computers, tv boxes, automated machinery.
|
|
Windows Mobile is used for:
|
Handhelds and cell phones
|
|
___ software applies the power of the computer to give individuals, workgroups, and the entire enterprise the ability to solve problems and perform specific task
|
Application Software
|
|
A one of kind, custom made, program for a specific application is called ___ ___
|
Proprietary Software
|
|
Software program that already exists which is purcahsed or aquired is called:
|
Off-the-shelf software
|
|
A ___ ___ __ is a company that provides software, support, and the computer hardware on which to run the software from the user's facilites.
|
Application service provider
(ASP) |
|
___ ___ help to perform maintenance or correct problems with a computer system.
EX.? |
Utility Programs
Ex. - Virus dection sftwre |
|
Personal application software includes: (
|
Spredsheets,Word Processing, Database apps, graphic progs(adobe), powerpoint, web apps.
|
|
Common Web Applications:
|
Webpage creation apps (frontpage)
Browsers (reags hypertext) Email (hotmail.com) IM |
|
A collection of single application programs packaged in a bundle.
|
Software Suite
Ex. Office |
|
Software that supports teamwork, whether in one location or around the world.
|
Workgroup application software
|
|
2 Types of Workgroup application software:
Ex. |
Groupware
Collaborative computing software Ex- Lotus Notes |
|
Software that benefits an entire ogranization.
Ex. |
Enterprise application software
Microsoft Office Small Bus. |
|
1st Generation Language (GL)
Characteristics: (3) |
Machine Language/binary code
ASCII Intrustions entered through front panel switches (ex. Altair) with punch cards |
|
2nd GL characteristics: (2)
|
Assembly Language
MVC |
|
3rd GL characteristics: (3)
|
Easier for humans to understand - named variables
Needs complier program |
|
Special software prgram that converts the programmers source code into machine-language instructions consisting of binary digits
Ex. |
Complier
COBOL, C, C++, BASIC |
|
4th GL characteristics: (1)
Ex. |
Programs tell CPU the desired results, not how to get them
Ex. Structured Query Language (SQL) |
|
5th GL characteristics:
|
Use "intelligence" to create source code
Ex. Drag & Drop a button Uses natural Language to communicate with computer |
|
__ ___ promgramming languages use objects rather than just procedures. Objects are made up of both data and actions.
Benefit? |
Object-Oriented
-Objects are reusable |
|
This web page language creates links in the webpage to connect to other pages, embeds control codes in your document, and can be created using FrontPage or even WebCT.
|
Hypertext Markup Language (HTML)
|
|
This web page language hides descriptive tags in your document, helps you find specific data labels, and is used for search.
|
eXtensible Markup Language (XML)
|
|
This web page language is object oriented, and used to create applets (small programs that are downloaded and run when you open a webpage).
|
JAVA
|
|
Active X?
|
Microsoft's version of JAVA
|
|
___ ___: little programs built into the webpage that will check to make certain field are filled in or that two indentical fields are the same.
(ex. enter password, reenter password) |
Scripting Languages
|
|
___: A specific instance of an entity. Collection of related DATA FIELDS
Ex. "Hauck" |
Record
|
|
____:Typically a name, number, or combination of characters that describes an aspect of a business object or activity.
Ex. "Office Number" |
Field
|
|
___: a generalized class of people, places, or things (objects) for which data is collected, stored, and maintained.
Ex. "Professors" |
Entity
|
|
____: the specific value of an attribute.
Ex. "COB267" |
Data Item
|
|
___: a field or set of fields that uniquely identifies the record.
Ex. SSN |
Primary Key
|
|
Whats in a Database
|
Data organized in a hierarchy
|
|
A group of programs that manipulates the database and provides an interface between the database and the user of the database and other application progams.
|
Database Management System
(DBMS) |
|
A ___ is an organized collection of data.
|
Database
|
|
A collection of related RECORDS:
|
File
|
|
Hierarchy of Data:
Top to Bottom |
Database
Files Records Fields Characters (Bytes) |
|
A characteristic of an entity
|
Attribute
|
|
Data models that use basic graphical symbols to show the organization of and relationships between data.
|
Entity-relationship Diagram
-helps ensure that the logical structure of application programs is consistent with the data relationships in the database |
|
A detailed description of all the data used in the database
|
Data Dictionary
|
|
A description of the enitre database
|
Schema
|
|
A ___ ___ is a database that collects business information from many sources in the enterprise, covering all aspects of the company's processes, products, and customers
|
Data Warehouse
|
|
Which Database design:
-abstract models of the data -whats the relationship b/w the data that makes sense? -entity-relationship diagrams |
Logical DB Model/design
|
|
Which Database design:
-how the data is acutally stored in the computer or computers -plan for performance and cost -Ex. Planned data redundancy |
Physical DB Model/design
|
|
___ ___: Describes data in which all data elements are placed in two-dimensional tables, called relations, that are the logical equivalent of files.
|
Relational Model
|
|
2 Characteristics of Relational Model:
|
Each Row of a table represents a data entity
Columns of the table represent attributes |
|
__ is the allowable values for data attributes
|
Domain
|
|
Database Management Systems characteristics:
|
Provide a user view
Create and modify database Store and Retrieve data Manipulate data: SQL Produce Reports Usually Handled by the Database administrator |
|
Instructions used to define the database schemas and subschemas
|
Data Definition Language
(DDL) |
|
___ ___: linking multiple relational databases through the internet
|
Semantic Web
|
|
Link between database and users via the internet that is used to control access/security, build page for user, and is scalable.
|
Web Server running middleware software
|
|
___ ___ are subsets of fata warehouses, which is data from one aspect of the business.
|
Data Marts
|
|
Program used to sift through Datawarehose to find hidden patterns or relationships.
-Find Questions instead of just answers |
Data Mining
|
|
Online Transaction Processing databases:
(OLTP) |
Read and Write
Simple database update and Query Only a few weeks of historical data Routine and Easy updating |
|
Online Analytical Processing
(OLAP) |
On the fly processing
data is multidimensional (cube) Top down query driven data analysis |
|
Distributed Databases
Adv/Disadv? |
Data exist at different physical locations
Adv - All your eggs arent in one baset Dis - Networks go down sometimes. |
|
Purposly storing same info in different areas
|
Replicated database
|
|
Goal of Communications:
|
Receiver gets the same message (data) that is sent by the sender through the signal
|
|
Communcations vs Telecommunications
|
communications are sent through the air by real people.
Telecommunications are sent through a wire/signal by computers |
|
Timing of message delivery is called ___
|
Synchronicity
|
|
___ means real-time, instantaneous
|
Synchronous
|
|
___means meassage is received after some delay
|
Asynchronous
|
|
Type of Communication Channels:
(3 + def) |
Simplex - data in one direction
half-duplex - both directions but not simultaneously Full-duplex - both directions at same time |
|
data travels as ___ ___ (or streams of particles) riding on some signal
|
radiation waves
|
|
Twisted Pair: advantages and disadvantages
|
Adv - Cheap, available, easy to work with
Disadv - electrical interference, slow, easily tapped. |
|
Coaxial Cable: Adv/disadv
|
adv - higher badnwidth, less interference
disadv - more expensive, inflexible, hard to work with |
|
Fiber Optics: adv/disadv.
|
adv - High badnwidth, smaller and lighter than coax, very secure
disadv - hard to work with, expensive, not flexible |
|
BPL
|
Broadband over power lines
-using powerlines and outlets -more interference |
|
Microwave
(terrectrial media) adv/disadv |
High frequencyradio signal sent through the atmosphere and space.
Adv- high bandwidth, no physical lines, wide coverage disadv - line of sight path, interference, must be encrypted, expensive |
|
Radio Transmition
|
Operates at 30Hz-300MHz
Includes: RFID, Bluetooth, WiFi and Cell transmissions |
|
Devices that allow several telecommunications signals to be transmitted over a single communications medium at the same time.
|
Multiplexers
|
|
Helps manage the communication load on the main system, by managing traffic, logs, determining data priority, etc.
|
Front-End Processors
|
|
An on-premise switching system owned or leased by an organization. Has limited connections to outside. Can work with both analog and digital.
Ex. Dial 9 to get outside line |
Private Branch Exchange
|
|
Personal Area Network
|
Range of 33ft
can be on the body Ex. using bluetooth |
|
ISUnet has ___(#) connections to the public internet
|
2
|
|
Wide Area Networks tie together large geograpic areas like ____
|
International networks
|
|
Partial or full connectivity between computers on a network. If one connection goes down, the others are not effected.
keyword? |
Mesh Network
Topology - arrangement of computers on a network |
|
This network device Uses physical device address in each message to find the right machine in the current network
|
Switch
|
|
Forwards data packets across two or more distinct networks (“routing”)
|
Router
|
|
Connects one LAN to another LAN that uses the same telecomm protocol
|
Bridge
|
|
a network point that acts as an entrance to another network (e.g., gateway between ISUnet and the public Internet)
|
Gateway
|
|
Types of Distributed Computing Architectures:
Terminal-to-host Client-server Peer-to-Peer |
Terminal - keyboard and monitor using the host computer (usually a mainframe)
Client - multiple servers and clients on a network (WWW) Peer-to-Peer - doesnt rely on server, but traffic can slow it down. Best for under 25 computers. |
|
Which is more important to a business. Hardware or Software?
|
Software
|
|
What is the heart of the operating system called that controls most of the critical processes?
|
Kernel
|
|
Multitasking and Time-sharing are essentially the same thing. T or F?
|
False
|
|
The user interface is part of the OS. T or F?
|
True
|
|
This is used to connect software applications to the OS rather than the hardware itself
|
Aplication program interface (API)
|
|
Any OS can be used with any hardware. T or F?
|
False
|
|
The file manager component of the OS controls how memory is accessed and maimizes available memeory and storage. T or F?
|
False
|
|
What type of software would support a team of people writing a report?
|
Workgroup application
|
|
Which type of application would manage the supply chain for an entire organization?
|
Enterprise Application
|
|
Proprietary software is standard software that is typically cheap, quick and easy to create. T or F?
|
False
|
|
Whic type of programming language needs a compiler?
|
3rd generation language
|
|
A programmer needs to know machine language to program in what language
|
1st generation language
|
|
Programs in this "english-like" language tell the computer the desired results rather than how to get the results?
|
4th generation language
(SQL - most common) |
|
Which programming language is an object-oriented language often used to create web page applets?
|
JAVA
|
|
Which programming language is know for its use in financial business systems (often legacy/mainframe systems)
|
COBOL
|
|
This type of language uses embedded tags to "tag" key words or phrases for searching?
|
XML
|
|
A database comprises..
A. attributes B. records C.Organized data for querying D. All of above |
All of above
|
|
What is the correct order of the hierarchy of data?
|
Character - fields-records-files-database
|
|
Which terms refer to the objects or things you want to know about in your database. (choose more than 1)
A. Primary Key B. Attributes C. Fields D. Entities E. Records |
Entities
Records |
|
Which terms refer to the characteristics that you want to knwo about in your database?
A. Primary Key B. Attributes C. Fields D. Entities E. Records |
Attributes
Fields |
|
Which is a characteristic of the tradional approach
|
program and data dependence
|
|
Which is a characteristic of the data approach
|
increased vulnerability to system failure
|
|
which database model uses tables to organize data
|
???
|
|
A technique to make a complex database more different by eliminating redundancy in a table?
|
Normalization
|
|
A ___ is a unique identifier of a particular record
|
Primary Key
|
|
A logical model helps you plan...
|
what data and relationships in your database
|
|
Which mega database stores historical external and data from other sources
|
data warehouse
|
|
which database do you use for data mining
|
data warehouse
|
|
you dont need to know exactly what your looking for in this type of analysis?
|
Data mining
|
|
Database where I know exactly what questions I can ask, what answers i can get, and which is the best db processing for me?
|
OLAP
|
|
Is this communication channel, comunication moves in both directions but not at the same time
|
half duplex
|
|
if you use cable tv, and cable internet, you have this type of comm channel
|
full duplex
|
|
bandwidth refers to the capacity of data that a medium can carry out. T or F?
|
True
|
|
Of the wired media, this is the fastest?
|
Fiber optics
|
|
This type of media requires a straight line of sight path for transmission.
|
Microwave
|
|
Most secure media?
|
Fiber Optics
|
|
This device determines the next destination for incoming data then forwards it to that destination
|
router
|
|
this device often works to connect different networks together
|
gateway
|
|
ISUnetwork would best be considered a ...
|
MAN
|
|
Data redundency can lead to problems with...
|
data integrity
|
|
Windows ___ is a family of microsoft operating systems included with or embedded into a small computer device.
|
Embedded
|
|
___ supports top-down query driven analysis.
|
OLAP
|
|
Multitasking allows more than one person to use a computer system at the same time. T or F?
|
False
|
|
___ allows users to explore corporate data from a number of different perspectives
|
OLAP
|
|
___ refers to the idea that application programs can be developed by a programmer without a thorough understanding of computer systems hardware.
|
hardware independence
|
|
One of the advantages of the database approach to data management is the standardization of data. T or F?
|
True
|
|
A computer system that can smoothly handle an increasing number of concurrent users exibits ...
|
scalability.
|