what is data transaction ?

mohit007kumar00's Avatar, Join Date: Apr 2010
Newbie Member
hi friends,
.
any one know something about database transction ?
satyedra pal's Avatar, Join Date: Mar 2010
Contributor
A database transaction is a collection of database operations which are executed all for process user requests for retrieving data from database or updating the database.Database transaction is independent to the other transaction performing in the database.A database transaction follows ACID properties.So A transaction must be Atomic,consistent,isolate, and durable.
A transaction starts with first executing SQL statement as tasks of database transaction. And a transaction ends when it is committed or rolled back.
The properties of database transactions are follows:

Atomicity :Whole or nothing
All the step of a database transaction must be completed or If it is not complete due to any reasons, the database transaction must be aborted.
Consistency :Integrity
The database must be in a consistent before and after perform the task of the database transaction.It means that a database
transaction must not break the database integrity.
Isolation: Data that are using to execution of one database transaction must not be used by another database transaction until the
execution of one database is completed.
Durability:Updation of the database in the transaction will be permanent even if a system failure occurs after the completion of transaction.
agraj1's Avatar, Join Date: Apr 2010
Light Poster
hello,
as my openion

Transaction data is data describing an event (the change as a result of a transaction) and is usually described with verbs. Transaction data always has a time dimension, a numerical value and refers to one or more objects (i.e. the reference data).
Typical transactions are:
Financial: orders, invoices, payments
Work: Plans, activity records
Logistics: Deliveries, storage records, travel records, etc.
Typical transaction processing systems (systems generating transactions) are SAP and Oracle Financials
Thankyou
coffee_friday like this
coffee_friday's Avatar, Join Date: Feb 2012
Newbie Member
Hi! agri

"Transaction data is data describing an event (the change as a result of a transaction) and is usually described with verbs. Transaction data always has a time dimension, a numerical value and refers to one or more objects (i.e. the reference data)."


Thanks for your answer, and I have some confusing about "is usually described with verbs" Could you please describe for me?

Now, I have to prepare some of data for using with apriori algorithms , many papers say that's the data structure should be a "Transaction Data". But my data is a record data.

Could you tell me about how is the different of Record Data, Transaction Data,Matrix Data and Document Data?

I'm not good in English and I'm not good in data mining.
Apologize for something wrong.

Thank you very much.
coffee_friday's Avatar, Join Date: Feb 2012
Newbie Member
Hi! agraj1 ^^"

"Transaction data is data describing an event (the change as a result of a transaction) and is usually described with verbs. Transaction data always has a time dimension, a numerical value and refers to one or more objects (i.e. the reference data)."


Thanks for your answer, and I have some confusing about "is usually described with verbs" Could you please describe for me?

Now, I have to prepare some of data for using with apriori algorithms , many papers say that's the data structure should be a "Transaction Data". But my data is a record data.

Could you tell me about how is the different of Record Data, Transaction Data,Matrix Data and Document Data?

I'm not good in English and I'm not good in data mining.
Apologize for something wrong.

Thank you very much
mountainman's Avatar
Banned
Data transaction is all about describing about an even that normally explains with the help of verbs. Data transaction will always has a time dimension and it refers numerical value of one or more.
For example financially we have orders, invoices and payments