Dude Database, database access, and charts

RouterOS The Dude
1

I have a few questions regarding the DUDE database:

  1. If I have the same element on two maps, is the data to display for both pulled from the database (probe/snmp results) or are no queries made to the device for the multiple instances of the element.

  2. How large can the DUDE database get? Is this a propritary DB design that does not allow access to the data from other programs?

  3. For charts, is there a way to display the data associated with a chart. There are a lot of chart programs that will display the value of the plot as you move a vertical line across the graph (data is displayed for the intersection of the vertical line and the chart plot). Can this functionality be added?

  4. When plotting charts using the data stored in the database, the charts are being averaged over larger amounts of time. Is all of the data still present in the database to plot the actual non-averaged data? I like the charts with averages but also would like the actual plots at plotted with the granularity original sampled (I know this will increase the plot time from graphs)

2

??

3

  1. Yes, devices will be polled twice

  2. Currently this is proprietary database with no way to access it from
    outside. You should see for yourself how well does it scale. In future we are
    going to move to some better solution - that both scales well and is
    accessible with ODBC or something.

  3. We have added this to our TODO list

  4. No, Dude is keeping only averaged data to keep memory/disk usage low. Now
    it is ~10K per data source. Saving all the historic data will be possible
    when we move to a better database.