System, method, and product for development and maintenance of database-related software applications

摘要

A schema-isolated system is disclosed for developing, modifying, or maintaining client applications that accesses target databases. The system includes a middleware-table inserter that inserts middleware tables into the target database. The middleware tables include a set of compatibility data relating one or more client-application data requests with one or more corresponding target-database data capabilities. The middleware tables also include a data communication component. This component receives a client-application data request from the client application, and, based on at least a first datum of the set of compatibility data, provides to the client application the one or more target-database data capabilities corresponding to the client-application data request. The first compatibility datum relates the one or more client-application data requests with the one or more corresponding target-database data capabilities based, at least in part, on an application-usage-independent criterion. An application-usage-independent criterion may be a syntax criterion, a configuration criterion, or a component-usage criterion. The first compatibility datum may include at least one SQL query. The at least one target database may be a relational database.