System and method for performing database operations on a continuous stream of tuples

摘要: The SQL compiler and executor in a database management system are extended to process queries requiring streaming mode processing of data stored table. A scan operator performs table access functions during execution the query. first an initial rows specified table, then delta new added as well modified by other queries. continues until initiating user or application closes associated cursor. set structures provided keep track active operators, including session control block that includes fields for keeping whether is performing scan. also includes, list be processed When transaction terminates, any operators whose operation was suspended because locked automatically rescheduled execution.