Abstract: Methods, systems, and computer program products, implementing techniques for visual database modeling. The techniques include receiving in a web browser user input defining a structure for a database, the structure including one or more tables and one or more relations between the tables; and displaying in the web browser a visual model of the defined database structure, the visual model including one or more graphical objects representing the tables and relations.

Abstract: A method, computer program product, and system for distributing changes to an application are disclosed. A graphical application modeling tool is provided for displaying a model of a pattern of the application. The model has a plurality of elements, where each element is linked to another element via a port. Each port representing a class that contains information about the pattern qualities of that port as related to the element. A change that is applied to a first element of the plurality of elements of the model is propagated to a second element of the plurality of elements via linked ports associated with the first and second elements.

Abstract: Methods, systems, and computer program products, implementing techniques for developing applications using configurable patterns. The techniques include determining the functionality of a pre-existing application; selecting one or more patterns based on the functionality of the pre-existing application, and configuring the patterns so that the patterns execute similar functionality as the pre-existing application. The patterns comprise multiple pattern elements including prearranged user interface elements. The patterns specify predefined actions that can be performed using the user interface elements. The predefined actions match actions performed by the pre-existing application. Configuring the patterns includes importing database structure from a database used by the pre-existing application, generating a visual model of a query performed on the database by the pre-existing application, converting the visual model of a query into a query statement, and configuring the patterns to use the query statement.

Abstract: A design-time architecture that allows for flexible creation of application programs is disclosed. A composer core generates displays of application components and application interfaces that define patterns of functions and interactions between interfaces. A pattern base kit tool may provide common logic for the application components. A repository stores the application components and interfaces during run-time.

Abstract: Methods, systems, and computer program products, implementing techniques for visual query modeling. In one aspect, the techniques include displaying in a web browser a visual model of a database, the visual model including one or more graphical objects representing one or more tables in the database and relations between the tables, receiving in the web browser user input creating a visual model of a query into the database, and generating code for the query based on the visual model of the query.