Technology Vocabulary

#261

Record

Example sentences

1. Each record contains information about one customer.
2. The clerk updated the customer's record.
3. A duplicate record appeared in the database.

#

#262

Field

Example sentences

1. The email field is required on the form.
2. Each database field stores one type of information.
3. She left the address field empty.

#

#263

Schema

Example sentences

1. The schema describes the structure of the database.
2. The developer changed the schema to add a new table.
3. A clear schema helps people understand how data is organized.

#

#264

Primary key

Example sentences

1. The primary key gives each record a unique identity.
2. Customer ID is the primary key in this table.
3. Two rows cannot use the same primary key value.

#

#265

Foreign key

Example sentences

1. A foreign key connects one table to another.
2. The order table uses a foreign key for the customer ID.
3. The database checks that each foreign key matches a valid record.

#

#266

Relationship

Example sentences

1. The relationship links customers with their orders.
2. The diagram shows the relationship between the two tables.
3. A one-to-many relationship is common in databases.

#

#267

Query

Example sentences

1. The query returned all orders from this month.
2. She wrote a query to find inactive users.
3. A complex query may take longer to run.

#

#268

SQL

Example sentences

1. SQL is used to read and change data in relational databases.
2. He learned SQL to create reports.
3. The application sends an SQL command to the database.

#

#269

Index

Example sentences

1. An index helps the database find records faster.
2. The administrator created an index on the email field.
3. Too many indexes can slow down updates.

#

#270

View

Example sentences

1. A database view shows selected data from one or more tables.
2. The sales team uses a view that hides private details.
3. The view looks like a table but may not store its own data.

#

#271

Transaction

Example sentences

1. A transaction groups several database actions into one unit.
2. The payment transaction updated two accounts.
3. The transaction failed, so no changes were saved.

#

#272

Commit transaction

Example sentences

1. A commit transaction makes database changes permanent.
2. The system completed the commit transaction after all checks passed.
3. Do not commit the transaction until the data is correct.

#

#273

Rollback

Example sentences

1. A rollback returns the database to its earlier state.
2. The program started a rollback after the error.
3. We used rollback to cancel the unfinished changes.

#

#274

Constraint

Example sentences

1. A constraint prevents invalid data from entering the database.
2. The unique constraint stopped a duplicate email address.
3. The database checks each constraint before saving a record.

#

#275

Normalization

Example sentences

1. Normalization reduces repeated data in a relational database.
2. The team used normalization to improve the table structure.
3. Good normalization can make data more consistent.

#

#276

Denormalization

Example sentences

1. Denormalization adds some repeated data to improve reading speed.
2. The reporting system uses denormalization for faster results.
3. Too much denormalization can make updates harder.

#

#277

Data warehouse

Example sentences

1. The data warehouse stores information for business reporting.
2. Managers use the data warehouse to study long-term trends.
3. Data from several systems enters the data warehouse each night.

#

#278

Data lake

Example sentences

1. A data lake can store large amounts of raw data.
2. The company placed logs, images, and records in a data lake.
3. Analysts prepare data from the data lake before using it.

#

#279

Data mart

Example sentences

1. The finance department has a data mart for its reports.
2. A data mart contains data for a specific team or purpose.
3. The data mart receives selected information from the main warehouse.

#

#280

Extract, transform, load

Example sentences

1. Extract, transform, load moves data into a target system.
2. The nightly extract, transform, load process cleans sales records.
3. The team checked each step of the extract, transform, load job.

#