|
| Index | Recent Threads | Unanswered Threads | List Polls | Public Albums | Who's Online | Help |
mvnForum
mvnForum Development
Hibernate Migration
Thread: food for thought
|
| No member browsing this thread |
|
Thread Status: Active Total posts in this thread: 15
|
|
| Author |
|
sru
Member  Joined: Sep 8, 2003 Post Count: 75 Status: Offline |
food for thought from our competitors http://www.jivesoftware.com/builds/docs/latest/database-guide.html I think as long as we don't have access to their code, this shouldn't cause any license issues, i hope.  |
||
|
|
dyoo78
Newbie  Joined: Sep 28, 2003 Post Count: 35 Status: Offline |
the link is broken  EDIT: the link is now good  ---------------------------------------- [Edit 1 times, last edit by dyoo78 at Nov 16, 2003 1:26:31 AM] |
||
|
|
dyoo78
Newbie Joined: Sep 28, 2003 Post Count: 35 Status: Offline |
Just in case the link gets broken. ---------------------------------------- 
dbase schema.htm
(30542 bytes)
(Download count: 55)
|
||
|
|
dyoo78
Newbie Joined: Sep 28, 2003 Post Count: 35 Status: Offline |
food for thought from our competitors http://www.jivesoftware.com/builds/docs/latest/database-guide.html I think as long as we don't have access to their code, this shouldn't cause any license issues, i hope. By the way, in order for this information to be infringing, this information must be patented. In software patents however, data structures are not patentable because it is non-unique and data structures do not patent business processes. That's why MS doesn't release source code, because the only way to keep stufff secret in the software world is trade secret. Software GUIs, data structure, structure are all ruled uncopyrightable, as well. This was decided when Yellow Pages attempted to patent the idea of the yellow pages, when apple sued MS for making a GUI, etc. So to answer the above dillemma, we can look at it without worrying. |
||
|
|
minhnn
mvnForum Developer Vietnam Joined: Oct 16, 2002 Post Count: 2956 Status: Offline |
Thanks for make this suggestion  , I also had a look at all major forum's sql script too for some nice ideas  ---------------------------------------- Minh Nguyen mvnForum Developer Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com http://www.DienDanLinux.org |
||
|
|
dejan
mvnForum Developer Joined: Feb 27, 2003 Post Count: 185 Status: Offline |
Note how jive user is much more extensible then mvnForum's. There are only few necessery columns in user table and all other data can be specified as extended properties (table jiveUserProp). So you can add properties needed by yor specific application, don't need to use others... |
||
|
|
minhnn
mvnForum Developer Vietnam Joined: Oct 16, 2002 Post Count: 2956 Status: Offline |
Yes, I agree that Jive is more extendable, but it also hurt the performance of the forum if user add some extended properties. For example, add a property to store the Thread view count in Jive is not easy without hurting the performance ---------------------------------------- Minh Nguyen mvnForum Developer Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com http://www.DienDanLinux.org |
||
|
|
llchen
Newbie Canada Joined: Sep 2, 2003 Post Count: 40 Status: Offline |
Hi, Minh: Did you check the phpBB's schema, one thing I found that the additional field [permissionLevel] in the forum table would be quite useful. Thus, before query any info related to any forum, it only needs to compare the forum's permission level with the current user's permission level, then do things accordingly. That makes the permission checking and setting much simpler and I believe this will also increase the performance in the runtime. The current mvnforum's permission schema is too complex and very confusing, and very difficult to use. |
||
|
|
dejan
mvnForum Developer Joined: Feb 27, 2003 Post Count: 185 Status: Offline |
Yes, I agree that Jive is more extendable, but it also hurt the performance of the forum if user add some extended properties. For example, add a property to store the Thread view count in Jive is not easy without hurting the performance Minh, you must admit that Jive is much more used than mvnForum. A lot of comercial sites like Oracle, Sun or sites like JavaLobby does use Jive and I guess it has acceptable performance for them even they have much more traffic then any mvnForum powered site (correct me if I am wrong!). I am not suggesting that fields that are often used such as thread count should be extended properties. But, mvnForumUser table has 40 or more columns. I am pretty sure that not every field in this table is needed for everybody. And also, if someone wants to extend mvnForum with some new property (that is part of core mvnForum) he would need to change db schema and to add new column, which is not that good. And I am not sure that joining two tables or executing one query more (thats all you need to get extended properties in Jive) would cause some visible performance problems! In fact, using caching you would reduce most db hits so this won't cause performance problems at all! Dejan |
||
|
|
murrumbeena
Newbie Joined: Dec 6, 2003 Post Count: 20 Status: Offline |
I am not suggesting that fields that are often used such as thread count should be extended properties. But, mvnForumUser table has 40 or more columns. I am pretty sure that not every field in this table is needed for everybody. And also, if someone wants to extend mvnForum with some new property (that is part of core mvnForum) he would need to change db schema and to add new column, which is not that good. And I am not sure that joining two tables or executing one query more (thats all you need to get extended properties in Jive) would cause some visible performance problems! In fact, using caching you would reduce most db hits so this won't cause performance problems at all! Dejan exactly! mvnForumUser table has 40 or more columns, some of them is not necessary for me,also,it caused hard to extend mvnforum to my website.i add some column in my mvn-build version but it will be hard to upgrade.i have to modified cold again if i want to my mvnforum up to date. my suggestion is make mvnforum more extensible so it can get bigger community. Just my two cents. ---------------------------------------- [Edit 1 times, last edit by minhnn at Jan 15, 2004 3:39:52 PM] |
||
|
|
|
|
Current timezone is GMT Jan 7, 2009 4:27:13 PM |