125 reputation
6
bio website
location Brasilia, Brazil
age 24
visits member for 1 year, 10 months
seen Mar 9 at 17:35

Beginner/Intermediary Java Webapps Developer. I use mostly JSF 2, PrimeFaces, Weld (CDI), Hibernate, Apache Tomcat 7, JBoss AS7 and MySQL.


Sep
24
awarded  Autobiographer
Sep
23
awarded  Popular Question
Jan
19
comment What is the locking behavior for Updatable/Insertable Views?
Thank you very much. :)
Jan
19
accepted What is the locking behavior for Updatable/Insertable Views?
Jan
15
asked What is the locking behavior for Updatable/Insertable Views?
Jan
15
awarded  Scholar
Jan
15
accepted Is it a good practice to apply Vertical Partition to a newly created model?
Jan
5
comment Is it a good practice to apply Vertical Partition to a newly created model?
Since Requirements says only 1 entity exists, creating 2 classes is the last option. I would need to map the same Entity Class to two tables, but that is not an ORM best practice. Having a 100% transparent way of splitting the table and only externalizing one table/view/whatever to the application would be the perfect solution.
Jan
5
comment Is it a good practice to apply Vertical Partition to a newly created model?
Have you ever tested inserting/updating a view? Do you know if in the situation where all the modified columns belong to only one table, only that table is going to get a lock on? If yes, would you mind elaborating on that in your answer?
Jan
5
awarded  Editor
Jan
5
revised Is it a good practice to apply Vertical Partition to a newly created model?
edited body
Jan
5
comment Is it a good practice to apply Vertical Partition to a newly created model?
I think it is about table design AND vertical partitioning, since the latter may be a solution for the design. Although I liked you answer, I don't know if those partitions you mentioned are only horizontal. The suggestion I mentioned on the question was to split the table vertically, half columns go to one table, the other half goes to the other table, separating data that will be inserted on the first moment from data that will be populated only latter, without causing locks on the first table.
Jan
5
revised Is it a good practice to apply Vertical Partition to a newly created model?
edited tags
Jan
5
awarded  Supporter
Jan
5
comment Is it a good practice to apply Vertical Partition to a newly created model?
Thanks for the very complete answer. Although, I think I was not clear about my question. It's about vertical partition, not horizontal. I don't if the 3 methods you said apply to vertical partitioning, and preventing locks on the whole table.
Jan
4
awarded  Student
Jan
4
asked Is it a good practice to apply Vertical Partition to a newly created model?