I'm new to drools world. Kindly clarify following things My requirement is to log each data in the DB(that meets any of the business rule) along with rule info. if I use BRMS ( i think it maintains the rules separately in its own db table) How I can associate each log with the rule info? Approach 1. Can I access BRMS's rules directly and associate it in my logging? Approach 2. I can't do Approach 1, then I'm thinking to have RULES table in my app db.Then whenever any rule is added using BRMS, Then add an entry into RULES table and use this table for my logging Please advise me on the right approach. Thanks in advance. -- View this message in context: http://www.nabble.com/BRMS-rule-info-logging-tp19766982p19766982.html Sent from the drools - user mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

Thanks Michael. that gives me some idea. It think BRMS has its own tables to manage the rules(please correct if I'm wrong). 1.Can I directly make/delete rule entry in those table without using BRMS. Will BRMS identify those rules without any issues? 2. Can I reference the Ids(something rule_id) from these table as foreign key in my other app tables? Please clarify, Michael Neale wrote: > > BRMS is more of a design time feature - what you are talking is > logging an audit trail of rules execution - you can do that with event > listeners in your code (so your rules don't even have to be aware of > it) then as rules fire, you can grab the details (from the listener > APIs) and log it as you please ! > > > Michael. > > On Thu, Oct 2, 2008 at 5:01 AM, techluver <techluver007(a)gmail.com&gt; wrote: >> >> I'm new to drools world. Kindly clarify following things >> >> My requirement is to log each data in the DB(that meets any of the >> business >> rule) along with rule info. >> >> if I use BRMS ( i think it maintains the rules separately in its own db >> table) >> >> How I can associate each log with the rule info? >> >> Approach 1. Can I access BRMS's rules directly and associate it in my >> logging? >> >> Approach 2. I can't do Approach 1, then I'm thinking to have RULES table >> in >> my app db.Then whenever any rule is added using BRMS, Then add an entry >> into >> RULES table and use this table for my logging >> >> Please advise me on the right approach. >> >> Thanks in advance. >> -- >> View this message in context: >> http://www.nabble.com/BRMS-rule-info-logging-tp19766982p19766982.html >> Sent from the drools - user mailing list archive at Nabble.com. >> >> _______________________________________________ >> rules-users mailing list >> rules-users(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/rules-users >> > > > > -- > Michael D Neale > home: www.michaelneale.net > blog: michaelneale.blogspot.com > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > > -- View this message in context: http://www.nabble.com/BRMS-rule-info-logging-tp19766982p19799028.html Sent from the drools - user mailing list archive at Nabble.com. _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

From: David Sinclair <dsinclair(a)chariotsolutions.com&gt; Subject: Re: [rules-users] BRMS rule info logging To: "Rules Users List" <rules-users(a)lists.jboss.org&gt; Date: Friday, October 3, 2008, 3:13 PM I would fist step back and ask the question if a rules engine is the right solution to your problem. Is this data you are getting in daily in a single table, multiple tables? How complex is the data? Is the data simple enough that rules could just be some SQL statements/Stored procs? How many rules are you talking about? Could there be all kinds of rules, or just a fixed set of rules with different parameters? On Fri, Oct 3, 2008 at 1:55 PM, techluver <techluver007(a)gmail.com&gt; wrote: > > Thanks David. > I would like to give more details on my requirement. Please throw your > ideas > for good design using drools. > > 1.I'll get huge amount of data in database(60 or 70 millions) daily. I > would > like to apply the rules on those records and store the data which satisfied > the rules. So my rule engine has to run daily at specific time. > > 2.I also have to provide the reporting GUI to business users to generate > report based on rules > > 3. users also need user friendly GUI to manage the rules something like > BRMS(this would be last thing user want) > > 4. till I develop rules manager gui, I should be able to manage the rules > from the database. > > 5. I don''t need to load and apply the rules dynamically. But If I > add/remove any rule, then it should be loaded/removed during next run of > rule engine. > > I'm not really sure whether to use drools' BRMS or not here. I think i need > database driven rule engine. > > Please share your ideas for this requirement on what kind of design I need > here. > > > Thanks in advance. > > > > > techluver wrote: > > > > I'm new to drools world. Kindly clarify following things > > > > My requirement is to log each data in the DB(that meets any of the > > business rule) along with rule info. > > > > if I use BRMS ( i think it maintains the rules separately in its own db > > table) > > > > How I can associate each log with the rule info? > > > > Approach 1. Can I access BRMS's rules directly and associate it in my > > logging? > > > > Approach 2. I can't do Approach 1, then I'm thinking to have RULES table > > in my app db.Then whenever any rule is added using BRMS, Then add an > entry > > into RULES table and use this table for my logging > > > > Please advise me on the right approach. > > > > Thanks in advance. > > > > -- > View this message in context: > http://www.nabble.com/BRMS-rule-info-logging-tp19766982p19802730.html > Sent from the drools - user mailing list archive at Nabble.com. > > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > _______________________________________________ rules-users mailing list rules-users(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/rules-users

1.I would fist step back and ask the question if a rules engine is the right solution to your problem. - Actually I do have same question and need experts help to found out right answer. 1.Is this data you are getting in daily in a single table, multiple tables? - we want to assume that it is from multiple tables. 2.How complex is the data? Is the data simple enough that rules could just be some SQL statements/Stored procs? - data won't be very complex. We don't really want to do sql or SP way. Right now we want to run this rule engine for daily data at specific time. But we also want to use it for live data later on. so we want to develop this rule engine as a library to use for different source( could be from database, or live data feed etc.,). 3.How many rules are you talking about? Could there be all kinds of rules, or just a fixed set of rules with different parameters? - we are working on iterative model. now we have with 10 rules and develop rules engine for those and keep adding new rules. We are expecting to have 1200 rules at the end. right now we have two sets of rules. a.one set of rules will come compare values from field combination. It it does not match the expected value, then log it in the database with that rule info. each rule in this category will check for different field combination. i think we can say this category as "fixed set of rules with different parameters" b. another set of rule can be complicated. some examples are given below. I.To watch for field combo for n number of days. i can create a rule saying that " if field1 =''a" and field2 = 'b' combo occurs for 3 days continuously in daily data, then log those data into database. or II. i can also create a rule like this. If % variation of total count of daily data for field combo field1 =''a" & field2 = 'b' between two days > 10%, then log those data into database. Ex: 1 day i get 100 data for this combo and next day i get only 50 data for this combo. then I need to log this data(1 day count & 2nd day count) into database. Please guide me on the right approach. dave sinclair wrote: > > I would fist step back and ask the question if a rules engine is the > right > solution to your problem. > > Is this data you are getting in daily in a single table, multiple tables? > How complex is the data? Is the data simple enough that rules could just > be > some SQL statements/Stored procs? > > How many rules are you talking about? Could there be all kinds of rules, > or > just a fixed set of rules with different parameters? > > On Fri, Oct 3, 2008 at 1:55 PM, techluver <techluver007(a)gmail.com&gt; wrote: > >> >> Thanks David. >> I would like to give more details on my requirement. Please throw your >> ideas >> for good design using drools. >> >> 1.I'll get huge amount of data in database(60 or 70 millions) daily. I >> would >> like to apply the rules on those records and store the data which >> satisfied >> the rules. So my rule engine has to run daily at specific time. >> >> 2.I also have to provide the reporting GUI to business users to generate >> report based on rules >> >> 3. users also need user friendly GUI to manage the rules something like >> BRMS(this would be last thing user want) >> >> 4. till I develop rules manager gui, I should be able to manage the >> rules >> from the database. >> >> 5. I don''t need to load and apply the rules dynamically. But If I >> add/remove any rule, then it should be loaded/removed during next run >> of >> rule engine. >> >> I'm not really sure whether to use drools' BRMS or not here. I think i >> need >> database driven rule engine. >> >> Please share your ideas for this requirement on what kind of design I >> need >> here. >> >> >> Thanks in advance. >> >> >> >> >> techluver wrote: >> > >> > I'm new to drools world. Kindly clarify following things >> > >> > My requirement is to log each data in the DB(that meets any of the >> > business rule) along with rule info. >> > >> > if I use BRMS ( i think it maintains the rules separately in its own >> db >> > table) >> > >> > How I can associate each log with the rule info? >> > >> > Approach 1. Can I access BRMS's rules directly and associate it in my >> > logging? >> > >> > Approach 2. I can't do Approach 1, then I'm thinking to have RULES >> table >> > in my app db.Then whenever any rule is added using BRMS, Then add an >> entry >> > into RULES table and use this table for my logging >> > >> > Please advise me on the right approach. >> > >> > Thanks in advance. >> > >> >> -- >> View this message in context: >> http://www.nabble.com/BRMS-rule-info-logging-tp19766982p19802730.html >> Sent from the drools - user mailing list archive at Nabble.com. >> >> _______________________________________________ >> rules-users mailing list >> rules-users(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/rules-users >> > > _______________________________________________ > rules-users mailing list > rules-users(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/rules-users > >