Wed, 20/05/09 – 11:18 | Comments

Paris, FRANCE – March 26, 2009 -
Team Trade, a financial business consultancy & IT services provider to the financial markets is now
an official member of the Partnership Program developed by Murex S.A.S., the leading provider …

Read the full story »
Announcements

Official announcements regarding the Murex User Group

Books

Book recommendations. Please contribute book reviews and list your favorite books.

Consulting

Consulting companies specialized in Murex implementations and related services.

Events

Event anouncements; we usually meet 3-4 times per year in London, New York and other financial centers.

FAQ

Frequently asked questions.

Home » Murex Mailing List

Murex – Archiving & Purging

Submitted by Markus Linke on Friday, 31 October 2008Comments

Hi Folks:

We would like to archive our existing Murex transaction database to save database space, better data management and gain performance.

Does Murex provide any tool to archive Murex transaction database? We can think of few ways to archive data from Murex transaction database…

1) Database procedure: Store proc based archive process which will extract data from Murex DB. But here underlying murex database (read datamodel) is unknown to us. [...]

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks

  • NTT
    You can try to use the Murex native "Logical purge" procedure (akin to archiving). This procedure will retain the basic characterisitcs of the purged transactions in the database and will delete any non-critical data associated with the transactions. Refer to mxdoc document for details. Alternatviely, the "Physical purge" procedure will completely remove the transactions from the database.

    You can write a dynamic database formula/filter to identify the deals that will be affected by the purge procedure prior to purging.
blog comments powered by Disqus