DB Columns ordering
Original Publication Date: 2005-Apr-25
Included in the Prior Art Database: 2005-Apr-25
DB Columns language-based ordering. In a database or spread sheet, usually the columns are represented and extracted in the order they are written in (unless otherwise decided). The normal extraction order will include the most meaningful fields on the left (key columns) and all the evaluated fields following, going from left to the right. If this natural order is fine for European people, it could not be fine for people used to write from right to the left and to read from the end to the beginning (like Arabic based languages).
DB Columns ordering
Disclosed is a method that avoids to manually change the "European based" queries to make them specific for right-left languages.
The idea is to add a simple "mirroring feature" software to the database so that when a table display is issued, it starts from the right part of the table (having the most meaningful columns on the right, the key ones) and following on the left all the other, in a mirrored order.
The same would apply to the reporting (select). Instead of providing a specific query containing a select specific for right-left languages, the normal select can just be mirrored, so that the columns will appear in the output in the proper order, according to the language.
This would also be of help in case the table display or the report output will be printed out for a later use. The same principle applies to a spreadsheet, as well.
There are some easy logic components (shown in fig.1) that will "mirror" the query used for the table or report display. It is just matter to invert the order of the selected columns and enable the display to start from the right most part of the available display area.
There is a switch based on the language environment variable that will automatically activate the order feature so that the output will be shown in the proper "language order.", unless the feature is disabled. There could be a list to selectively enable the feature for a set/group of tables only.
In the picture (fig.1) are highlited the displ...