Not Signed-In
Which clippings match 'Oracle Database' keyword pg.1 of 1
08 MAY 2011

Gamestorming: structured play for business innovation

"Games come naturally to human beings. Playing a game is a way of exploring the world, a form of structured play, a natural learning activity that's deeply tied to growth. Games can be fun and entertaining, but games can have practical benefits too.

This blog is about games designed to help you get more innovative, creative results in your work. We'll show you not only how to play them but how to design them so they fit your own specific work goals."

(Dave Gray, Sunni Brown and James Macanufo)

Dave Gray, Sunni Brown and James Macanufo (2010). 'Gamestorming: A Playbook for Innovators, Rulebreakers, and Changemakers', O'Reilly Media

1

TAGS

Amazon.comApplebest practicesbusiness innovationchange agentscollaboration • creative results • Dave Gray • design methodsdesign the futureeBayeconomic growthelevator pitchexploringgamegame mechanicgame playing • game principles • games • gamestorming • gamificationgamifyingGoogle IncHewlett-Packardinnovationinnovative companies • innovative people • James Macanufo • learning activity • MicrosoftNetflix • networked economy • Oracle Databasesoftware companies • structured play • Sunni Brown • teamwork • toolkit • tools and rules • visual thinking • work goals • Yahoo!

CONTRIBUTOR

Simon Perkins
07 MAY 2011

Oracle database server: transaction management

"A transaction is a logical unit of work that contains one or more SQL statements. A transaction is an atomic unit. The effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database).

A transaction begins with the first executable SQL statement. A transaction ends when it is committed or rolled back, either explicitly with a COMMIT or ROLLBACK statement or implicitly when a DDL statement is issued.

To illustrate the concept of a transaction, consider a banking database. When a bank customer transfers money from a savings account to a chequing account, the transaction can consist of three separate operations: decrement the savings account; increment the chequing account; record the transaction in the transaction journal.

Oracle must allow for two situations. If all three SQL statements can be performed to maintain the accounts in proper balance, the effects of the transaction can be applied to the database. However, if a problem such as insufficient funds, invalid account number, or a hardware failure prevents one or two of the statements in the transaction from completing, the entire transaction must be rolled back so that the balance of all accounts is correct."

(Richard Strohm, 2011)

Fig.1 a banking transaction example

2) .Richard Strohm (January 2011). 'Oracle Database Concepts'

1

TAGS

databasedocumentation • hardware failure • ICT • logical unit of work • operations • Oracle Database • Oracle database server • process • rollback • rolled back • SQL • SQL statements • technologytransaction • transaction management • undone

CONTRIBUTOR

Simon Perkins
Sign-In

Sign-In to Folksonomy

Can't access your account?

New to Folksonomy?

Sign-Up or learn more.