How to model Semantic Conventions for Database Transactions

[tkmsaaaam]

Area(s)

area:db

Is your change request related to a problem? Please describe.

In this repository, model calls in the database semantic conventions are already defined. However, database transactions have not yet been defined. Therefore, I think it needs to be defined. This is the issue that prompted this issue. open-telemetry/opentelemetry-java-instrumentation#10381

Describe the solution you'd like

I think most of the attributes of the transaction are the same at the time of the call.
https://github.com/open-telemetry/semantic-conventions/blob/ca6e1c5df5efd7f746266cff0dbaab5672a251c3/docs/database/database-spans. md
https://github.com/open-telemetry/semantic-conventions/blob/ca6e1c5df5efd7f746266cff0dbaab5672a251c3/docs/database/sql.md
https://github.com/open-telemetry/semantic-conventions/blob/ca6e1c5df5efd7f746266cff0dbaab5672a251c3/docs/database/mssql.md

However, you need to define db.operation.name.
I think it should be COMMIT TRANSACTION and ROLLBACK TRANSACTION.

Describe alternatives you've considered

No response

Additional context

No response