The database server and that database are not the same thing, as a database server can potentially host multiple databases. The database server is indeed a software server, but the database instance itself is a separate logical entity that is managed/used/controlled by the database server. I model them using the Database class and relate that to the software server that hosts the database. For example, you could have a SQL Server represented by a SoftwareServer class, and then every separate database instance hosted by that SQL Server (the database software, not the machine) would be an instance of the Database class related back to that SoftwareServer (e.g., a Dependency). You could potentially also use the DatabaseStorage class which represents the physical storage used by the database, but unless you actually care about modeling and tracking the storage for the database separately, you're probably better off just using Database.
Having said all that, what you use will depend on the level of detail that you are trying to capture. If all you want to say is that Application X depends on Database Y, but you don't care about whether it's Oracle, SQL Server, etc., then you probably could just use the Database class and not worry about the Software Server class. If you want to track your database server software and keep track of what databases are hosted by which servers, then you will want to use both classes. If you're storage is stored on SANs or the like, then you may also want to use the DatabaseStorage class so that you can store more information about your database's storage allocation, etc. and easily relate it to things like the actual disk array the storage is on, etc. Does that make any more sense? Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kathy Morris Sent: Wednesday, January 06, 2010 2:18 PM To: [email protected] Subject: CMDB 2.0 & Class ** Hello All, I have a list of database instances that I will be associating with servers. What table would database instances be stored in? Would the database instance be stored in AST:SoftwareServer table? I read that database servers are modeled a an instance of the BMC_SoftwareServer class. It is getting confusing. Are databases servers considered software servers? I am not sure how to classify the database instances. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
