Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
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
Normal Size Small Size show me how
Database
Introduction to Database Systems (Information Systems, Technology)
| Question | Answer |
|---|---|
| Embedded SQL | Hard-Coded SQL in another programming language |
| Dynamic SQL | SQL Created on the fly as the application is running |
| Pre-Compiler | Compiles SQL code so that it can be translated so that other programming languages can use |
| Thin Client | Remote connection to a database server, this client has few application programs and stores all data remotely |
| Fat Client | Stores all of the data and database at the client, All data is transferred from the server to the client |
| How does a database server differ from a file server? | A File Server does all of the processing at the PC that requested the data, the database server does all access processing and storage at the database. |
| Datawarehouse Model | A central repository of data collected from enterprise's business systems |
| Data Replication | Allowing data to be redundant so that more users can access the data |
| File Clustering | Reducing the number of field names that are used in a database by combining them together to improve efficiency and save space |
| Transaction Integrity | Ensuring that all of the data that is processed completely or should not be completed at all |
| What is a view in a relational database model? | A view provides users with controlled access to the database |
| What are the advantages of accessing data through the view? | Simpler Query Commands, Hides the data from the user, Increases Productivity and Provides user with controlled access to the database |
| What role does a "Page" Play in how data is written or retrieved from a disk drive? | Only an amount of data can be modified during an input/output operation like a hardrive |
| Ordered by Clause | Data is ordered according to a particular criteria |
| On Delete Clause | Deleting or Removing particular rows from a column |
| Partitioning | Distributing Rows and Columns across separate files |
| Publish and Subscribe | Push Technology -> Proving clients with data when information is available |
| Publish | The data a database allows to be accessed |
| Subscribe | The client that is allowed to have access to the data |
| Scalability | Increase capacity, The ability to grow with the company and accomodate the needs of the company as it grows |
| Stored Procedure | Some business rules are applied to the server |
| Query by Example | A method of query creation when the user searched for documents based on an example such as a selected text, list of documents etc. |
| Referential Integrity | Ensuring that all foreign keys in a 1:M relationship match the primary keys |
| Trigger | An event that causes the database to perform an action or command |
| Sub-Query | An inner query inside an outer query |
| Correlated | Executed each row queried by the outer command |
| Non-Correlated | Executing the entire command once |
| Equi-Join | Equivalent matches of columns are joined and appear redundantly in the result table |
| Natural Join | An equi-join that eliminates the redudant columns |
| Outer Join | A join in which rows that have columns of values not matching the columns in the other table are shown in the result table |
| Sequential | Organizing the files in order by primary key and in order to access a desired file, all of the files preceding the desired file must be searched |
| Index- Sequential | All of the data is organized in sequential form by primary key where the primary key has a built in index |
| Hash | Converts a primary key into an record address |
| Define Hashing Algorithm | A division-reminder method of determining the position. PROS: Positions are grouped in lists, speed, CONS: Only one hash value per record |
| Rollback | Resets all of the data to a previous state |
| Commit | Saves the modifications made by the user and applies it to the database |
| Difference between Rollback and Commit | Commit makes all updates permanent, Rollback cancels all updates since last commit |
Created by:
xyingthaix
Popular Computers sets