Database structures and administration techniques for generalized localization of database items
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.
21 Assignments
0 Petitions
Accused Products
Abstract
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.
401 Citations
17 Claims
-
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 Dependent Claims (2, 3, 4, 5)
-
-
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. - View Dependent Claims (7, 8, 9, 10)
-
-
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. - View Dependent Claims (12, 13, 14, 15, 16, 17)
-
Specification