I posed the same question to BMC and received the response below. >From BMC: How is the data normalized from DSL and Inventory? Normalization happens inside the "inv_application" view or "mrb_inv_application" view in case of CD-integration (for EIE purposes). It happens "on-the-fly" where we join Configuration Management views with the cache DSL data in certain tables in the CM database. When data is inserted into the Inventory database from the inv plugin, its inserted NON-normalized. The normalization happens on the fly when someone wants to view the app data. There is a stored procedure "refresh_pdl_tables" which is used to normalize the data right away so that we don't have to go over the Data base-link for EVERY single application normalization. The procedure will refresh the PDL tables. On SQL there is a explicit job called "Refresh PDL Tables" which can be scheduled to run every night at 11:59pm which invokes the "refresh_pdl_tables" stored procedure. I believe there is no such "job" on Oracle, but I'm still verifying the behavior and will update you once I have confirmed. Regarding documentation on the above topics, I could not find a detailed description explaining the above, so I will be filing a defect for documentation to include a section in the DSL docs which details the process for normalizing the data in the Inventory database against the DSL.
Eric Alfonso, Contractor, 95 CG/SCCSS Remedy Support Team [EMAIL PROTECTED] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Thursday, April 26, 2007 1:16 PM To: [email protected] Subject: DSL - How does it normalize? Hi everyone: I have a question regarding the DSL that I just can't seem to figure out. In the documentation for the DSL, CMDB, Archtecture, etc. it states that the "DSL is used to normalize the data going into the CMDB". However, I've been searching through all the documentation, and spent a day going through the workflow, forms, active links, filters, etc. that touch the DSL, and I simply cannot see how the DSL interacts with the CMDB at all. The closest interaction with anything regarding the DSL is with Contracts and the Product Catalog (and even that is pretty limited) Does anyone have any idea how the DSL normalizes data going into the CMDB? Or better yet, even how to set it up to normalize data that goes in the CMDB? _________________________________________________________________ Exercise your brain! Try Flexicon. http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglin eapril07 ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
