Recordset

from Wikipedia, the free encyclopedia

A recordset is in the database language , a copy of data sets (engl. Data record ) from one or more tables for further processing such as the display on the screen or transmission to separate applications. Such a record set remains stable, even if the data records concerned change in the meantime, and is returned by a database as the result of a query.

It is used to generate partial quantities optimized for the respective purpose from a database, which are tailored to the subsequent processing. The record set can contain any amount of data (relating to records and columns, possibly from several tables) and corresponds to a virtual table.

Recordsets have the advantage that the appropriate selection and summary of the requested information is usually much faster than when the data is requested individually and combined in scripts outside the database. In addition, the amount (usually fewer columns) of the data returned by the database is reduced and fewer resources are required for processing in scripts (usually fewer data records or no further selection required). Particularly in systems with a high workload due to many accesses or very extensive data records, significant performance gains can be achieved through an optimized design of the record sets.

Example of a recordset

A recordset can contain data from active customers and consist of address data combined with aggregated sales figures and the name of a contact person.

Here, information is selected for all customers who have bought something in a predetermined period of time, all individual sales are added up and the name of the contact person is added. The data contained can then be z. B. can be output in table form line by line.