I came across the term Transaction Path Analysis which I am not familiar with. A Google search resulted in only a few results, most of which seem to assume everyone knows what it means. From these my understanding is that it is about tracking what columns are used by queries to access data, in preparation for deciding indexes. This seems like common sense, but I'm surprised I can't find more specifics on it.

Is there a concise definition for transaction path analysis, a process for completing one, or any alternative more commonly used phrases that mean the same thing?

  • People can coin terms whatever they want. It will be better to ask the person who coined it. Can you be more specific as to what you want to ask - do you want to understand how tables\indexes are being accesses by the query ?
    – Kin Shah
    May 30 '13 at 14:59
  • The term appears as one of the headings of a document format I am working with. The example I was given has an entity relationship diagram in that section which is fine for my version of the document, but I think the original intent of that section may have been different. I'm just curious to know is it a term with a well recognized meaning.
    – Rattle
    May 30 '13 at 22:03
  • to the best of my knowledge, it is not.
    – Kin Shah
    May 31 '13 at 0:58
  • 3
    Please refer to Richard C. Perkinson's book (Q.E.D.) "Data Analysis : The Key to Database Design", which includes fully detailed methodology on transaction (access) path analysis, together with two more examples. Happy reading.
    – user26644
    Aug 2 '13 at 3:41

This term relates to the process of identifying the significant events in the transaction life-cycle, including error-processing, auditing, save-points, nested transactions, and distribution paths for distributed transactions.

I think you may find more results with the synonymous term Transaction Life-cycle Analysis.


Perkinson's mtehodology merges logical(ideal) process model and logical(ideal) data model into one combined ideal model and calculates resources of each access path in a table. In this calculation, peak event frequency, entry point, data volume, cardinality, from entity, to entity, access type & required resources by each access, etc. are needed. According to calculation result, we can add new access path or new entity type for optimal performance. I strongly recommend you to read J. Palmer & S. McMenamin's book 'Essential Systems Analysis' for the exact meaning of 'Logical'.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.