Aremos Databank Backup command

For making suggestions and/or requests for new features you'd like added to EViews.

Moderators: EViews Gareth, EViews Moderator

mmiller2
Posts: 16
Joined: Tue Aug 23, 2016 9:56 am

Aremos Databank Backup command

Postby mmiller2 » Thu Jun 17, 2021 6:37 am

We have been transitioning from Aremos to EViews for a number of years now, and there is really only one thing we still need Aremos to accomplish - compressing databanks. We have tried, unsuccessfully, to implement this feature in EViews by opening an existing databank and copying all of the objects in it (i.e., just series and lists) to a newly created databank.

Although that process is slower and less efficient than doing it in Aremos, it does "work." However, the problem with that method is that the "Last Update" field, which is stored internally in the databank for each object, gets updated to the current date. Would it be possible to create an option to the EViews copy command to not update the "Last Update" field when bulk copying from one databank to another?

I believe that created and last updated fields are also stored internally in the databank itself (in the very first 256 byte block), as they are both displayed when a databank is opened and don't necessarily correspond to what the operating system says (e.g., Created on 16 JUN 2017 Last updated on 13 APR 2021, while OS says created ‎Wednesday, ‎March ‎24, ‎2021, ‏‎9:52:26 AM).

I could probably put together some poorly written code to do this myself in Java or Python, but I figured why not ask the professionals.

Backup.png
Backup.png (84.84 KiB) Viewed 496 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12914
Joined: Tue Sep 16, 2008 5:38 pm

Re: Aremos Databank Backup command

Postby EViews Gareth » Thu Jun 17, 2021 6:41 am

What's the end goal?

In Aremos how does creating a copy, compress the database?
Follow us on Twitter @IHSEViews

mmiller2
Posts: 16
Joined: Tue Aug 23, 2016 9:56 am

Re: Aremos Databank Backup command

Postby mmiller2 » Thu Jun 17, 2021 7:36 am

Internally, the databank is a forest of B-trees with each forest based on the version (e.g., .a, .q, .m, .null, etc.) of each object. To improve runtime performance (at the expense of space), Aremos (and EVIews) does not actually remove objects in databanks from the trees on deletes or relocations (if more space is needed), it just marks things as deleted and leaves them in place. Over time, this leads to an accumulation of "deleted "space in the databank that is never reclaimed. A normal copy does not remove this space, but a backup command in Aremos achieves compression proportional to the amount of "deleted" space. Additionally, the backup command does not modify the metadata (i.e., Last Update) for objects. There is currently no way to accomplish this functionality in EViews.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12914
Joined: Tue Sep 16, 2008 5:38 pm

Re: Aremos Databank Backup command

Postby EViews Gareth » Thu Jun 17, 2021 8:40 am

Doesn't a repack do that?
Follow us on Twitter @IHSEViews

mmiller2
Posts: 16
Joined: Tue Aug 23, 2016 9:56 am

Re: Aremos Databank Backup command

Postby mmiller2 » Thu Jun 17, 2021 8:54 am

Doesn't a repack do that?


I'm not aware of a repack command, but the dbpack command appears not to be implemented for databanks:

PackDatabase.png
PackDatabase.png (2.86 KiB) Viewed 479 times

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 12914
Joined: Tue Sep 16, 2008 5:38 pm

Re: Aremos Databank Backup command

Postby EViews Gareth » Thu Jun 17, 2021 9:27 am

Ah, I didn't understand you wanted EViews to do this on external databases, sorry.

Its unlikely we'll add features to support a dead external database type, but we'll make a note nevertheless.
Follow us on Twitter @IHSEViews

mmiller2
Posts: 16
Joined: Tue Aug 23, 2016 9:56 am

Re: Aremos Databank Backup command

Postby mmiller2 » Thu Jun 17, 2021 7:26 pm

Thanks for making a note of it, Gareth. Referring to the Aremos databank format as a dead external database type reminded me of that scene from Monty Python and the Holy Grail: https://www.youtube.com/watch?v=QcbR1J_4ICg :lol:


Return to “Suggestions and Requests”

Who is online

Users browsing this forum: No registered users and 1 guest