Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

Info Tech Ch. 7

TermDefinition
Database A structured set of data held in a computer, usually in a way that is accessible by multiple concurrent users
Data Modeling A way to help programmers and other related parties make sense of database information
Operational Data Data that is produced by an organization's everyday operations. It's gathered in real time to provide a snapshot of what's happening in the present
Analytical Data Historical data that is used to help people make decisions in the present. It's various categories include market data, transactional data, sensor data, natural language, and machine data
Database Management System (DBMS) Software that allows users to define, manipulate, retrieve, and manage data stored in a database. Examples are Microsoft SQL Server, Oracle Database, MySQL, and Microsoft Access
Table A data structure in a relational database that is comprised of fields (columns) and records (rows)
Query A method of asking questions about the data stored in a database
Form A graphical interface that allows users to query a database by filling in information on the form
Report An easy-to-read listing of the results of a query
Relational Database A database that holds data on multiple related tables
Field A single attribute of each record in a table
Record A single instance of an entity stored in a database table
Primary Key A field in a table that uniquely identifies a record
Foreign Key A field that corresponds to the primary key field in another table
Normalization A design technique that organizes data in a database in an optimal way. This results in it being easier to add, remove, and update data without introducing errors
Direct Access A method of accessing a database directly using the database management system itself
Query Builder A method of accessing a database using a graphical user interface that allows users to select what actions they want to perform on a database
User Interface Access A method of accessing a database using forms that allow users to interact with the database
Programmatic Access A method of accessing a database using custom computer programs
SQL A computer language that makes relational databases work
Data Definition Language (DDL) Database commands that change the structure, or schema, of the database
Data Manipulation Language (DML) Database commands that modify the records within the database and not the schema itself
Structured Query Language (SQL) A computer language used by most relational databases for creating queries
Structured Data Data that can be divided into discrete categories
Unstructured Data Data that doesn't follow a clear pattern
Semi-Structured Data Data that has some discrete categories but also other information that doesn't follow a clear pattern
Big Data Extremely large sets of data, usually automatically recorded, that can be analyzed to show insights into human behavior trends
Data Extraction The process of gathering and organizing big data
Data Mining A broad and open-ended analysis of extracted big data
Big Data Analytics The process of asking specific questions to help interpret big data
NoSQL Nonrelational databases that arise from big data
Database Administrator A person who is responsible for designing, maintaining, backing up, and securing an organization's databases
Data Scientist A person who focuses on data analysis, especially as it relates to data mining and big data analytics. These positions require even more advanced programming and analytical skills
Database Developer A person who designs and implements databases, usually by writing SQL code and conducting performance tests to ensure database optimization
Data Analyst A person who specializes in gathering and analyzing data to inform business decisions
Created by: acrusey
Popular Computers sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards