Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

bus237 > CHP. 5 > Flashcards

CHP. 5 Flashcards

1
Q

Intellectual property

A

A form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Content management systems (CMSs)

A

An information system that tracks organizational documents, webpages, graphics, and related materials.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Database

A

A self-describing collection of integrated records.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Columns, Fields, Groups of bytes

A

A database table has multiple columns that are used to represent the attributes of an entity. Examples are PartNumber, EmployeeName, and SalesDate.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Rows or Records

A

groups of columns in a database table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Table or File

A

a group of similar rows or records in a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Key

A

(1) A column or group of columns that identifies a unique row in a table. (2) A number used to encrypt data. The encryption algorithm applies the key to the original message to produce the coded message. Decoding (decrypting) a message is similar; a key is applied to the coded message to recover the original text.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Foreign keys

A

A column or group of columns used to represent relationships. Values of the foreign key match values of the primary key in a different (foreign) table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Relational databases

A

Databases that carry their data in the form of tables and that represent relationships using foreign keys.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Relation

A

The more formal name for a database table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Metadata

A

Data that describe data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Database application system

A

Applications with the standard five components that make database data more accessible and useful. Users employ a database application that consists of forms, formatted reports, queries, and application programs. Each of these, in turn, calls on the database management system (DBMS) to process the database tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Database management system (DBMS)

A

A program used to create, process, and administer a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

DB2

A

A popular, enterprise-class DBMS product from IBM.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Access

A

A popular personal and small workgroup DBMS product from Microsoft.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

SQL Server

A

A popular enterprise-class DBMS product from Microsoft.

17
Q

Oracle

A

Software company focused on large scale database systems providing enterprise global cloud computing.

18
Q

MySQL

A

A popular open-source DBMS product that is licence-free for most applications.

19
Q

Structured Query Language (SQL)

A

An international standard language for processing database data.

20
Q

Database application

A

A collection of forms, reports, queries, and application programs that process a database.

21
Q

Form

A

Data entry forms are used to read, insert, modify, and delete database data.

22
Q

Report

A

A presentation of data in a structured, or meaningful, context.

23
Q

Query

A

A request for data from a database.

24
Q

Multiuser processing

A

When multiple users process the database at the same time.

25
Q

Lost-update problem

A

An issue in multiuser database processing, in which two or more users try to make changes to the data but the database cannot make all the changes because it was not designed to process changes from multiple users.

26
Q

Enterprise DBMS

A

A product that processes large organizational and workgroup databases. These products support many users, perhaps thousands, and many different database applications. Such DBMS products support 24/7 operations and can manage databases that span dozens of different magnetic disks with hundreds of gigabytes or more of data. IBM’s DB2, Microsoft’s SQL Server, and Oracle’s Oracle are examples of enterprise DBMS products.

27
Q

Personal DBMS

A

DBMS products designed for smaller, simpler database applications. Such products are used for personal or small workgroup applications that involve fewer than 100 users and normally fewer than 15. Today, Microsoft Access is the only prominent personal DBMS.

28
Q

ACID

A

An acronym standing for atomic, consistent, isolated, and durable. Used to describe the processing of transactions such that all of the transaction is processed or none of it is (atomic), transactions are processed in the same manner (consistent) whether processed alone or in the presence of millions of other transactions (isolated), and that once a transaction is stored, it never goes away—even in the presence of failure (durable).

29
Q

Dynamo

A

A nonrelational data store developed by Amazon.com.

30
Q

Bigtable

A

A nonrelational data store developed by Google.

31
Q

Cassandra

A

A durable, nonrelational data store that operates over hundreds or thousands of servers. Originally developed by Facebook but later turned over to the open source community; has become an Apache Top-Level Project (TLP).

bus237 (11 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions