Shared Flashcard Set

Details

CS/IS 101
N/A
63
Computer Science
Undergraduate 3
04/25/2012

Additional Computer Science Flashcards

 


 

Cards

Term
Data
Definition
which can be defined as facts or observations about people, places, things, and events.
Term
Physical View
Definition
focuses on the actual format and location of the data.
Term
Logical view
Definition
focuses on the meaning, content, and context of the data.
Term
Character
Definition
is the most basic logical data element.
Term
Field
Definition
group of related characters.
Term
Attribute
Definition
description or characteristic
Term
Entity
Definition
person, place, thing, or object.
Term
Record
Definition
a collection of related fields.
Term
Table
Definition
a collection of related record.
Term
Database
Definition
is an integrated collection of logically related tables.
Term
Key field
Definition
Each record in a database has at least one distinctive field.
Term
Primary Key
Definition
this field uniquely identifies the record.
Term
Batch processing
Definition
data is collected over several hours, days, or even weeks.
Term
Real-time processing
Definition
Online processing. data is processed at the same time the transaction occurs.
Term
Data redundancy
Definition
Many organizations have multiple files on the same subject or person.
Term
Data integrity
Definition
If the customer moves, then the address in each file must be updated. When there are multiple sources of data, each source may have variations.
Term
Sharing
Definition
In organizations, information from one department can be readily shared with others.
Term
Security
Definition
Users are given passwords or access only to the kind of information they need.
Term
Less data redundancy
Definition
Without a common database, individual departments have to create and maintain their own data and data redundancy results.
Term
Database management system
Definition
In order to create, modify, and gain access to database, special software is required.
Term
Database management engine
Definition
provides a bridge between the logical view of the data and the physical view of the data.
Term
Data definition subsystem
Definition
logical structure of the database.
Term
Data dictionary
Definition
This dictionary contains a description of the structure of data in the database.
Term
Data manipulation subsystem
Definition
provides tools for maintaining and analyzing data.
Term
Data maintenance
Definition
Maintaining data.
Term
Query-by-example
Definition
specific tools
Term
Structured Query Language
Definition
specialized programming language.
Term
Application generation subsystem
Definition
provides tools to create data entry forms and specialized programming language that interface or work with common and widely used programming languages.
Term
Data administration subsystem
Definition
helps to manage the overall database, including maintaining security, providing disaster recovery support, and monitoring the overall performance of database operations.
Term
Database Administrators
Definition
Larger organizations typically employ highly trained computer specialists.
Term
Processing rights
Definition
determining which people have access to what kinds of data in the database.
Term
Database model
Definition
these models define rules and standards for all the data in a database.
Term
Hierarchical Database
Definition
fields or records are structured in nodes.
Term
Nodes
Definition
are points connected like the branches of an upside-down tree.
Term
one-to-many relationship
Definition
one parent node with several child nodes.
Term
Network database
Definition
hierarchical arrangement of nodes.
Term
Many-to-many relationships
Definition
child node has several parent nodes.
Term
Pointers
Definition
additional connections
Term
Relational database
Definition
flexible type of organization. there are no access paths down a hierarchy.
Term
Relation
Definition
a table and its data.
Term
Common data item
Definition
key field, enabling information stored in one table to be linked with information stored in another.
Term
multidimensional databases
Definition
extend this two-dimensional data model to include additional or multiple dimensions also data cube.
Term
Data cube
Definition
Data can be viewed as a cube having three or more sides and consisting of cells.
Term
Conceptualization
Definition
Multidimensional databases and data provide users with an intuitive model in which complex data and relationships can be conceptualized.
Term
Processing speed
Definition
Analyzing and querying a large multidimensional database can be much faster.
Term
Object-oriented databases
Definition
are more flexible and store data as well as instructions to manipulate the data.
Term
Classes
Definition
are general definitions
Term
Objects
Definition
are specific instances of a class that can contain both data and instructions to manipulate the data.
Term
Attributes
Definition
are the data fields an object possesses.
Term
Methods
Definition
instructions for retrieving or manipulating attribute values.
Term
individual database
Definition
microcomputer database. collection of integrated files primarily used by just one person.
Term
company database
Definition
may be stored on a central database server and managed by a database administrator.
Term
distributed database
Definition
Many times the data in a company is stored not in just one location but in several locations. Accessible through a variety of communications networks.
Term
commercial database
Definition
generally an enormous database that an organization develops to cover particular subjects.
Term
information utilities or data banks
Definition
commercial databases.
Term
CSi
Definition
Offers consumer and business services, including electronic mail.
Term
Dialog Information Services
Definition
Offers business information, as well as technical and scientific information.
Term
Dow Jones Interactive Publishing
Definition
Provides world news and information on business, investments, and stocks.
Term
LexisNexis
Definition
Offers news and information on legal, public records, and business issues.
Term
Data warehouse
Definition
This data is then stored in a special type of database.
Term
Data mining
Definition
to search these databases to look for related information and patterns.
Term
firewalls
Definition
special hardware and software. control access to their internal networks.
Term
Database administrators
Definition
use database management software to determine the mose efficient ways to organize and access a company's data.
Supporting users have an ad free experience!