stored procedure
Saved database routine
A stored procedure is a prewritten set of database commands saved on a server and executed as a unit.
Rather than sending multiple queries from an application, you call the stored procedure by name: The stored procedure handles all the validation logic.
Stored procedures improve performance and consistency, since the database engine compiles and optimizes the code once.
Regular sequence of actions
- subroutinePackaged callable code segment
- callableSubject to early redemption
- invocationCalling upon higher authority
- parametersDefined boundaries or constraints
return value · execution · batch · transaction · query · precompiled · trigger · cursor
Organized representational structure
- tableHorizontal furniture surface
- viewWhat's seen from somewhere
- indexAlphabetical guide to contents
- joinConnect or enlist
relational · fetch · cursor · metadata · catalog · permission · grant · revoke
Assigning times to events
- jobPaid position of employment
- batch processingRunning queued jobs automatically
- ETLSource-to-destination data process
- workflowSequential task progression
trigger · maintenance · backup · cleanup · data migration
Maximizing efficiency or performance
- cachingTemporary local storage
- indexingSystematic organization for retrieval
- throughputProcessing rate over time
- latencyDelay in system response
response time · profiling · benchmarking · tuning · bottleneck · recompilation · statistics · cost estimation
Granted right to act
- grantBestow or award money
- revokeOfficially cancel authorization
- access controlRestricting resource availability selectively
- encryptionConverting data into code
signing · privilege · role · authentication · authorization · input validation · audit
routine
Regular sequence of actions
- subroutinePackaged callable code segment
- callableSubject to early redemption
- invocationCalling upon higher authority
parameters · return value · execution · batch · transaction · query · precompiled · trigger · cursor · CALL
schema
Organized representational structure
join · relational · fetch · cursor · metadata · catalog · permission · grant · revoke · encapsulation
scheduling
Assigning times to events
- jobPaid position of employment
- batch processingRunning queued jobs automatically
- ETLSource-to-destination data process
workflow · trigger · maintenance · backup · cleanup · data migration
optimization
Maximizing efficiency or performance
- cachingTemporary local storage
- indexingSystematic organization for retrieval
- throughputProcessing rate over time
latency · response time · profiling · benchmarking · tuning · bottleneck · recompilation · statistics · cost estimation
permission
Granted right to act
- grantBestow or award money
- revokeOfficially cancel authorization
- access controlRestricting resource availability selectively
encryption · signing · privilege · role · authentication · authorization · input validation · audit
- functionslinear function, function, quadratic function, polynomial function, exponential function
- databasesSQL, table, databases, database, tables
- SQLAND, OR, ON, ALL, insert
- SQL Serverdatabase, table, query, index, transaction
- database operationsselect, insert, update, delete, query
- filesfile, filename, folder, flat file, directory