Abstract: Embodiments are provided for creating and reusing custom data types in a database. A selection of a field or group of fields may be received from a database table in the database by a database software application executing on a computer system. Each selected field may include a set of field properties. The application may further receive a user input to initiate saving the selected field or group of fields as a custom data type. In response to receiving the input, the application may be configured to generate a dialog for receiving custom data type information for the selected field or group of fields and save the selected field or group of fields as a custom data type. The custom data type may then be reused by the application in the database.

Abstract: Embodiments are provided for creating and reusing custom data types in a database. A selection of a field or group of fields may be received from a database table in the database by a database software application executing on a computer system. Each selected field may include a set of field properties. The application may further receive a user input to initiate saving the selected field or group of fields as a custom data type. In response to receiving the input, the application may be configured to generate a dialog for receiving custom data type information for the selected field or group of fields and save the selected field or group of fields as a custom data type. The custom data type may then be reused by the application in the database.

Abstract: Creating web application using cloud-based friction-free databases without web hosting knowledge. User credentials are received at a web application service for initiating a web application task via client software. The user credentials are analyzed to determine whether to grant the user permission to initiate the requested web application task. The web application task is initiated when the permission is granted. Data associated with the initiated web application task is received at the web application service for analysis of the data to host and render a web application based solely on received data provided without basis of web hosting knowledge.

Abstract: Creating web application using cloud-based friction-free databases without web hosting knowledge. User credentials are received at a web application service for initiating a web application task via client software. The user credentials are analyzed to determine whether to grant the user permission to initiate the requested web application task. The web application task is initiated when the permission is granted. Data associated with the initiated web application task is received at the web application service for analysis of the data to host and render a web application based solely on received data provided without basis of web hosting knowledge.

Abstract: A customized form is provided for entering parameters associated with a query. A user may desire to modify a report resulting from a query to a database. To enter the parameters for modification, a customized form is displayed to the user. The customized form allows for entry of the parameters according to prompts that are related by their presentation to the form being generated.

Abstract: Computer software applications may be separated into components and distilled into functional and identifying attributes, which may then be used to regenerate the computer software application on a different system. A component of a computer software program is received. From the component, one or more functional attributes describing the operation of the component on a first operating platform are distilled from which the component can be generated to operate on one or more operating platforms. Attributes identifying the component are identified. The functional attributes and the identifying attributes of the component are stored in a distillation store. From the distillation store, using information about a selected operating platform on which the computer software program is to be executed, components of the computer software program may be generated to execute on the selected operating platform.

Abstract: Embodiments are provided to define relationships for merging template or database part tables with one or more database tables in a computer system. A database application may utilize a schema to receive metadata associated with a target database part table in one or more markup language elements. The database application may then receive metadata associated with a source database table to be joined with the target table in the schema elements. The database application may then receive join type metadata in the schema elements. The join type metadata may specify whether fields from the source table are to be merged into the target table or whether fields from the target table are to be merged into the source table. In response to receiving the target table metadata and the source table metadata, the database application may then merge the target and source tables utilizing the join type metadata.

Abstract: Methods, systems, and computer-readable media implementing various aspects of complex data in a conceptual table are disclosed which enable complex data in the form of tables to be added to a conceptual table. The complex data can map to scalar values in a plurality of data tables. Complex data may be entered via data modeling methods, accessed via cursoring methods, and queried via query expansion methods.

Abstract: Embodiments are provided to merge, manage, create, and reuse database parts in a computer system. Database parts may include database tables, datatypes, field combinations or entire databases. A selection of a database part is received by a database software application executing on a computer system. The application may be configured to check for metadata associated with the database part to identify an action property. If, after checking for the metadata, a merge action property is identified, then the application may check for a metadata property associated with a database table. If a merge action associated with the database table is identified, then the application may merge the database part with the database table in the database. The application may also be configured to generate a user interface for creating database parts using database tables and for creating a database part by saving a database.

Abstract: Embodiments are provided to calculate and provide information based in part on a defined expression. In an embodiment, a database system can be configured to include a number of calculated columns as part of a database table structure. The database system can be configured to present a calculated result based in part on a determined result type. In one embodiment, a database system can be configured to enable calculated columns to be defined on a table of a database, wherein a component can be used to evaluate an expression associated with a column calculation to determine a proper result type. The proper result type can be stored and used when presenting a result of the calculation. Other embodiments are available.

Abstract: Computer software applications may be separated into components and distilled into functional and identifying attributes, which may then be used to regenerate the computer software application on a different system. A component of a computer software program is received. From the component, one or more functional attributes describing the operation of the component on a first operating platform are distilled from which the component can be generated to operate on one or more operating platforms. Attributes identifying the component are identified. The functional attributes and the identifying attributes of the component are stored in a distillation store. From the distillation store, using information about a selected operating platform on which the computer software program is to be executed, components of the computer software program may be generated to execute on the selected operating platform.

Abstract: Embodiments are provided for creating and reusing database forms and reports. A selection of an object may be received from a database by a database software application executing on a computer system. The object may include a form or a report. The application may further receive an input to initiate saving the selected object as a new form template or a new report template. In response to receiving the input, the application may be configured to generate a dialog for receiving the selected object and save the selected object as a new form template or a new report template. Any controls, sub-forms, sub-reports, properties, macros, code, and object model references which may be included in the selected object are persisted in the newly created templates for reuse.

Abstract: Embodiments are provided to define relationships for merging template or database part tables with one or more database tables in a computer system. A database application may utilize a schema to receive metadata associated with a target database part table in one or more markup language elements. The database application may then receive metadata associated with a source database table to be joined with the target table in the schema elements. The database application may then receive join type metadata in the schema elements. The join type metadata may specify whether fields from the source table are to be merged into the target table or whether fields from the target table are to be merged into the source table. In response to receiving the target table metadata and the source table metadata, the database application may then merge the target and source tables utilizing the join type metadata.

Abstract: Embodiments are provided for creating and reusing custom data types in a database. A selection of a field or group of fields may be received from a database table in the database by a database software application executing on a computer system. Each selected field may include a set of field properties. The application may further receive a user input to initiate saving the selected field or group of fields as a custom data type. In response to receiving the input, the application may be configured to generate a dialog for receiving custom data type information for the selected field or group of fields and save the selected field or group of fields as a custom data type. The custom data type may then be reused by the application in the database.

Abstract: Embodiments are provided to calculate and provide information based in part on a defined expression. In an embodiment, a database system can be configured to include a number of calculated columns as part of a database table structure. The database system can be configured to present a calculated result based in part on a determined result type. In one embodiment, a database system can be configured to enable calculated columns to be defined on a table of a database, wherein a component can be used to evaluate an expression associated with a column calculation to determine a proper result type. The proper result type can be stored and used when presenting a result of the calculation. Other embodiments are available.

Abstract: Methods, systems and computer products are provided for allowing bi-directional communication between a database application and a remote data source and for allowing updating of data on a remote data source with data edited or created at a client site remote from the remote data source during an offline data editing or entry session via a client database application.

Abstract: Embodiments are provided to merge, manage, create, and reuse database parts in a computer system. Database parts may include database tables, datatypes, field combinations or entire databases. A selection of a database part is received by a database software application executing on a computer system. The application may be configured to check for metadata associated with the database part to identify an action property. If, after checking for the metadata, a merge action property is identified, then the application may check for a metadata property associated with a database table. If a merge action associated with the database table is identified, then the application may merge the database part with the database table in the database. The application may also be configured to generate a user interface for creating database parts using database tables and for creating a database part by saving a database.

Abstract: A customized form is provided for entering parameters associated with a query. A user may desire to modify a report resulting from a query to a database. To enter the parameters for modification, a customized form is displayed to the user. The customized form allows for entry of the parameters according to prompts that are related by their presentation to the form being generated.

Abstract: Methods and systems provide for bi-directional communication between a spreadsheet application worksheet and a database data source that allows modified data to be written from a spreadsheet application to source data in a database data source from which the original pre-modified data was obtained. Offline data changes in a spreadsheet application are cached by a data provider application and are published to a remote data source when the spreadsheet application is synchronized with the data source. Error conditions and data conflicts resulting from new or modified data published to a database data source from a spreadsheet application worksheet are reported to a user of the spreadsheet application worksheet through a data provider application to allow the user an opportunity to resolve error conditions and data conflicts between the user's data changes and other data changes made to the same source data contained in the database data source.

Abstract: Methods, systems, and computer-readable media implementing various aspects of complex data in a conceptual table are disclosed which enable complex data in the form of tables to be added to a conceptual table. The complex data can map to scalar values in a plurality of data tables. Complex data may be entered via data modeling methods, accessed via cursoring methods, and queried via query expansion methods.