Saturday, February 25, 2012

Rules based Configuration ER design

I'm looking at a head start in developing a "Rules based configuration
system." One like Dell Computer has where you build your PC. Are there any
database designs available for this type of thing?
--
Regards,
Gary BlakelyHello Gary,
Since rules based system is too general and you may want to be more
specific.
A very simple sample, let's say you have 3 configuration parameters and 2
rules. 1 rule has some relation to all 3 parameters. The tables shall be
tbl-rule
ruleid rulename ..
1 rule1
tbl-parameters
paramid paramname ..
1 p1
tbl-rule-parm-relation
ruleid paramid value relation
1 1 10 >
1 2 5 <
Some more complex situation might be based on knowledge management, expert
system etc which is beyond a simple E-R desgin.
Some issues may require a bit more in depth attention and may fall under
the umbrella of Advisory Services. Microsoft now offers short-term and
proactive assistance for specific planning, design, development or
assistance with installing, deploying, and general "how to" advice via
telephone. For more information:
http://support.microsoft.com/default.aspx?scid=fh;en-us;advisoryservice
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment