Ingres Corporation, "Ingres SQL and ESQL Reference Manual" (for release 6.4), 1991.  Home/Search Document Not in Database Summary Related Articles Check |
This paper is cited in the following contexts:
Implementing Embedded Valid Time Query Languages - Costas Vassilakis Panagiotis (Correct)
....omitted, the deletion applies to the whole tuple that is current for the designated cursor. The cursor version of the statement may be used only if the cursor points to an updatable result tuple set. The cases for which a result tuple set is updatable practically depend on the underlying DBMS ([12], 14] 18] The SQL standard ( 9] specifies a minimal set of queries yielding updatable results (roughly, this includes queries which apply only PROJECT relational algebra operations, with no duplicates removal, on a single base table; joins are permitted but only when expressed via a ....
.... generated for each declared cursor is named evtql exec CName, and contains the embedded SQL statement EXEC SQL EXECUTE IMMEDIATE :cursor statement; This function is called whenever deletions or updates must be performed through the RDBMS cursor and is used because some DBMSs (e.g. Ingres [12]) require that all operations through a cursor must be performed from within the file that the cursor has been declared. cursor statement is a dynamically formulated SQL statement (by some function in the EVTQL library) which is passed as a parameter to the evtql exec CName function. In order ....
Ingres Corporation, "Ingres SQL and ESQL Reference Manual" (for release 6.4), 1991.
Implementation Of Transaction And Concurrency.. - Vassilakis.. (1998) (5 citations) (Correct)
....not result in lock imposition on the accessed data because a deadlock will then occur. In order to achieve this, the command WHERE READLOCK = NOLOCK is forwarded to the DBMS, through the user session, prior to the INSERT command. The SET LOCKMODE statement is an INGRES extension to SQL89 ([22]) the syntax in other DBMSs is different. In the algorithm presented here, the user session will acquire shared locks on the used data during the query evaluation phase. Additionally, during the insertion phase the same session will obtain exclusive locks on the inserted tuples making them ....
INGRES Corporation. INGRES SQL and ESQL Reference Manual (for release 6.4). INGRES Corporation (1991).
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC