Systems and methods for multilingual metadata
A content management system provides a mechanism for representing a particular piece of metadata in multiple languages. The multilingual metadata system provides a user with an ability to visualize a single translation in a language of the user's preference or based on the user's locale. The system receives an indication that at least one metadata field associated with a managed object contains multilingual metadata. A locale metadata table and a new metadata table for the managed object are created using information from an original metadata table for the managed object. Two or more metadata field values representing at least two languages are received by the system. The metadata fields are tagged with locale information and stored in the locale metadata table in association with the at least one metadata field in the new metadata table.
1. A method for managing metadata in an enterprise computing network environment, the method comprising:
receiving, through a user interface adapted to creating or editing metadata of a managed object, an indication that at least one metadata field of the managed object now contains multilingual metadata, the receiving performed by a content management system operating in the enterprise computing network environment, the content management system having a processor, the managed object managed by the content management system;
responsive to the indication that at least one metadata field of the managed object contains multilingual metadata, creating, by the content management system, a new custom metadata table for the managed object using information, including the at least one metadata field, from an original metadata table for the managed object;
specifying, through the user interface whether or not each of the fields in the new custom metadata table require multilingual support via the user interface;
responsive to the indication that the at least one metadata field of the managed object contains multilingual metadata, creating, by the content management system, a locale metadata table, wherein the locale metadata table includes text columns from the original metadata table that are marked as multilingual, and wherein the locale metadata table is a multilingual metadata table ancillary to the new custom metadata table to provide support for multilingual metadata in the new custom metadata table by allowing storage of language variant values for alternative languages;
receiving, by the content management system through the user interface, at least two metadata field values for the at least one metadata field, wherein the at least two metadata field values representing at least two languages;
storing, by the content management system, the at least two metadata field values in the new custom metadata table;
tagging, by the content management system, each of the at least two languages with locale information, the locale information relating to a geographic location;
storing, by the content management system, the locale information in the locale metadata table in association with the at least one metadata field in the new custom metadata table for the managed object;
receiving a request from a user for metadata information;
receiving location information for the user;
identifying a preferred language for the user, wherein the identification of the preferred language for the user is based on the location information received; and
responsive to a metadata field description for the metadata information requested by the user containing metadata in the preferred language identified for the user, displaying the metadata in the preferred language, otherwise displaying the metadata in a default language.
2. The method according to claim 1 , wherein the new custom metadata table includes a multilingual attribute for the managed object.
3. The method according to claim 2 , wherein the multilingual attribute provides an indication of whether the managed object is multilingual-enabled.
4. The method according to claim 3 , wherein the indication of the multilingual attribute is selectable by a user through a table editor.
5. The method according to claim 1 , further comprising creating separate search indexes for each language variant of the managed object.
6. The method according to claim 5 , further comprising:
providing a search platform for use with the content management system, the search platform comprising searching functions; and
in response to receiving, through the search platform, a multilingual metadata search query from a user for a managed object containing multilingual metadata, modifying the multilingual metadata search query to make the multilingual metadata search query compatible with the provided search platform.
7. The method according to claim 6 , wherein modifying the multilingual metadata search query includes mapping multilingual metadata fields to fields that are compatible with the provided search platform.
8. A system, comprising:
a processor;
a non-transitory computer readable medium storing instructions translatable by the processor, the instructions when translated by the processor perform, in an enterprise computing network environment:
receiving, through a user interface adapted to creating or editing metadata of a managed object, an indication that at least one metadata field of the managed object now contains multilingual metadata, the managed object managed by the system;
responsive to the indication that at least one metadata field of the managed object contains multilingual metadata, creating a new custom metadata table for the managed object using information, including the at least one metadata field, from an original metadata table for the managed object;
specifying, through the user interface whether or not each of the fields in the new custom metadata table require multilingual support via the user interface;
responsive to the indication that the at least one metadata field of the managed object contains multilingual metadata, creating, by the content management system, a locale metadata table, wherein the locale metadata table includes text columns from the original metadata table that are marked as multilingual, and wherein the locale metadata table is a multilingual metadata table ancillary to the new custom metadata table to provide support for multilingual metadata in the new custom metadata table by allowing storage of language variant values for alternative languages;
receiving at least two metadata field values for the at least one metadata field, wherein the at least two metadata field values representing at least two languages;
storing, by the content management system, the at least two metadata field values in the new custom metadata table;
tagging each of the at least two languages with locale information, the locale information relating to a geographic location;
storing the locale information in the locale metadata table in association with the at least one metadata field in the new custom metadata table for the managed object;
receiving a request from a user for metadata information;
receiving location information for the user;
identifying a preferred language for the user, wherein the identification of the preferred language for the user is based on the location information received; and
responsive to a metadata field description for the metadata information requested by the user containing metadata in the preferred language identified for the user, displaying the metadata in the preferred language, otherwise displaying the metadata in a default language.
9. The system according to claim 8 , wherein the new custom metadata table includes a user-selectable multilingual attribute for the managed object, the user-selectable multilingual attribute providing an indication of whether the managed object is multilingual-enabled.
10. The system according to claim 8 , wherein the instructions are further translatable by the processor to perform:
creating separate search indexes for each language variant of the managed object.
11. The system according to claim 10 , wherein the instructions are further translatable by the processor to perform:
providing a search platform for use with the content management system, the search platform comprising searching functions; and
in response to receiving, through the search platform, a multilingual metadata search query from a user for a managed object containing multilingual metadata, modifying the multilingual metadata search query to make the multilingual metadata search query compatible with the provided search platform.
12. A computer program product comprising a non-transitory computer readable medium storing instructions translatable by a processor, the instructions when translated by the processor perform, in an enterprise computing network environment:
receiving, through a user interface adapted to creating or editing metadata of a managed object, an indication that at least one metadata field of the managed object now contains multilingual metadata;
responsive to the indication that at least one metadata field of the managed object contains multilingual metadata, creating a new custom metadata table for the managed object using information, including the at least one metadata field, from an original metadata table for the managed object;
specifying, through the user interface whether or not each of the fields in the new custom metadata table require multilingual support via the user interface;
responsive to the indication that the at least one metadata field of the managed object contains multilingual metadata, creating, by the content management system, a locale metadata table, wherein the locale metadata table includes text columns from the original metadata table that are marked as multilingual, and wherein the locale metadata table is a multilingual metadata table ancillary to the new custom metadata table to provide support for multilingual metadata in the new custom metadata table by allowing storage of language variant values for alternative languages;
receiving at least two metadata field values for the at least one metadata field, wherein the at least two metadata field values representing at least two languages;
storing, by the content management system, the at least two metadata field values in the new custom metadata table;
tagging each of the at least two languages with locale information, the locale information relating to a geographic location;
storing the locale information in the locale metadata table in association with the at least one metadata field in the new custom metadata table for the managed object;
receiving a request from a user for metadata information;
receiving location information for the user;
identifying a preferred language for the user, wherein the identification of the preferred language for the user is based on the location information received; and
responsive to a metadata field description for the metadata information requested by the user containing metadata in the preferred language identified for the user, displaying the metadata in the preferred language, otherwise displaying the metadata in a default language.
13. The computer program product according to claim 12 , wherein the new custom metadata table includes a user-selectable multilingual attribute for the managed object, the user-selectable multilingual attribute providing an indication of whether the managed object is multilingual-enabled.
14. The computer program product according to claim 12 , wherein the instructions are further translatable by the processor to perform:
creating separate search indexes for each language variant of the managed object.