1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

what is data transaction ?

Discussion in 'MySQL' started by mohit007kumar00, Apr 17, 2010.

  1. mohit007kumar00

    mohit007kumar00 New Member

    Joined:
    Apr 14, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    hi friends,
    .
    any one know something about database transction ?
     
  2. satyedra pal

    satyedra pal New Member

    Joined:
    Mar 26, 2010
    Messages:
    93
    Likes Received:
    1
    Trophy Points:
    0
    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.
     
  3. agraj1

    agraj1 New Member

    Joined:
    Apr 18, 2010
    Messages:
    9
    Likes Received:
    1
    Trophy Points:
    0
    Occupation:
    Hosting Service
    Location:
    Hosting Service
    Home Page:
    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 likes this.
  4. coffee_friday

    coffee_friday New Member

    Joined:
    Feb 15, 2012
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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.
     
  5. coffee_friday

    coffee_friday New Member

    Joined:
    Feb 15, 2012
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  6. mountainman

    mountainman Banned

    Joined:
    Feb 6, 2012
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  7. mialuzzatto

    mialuzzatto New Member

    Joined:
    Aug 5, 2015
    Messages:
    122
    Likes Received:
    4
    Trophy Points:
    0
    Occupation:
    Work at https://www.idevelopersquare.com
    Location:
    Waltham, MA, USA
    Home Page:
    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
     
  8. alia123

    alia123 New Member

    Joined:
    Jan 8, 2016
    Messages:
    65
    Likes Received:
    3
    Trophy Points:
    0
    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.
     

Share This Page