B4 Vocab (Appendix) Flashcards
components of computerized systems
People, data, hardware, software, and networks
hardware
CPU- processor and primary storage
processor
interprets program instructions, coordinates input, output and storage devices and performs arithmetic calculations
primary storage
used to store program instructions and data until program instructions can be executed
secondary storage devices
hard drives/flash drives
means to permanently store programs and data
peripherals
devices that transfer data to or from the CPU but do not take part in the actual processing of data
include input and output devices
input devices
peripherals-
supply the data to be processed
e.g. keyboards, mice, scanners, magnetic ink character readers, etc
output devices
peripherals-
transfer data from the processing unit to various output media
e.g. printers, speakers, CRTS or monitors, etc
classes of processors
processing power
multiprocessing
processing power
class of processors- described in terms of MIPS (millions of instructions per second) speed
multiprocessing
class of processors-
general term
symmetric multiprocessing- one operating system controls the processing
parallel processing- each processor has its own operating system
software
three broad categories
- system software
- programming languages
- application software
system software
programs that run the computer and support system mgmt operations
- operating systems
- database management systems
operating systems
provides interface between the user an hardware
Windows
database management system
software package that controls the development, use, and maintenance of the databases used by the organization
bit
data storage
binary digit with which all computer data is stored
byte
data storage
group of 8 bits that represent a number or letter
sometimes called characters
field
group of bytes in which a specific data element such as an employee number or name is stored
record
group of fields that represents the data that is being stored for a particular entity such as a customer or A/R
file
collection of related records, often arranged in some kind of sequence, such as a customer file made up of customer records and organized by customer number
traditional file storage
data stored in files, with the formats and organization of the data often specific to each particular application system
- duplicate data
- data errors
- change in data (program-data dependence)
database
integrated collection of data records and data files.
centralizes data and minimizes redundant data
database management system
tool separate computer program that allows an organizzation to create new databases and use and work with the data in the databases after they have been created. allows for maintenance addition or subtraction of data elements Access and Oracle
relational technology
data is stored in two dimensional tables that are related to each other via keys
often include ad hoc report writers
normalization
process of separating data into logical tables
before a relational database can be designed, a process of normalization has to occur
object-oriented databases
includes data such as comments, drawings, images, voice, and video
more flexible than relational database
slower than relational database
Major uses of DBMS
- database development
- database query
- database maintenance
- Application development
database development
one of the major uses of DBMS
procedure by which a database administrator uses the DBMS to create a new, empty database
database query
one of the major uses of DBMS
process by which end users can retrieve specific data or info from the database
end user establishes certain criteria and all data are displayed
SQL
database maintenance
one of the major uses of DBMS
updating of DBMS software and revision of the database structure to reflect new business needs
includes testing the effectiveness and efficiency of the database- via built in diagnostic and maintenance programs(database tuning)
application development
one of the major uses of DBMS
allows a DBA or computer programmer to use a programming language or a series of macros to turn a database into a computer software application.
(instead of creating queries as needed, automated)
types of databases
operational analytical data warehouses distributed databases end-user databases