Multilingual storage and retrieval
First Claim
1. In a networked system comprising a plurality of client stations interconnected to at least one server, and wherein database records are received at the server from the client stations in a plurality of written languages each using a designated character set for a given language, a method for generating at the server a database which permits (a) storing of multilingual data in the database using a universal character set but without having to translate the entirety of each received data record into the universal character set, and which also permits (b) returning, in response to a client request, data in a requested one of said plurality of written languages using the designated character set for that language, the method comprising the steps of:
- receiving from one of said client stations a database record comprising a plurality of data fields containing data in a native character set for a given language;
separating said plurality of data fields into a first set and a second set, said first set including only those data fields from which the database record is sorted, and said second set containing the remaining data fields of the database record;
storing said data fields of said second set into the database such that the data of said second set is maintained in said native character set;
translating said data fields of said first set from said native character set into a universal character set and then storing said data fields of said first set into the database;
receiving at said server a request from a client station for an index of at least a portion of the database sorted according to user-specified language rules; and
sorting at least a portion of said first set of data fields to generate said requested index and returning said requested index to the client station from which the request was received in said user-specified language.
2 Assignments
0 Petitions
Accused Products
Abstract
A single processor/storage device provides multilingual support for a computer system. Information is divided into two parts. The first part is initially stored in a first character set, e.g., the character set in which it was created. A tag, identifying the character set, is associated with the first part. The second part is stored in a universal character set. The first part is converted to another character set only when requested. Indices may be generated from the second part using specified language sorting rules.
-
Citations
12 Claims
-
1. In a networked system comprising a plurality of client stations interconnected to at least one server, and wherein database records are received at the server from the client stations in a plurality of written languages each using a designated character set for a given language, a method for generating at the server a database which permits (a) storing of multilingual data in the database using a universal character set but without having to translate the entirety of each received data record into the universal character set, and which also permits (b) returning, in response to a client request, data in a requested one of said plurality of written languages using the designated character set for that language, the method comprising the steps of:
-
receiving from one of said client stations a database record comprising a plurality of data fields containing data in a native character set for a given language; separating said plurality of data fields into a first set and a second set, said first set including only those data fields from which the database record is sorted, and said second set containing the remaining data fields of the database record; storing said data fields of said second set into the database such that the data of said second set is maintained in said native character set; translating said data fields of said first set from said native character set into a universal character set and then storing said data fields of said first set into the database; receiving at said server a request from a client station for an index of at least a portion of the database sorted according to user-specified language rules; and sorting at least a portion of said first set of data fields to generate said requested index and returning said requested index to the client station from which the request was received in said user-specified language. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A database system for storing and retrieving multilingual data comprising:
-
a plurality of client stations; at least one server networked together with said plurality of client stations, said at least one server comprising program means for generating at the server a database using a method comprising the steps of; receiving from one of said client stations a database record comprising a plurality of data fields containing data in a native character set for a given language; separating said plurality of data fields into a first set and a second set, said first set including only those data fields from which the database record is sorted, and said second set containing the remaining data fields of the database record; storing said data fields of said second set into the database such that the data of said second set is maintained in said native character set; translating said data fields of said first set from said native character set into a universal character set and then storing said data fields of said first set into the database; receiving at said server a request from a client station for an index of at least a portion of the database sorted according to user-specified language rules; and sorting at least a portion of said first set of data fields to generate said requested index and returning said requested index to the client station from which the request was received in said user-specified language.
-
-
12. In a networked system comprising a plurality of client stations interconnected to at least one server, as an article of manufacture, a computer program product comprising:
a computer readable medium for storing computer program code means for generating a database; and
wherein said computer program code means comprises;means for receiving from one of said client stations a database record comprising a plurality of data fields containing data in a native character set for a given language; means for separating said plurality of data fields into a first set and a second set, said first set including only those data fields from which the database record is sorted, and said second set containing the remaining data fields of the database record; means for storing said data fields of said second set into the database such that the data of said second set is maintained in said native character set; means for translating said data fields of said first set from said native character set into a universal character set and then storing said data fields of said first set into the database; means for receiving at said server a request from a client station for an index of at least a portion of the database sorted according to user-specified language rules; and means for sorting at least a portion of said first set of data fields to generate said requested index and returning said requested index to the client station from which the request was received in said user-specified language.
Specification