Re: [Skunkworks] Database design question
That's a clever design. So here's my question: Problem 1: Suppose you have 2 Objects, Object1 and Object2 with respective properties as Object1.ObjectProperties1, Object1.ObjectProperties2 and Object2.ObjectProperties1, Object2.ObjectProperties2 If you want to select values for Object1.ObjectPropertyTypes1 and Object2.ObjectPropertyTypes2 into 1 result set, then the query has to first resolve the respective IDs of the properties then query the values. Problem 2: Any result from query has to contain the ObjectPropertyType so that the type is know and can be placed in the right class type in your code e.g. for dates, you might like to place that in a Date object, Float object etc (since these are stored as strings in the DB). There are 2 sub-problems here. 1 is that the ObjectPropertyType table has to be re-queried every time u run a query, and 2, existing libraries that might translate a DB value to int, float, etc will not understand your structure therefore will resolve the field values to strings and u have to cast them to the types you want. Problem 3: You loose out on indexing features of the DB thus your DB will perform slower. I bet there are other problems... 8~) --- On Thu, 2/24/11, skunkworks-request@lists.my.co.ke <skunkworks-request@lists.my.co.ke> wrote: From: skunkworks-request@lists.my.co.ke <skunkworks-request@lists.my.co.ke> Subject: Skunkworks Digest, Vol 12, Issue 326 To: skunkworks@lists.my.co.ke Date: Thursday, February 24, 2011, 7:07 AM Send Skunkworks mailing list submissions to skunkworks@lists.my.co.ke To subscribe or unsubscribe via the World Wide Web, visit http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks or, via email, send a message with subject or body 'help' to skunkworks-request@lists.my.co.ke You can reach the person managing the list at skunkworks-owner@lists.my.co.ke When replying, please edit your Subject line so it is more specific than "Re: Contents of Skunkworks digest..." Today's Topics: 1. Re: Dont try make a complete CMS by yourself (Steve Obbayi) 2. Re: Forum ya opinions (Geoffrey Mimano) 3. Re: Forum ya opinions (Okechukwu) 4. Re: Dont try make a complete CMS by yourself (Frankline Chitwa) 5. Re: Wordpress releases Django, wait WTF? (Frankline Chitwa) ---------------------------------------------------------------------- Message: 1 Date: Thu, 24 Feb 2011 05:41:30 +0300 (EAT) From: Steve Obbayi <steve@sobbayi.com> To: Skunkworks Mailing List <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] Dont try make a complete CMS by yourself Message-ID: <15890304.401298515288968.JavaMail.SYSTEM@obbayi> Content-Type: text/plain; charset="utf-8"
I refuse to divulge the URLs so that you can hack them.
Are they that insecure, just kidding :)... maybe I can help
@Steve Obbayi, being a flash developer I am sure you will appreciate what I was trying to clone.
Actually I dont regard myself a Flash developer, my work doesnt require it, I mainly use it to tutor a bunch of people, the same goes for PHP, Java and a bunch of other languages. I actually code in C/C++ and Assembly (well, sue me) on a daily basis. Also Python. @Humphrey thats a Nice App though ----- "Humphrey Ngoiya" <hngoiya@yahoo.co.uk> wrote:
I refuse to divulge the URLs so that you can hack them. attached is my futile attempt at making the nokia calling for all innovators-Africa, ADOBE flash app category (source code is also included). If you want to attack my coding pedigree, go ahead.
@ Steve Obbayi , being a flash developer I am sure you will appreciate what I was trying to clone.
@Mimano, I can't think of any semantic importance. I am just curious if it would work and if not, why. If it did, would it be better than the norm and if not, why? @Wesley, at the back of my mind, I knew there was something I was overlooking, I just didn't know what. Your problems have shed more light. I will create the proposed structure in MySQL, load it up with some data and then run some benchmarks. Then maybe we can analyze the findings from there. On Thu, Feb 24, 2011 at 8:40 AM, wesley kirinya <kiriinya2000@yahoo.com>wrote:
That's a clever design. So here's my question:
Problem 1: Suppose you have 2 Objects, Object1 and Object2 with respective properties as Object1.ObjectProperties1, Object1.ObjectProperties2 and Object2.ObjectProperties1, Object2.ObjectProperties2 If you want to select values for Object1.ObjectPropertyTypes1 and Object2.ObjectPropertyTypes2 into 1 result set, then the query has to first resolve the respective IDs of the properties then query the values.
Problem 2: Any result from query has to contain the ObjectPropertyType so that the type is know and can be placed in the right class type in your code e.g. for dates, you might like to place that in a Date object, Float object etc (since these are stored as strings in the DB). There are 2 sub-problems here. 1 is that the ObjectPropertyType table has to be re-queried every time u run a query, and 2, existing libraries that might translate a DB value to int, float, etc will not understand your structure therefore will resolve the field values to strings and u have to cast them to the types you want.
Problem 3: You loose out on indexing features of the DB thus your DB will perform slower.
I bet there are other problems...
8~)
--- On *Thu, 2/24/11, skunkworks-request@lists.my.co.ke < skunkworks-request@lists.my.co.ke>* wrote:
From: skunkworks-request@lists.my.co.ke <skunkworks-request@lists.my.co.ke
Subject: Skunkworks Digest, Vol 12, Issue 326 To: skunkworks@lists.my.co.ke Date: Thursday, February 24, 2011, 7:07 AM
Send Skunkworks mailing list submissions to skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks or, via email, send a message with subject or body 'help' to skunkworks-request@lists.my.co.ke<http://mc/compose?to=skunkworks-request@lists.my.co.ke>
You can reach the person managing the list at skunkworks-owner@lists.my.co.ke<http://mc/compose?to=skunkworks-owner@lists.my.co.ke>
When replying, please edit your Subject line so it is more specific than "Re: Contents of Skunkworks digest..."
Today's Topics:
1. Re: Dont try make a complete CMS by yourself (Steve Obbayi) 2. Re: Forum ya opinions (Geoffrey Mimano) 3. Re: Forum ya opinions (Okechukwu) 4. Re: Dont try make a complete CMS by yourself (Frankline Chitwa) 5. Re: Wordpress releases Django, wait WTF? (Frankline Chitwa)
----------------------------------------------------------------------
Message: 1 Date: Thu, 24 Feb 2011 05:41:30 +0300 (EAT) From: Steve Obbayi <steve@sobbayi.com<http://mc/compose?to=steve@sobbayi.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Dont try make a complete CMS by yourself Message-ID: <15890304.401298515288968.JavaMail.SYSTEM@obbayi> Content-Type: text/plain; charset="utf-8"
I refuse to divulge the URLs so that you can hack them.
Are they that insecure, just kidding :)... maybe I can help
@Steve Obbayi, being a flash developer I am sure you will appreciate what I was trying to clone.
Actually I dont regard myself a Flash developer, my work doesnt require it, I mainly use it to tutor a bunch of people, the same goes for PHP, Java and a bunch of other languages. I actually code in C/C++ and Assembly (well, sue me) on a daily basis. Also Python.
@Humphrey thats a Nice App though
----- "Humphrey Ngoiya" <hngoiya@yahoo.co.uk<http://mc/compose?to=hngoiya@yahoo.co.uk>> wrote:
I refuse to divulge the URLs so that you can hack them. attached is my futile attempt at making the nokia calling for all innovators-Africa, ADOBE flash app category (source code is also included). If you want to attack my coding pedigree, go ahead.
@ Steve Obbayi , being a flash developer I am sure you will appreciate what I was trying to clone.
@David, I'll contact you offlist in a short while. @James, regarding the Blob/Filesytem issue, it is as debatable as the Apple vs. Adobe Flash debate. Most of the open source apps I have interacted with tend to prefer storing files on the filesystem. Regarding the BWC CMS, let us do some experiments first and see how they come out :-) On Thu, Feb 24, 2011 at 10:45 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:
@Mimano, I can't think of any semantic importance. I am just curious if it would work and if not, why. If it did, would it be better than the norm and if not, why?
@Wesley, at the back of my mind, I knew there was something I was overlooking, I just didn't know what. Your problems have shed more light.
I will create the proposed structure in MySQL, load it up with some data and then run some benchmarks. Then maybe we can analyze the findings from there.
On Thu, Feb 24, 2011 at 8:40 AM, wesley kirinya <kiriinya2000@yahoo.com>wrote:
That's a clever design. So here's my question:
Problem 1: Suppose you have 2 Objects, Object1 and Object2 with respective properties as Object1.ObjectProperties1, Object1.ObjectProperties2 and Object2.ObjectProperties1, Object2.ObjectProperties2 If you want to select values for Object1.ObjectPropertyTypes1 and Object2.ObjectPropertyTypes2 into 1 result set, then the query has to first resolve the respective IDs of the properties then query the values.
Problem 2: Any result from query has to contain the ObjectPropertyType so that the type is know and can be placed in the right class type in your code e.g. for dates, you might like to place that in a Date object, Float object etc (since these are stored as strings in the DB). There are 2 sub-problems here. 1 is that the ObjectPropertyType table has to be re-queried every time u run a query, and 2, existing libraries that might translate a DB value to int, float, etc will not understand your structure therefore will resolve the field values to strings and u have to cast them to the types you want.
Problem 3: You loose out on indexing features of the DB thus your DB will perform slower.
I bet there are other problems...
8~)
--- On *Thu, 2/24/11, skunkworks-request@lists.my.co.ke < skunkworks-request@lists.my.co.ke>* wrote:
From: skunkworks-request@lists.my.co.ke < skunkworks-request@lists.my.co.ke> Subject: Skunkworks Digest, Vol 12, Issue 326 To: skunkworks@lists.my.co.ke Date: Thursday, February 24, 2011, 7:07 AM
Send Skunkworks mailing list submissions to skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks or, via email, send a message with subject or body 'help' to skunkworks-request@lists.my.co.ke<http://mc/compose?to=skunkworks-request@lists.my.co.ke>
You can reach the person managing the list at skunkworks-owner@lists.my.co.ke<http://mc/compose?to=skunkworks-owner@lists.my.co.ke>
When replying, please edit your Subject line so it is more specific than "Re: Contents of Skunkworks digest..."
Today's Topics:
1. Re: Dont try make a complete CMS by yourself (Steve Obbayi) 2. Re: Forum ya opinions (Geoffrey Mimano) 3. Re: Forum ya opinions (Okechukwu) 4. Re: Dont try make a complete CMS by yourself (Frankline Chitwa) 5. Re: Wordpress releases Django, wait WTF? (Frankline Chitwa)
----------------------------------------------------------------------
Message: 1 Date: Thu, 24 Feb 2011 05:41:30 +0300 (EAT) From: Steve Obbayi <steve@sobbayi.com<http://mc/compose?to=steve@sobbayi.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Dont try make a complete CMS by yourself Message-ID: <15890304.401298515288968.JavaMail.SYSTEM@obbayi> Content-Type: text/plain; charset="utf-8"
I refuse to divulge the URLs so that you can hack them.
Are they that insecure, just kidding :)... maybe I can help
@Steve Obbayi, being a flash developer I am sure you will appreciate what I was trying to clone.
Actually I dont regard myself a Flash developer, my work doesnt require it, I mainly use it to tutor a bunch of people, the same goes for PHP, Java and a bunch of other languages. I actually code in C/C++ and Assembly (well, sue me) on a daily basis. Also Python.
@Humphrey thats a Nice App though
----- "Humphrey Ngoiya" <hngoiya@yahoo.co.uk<http://mc/compose?to=hngoiya@yahoo.co.uk>> wrote:
I refuse to divulge the URLs so that you can hack them. attached is my futile attempt at making the nokia calling for all innovators-Africa, ADOBE flash app category (source code is also included). If you want to attack my coding pedigree, go ahead.
@ Steve Obbayi , being a flash developer I am sure you will appreciate what I was trying to clone.
Regarding storing files in a blob field or filesystem, i think you should only store files in a blob if you really have to, otherwise filesystem do a better job at storing files than databases. Thats what they were made for. @Peter, the schema you have proposed is quite flexible (2 likes!!). It sees ahead :-) On 24 February 2011 02:50, Peter Karunyu <pkarunyu@gmail.com> wrote:
@David, I'll contact you offlist in a short while.
@James, regarding the Blob/Filesytem issue, it is as debatable as the Apple vs. Adobe Flash debate. Most of the open source apps I have interacted with tend to prefer storing files on the filesystem. Regarding the BWC CMS, let us do some experiments first and see how they come out :-)
On Thu, Feb 24, 2011 at 10:45 AM, Peter Karunyu <pkarunyu@gmail.com>wrote:
@Mimano, I can't think of any semantic importance. I am just curious if it would work and if not, why. If it did, would it be better than the norm and if not, why?
@Wesley, at the back of my mind, I knew there was something I was overlooking, I just didn't know what. Your problems have shed more light.
I will create the proposed structure in MySQL, load it up with some data and then run some benchmarks. Then maybe we can analyze the findings from there.
On Thu, Feb 24, 2011 at 8:40 AM, wesley kirinya <kiriinya2000@yahoo.com>wrote:
That's a clever design. So here's my question:
Problem 1: Suppose you have 2 Objects, Object1 and Object2 with respective properties as Object1.ObjectProperties1, Object1.ObjectProperties2 and Object2.ObjectProperties1, Object2.ObjectProperties2 If you want to select values for Object1.ObjectPropertyTypes1 and Object2.ObjectPropertyTypes2 into 1 result set, then the query has to first resolve the respective IDs of the properties then query the values.
Problem 2: Any result from query has to contain the ObjectPropertyType so that the type is know and can be placed in the right class type in your code e.g. for dates, you might like to place that in a Date object, Float object etc (since these are stored as strings in the DB). There are 2 sub-problems here. 1 is that the ObjectPropertyType table has to be re-queried every time u run a query, and 2, existing libraries that might translate a DB value to int, float, etc will not understand your structure therefore will resolve the field values to strings and u have to cast them to the types you want.
Problem 3: You loose out on indexing features of the DB thus your DB will perform slower.
I bet there are other problems...
8~)
--- On *Thu, 2/24/11, skunkworks-request@lists.my.co.ke < skunkworks-request@lists.my.co.ke>* wrote:
From: skunkworks-request@lists.my.co.ke < skunkworks-request@lists.my.co.ke> Subject: Skunkworks Digest, Vol 12, Issue 326 To: skunkworks@lists.my.co.ke Date: Thursday, February 24, 2011, 7:07 AM
Send Skunkworks mailing list submissions to skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks or, via email, send a message with subject or body 'help' to skunkworks-request@lists.my.co.ke<http://mc/compose?to=skunkworks-request@lists.my.co.ke>
You can reach the person managing the list at skunkworks-owner@lists.my.co.ke<http://mc/compose?to=skunkworks-owner@lists.my.co.ke>
When replying, please edit your Subject line so it is more specific than "Re: Contents of Skunkworks digest..."
Today's Topics:
1. Re: Dont try make a complete CMS by yourself (Steve Obbayi) 2. Re: Forum ya opinions (Geoffrey Mimano) 3. Re: Forum ya opinions (Okechukwu) 4. Re: Dont try make a complete CMS by yourself (Frankline Chitwa) 5. Re: Wordpress releases Django, wait WTF? (Frankline Chitwa)
----------------------------------------------------------------------
Message: 1 Date: Thu, 24 Feb 2011 05:41:30 +0300 (EAT) From: Steve Obbayi <steve@sobbayi.com<http://mc/compose?to=steve@sobbayi.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Dont try make a complete CMS by yourself Message-ID: <15890304.401298515288968.JavaMail.SYSTEM@obbayi> Content-Type: text/plain; charset="utf-8"
I refuse to divulge the URLs so that you can hack them.
Are they that insecure, just kidding :)... maybe I can help
@Steve Obbayi, being a flash developer I am sure you will appreciate what I was trying to clone.
Actually I dont regard myself a Flash developer, my work doesnt require it, I mainly use it to tutor a bunch of people, the same goes for PHP, Java and a bunch of other languages. I actually code in C/C++ and Assembly (well, sue me) on a daily basis. Also Python.
@Humphrey thats a Nice App though
----- "Humphrey Ngoiya" <hngoiya@yahoo.co.uk<http://mc/compose?to=hngoiya@yahoo.co.uk>> wrote:
I refuse to divulge the URLs so that you can hack them. attached is my futile attempt at making the nokia calling for all innovators-Africa, ADOBE flash app category (source code is also included). If you want to attack my coding pedigree, go ahead.
@ Steve Obbayi , being a flash developer I am sure you will appreciate what I was trying to clone.
Seems like the proposed database structure is eerily similar to the Object Database model <http://en.wikipedia.org/wiki/Object_database>, but maybe the experiment will provide some insights into the viability of implementing OODBMS on top of RDBMS. Maybe by writing the data access layer functionality in the application, one can achieve the best of both worlds. On Thu, Feb 24, 2011 at 11:09 AM, Ndungi Kyalo <ndungi@gmail.com> wrote:
Regarding storing files in a blob field or filesystem, i think you should only store files in a blob if you really have to, otherwise filesystem do a better job at storing files than databases. Thats what they were made for.
@Peter, the schema you have proposed is quite flexible (2 likes!!). It sees ahead :-)
On 24 February 2011 02:50, Peter Karunyu <pkarunyu@gmail.com> wrote:
@David, I'll contact you offlist in a short while.
@James, regarding the Blob/Filesytem issue, it is as debatable as the Apple vs. Adobe Flash debate. Most of the open source apps I have interacted with tend to prefer storing files on the filesystem. Regarding the BWC CMS, let us do some experiments first and see how they come out :-)
On Thu, Feb 24, 2011 at 10:45 AM, Peter Karunyu <pkarunyu@gmail.com>wrote:
@Mimano, I can't think of any semantic importance. I am just curious if it would work and if not, why. If it did, would it be better than the norm and if not, why?
@Wesley, at the back of my mind, I knew there was something I was overlooking, I just didn't know what. Your problems have shed more light.
I will create the proposed structure in MySQL, load it up with some data and then run some benchmarks. Then maybe we can analyze the findings from there.
On Thu, Feb 24, 2011 at 8:40 AM, wesley kirinya <kiriinya2000@yahoo.com>wrote:
That's a clever design. So here's my question:
Problem 1: Suppose you have 2 Objects, Object1 and Object2 with respective properties as Object1.ObjectProperties1, Object1.ObjectProperties2 and Object2.ObjectProperties1, Object2.ObjectProperties2 If you want to select values for Object1.ObjectPropertyTypes1 and Object2.ObjectPropertyTypes2 into 1 result set, then the query has to first resolve the respective IDs of the properties then query the values.
Problem 2: Any result from query has to contain the ObjectPropertyType so that the type is know and can be placed in the right class type in your code e.g. for dates, you might like to place that in a Date object, Float object etc (since these are stored as strings in the DB). There are 2 sub-problems here. 1 is that the ObjectPropertyType table has to be re-queried every time u run a query, and 2, existing libraries that might translate a DB value to int, float, etc will not understand your structure therefore will resolve the field values to strings and u have to cast them to the types you want.
Problem 3: You loose out on indexing features of the DB thus your DB will perform slower.
I bet there are other problems...
8~)
--- On *Thu, 2/24/11, skunkworks-request@lists.my.co.ke < skunkworks-request@lists.my.co.ke>* wrote:
From: skunkworks-request@lists.my.co.ke < skunkworks-request@lists.my.co.ke> Subject: Skunkworks Digest, Vol 12, Issue 326 To: skunkworks@lists.my.co.ke Date: Thursday, February 24, 2011, 7:07 AM
Send Skunkworks mailing list submissions to skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks or, via email, send a message with subject or body 'help' to skunkworks-request@lists.my.co.ke<http://mc/compose?to=skunkworks-request@lists.my.co.ke>
You can reach the person managing the list at skunkworks-owner@lists.my.co.ke<http://mc/compose?to=skunkworks-owner@lists.my.co.ke>
When replying, please edit your Subject line so it is more specific than "Re: Contents of Skunkworks digest..."
Today's Topics:
1. Re: Dont try make a complete CMS by yourself (Steve Obbayi) 2. Re: Forum ya opinions (Geoffrey Mimano) 3. Re: Forum ya opinions (Okechukwu) 4. Re: Dont try make a complete CMS by yourself (Frankline Chitwa) 5. Re: Wordpress releases Django, wait WTF? (Frankline Chitwa)
----------------------------------------------------------------------
Message: 1 Date: Thu, 24 Feb 2011 05:41:30 +0300 (EAT) From: Steve Obbayi <steve@sobbayi.com<http://mc/compose?to=steve@sobbayi.com>
To: Skunkworks Mailing List <skunkworks@lists.my.co.ke<http://mc/compose?to=skunkworks@lists.my.co.ke>
Subject: Re: [Skunkworks] Dont try make a complete CMS by yourself Message-ID: <15890304.401298515288968.JavaMail.SYSTEM@obbayi> Content-Type: text/plain; charset="utf-8"
I refuse to divulge the URLs so that you can hack them.
Are they that insecure, just kidding :)... maybe I can help
@Steve Obbayi, being a flash developer I am sure you will appreciate what I was trying to clone.
Actually I dont regard myself a Flash developer, my work doesnt require it, I mainly use it to tutor a bunch of people, the same goes for PHP, Java and a bunch of other languages. I actually code in C/C++ and Assembly (well, sue me) on a daily basis. Also Python.
@Humphrey thats a Nice App though
----- "Humphrey Ngoiya" <hngoiya@yahoo.co.uk<http://mc/compose?to=hngoiya@yahoo.co.uk>> wrote:
I refuse to divulge the URLs so that you can hack them. attached is my futile attempt at making the nokia calling for all innovators-Africa, ADOBE flash app category (source code is also included). If you want to attack my coding pedigree, go ahead.
@ Steve Obbayi , being a flash developer I am sure you will appreciate what I was trying to clone.
What if i have to store data related to an event that spurns several days (> 1) how will that be stored in the tables? If i have different pieces of data but are related and need to be displayed as such eg a drop down menu, quick links how does the data get linked? Just curious
boss thats what foreign keys are for
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
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
also see http://stackoverflow.com/questions/4481672/is-eav-hybrid-a-bad-database-desi... 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
yap http://en.wikipedia.org/wiki/Class_diagram <http://en.wikipedia.org/wiki/Class_diagram> 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-desi...
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
Damn! Seems like i just opened a can of goodies! This EAV<http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores>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/Class_diagram 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-desi...
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
@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<http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores>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/Class_diagram 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-desi...
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
@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<http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores>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/Class_diagram 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-desi...
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
On Sat, Feb 26, 2011 at 10:17 AM, Michael Muraguri <mickie.mic@gmail.com>wrote:
@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 ).
Ok, will check them out. I am looking at this as a sort of experiment. I will create a simple CMS with an EAV database structure running on top of MySQL and code igniter, then use it on a real life scenario replica ndio nione how it behaves. Then later I explore this NoSQL and Cassandra universe. Much thanks
participants (9)
-
David Njuguna -
James Nzomo -
Kiti Chigiri -
Michael Muraguri -
Nd'wex Common -
Ndungi Kyalo -
Paul Kevin -
Peter Karunyu -
wesley kirinya