Glad to see some more work on NDO, I=92m excited to try I out. In light of =
the recent developments with NDO, I=92m going to repost a email I sent quit=
e a while ago with some feedback about the NDO database:
[snip]
1. objects.name1 and objects.name2 shouldn't exist. The names of objects sh=
ould
live in their respective tables. Hosts should have a hostname and a alias f=
ield.
Services should have a service_description field. Hostgroups should have a
hostgroup_name and a hostgroup_alias field. etc. etc. etc. I believe this t=
o be
the case because they are unique to each object and cannot be generified-the
result is a bunch of NULLs in the objects table. This also makes joining ob=
jects
together easier/possible. In the current NDO database I couldn't use a join=
to
show me all the services in a particular servicegroup. This could possibly =
be
done with a subquery, but that seems excessive for a seemingly simple query.
2. Host and Services should not be linked by name. At very least the id of =
the
host and service object should be linked. But to truly model the Nagios wor=
ks,
it should be a many-to-many relationship with an association table. Since t=
he
NDO database with Nagios 2.x isn't the authority of data (the flat files st=
ill
are) this shouldn't be a problem. And in Nagios 3.0 a relationship based on
primary keys seems more appropriate.
3. The instance table shouldn't need to be related to EVERY other table. In
fact I think that a relationship to the objects table seems sufficient. That
relationship should then carry throughout all other relationships. There ar=
e a
few exceptions in tables which don't link to the objects table.
[snap]
Also, I would like to add to this:
4. The acknowledgements and comments should be closely linked. Since an ack=
nowledgement requires a comment, Why keep them separate? Just have the ackn=
owledgements table link to the comment_id of the acknowledgement comment.
5. On page 15 of the schema docs there are a few tables (processevents, sys=
temcommands, externalcommands) which don=92t seem to have a foreign key lin=
king them to the objects table as shown in the diagram.=20
Marlo
_____________________________________________
From: Ethan Galstad [mailto:[email protected]]=20
Sent: Sunday, January 07, 2007 9:41 PM
To: Nagios-Devel
Subject: [Nagios-devel] NDOUtils 1.4b1 Released
Its been quite a while since I released an update to the NDOUtils addon,=20
but the time has finally arrived. I just squashed some big bugs and=20
released 1.4b1, so give it a try and let me know (on the -devel list)=20
what does/doesn't work. Its a beta release, so don't if you're using a=20
prior version for production purposes, use caution with this.
The new release has a slightly different DB structure (there's a script=20
that should upgrade the 1.3 table structures) and the default table=20
prefix is now "nagios_" instead of "ndo_". Should work with Nagios 2.x=20
and the Nagios 3 alpha CVS code.
The new release also has a separate PDF document describing the DB=20
structure. Its 55 or so pages and doesn't cover the ~20 tables=20
containing configuration data yet, but that will get filled in for=20
future releases. Thanks to Marlo Bell for his early Visio diagram=20
several months back - it was a great start for the docs!
Ethan Galstad,
Nagios Developer
---
Email: [email protected]
Website: http://www.nagios.org
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page ... &CID=3DDE=
VDEV
_______________________________________________
Nagios-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/lis ... gios-devel
----------------------------------------------------------------------
NOTICE: This email message is for the sole use of
...[email truncated]...
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: than Galstad [mailto:[email protected]]=2