Design And Implement Of TemplatBuilder Database Templates

Because of the tremendous success of the commercial sector, information technology (IT) of the database, object-oriented, network technologies is the computer technology in one of the fastest-growing areas, and the application of one of the most widely. For text, data, code, data flow features such as object, relying on networks of the heterogeneous data source information fusion, applications for different groups of individual information and information processing services, making IT has become a key of the complexity of component of software systems. The enormous market of application, demand of massive information processing, inefficient traditional IT development technologies, and the high cost of system maintenance, the so-called fourth-generation computer language (4GL) has became: database front-end development tools PowerBulder, small-scale data management system software Visual FoxPro, relational database management system such as Informix. However, the current 4GL which has relation with IT does not solution or alleviate the increasingly serious contradiction between software supply and demand, and growing pressure on IT system maintenance, this need to explore more effective the new IT language and new mechanisms.TemplateBuilder as an intelligent information processing technology as its major objective and the Chinese-style scripting language template system include a variety of new mechanisms such asfunctional integration, templates expansion and script components has the professional database: Heshibi database system. Its multimedia database is superior performance, outreach data source support two modes(C/S and B/S), freedom of self-table mechanism support worksheet dynamic created, additions and deletions, structural modify, Data conversion etc. programming is convenience and the data source is security. Its database systems and development platforms has "Heshibi" professional database system, integrated a lot of programming to meet the needs of mixed-template user needs, support the C / S and B / S modes, and ensure the same high-performance, ensure there is a little programming in system develop(or even non-programming).The main work of this paper is as follows:(1) Design and implement of data source template. For information systems, data source is often the main components of the entire system, it need to solve the following questions:①support for the effective management and efficient access to the data of increasing and new;②Services for heterogeneous database systems integration;③dynamic registration and configuration of data source, such as the dynamic of ODBC (OLEDB) data sources;④the problem of client configuration database system's issues: do not install and configuration database on the client system, and support thin-client.(2) Design and implement of View template. Using view mechanism,the security model can be constructed. So the user access is not specific tables, the database system is also unnecessary to accredit the specific view, and just to accredit a user permission to visit certain view, and thus can protect the database tables.