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.
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
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.
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
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
Hello, Transactions (Database Engine) SQL Server 2008 R2. A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the atomicity, consistency, isolation, and durability (ACID) properties, to qualify as a transaction. --- Regards, Mia Luzzatto
Hey, Transaction data are data describing an event 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.
A transaction can be defined as a group of tasks. A single task is the minimum processing unit which cannot be divided further. A transaction is a very small unit of a program and it may contain several lowlevel tasks. A transaction in a database system must maintain Atomicity, Consistency, Isolation, and Durability − commonly known as ACID properties − in order to ensure accuracy, completeness, and data integrity.