Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   what is data transaction ? (http://www.go4expert.com/forums/data-transaction-t21826/)

mohit007kumar00 17Apr2010 20:49

what is data transaction ?
 
hi friends,
.
any one know something about database transction ?

satyedra pal 22Apr2010 12:14

Re: what is data transaction ?
 
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 23Apr2010 09:42

Re: what is data transaction ?
 
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 15Feb2012 21:38

Re: what is data transaction ?
 
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 15Feb2012 21:45

Re: what is data transaction ?
 
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 2Mar2012 19:22

Re: what is data transaction ?
 
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


All times are GMT +5.5. The time now is 20:06.