1. A computer program product for generating a database interface comprising a computer usable memory medium having computer readable program code embodied therein wherein said computer readable program code is configured to: obtain a schema associated with an extended SQL database comprising one or more main database tables and a plurality of sub-tables, wherein said extended SQL database comprises one or more advanced constructs comprising one or more structural optimizations of said one or more primary table using said plurality of sub-tables; display a generation interface on a first computer wherein said generation interface comprises a structure interface, a content interface and an output interface; said structure interface comprising a tag format interface and an annotation interface comprising an audience selector, wherein said extended SQL database supports multi-audience data for one or more audiences, wherein the multi-audience data is stored in a plurality of language layers to avoid data duplication between said plurality of language layers; said content interface comprising a table interface and a list of lookup fields and an enumeration source interface, wherein at least one of said one or more advanced constructs is flattened to expose said one or more main database tables as a flat record; said output interface comprising a output filename element; present at least one audience in said audience selector; present at least one table name in said table interface; present at least one lookup field in said list of lookup fields; present at least one enumeration source in said enumeration source interface; accept at least one input in said generation interface; and, generate an interface to said extended SQL database into XSD based on said at least one input.
1. A computer program product for generating a database interface comprising a computer usable memory medium having computer readable program code embodied therein wherein said computer readable program code is configured to: obtain a schema associated with an extended SQL database comprising one or more main database tables and a plurality of sub-tables, wherein said extended SQL database comprises one or more advanced constructs comprising one or more structural optimizations of said one or more primary table using said plurality of sub-tables; display a generation interface on a first computer wherein said generation interface comprises a structure interface, a content interface and an output interface; said structure interface comprising a tag format interface and an annotation interface comprising an audience selector, wherein said extended SQL database supports multi-audience data for one or more audiences, wherein the multi-audience data is stored in a plurality of language layers to avoid data duplication between said plurality of language layers; said content interface comprising a table interface and a list of lookup fields and an enumeration source interface, wherein at least one of said one or more advanced constructs is flattened to expose said one or more main database tables as a flat record; said output interface comprising a output filename element; present at least one audience in said audience selector; present at least one table name in said table interface; present at least one lookup field in said list of lookup fields; present at least one enumeration source in said enumeration source interface; accept at least one input in said generation interface; and, generate an interface to said extended SQL database into XSD based on said at least one input. 4. The computer program product of claim 1 wherein said one or more advanced constructs comprise one or more multi-value lookup tables configured to store multiple separate values in one field, wherein at least one attribute associated with said multiple separate values is presented in said list of lookup fields.