초록 ▼

Techniques for simplifying the aggregation of data stored in a number of objects in a database system. A user-defined type and an object view are associated with a kind of data to be aggregated. The object view specifies the locations of the data in the objects and maps the data to be aggregated int

Techniques for simplifying the aggregation of data stored in a number of objects in a database system. A user-defined type and an object view are associated with a kind of data to be aggregated. The object view specifies the locations of the data in the objects and maps the data to be aggregated into the user-defined type. An application program interface includes a fetch interface that causes the database system to make a query over the object view associated with the kind of data and return the aggregated data in a set of objects of the user-defined type. The returned data is converted to XML and may be further transformed using XSL stylesheets. The application program interface further includes a filter interface that specifies a restriction for the query, a count interface that specifies the number of objects to be returned at once by the application program interface, a transform interface that specifies an XSL style sheet, and a transform parameter interface for providing parameters to the XSL style sheet. The techniques may be used to aggregate metadata for various classes of objects from a data dictionary in a database system. In this application, each class of object has a name and a user-defined type and object view are associated with the class name. The fetch interface specifies a class name and the user-defined type and object view associated with the name are used to aggregate the metadata. One of the transforms performed in this application is the transformation of the metadata for an object into creation DDL for the object.

대표청구항 ▼

Techniques for simplifying the aggregation of data stored in a number of objects in a database system. A user-defined type and an object view are associated with a kind of data to be aggregated. The object view specifies the locations of the data in the objects and maps the data to be aggregated int

Techniques for simplifying the aggregation of data stored in a number of objects in a database system. A user-defined type and an object view are associated with a kind of data to be aggregated. The object view specifies the locations of the data in the objects and maps the data to be aggregated into the user-defined type. An application program interface includes a fetch interface that causes the database system to make a query over the object view associated with the kind of data and return the aggregated data in a set of objects of the user-defined type. The returned data is converted to XML and may be further transformed using XSL stylesheets. The application program interface further includes a filter interface that specifies a restriction for the query, a count interface that specifies the number of objects to be returned at once by the application program interface, a transform interface that specifies an XSL style sheet, and a transform parameter interface for providing parameters to the XSL style sheet. The techniques may be used to aggregate metadata for various classes of objects from a data dictionary in a database system. In this application, each class of object has a name and a user-defined type and object view are associated with the class name. The fetch interface specifies a class name and the user-defined type and object view associated with the name are used to aggregate the metadata. One of the transforms performed in this application is the transformation of the metadata for an object into creation DDL for the object. such as an extensible Markup Language (XML) data stream is disclosed. A database server receives a query and generates a rowset. A rowset processor, using the mode specified in the query, processes the rowset and query to generate the XML data stream. For the "auto1" mode, the rowset processor transforms a rowset into an XML data stream using primary-foreign key information specified in the query to determine nesting. For the "auto2" mode, the rowset processor transforms a rowset into an XML data stream using table ordering information included in the query to determine nesting. For the "explicit" mode, the rowset processor transforms a rowset into an XML data stream using the explicit organizational information specified in the query. second pronunciation of the specific word with the first pronunciation of the specific word when it has been judge that the given word contains the specific; the second pronunciation being originally included in the first recognition word of the given word; the first pronunciation being different from the second pronunciation; and a speech recognition processing device that performs speech recognition processing by comparing audio data obtained through the voice input device and speech recognition data created in correspondence to the second recognition word of the given word. 2. A speech recognition navigation apparatus, comprising: a voice input device; a first storage device that stores a first recognition word indicating a pronunciations of a word to undergo speech recognition; a second storage device that stores a specific word that includes a first pronunciation different from a second pronunciation, which specific word is prepared in advance as a word that is a common part of a plurality of words to undergo speech recognition; a generating device that judges whether or not a given word contains the specific word as a part of the given word and generates a second recognition word of the given word by replacing a second pronunciation of the specific word with the first pronunciation of the specific word when it has been judged that the given word contains the specific word; the second pronunciation being originally included in the first recognition word of the given word; the first pronunciation being different from the second pronunciation; and a speech recognition processing device that performs speech recognition processing by comparing audio data obtained through the voice input device and speech recognition data created in correspondence to the second recognition word of the given word; a map information storage device that stores map information; and a control device that engages in control for providing route guidance based upon, at least, recognition results obtained by the speech recognition processing device and the map information. 3. A speech recognition navigation apparatus, comprising: a voice input device; a first storage device that stores a first recognition word indicating a pronunciation of a word to undergo speech recognition; a second storage device that stores a specific word that is prepared in advance as a word that is a common part of a plurality of words to undergo speech recognition; a generating device that judges whether or not a given word contains the specific word as a part of the given word and generates a second recognition word of the given word by adding a pronunciation of the specific word when it has been judged that the given word does not contain the specific word; a speech recognition processing device that performs speech recognition processing by comparing audio data obtained through the voice input device and speech recognition data created in correspondence to the second recognition word of the given word; a map information storage device that stores map information; and a control device that engages in control for providing route guidance based upon, at least, recognition results obtained by the speech recognition processing device and the map information. 4. A method of recognition word generation through which recognition words indicating pronunciations of words to undergo speech recognition used to generate speech recognition data to be compared against audio data obtained through a voice input device are generated, the method comprising the acts of: obtaining a first recognition word of a given word to undergo speech recognition; obtaining a specific word that includes a first pronunciation and is prepared in advance as a word that is a common part of a plurality of words to undergo speech recognition; judging whether or not the given word contains the specific word as a part of the given word; generating a second recognition word of the given word by replacing a second pronunciation of the specific word with the first pronunciation of the specific word when it has been judged that the given word contains the specific word; the second pronunciation being originally included in the first recognition word of the given word; and the first pronunciation being different from the second pronunciation. 5. A method of recognition word generation according to claim 4, wherein: the second pronunciation of the specific word is a standard pronunciation. 6. A method of recognition word generation according to claim 4, wherein: the second pronunciation of the specific word is a standard pronunciation; and the first pronunciation indicates how the specific word is pronounced in everyday life. 7. A method of recognition word generation according to claim 4, further comprising the act of: storing both the first recognition word and the second recognition word for the given word. 8. A method of recognition word generation according to claim 4, wherein: the first pronunciation is constituted of no sound made for the specific word. 9. A method of recognition word generation according to claim 4, wherein: the first pronunciation of the specific word is constituted of a pronunciation corresponding to an alternative term or an abbreviated term for the specific word. 10. A recording medium that stores a recognition word generating program for generating recognition words indicating pronunciations of words to undergo speech recognition used to generate speech recognition data to be compared against audio data obtained through a voice input device in speech recognition processing, the recognition word generating program comprising: an instruction of obtaining a first recognition word of a given word to undergo speech recognition; an instruction of obtaining a specific word that includes a first pronunciation and is prepared in advance as a word that is a common part of a plurality of words to undergo speech recognition; an instruction of judging whether or not the given word contains the specific word as a part of the given word; an instruction of generating a second recognition word of the given word by replacing a second pronunciation of the specific word with the first pronunciation of the specific word when it has been judged that the given word contains the specific word; the second pronunciation being originally included in the first recognition word of the given word; and the first pronunciation being different from the second pronunciation. 11. A data signal transmitted in a communication line that comprises a recognition word generating program for generating recognition words indicating pronunciations of words to undergo speech recognition used to generate speech recognition data to be compared against audio data obtained through a voice input device in speech recognition processing, the recognition word generating program comprising: an instruction of obtaining a first recognition word of a given word to undergo speech recognition; an instruction of obtaining a specific word that includes a first pronunciation and is prepared in advance as a word that is a common part of a plurality of words to undergo speech recognition; an instruction of judging whether or not the given word contains the specific word as a part of the given word; an instruction of generating a second recognition word of the given word by replacing a second pronunciation of the specific word with the first pronunciation of the specific word when it has been judged that the given word contains the specific word; the second pronunciation being originally included in the first recognition word of the given word; and the first pronunciation being different from the second pronunciation. 12. A method of recognition word generation through which recognition words indicating pronunciations of words to undergo speech recognition used to generate speech recognition data to be compared against audio data obtained through a voice input device are generated, the method comprising the acts of: obtaining a first recognition word of a given word to undergo speech recognition in a given category; obtaining a specific word that is prepared in advance as a word that is a common part of a plurality of words to undergo speech recognition in the given category; judging whether or not the given word contains the specific word as a part of the given word; generating a second recognition word of the given word by adding a pronunciation of the specific word when it has been judged that the given word does not contain the specific word. 13. A speech recognition apparatus, comprising: a voice input device; a first storage device that stores a first recognition word indicating a pronunciation of a word to undergo speech recognition; a second storage device that stores a specific word that is prepared in advance as a word that is a common part of a plurality of words to undergo speech recognition; a generating device that judges whether or not a given word contains the specific word as a part of the given word and generates a second recognition word of the given word by adding a pronunciation of the specific word when it has been judged that the given word does not contain the specific word and; a speech recognition processing device that performs speech recognition processing by comparing audio data obtained through the voice input device and speech recognition data created in correspondence to the second recognition word of the given word.