Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Transaction log library

I am in need of transaction log library with following features:

  • maximum performance. No force (flush), let O/S write buffers at its own discretion. File size increases in big chunks, to minimize metadata modifications. I don't care if some last records are lost.

    • reading records in backward order (most recent first).

The problem is, how to find the last valid record when reading the log file? What technics can be used, or is there a ready opensource library?

like image 967
Alexei Kaigorodov Avatar asked Oct 01 '12 07:10

Alexei Kaigorodov


People also ask

What is stored in transaction log?

Every SQL Server database has a transaction log that records all transactions and the database modifications made by each transaction. The transaction log is a critical component of the database. If there is a system failure, you will need that log to bring your database back to a consistent state.

Where is the Oracle transaction log?

By default, all log files are stored in the /logs/transaction directory of your API Gateway installation.

What is log analysis explain how it can be used for evaluating digital library?

Log analysis is an effective approach to illustrate usage patterns, in particular how users interact with digital libraries. Digital libraries were not frequently used compared with other types of online resources, especially in the early age of digital library development.


1 Answers

Did you check if HOWL - High-speed ObjectWeb Logger matches your requirements? It is rather out of date and seems not to allow random access or reading backward. However, it supports setting a mark and replaying events from a mark on. Because it is open source it might be adaptable to your needs.

You may investigate too if the logging part of JBoss Transaction is suitable.

Please specifiy what you mean with "read backwards" through a transaction log. A transaction log may contain logs from multiple transactions each consisting of a sequence of events.

More information on transaction logging can be found here (and on the web of course):

  • Java Transaction Processing: Design and Implementation (ISBN 978-0130352903)
  • Fundamentals of Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery (ISBN 978-1558605084)
  • Principles of Transaction Processing (ISBN 978-1558606234)
  • and in various books about database system concepts

Hope this helps a bit to come closer to your goal

Michael

like image 110
Claude Avatar answered Oct 13 '22 13:10

Claude