- Where Developers Learn, Share, & Build Careers


OK, so data about several types of posts (common post and complicated with many form fields, assuming DB Preformated post). It is clear that the data of these posts should be stored in separate tables.

The problem is that all these post tables should have some additional choices / comments that are linked to them. This will mean more than tables / queries ...

Would you recommend top organizations in this reply? Or this image:

Another example of the pyphomorphic association But another with polymorphic assoc The problem is, there can not be comment in all the posts (entities). And if I only have to do a search to post, then this is only the information of the object (from the comment table), I have to find a table of all the posts to find it ... or you would recommend it to the solid aproach and a lot Have more tables and inquiries? PS: Any suggestion will be very unfair :)

As you do not paint it, consider getting a good database book and reading part about general forms. In the very wrong context it is the idea that the database is to be enumerated with a lot of tap entries as a very large table, and then to create more tables, the column set is divided carefully. Intuition is not required for many common forms (proper to focus on BCNF), there are well defined generalization rules that guarantee a good result. When you do not need any taps to represent the data model, you have done it. In some cases you might want to avoid some division (and skip) to avoid joining performance reasons, but it should be done only after benchmarking or if you are very experienced with your environment and data. Databases in a Well Normally Databases are a beautiful thing, the questions are simple and the data integrity is easy to implement.

This is a proper introduction.

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more