by Jason Williscroft

Classification is a universal problem in Data Management.

Some classification problems are very straightforward. For example, a data vendor uses a numerical country code, and the business uses the alphanumeric ISO-2 standard. In principle, there is a one-to-one mapping between values, and a few obvious and simple implementation choices. In practice, there are always exceptions, and even this simple scenario can be tricky.

Other classification problems get very complex. A dozen data elements from three different vendors traverse a branchy decision tree to produce a proprietary asset risk classification. The observations of a handful of doctors who have never met produce an evolving medical diagnosis. From a universe of potential suitors, a bride chooses one.

Classification is a particular problem in Master Data Management (MDM), which requires the alignment of mostly-incompatible data standards from multiple vendors, as well as the implementation of deeper logic like the asset classification system described above. Hard-pressed MDM teams focus on the problem of the moment, typically producing a special-purpose solution to each issue as it arises, instead of a general solution to all their classification requirements.

An example Ruleset: Private Capital Asset Classification (click to enlarge)

hqRule is a general-purpose classification engine. It is designed specifically to support high-volume Data Management scenarios, and has two parts:

  • The browser-based User Interface permits users to create and manage an unlimited number of Rulesets, one for each specific use case. Rulesets can be as simple and flat as a country-code mapping, or as complex and deeply hierarchical as required.
  • The Database maintains Ruleset definitions and configuration data. Its CLR-based SQL API permits users to evaluate incoming data against a Ruleset, and also to create and manage Rulesets programmatically.

hqRule is easy for business users to understand. The construction and configuration of even complex Rulesets is straightforward and intuitive. Click here for a real-world explanation of Rulesets and processing logic options, and here to test-drive the hqRule UI!

hqRule is fast and painless to integrate. Install the Database, configure a Ruleset either programmatically or with the UI, and immediately begin evaluating incoming data, on an industrial scale, by calling a single user-defined function against the Database. Place the focus on business rules instead of implementation, and save man-years of development effort over the life of any major Data Management project. Click here for examples of scripted Ruleset management and data evaluation.

hqRule is available now! Contact us for more info.

Previous Post Exception Handling and the Open/Closed Principle
Next Post Exporting All Diagrams From Visio