wUser’s Guide
Introduction to Database Views
Hitachi Storage Viewer provides a set of published read-only
database views into the Reporting Database and related object model.
The
database views provide a native SQL interface into the Reporting Database. HDS publishes a collection of views that overlay the underlying database tables. Using these read-only views, you can write your own reports or stored procedure handlers to query the Reporting Database. These views provide a simple and fast mechanism to access a read-only view into the raw data maintained within the Reporting Database. Typically, you’ll use the Hitachi Storage Viewer SQL Template Designer to create queries for custom reports.
There are two sets of database views:
• Common Views. Provides read access to the properties for every backup server that the Hitachi Storage Viewer maintains.
• Product-Specific Views. Provides read access to information about a given underlying backup product. If your backup solution is such that it only uses properties that are typical to all backup solutions, Hitachi Storage Viewer does not need to provide you a product‑specific view because all properties are adequately covered by the common views.
• Storage-Specific Views. Provides read access to data specific to a storage vendor, such as NetApp or HDS.