Cursor (databases)

Charles Babbage, sometimes referred to as the "father of computing".

Mechanism that enables traversal over the records in a database.

- Cursor (databases)

11 related topics

Relevance

Iterator

Iterator is an object that enables a programmer to traverse a container, particularly lists.

Ada Lovelace, whose notes added to the end of Luigi Menabrea's paper included the first algorithm designed for processing by an Analytical Engine. She is often recognized as history's first computer programmer.

An iterator is behaviorally similar to a database cursor.

Java Database Connectivity

Application programming interface (API) for the programming language Java, which defines how a client may access a database.

A diagram from 1978 proposing the expansion of the idea of the API to become a general programming interface, beyond application programs alone.

In the case of Connections to remote database servers, further resources are tied up on the server, e.g., cursors for currently open ResultSets.

Select (SQL)

The SQL SELECT statement returns a result set of records, from one or more tables.

Relational database terminology

cursors, or

Stored procedure

Subroutine available to applications that access a relational database management system (RDBMS).

Relational database terminology

Such result sets can be processed using cursors, by other stored procedures, by associating a result-set locator, or by applications.

Microsoft Data Access Components

Framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store.

MDAC provides a uniform framework for accessing a variety of data sources on their Windows platform

Cursors were also deprecated in ADO.NET, being replaced with a DataReader object, which is used to efficiently process a large list of results one record at a time without storing them.

SQL-92

The third revision of the SQL database query language.

Relational database terminology

Scrolled cursors.

DataReader

Broad category of objects used to sequentially read data from a data source.

This technology forms a part of .NET Framework 3.0 (having been part of the framework since version 1.0)

DataReaders provide a very efficient way to access data, and can be thought of as a Firehose cursor from ASP Classic, except that no server-side cursor is used.

SQL/PSM

ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures.

Relational database terminology

SQL/PSM standardizes syntax and semantics for control flow, exception handling (called "condition handling" in SQL/PSM), local variables, assignment of expressions to variables and parameters, and (procedural) use of cursors.

MySQL

Open-source relational database management system .

Screenshot of the default MySQL command-line banner and prompt
Screenshot of the default MySQL command-line banner and prompt
David Axmark (left) and Michael "Monty" Widenius, founders of MySQL AB, in 2003
Geir Høydalsvik, current Senior Software Development Director for MySQL at Oracle in 2018
LAMP software bundle, displayed here together with Squid.
MySQL Workbench running on macOS

Cursors

Outline of databases

Provided as an overview of and topical guide to databases:

Partial map of the Internet, with nodes representing IP addresses

Cursor