×

Database structures and administration techniques for generalized localization of database items

  • US 8,504,534 B1
  • Filed: 09/26/2007
  • Issued: 08/06/2013
  • Est. Priority Date: 09/26/2007
  • Status: Active Grant
First Claim
Patent Images

1. A method, comprising:

  • receiving an event notification;

    in response to receiving an event notification, creating a first set of tables defining an entity;

    in response to creating the first set of tables and when an attribute of the entity is subject to a plurality of differing forms of language expression, automatically creating a set of localization tables separate from the first set of tables, wherein the set of localization tables comprises a language locale assignment table and a locale administration item table;

    in the language locale assignment table, creating two or more locale identifiers wherein each locale identifier identifies a different location, wherein the language locale assignment table includes forms of language expression to be used for the attribute;

    in the language locale assignment table, creating two or more locale keys wherein each locale key is associated with a locale identifier;

    in the locale administration item table, creating two or more rows, wherein each row corresponds to a different form of language expression for the attribute;

    including a different form of language expression in each of the two or more rows in the locale administration item table;

    including a locale key in each of the two or more rows in the locale administration item table, wherein the locale key associates the language expression rows in the locale administration item table with a locale identifier, in the language locale assignment table, that identifies a location; and

    wherein the attribute of the entity has a base value as received from a source of the event notification, wherein the base value differs from at least one of the forms of language expression, wherein the base value is included, as a dimension, in the set of localization tables, wherein a column in the first set of tables is identified by at least one of a group and category in the set of localization tables, and wherein a new form of language expression is configured to be added to the set of localization tables without adding a new table to the set of localization tables and a new column to the existing set of localization tables.

View all claims
  • 21 Assignments
Timeline View
Assignment View
    ×
    ×