r4 - 2017-01-31 - 18:20:05 - TimFeeneyYou are here: TWiki >  Deployment Web > DeploymentPlanningAndDesign > CLMUsageModelBestPractices > DNGViewQueryBestPractices

DNG View Query Best Practices

Authors: HazelWoodcock, TimFeeney
Build basis: The Rational solution for Collaborative Lifecycle Management (CLM) and the Rational solution for systems and software engineering (SSE) v6.0.1.

View Query search techniques ranked from the quickest to the slowest:

  1. Search on indexed data. This means searching within Modules, or Folders, searching on Tags, searching for specific Artifact types.
  2. Search on enumerated attributes. By looking at a value in an enumerated attribute the tool is doing a simple 'is this equal' operation.
  3. String searches. Searching for a string in an attribute (including title and description) takes much longer than an enumeration comparison. The full attribute content has to be searched for the string using something like a regular expression mechanism, this is resource hungry.
  4. Date searches. Searching for artifacts modified after a certain date takes time; in practice this is a slightly more complex version of the string search. Searching between dates requires first an 'after start date' search followed by a 'before end date' search on the results, so this is two date searches and therefore even slower.
  5. Link queries. Searching on whether artifacts have links of a certain type, and other link related queries take a long time because it requires the tool to go and investigate the other end of the link. For link types that can go external to DOORS Next Generation, such as 'Links To', 'References', 'Implemented By' etc, this can mean searching other repositories.

The tool automatically looks at the elements of the view query and finds the most efficient order for running the query.

Ad hoc string search queries using the Quick Search box at the top of the page are a quick way to find information.

Recommendations:

  1. For queries returning large quantities of data, Jazz Reporting Services is a better option than using views. The view will only show a few results per page, so there is limited value in a view that returns thousands of results. Insight offers better analysis tools for this type of query.
  2. The use of Modules and Folders to group artifacts, rather than collections, allows for more efficient searching within the scope of those groups.
  3. The use of tags on artifacts allows for efficient searching, although the tags have to be rigorously applied to ensure that artifacts are not missed out from a query.
  4. The use of the Quick Search box at the top of the page will give rapid results, although the search cannot be saved. Artifacts returned from a quick search can be tagged.

Related topics: Best Practices for CLM Usage Models

Edit | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r4 < r3 < r2 < r1 | More topic actions
 
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our Terms of Use. Please read the following disclaimer.
Ideas, requests, problems regarding the Deployment wiki? Create a new task in the RTC Deployment wiki project