Talk:Database transaction
Add topic | This article is rated Start-class on Wikipedia's content assessment scale. It is of interest to the following WikiProjects: | |||||||||||||||||
| ||||||||||||||||||
Terminology
[edit]The transitive verb "persist" is used but not defined. Wegesrand (talk) 12:25, 8 September 2008 (UTC)
References
[edit]This article is badly in need of references. SqlPac (talk) 04:25, 12 March 2008 (UTC)
Hibernate uses Unit Of Work as a pseudo-synonym for transaction, as does Fowler in his Patterns of Enterprise Application Architecture http://www.hibernate.org/42.html ¿would this qualify as a valid reference? Facuq (talk) 17:04, 14 January 2009 (UTC)
sql syntax
[edit]the syntax "BEGIN WORK" is so riduculously unsupported by db vendors that we should not mention it. —Preceding unsigned comment added by 88.66.134.54 (talk) 13:43, 17 January 2009 (UTC)
- Yes, most (relational databases) handle transaction start implictly, and the text should probably reflect that. For now, I've changed BEGIN WORK to START TRANSACTION, to at least use the sql standard's statement. TroelsArvin (talk) 00:10, 25 January 2009 (UTC)
For a cursor or a transaction?
[edit]A question about how it looks from a application programmer perspective. E.g. using Python on a PostgreSQL server, using the psycopg driver.
Beginning and ending a transaction, is that something you do on a connection or on a cursor? Or maybe it depends on the driver? Or on the dbms? Can you start a transaction in
LUW
[edit]Why does LUW redirect to this page? I came here expecting to see a definition after I saw someone use it on another talk page, but no reference is made to LUW here... GoBusto (talk) 17:02, 15 January 2015 (UTC)
- It means "logical unit of work". It should probably be incorporated into this article. Mindmatrix 20:55, 15 January 2015 (UTC)
Semantics of Database Transactions
[edit]I would like to see a definition of transaction that can be used to prove integrity properties in specific database applications. This means it must be formal and sufficiently simple to use in theorem provers. The scientific literature contains no usable definition so far. — Preceding unsigned comment added by Stefjoosten (talk • contribs) 07:05, 23 February 2018 (UTC)
- Well, if literature doesn't contain such a definition then it would be WP:OR. Wikipedia is not the right place for that. -- intgr [talk] 08:25, 23 February 2018 (UTC)
Wiki Education assignment: Research Process and Methodology - FA23 - Sect 201 - Thu
[edit]
This article was the subject of a Wiki Education Foundation-supported course assignment, between 7 September 2023 and 14 December 2023. Further details are available on the course page. Student editor(s): Artisticrush, Harrisondonnersbach (article contribs).
— Assignment last updated by Harrisondonnersbach (talk) 04:17, 12 November 2023 (UTC)