首页>
外国专利>
Method and system for managing database SQL statements in web based and client/server applications
Method and system for managing database SQL statements in web based and client/server applications
展开▼
机译:在基于Web和客户端/服务器应用程序中管理数据库SQL语句的方法和系统
展开▼
页面导航
摘要
著录项
相似文献
摘要
One embodiment of the present invention is a tokenized SQL architecture that provides a process for enabling application designers and developers to construct and manage database independent SQL statements and use them in Web based or client/server applications. The tokenized SQL architecture (“TSA”) uses a proprietary file format, plus a variety of components and utilities, to allow for both maximum design-time flexibility and maximum run-time performance on the target database. For example, the TSA allows application developers working with the latest data-driven web or C/S technology to create, modify and test SQL statements in a an easy to use folder and file based form. Once the SQL is tested and debugged, a utility is used to take all the SQL statements used in an application and generate each statement as a Database Stored Procedure (“DSP”). Then the developer flips an application variable and the entire application will switch over to using stored procedures maximum speed, scalability and efficiency. Additionally UI and output template authors and designers can use the original SQL files directly without having to have the variable substitution support provided by the application run-time environment.
展开▼