Wednesday, July 25, 2007

I was thinking of completing the Report Engine , but somehow the Rule Insertion Module seemed simple enough to be completed first.
So, now i am sitting just thinking over the Rule Insertion Scenario .!

Theres not really much to think of except for the DB Design which has changed once again.

Heres my latest design :

RuleMetaData:

Rule_Meta_data_ID

Rule Description

FLAG_ID

1

Any description about the rule

2

Rule_Set

Rule_set_id

Rule_Meta_data_ID

Field_id

Logic_id

Value

1

1

1

1

mysql.sheeri.com

2

1

2

1

3306

Field:

Field_id

Description

1

Port

2

Hostname


Logic:

Logic_id

Description

1

AND

2

OR

Flag:

Fag_id

Description

1

Use

2

Read

Sunday, July 22, 2007

So, Sheeri gave me a handful of rules which i would be using in creating the Rule Creation Module of the Reporting Component.

This is the Db Design which we finally came up with :

Rule:

Rule_ID

Rule Description

FLAG

1

Any description about the rule

USE


Rule_Desc

Rule_desc_id

Rule_ID

Fld

Value

Logic

1

1

hostname

mysql.sheeri.com

AND

2

1

Port

3306

AND


The link to the rule set is :

http://technocation.org/SoC/rules.html

I should now be able to integrate these requirements with my existing code of Rule Creation Module.
The module should be able to create 1 or many RULES with each RULE having exactly 1 Rule Description.


It should'nt be that hard !
Can you imagine, this is my first ever Blog !
I always hated Blogging and still do.
But then, right after i had a conversation call with Sheeri (my Manager for Google Sumemr of Code) and Warren (My Colleague for the MSYQL Auditing Software which we are working on), i decided to write all the points that i had in a word file.

But then i thought, why not post em up here.
Both ov them had been pushing me hard to go for blogging.
Not to forget that almost 99% of the GSocer's do blogging, with me being the only 1% hating to spend any time on blogging !

Anywayz,
Long Story short, Here i am writing down my first blog in the history of my internet usage !


Gosh...i really dont know wot to write now ..!!
lol
You see, it seems as if i am writing one of those lengthy emails to my girl friends !!
Lets see how this e-gf turns out to be.