Key Terminologies Related to Record-at-a-Time
- Record: Records in DBMS is a horizontal entry in a table that refers a single instance of data. It also consists of multiple columns and fields. Rows in the table refer to a record in the table.
- Table: A table that is a collection of records of an entity that is organized in the form of rows and columns where each column represents a specific attribute.
- Cursor: A the Cursor is a control structure in a DBMS that allows the DBMS to transverse in table to find the records. It tracks the current position in the table during record-at-a-time processing.
Visual Representation
Here the visual representation of table how the Record-at-a-time processing method work.
Name |
Age |
City |
---|---|---|
Ram |
25 |
Patna |
Mohan |
21 |
Chapra |
Shyam |
32 |
Hajipur |
Sita |
18 |
Sonpur |
In the above table Record-at-a-time process the table in following order
- Read the first record (Ram,25, Patna)
- Perform the operations or computations on record.
- Move to the next record (Mohan,21, Chapra).
- Repeat the steps 2-4 until all records are processed.
Steps in Record-at-a-time Processing
- Open the cursor on the table which has to be processed.
- Fetch the first row or record from table to process.
- Perform all operations or computation on fetched record.
- After processing the record move the cursor to the next record in table.
- Repeat steps 2-4 until all records are processed.
- Close the cursor when all the records are processed.
What is Record-at-a-Time in DBMS?
A database management system (DBMS) is a software system that is used to manage databases. In a database management system, there are various approaches to accessing the data from the databases. Record-at-a-time is one of the approaches in database management systems. Record-at-a-time is a processing method in DBMS in which each row or record can be processed individually and sequentially.
In this method DBMS process one record at a time and it process until all the records have been processed. In this article we will learn the concept of Record-at-a-time, its significance, its advantage, and frequently asked questions.