Database structures and administration techniques for generalized localization of database items
The present invention is directed to a data model for effecting transformations of entities from a first form of expression to a second different form of expression.
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.
2. The method of claim 1 , wherein the forms of language expression correspond to differing languages, wherein the set of localization tables comprise a display name category table, a display name group table, an administration item table, an administration locale table, a locale administration item table, and a language locale assignment table, wherein the display name category and group tables describe a column in the first set of tables by category and group, respectively, wherein the administration item table associates at least one of entities or attributes thereof with corresponding categories and groups, and wherein the administration locale table maps geographical identifiers to corresponding forms of language expression.
3. The method of claim 1 , further comprising:
receiving a request for information comprising a first entity, the first attribute of the first entity having a plurality of differing forms of language expression;
using a first localization table to identify an object corresponding to the first entity;
using a second localization table and the identified object to determine a form of language expression to be used for the first attribute of the first entity; and
selecting a form of language expression for the first attribute of the first entity related to the determined form of language expression.
4. The method of claim 1 , wherein the entity is at least one of contact, customer, data source, party, business role, state, trunk, communication device, routing method, queue, and resource and wherein a change to a form of language expression in the set of localization tables is not a Type 1 or Type 2 change.
5. The method of claim 1 , wherein a desired form of language expression is obtained using, as an index, the base value for the attribute of the first entity, and wherein the base value is not changed.
6. A method, comprising:
a processor receiving a request for data entities, at least one of the data entities or an attribute of the data entities having a plurality of differing forms of language expression;
the processor using a first set of tables to identify an object corresponding to the at least one of the data entities;
the processor determining, with a second set of tables and the identified object, a form of language expression to be used for the at least one of the data entities or attribute of the data entities from two or more forms of language expression;
the processor determining a location associated with the request;
the processor associating the location with a locale key in a language locale assignment table, wherein the language locale assignment table includes forms of language expression to be used for the attribute;
with the locale key, the processor selecting a value for the at least one of the data entities or attribute of the data entities related to the determined form of language expression in a locale administration item table, wherein the locale administration item table includes two or more different forms of language expression for the attribute;
receiving an event notification;
in response receiving an event notification, updating a third set of tables, the third set of tables comprising data entities comprising the selected data entity;
in response updating the third set of tables and when an attribute of the data entity is subject to a plurality of differing forms of language expression, creating, in the second set of tables separate from the third set of tables, a plurality of rows corresponding to at least some of the differing forms of language expression, the second set of tables comprising a plurality of differing forms of language expression for each of a plurality of different attributes thereof; and
including differing forms of language expressions for the selected data entity in differing ones of the plurality of rows; and
wherein the selected attribute of the data entity has a base value as received from a source of the event notification, wherein the base value is included, as a dimension, in the second set of tables, wherein the base value differs from at least one of the forms of language expression, wherein a column in the third set of tables is identified by at least one of a group and category in the first set of tables, and wherein a new form of language expression can be added to the second set of tables without adding a new table to the second set tables and a new column to the existing second set of tables.
7. The method of claim 6 , wherein the forms of language expression correspond to differing languages, wherein a fourth set of localization tables comprise a display name category table, a display name group table, an administration item table, an administration locale table, wherein the display name category and group tables describe at least one of a table and column in the third set of tables by category and group, respectively, wherein the administration item table associates at least one of selected data entities or attributes thereof with corresponding categories and groups, and wherein the administration locale table maps geographical identifiers to corresponding forms of language expression.
8. The method of claim 6 , wherein the forms of language expression correspond to differing languages, wherein the first and second sets of tables comprise a data item table, a data item localization table, a locale table, and a language locale assignment table, wherein the data item table comprises the at least one of the data entities, the data item localization table comprises the differing forms of language expression for the at least one of the data entities, the locale table maps geographical identifiers to corresponding forms of language expression, and the language locale assignment table maps geographical identifiers to forms of language expression to be used for display purposes.
9. The method of claim 6 , wherein a desired form of language expression is obtained using, as an index, the base value for the at least one of selected data entity or attribute of the data entity.
10. A non-transitory computer readable medium comprising processor executable instructions configured to perform the steps of claim 6 .
11. A system, comprising:
a memory configured to store instructions;
a processor in communication with the memory configured to execute the instructions, wherein executing the instructions causes the processor to execute:
a transformation module configured to:
in response to receiving an event notification, at least one of create and update a first set of tables;
in a language locale assignment table, creating two or more locale identifiers wherein each locale identifier identifies a location, wherein the language locale assignment table includes forms of language expression to be used for an attribute;
in the language locale assignment table, creating two or more locale keys wherein each locale key is associated with a locale identifier;
in response to receiving an event notification and when at least one of an entity or an attribute of the entity is subject to a plurality of differing forms of language expression, automatically create, in a locale administration item table, separate from the first set of tables, a plurality of rows corresponding to at least some of the differing forms of language expression;
include differing forms of language expressions for the entity and/or attribute of the entity in differing ones of the plurality of rows;
including a locale key in each of the two or more rows, wherein the locale key associates the language expression with a locale identifier that identifies a location; and
wherein the entity or attribute of the entity has a base value as received from a source of the event notification, wherein the base value is included, as a dimension, in the language locale assignment and locale administration tables, wherein the base value differs from at least one of the forms of language expression, wherein a table and column in the first language locale assignment and local administration tables of localization tables, and wherein a new form of language expression can be added to the language locale assignment and locale administration tables without adding a new table to the language locale assignment and locale administration tables and a new column to the existing language locale assignment and locale administration tables.
12. The system of claim 11 , wherein the forms of language expression correspond to differing languages, wherein the set of localization tables comprise a display name category table, a display name group table, an administration item table, an administration locale table, a locale administration item table, and a language locale assignment table, wherein the display name category and group tables describe at least one of a table and column in the first set of tables by category and group, respectively, wherein the administration item table associates entities and/or attributes thereof with corresponding categories and groups, wherein the administration locale table maps geographical identifiers to corresponding forms of language expression.
13. The system of claim 11 , wherein the processor is further operable to:
receive a request for information comprising a first entity, the first entity or an attribute of the first entity having a plurality of differing forms of language expression;
use a first localization table to identify an object corresponding to the first entity;
use a second localization table and the identified object to determine a form of language expression to be used for the first entity and/or attribute of the first entity; and
select a form of language expression for the first entity and/or attribute of the first entity related to the determined form of language expression.
14. The system of claim 11 , wherein the entity is at least one of contact, customer, data source, party, business role, state, trunk, communication device, routing method, queue, and resource.
15. The system of claim 11 , wherein a desired form of language expression is obtained, using, as an index, the base value for the entity and/or attribute of the first entity.
16. The system of claim 11 , wherein a form of language expression of the base value may be changed without changing the base value.
17. The system of claim 11 , wherein a selected entity has a plurality of differing forms of language expression, each form of language expression having a corresponding row in the set of localization tables, wherein the selected entity has at least first and second different base values, wherein the first and second base values have corresponding first and second time intervals of use, and wherein the first and second time intervals are different and nonoverlapping.