Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
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 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 May 31 '13 at 0:58
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

1 Answer 1

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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