Preparing a datamodel for internationalisation / localisation Post: 302735195

Sponsored Content

Special Forums UNIX and Linux Applications Preparing a datamodel for internationalisation / localisation Post 302735195 by figaro on Friday 23rd of November 2012 05:50:48 PM

11-23-2012

Registered User

Preparing a datamodel for internationalisation / localisation

I have a database that should ultimately be included in a reporting engine. This will be a point-and-click setup whereby the user selects columns to include in the report and the users can run and save the report-script themselves. Users will have affinity with the data, but we want to design the system so that it becomes clear in the user interface what the user is selecting. To that end we want to use the column_comment feature in MySQL.

We add column comments as follows:

Code:

ALTER TABLE productprices CHANGE price price FLOAT COMMENT 'price of a product at any given moment'

Given the flat nature of a database, this does not allow for expressions. For example, we would want to prepare the database for translations (localisation), that would in procedural languages be done using gettext for example. What would be the best way to maintain translations of column comments?

figaro

View Public Profile for figaro

Find all posts by figaro

8 More Discussions You Might Find Interesting

1. Solaris

book for preparing exam ?

dear solaris group, whitch are the best book for study admin 1 + 2 on solaris 9 to prepare for the exam of admin 1 & 2 best regards Maurizio

2. UNIX for Advanced & Expert Users

preparing veritas exams using nextcertify.com ?

how good are nextcertify.com preps for veritas exams ? . i look forward to yoiur responses

3. Linux

Documentation for preparing RHCE certification

Hi all, Could someony give me a link to download a document for preparing linux RHCE certification? Regards, Tovo

4. UNIX for Dummies Questions & Answers

Script for reading filelist and preparing param file.

Hi All, Not sure if this would be in a dummies sectiin or advanced. I'm looking for a script if someone has doen something like this. I have list of files - adc_earnedpoints.20070630.txt adc_earnedpoints.20070707.txt adc_earnedpoints.20070714.txt adc_earnedpoints.20070721.txt...

5. UNIX for Dummies Questions & Answers

Resources for preparing exam certification

I had install Sun Solaris 10 in my virtual machine. Anyhow I still very limitation knowledge how to operate it. Would like to search for help somemore could assist me how could I get the resources by free for me to learn and prepare myself for sitting the Sun cerfitication exam? Please help and...

6. AIX

AIX Monitoring Tool - under preparing

Guy's AIX Monitoring Tool - under preparing ..... I'm working to make and prepare tool to monitor AIX system and my idea it's based on the following outputs I want command to give me shout outpous about the following ... CPU load Memory load Used load Number of...

7. Shell Programming and Scripting

Preparing a list of spawned processes

Hi All I'm currently trying to develop a script which will find the child processes of a process ID already passed to the script. I then need the script to look for spawned processes of these child processes and so on until it can't find any more. For example At the moment, I have to...

8. Shell Programming and Scripting

Using localisation of a Perl package

I have a Perl package, which is widely used and tested, but recently a version in another language was added. The relevant po-files have been reviewed for this and are ready for testing. What are the steps to select the language by the user? From my understanding the language environment variable...

LEARN ABOUT CENTOS

bonds

Bonds(1)						      General Commands Manual							  Bonds(1)

NAME

       Bonds - Example of bond pricing

SYNOPSIS

       Bonds

DESCRIPTION

       Bonds is an example of using QuantLib.

       It  shows  how to set up a term structure and then price some simple bonds. The last part is dedicated to peripherical computations such as
       yield-to-price or price-to-yield.

SEE ALSO

       The source code Bonds.cpp, BermudanSwaption(1), CallableBonds(1), CDS(1), ConvertibleBonds(1), DiscreteHedging(1), EquityOption(1), Fitted-
       BondCurve(1),   FRA(1),	 MarketModels(1),   Replication(1),   Repo(1),	 SwapValuation(1),  the  QuantLib  documentation  and  website	at
       http://quantlib.org.

AUTHORS

       The QuantLib Group (see Authors.txt).

       This manual page was added by Luigi Ballabio .

QuantLib							  22 October 2008							  Bonds(1)