@Peter, I second David. Your project can easily grow and if you went the NoSQL way, then your question will turn from DBMS bottlenecks to  functionalities. I'd suggest starting with Apache Cassandra (Very Easy to start with) and Thrift (Developed by Facebook ).

On Thu, Feb 24, 2011 at 9:02 PM, David Njuguna <dnjuguna@gmail.com> wrote:
@Peter, you might want to check out NO-SQL, I believe you are facing the same challenges that led to NO-SQL evolution.


On Thu, Feb 24, 2011 at 7:06 PM, Peter Karunyu <pkarunyu@gmail.com> wrote:
Damn! Seems like i just opened a can of goodies! This EAV debate seems very interesting. I wonder how Joomla would behave if the database was EAV...


On Thu, Feb 24, 2011 at 5:36 PM, Paul Kevin <paultitude@gmail.com> wrote:
yap

http://en.wikipedia.org/wiki/Unified_Modeling_Language


On Thu, Feb 24, 2011 at 5:34 PM, Kiti Chigiri <kiti.chigiri@gmail.com> wrote:
also see http://stackoverflow.com/questions/4481672/is-eav-hybrid-a-bad-database-design-choice

On 2/24/11, Kiti Chigiri <kiti.chigiri@gmail.com> wrote:
> is http://en.wikipedia.org/wiki/Entity-attribute-value_model  what you
> are describing ?
>
> if so, you may want to check out MagentoCommerce   which uses a
> simiiar design structure. They have a well documented doc especcially
> . w.r.t  challenges and benefits
> see
> http://www.magentocommerce.com/wiki/development/magento_database_diagram
>
>
>
> On 2/24/11, Paul Kevin <paultitude@gmail.com> wrote:
>> I hope you are starting with a UML class diagram
>>
>> On Thu, Feb 24, 2011 at 5:02 PM, James Nzomo <kazikubwa@gmail.com> wrote:
>>
>>> boss thats what foreign keys are for
>>>
>>> _______________________________________________
>>> Skunkworks mailing list
>>> Skunkworks@lists.my.co.ke
>>> http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
>>> ------------
>>> Skunkworks Rules
>>> http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
>>> ------------
>>> Other services @ http://my.co.ke
>>>
>>
>
_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke


_______________________________________________
Skunkworks mailing list
Skunkworks@lists.my.co.ke
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks
------------
Skunkworks Rules
http://my.co.ke/phpbb/viewtopic.php?f=24&t=94
------------
Other services @ http://my.co.ke



--
Regards
Mike Muraguri
Software Engineer
Skype: mickie.mic
M: +254 - 722 - 799 445