Ch 3. Database systems, data centers, and business intelligence

studied byStudied by 4 people
5.0(1)
get a hint
hint

database

1 / 21

22 Terms

1

database

is an organized collection of data

New cards
2

database management system (DBMS)

software that handles the storage, retrieval, and updating of data in a computer system

New cards
3

database administer (DBA)

skilled IS professional who directs all activities related to an organizations database

New cards
4

Hierarchy of data

1- Bit (binary digit): circuit that is either on/off 2- Byte: made up of 8 bits 3- Character: building block of info 4- Field : name/number/combo of characters that describes an aspect of a business object or activity 5- Record: collection of related data fields 6- File: collection of related data records 7- Database: collection of integrated and related files

New cards
5

entity

General class of people, places, or things (objects) for which data is collected, stored, and maintained

New cards
6

attribute

characteristic of an entity

New cards
7

data item

specific value of an attribute

New cards
8

key

field or set of fields in a record that is used to identify the record

New cards
9

key field

field or set of fields that uniquely identifies the record

New cards
10

data centre

Is a climate controlled building or set of buildings that house database servers and the systems that deliver mission-critical information and services -Traditional data centres: Consist of warehouses filled with row upon row of server racks and powerful cooling systems

New cards
11

Enterprise data modelling

investigates the general data and information needs of an organisation at the strategic level

New cards
12

Entity-relationship (ER) diagrams

data models that use basic graphical symbols to show the organization of and relationships between data

New cards
13

Relational Model

describes data using a standard tabular format, each row of a table represents a data entity (record), columns of the table represent attributes (fields)

New cards
14

domain

allowable values for data attributes

New cards
15

Manipulating data

Selecting: eliminates rows according to certain criteria Projecting: eliminates column in a table Joining: combines two or more tables Linking: manipulating two or more tables that share at least one common data attribute

New cards
16

Database Management Systems

Creating and implementing the right database system: (ensure that the database will support both business activities and goals)

New cards
17

data definition language (DDL)

collection of instructions and commands used to define and describe data and relationships in a specific database

New cards
18

data dictionary

detailed description of all data used in the database

New cards
19

concurrency control

method of dealing with a situation in which two or more users or applications need to access the same record at the same time

New cards
20

Data manipulation language (DML)

commands that manipulate the data in a database

New cards
21

Structured query language (SQL)

standard query language for relational databases

New cards
22

Database Administration / administrator(DBA)

Responsible for defining and implementing consistent principles for a variety of data issues

  • works with users to decide the content of the database -Works with programmers as they build applications to ensure that their programs comply with database management system standards and conventions

New cards

Explore top notes

note Note
studied byStudied by 53356 people
Updated ... ago
4.9 Stars(282)
note Note
studied byStudied by 17 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 4 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 43 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 11 people
Updated ... ago
5.0 Stars(1)
note Note
studied byStudied by 30 people
Updated ... ago
5.0 Stars(2)
note Note
studied byStudied by 17 people
Updated ... ago
4.5 Stars(2)
note Note
studied byStudied by 96 people
Updated ... ago
4.9 Stars(7)

Explore top flashcards

flashcards Flashcard37 terms
studied byStudied by 5 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard28 terms
studied byStudied by 7 people
Updated ... ago
4.0 Stars(1)
flashcards Flashcard27 terms
studied byStudied by 36 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard30 terms
studied byStudied by 12 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard28 terms
studied byStudied by 5 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard44 terms
studied byStudied by 17 people
Updated ... ago
5.0 Stars(1)
flashcards Flashcard40 terms
studied byStudied by 274 people
Updated ... ago
5.0 Stars(2)
flashcards Flashcard24 terms
studied byStudied by 121 people
Updated ... ago
5.0 Stars(1)