Recently, I used bitwise Anding in my grails project. I am sharing the approach that we followed by means of an example.
\n<\/br>
\nSuppose we have a domain class Person which can have multiple attributes like Smart, Intelligent, Talkative etc.<\/p>\n
What sort of relationship comes to our mind when we see this?
\nI believe the obvious answer would be Person hasMany Attributes<\/p>\n
Next, what if we want to optimize our design so that the searches on the Person becomes better.<\/p>\n
Well, this was the question we were facing in our recent project where we finally used the bitwise AND.
\nWe decided to have one field of type Long in our Person class. We named this as attributes . Soon, I ll be explaining why a long for Attribute…<\/p>\n
We ensured that the Attributes are never going to be more than 20-30 . So, it became a nice candidate which could utilize the benefit of Bitwise ANDing.<\/p>\n
We associated a binary weight to every instance of Attribute domain class.<\/p>\n
The rows in the attribute table of our database looked somewhat like this
\n[java]
\nid | attribute | weight
\n1 | Smart | 1
\n2 | Talkative | 2
\n3 | Intelligent | 4
\n4 | Cooperative | 8
\n5 | Ignorant | 16
\n[\/java]
\nSo, in order to save a Person who is Smart and Cooperative , we would set his attributes field.
\nweight of Smart + weight of Cooperative.
\nie 1+8 = 9.<\/p>\n
Suppose our Person table has some entries as follows:<\/p>\n
[java]
\nid | name | attributes
\n1 | Tom | 9
\n2 | Fred | 12
\n3 | John | 18
\n[\/java]<\/p>\n
If we want to search a person who is Intelligent we need to have a final query like this
\n[java]
\nSelect * from person where attributes&4 = 4
\n(4 is the weight of Attribute – Intelligent)
\n[\/java]
\nSearch a person who is Cooperative and Talkative
\n[java]
\nSelect * from person where attributes&2=2 and attributes&8=8
\nor more optimally,
\nSelect * from person where attributes&10=10
\n(2 is the weight of Talkative and 8 is the weight of Cooperative)
\n[\/java]<\/p>\n
<\/br> Thanks & Regards Recently, I used bitwise Anding in my grails project. I am sharing the approach that we followed by means of an example. Suppose we have a domain class Person which can have multiple attributes like Smart, Intelligent, Talkative etc. What sort of relationship comes to our mind when we see this? I believe the obvious […]<\/p>\n","protected":false},"author":26,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":9,"footnotes":""},"categories":[7],"tags":[29,4840,265,76,477],"class_list":["post-3666","post","type-post","status-publish","format-standard","hentry","category-grails","tag-gorm","tag-grails","tag-hibernate","tag-mysql","tag-optimization"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
\nSome points to be kept in mind before taking this approach:<\/strong>
\nThere is a maximum limit of 64 values for the field on which we plan to do BitwiseANDing.
\nBitwise AND is not directly supported by Hibernate, but we can add a custom function and dialect.<\/p>\n
\nHope this helped.<\/p>\n
\nMohd Farid<\/p>\n","protected":false},"excerpt":{"rendered":"