Data - answer numeric , textual , visual or audio
information that describes real-world systems.
varies in ways such as scope, format, access.
analog data - answer Historically most common
before computers, encoded as continuous
variations on various physical media.
digital data - answer most common today,
recorded as 0's and 1's on electronic and magnetic
media.
database designer - answer determines the
format of each data element and the overall
database structure
database user - answer a consumer of data in a
database. can either use an application or submit
queries directly to the database. they use, request
and update data. to generate reports
,transaction - answer a group of queries that must
be completed or rejected as whole. will result in
incomplete or incorrect data if not terminated as a
whole.
Query processor - answer interprets queries,
creates a plan to modify the database or retrieve
data, and returns query results to the application.
Query optimization - answer to ensure the most
efficient instructions are executed on the data
from the processor.
Storage Manager - answer translates the query
processor instructions into low-level file-system
commands that modify or retrieve data.
indexes - answer used by the storage manager to
quickly locate data
catalog - answer also called a data dictionary , a
directory of tables, columns and indexes as well as
other database objects.
, relational database - answer a database that
stores data in tables that consist of rows and
columns, similar to a spreadsheet
SQL - answer Structured Query Language
NoSQL - answer A new generation of database
management systems that is not based on the
traditional relational database model.
query - answer command for a database that
typically inserts, retrieves, updates and deletes
data from the database.
crud - answer Create, Read, Update, Delete
statement - answer a database command such as
a query that inserts , selects updates and deletes
data
SELECT - answer Retrieves data from a table
UPDATE - answer modifies data in a table
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller BRAINBOOSTERS. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.99. You're not tied to anything after your purchase.