Database strucure for versioning and multiple languages

Posted by phobia on Stack Overflow See other posts from Stack Overflow or by phobia
Published on 2010-05-29T13:45:10Z Indexed on 2010/05/29 13:52 UTC
Read the original article Hit count: 263

Filed under:

database

|

versioning

|

natural-language

Hi,

I'm wondering how to best solve the issue of content existing in multiple versions and multiple languages.

An image of my current structure can be seen here: http://i46.tinypic.com/72fx3k.png

Each content can only have one active version in each language, and that's how I'm curious on how to best solve.

Right now I have a column of the contentversions table, which means for each change of active version I have to run a update and set active=false on all version and then a update to set active=true for the piece of content in question.

Any thoughts? :)

© Stack Overflow or respective owner

Related posts about database

SQL SERVER Retrieve and Explore Database Backup without Restoring Database Idera virtual database

as seen on Dot net Slackers - Search for 'Dot net Slackers'
I recently downloaded Ideras SQL virtual database, and tested it. There are a few things about this tool which caught my attention.My ScenarioIt is quite common in real life that sometimes observing or retrieving older data is necessary; however, it had changed as time passed by. The full database… >>> More
Cloning A Database On The Same Server Using Rman Duplicate From Active Database

as seen on Oracle Blogs - Search for 'Oracle Blogs'
To clone a database using Rman we used to require an existing Rman backup, on 11g we can clone databases using the "from active" database option. In this case we do not require an existing backup, the active datafiles will be used as the source for the clone. In order to clone with the source database… >>> More
cPickle ImportError: No module named multiarray

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm using cPickle to save my Database into file. The code looks like that: def Save_DataBase(): import cPickle from scipy import * from numpy import * a=Results.VersionName #filename='D:/results/'+a[a.find('/')+1:-a.find('/')-2]+Results.AssType[:3]+str(random.randint(0,100))+Results.Distribution+"… >>> More
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot

as seen on SQL Authority - Search for 'SQL Authority'
Snapshot database is one of the most interesting concepts that I have used at some places recently. Here is a quick definition of the subject from Book On Line: A Database Snapshot is a read-only, static view of a database (the source database). Multiple snapshots can exist on a source database and… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More

Related posts about versioning

Web Site Performance and Assembly Versioning – Part 3 Versioning Combined Files Using Mercurial

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Minification and Concatination of JavaScript and CSS Files Versioning Combined Files Using Subversion Versioning Combined Files Using Mercurial – this post I have worked on a project recently where there was a need to version the system (library dll, css and javascript files) by date and… >>> More
Web Site Performance and Assembly Versioning – Part 2 Versioning Combined Files Using Subversion

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Ok so it took a while to post this second part. Many apologies, we had a big roll out of a new platform at work and many things had to get sidelined. So this is the second part in a short series of website performance and using versioning to help improve it. Minification and Concatination of JavaScript… >>> More
Sharepoint webpart-page versioning

as seen on Stack Overflow - Search for 'Stack Overflow'
On webpart-pages it is possible modify the contained webparts over the Web by using Site Actions-Edit page. Is there a possibility to view the version history of such a page? >>> More
jboss envers for versioning?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have entities that required versioning support and from time to time, i will need to retrieve old version of the entity . should i just use options available 1. http://stackoverflow.com/questions/762405/database-data-versioning 2. jboss envers (can this be used on any web server,tomcat,jetty… >>> More
UPK Content State

as seen on Oracle Blogs - Search for 'Oracle Blogs'
State is an editable property for communicating the status of a document in the UPK library. This is particularly helpful when working with other authors in a development team. Authors can assign a state to any document using the values that are defined in the master list. The default master list… >>> More