Abstract: A method of computing a join pattern agnostic aggregate function includes loading source code and parsing the source code to identify different database query operations. In response to the identification of an aggregate function in one of the different database query operations in which records in multiple tables are joined together in a table join, a multiplicity of primary keys are retrieved, each corresponding to a different one of the multiple tables and also an object of one of the tables referenced by the identified aggregate function. An existence of a fan out condition associated with the table join is then computed. On condition that an existence of the fan out condition is not computed a non-fan out sensitive implementation of the aggregate function is invoked with respect to the object. But, otherwise, a different, fan-out sensitive implementation of the aggregate function is invoked with respect to the object.

Abstract: A system and method for querying a database is disclosed. Database tables are represented as nodes in a model. Each node is associated with at least one leaf. The nodes can be interconnected with one another. A model input is received by a server from a client device, the model input including a starting node, one or more leaves, and optionally one or more filters. A query is executed against a database based on the model input. A subsequent query can be generated by selecting a result of the first query. Also disclosed is a technique for cancelling queries.

Abstract: The present disclosure provides methods for performing a computation with an aggregate function using a database query, wherein the database query joins a plurality of database tables and includes a distinct aggregation function, which, when executed against one or more databases aggregates only values of database records corresponding to distinct keys by which the tables are joined, regardless of the cardinality of the joined tables. Related devices and systems are also provided.

Abstract: The present disclosure provides inclusive and exclusive approaches, including computer-implemented methods for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table. Also provided are related systems and non-transitory computer-readable recording media.

Abstract: A system and method for querying a database is disclosed. Database tables are represented as nodes in a model. Each node is associated with at least one leaf. The nodes can be interconnected with one another. A model input is received by a server from a client device, the model input including a starting node, one or more leaves, and optionally one or more filters. A query is executed against a database based on the model input. A subsequent query can be generated by selecting a result of the first query. Also disclosed is a technique for cancelling queries.

Abstract: A system and method for querying a database is disclosed. Database tables are represented as nodes in a model. Each node is associated with at least one leaf. The nodes can be interconnected with one another. A model input is received by a server from a client device, the model input including a starting node, one or more leaves, and optionally one or more filters. A query is executed against a database based on the model input. A subsequent query can be generated by selecting a result of the first query. Also disclosed is a technique for cancelling queries.

Abstract: The present disclosure provides inclusive and exclusive approaches, including computer-implemented methods for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table. Also provided are related systems and non-transitory computer-readable recording media.

Abstract: The present disclosure provides methods for performing a computation with an aggregate function using a database query, wherein the database query joins a plurality of database tables and includes a distinct aggregation function, which, when executed against one or more databases aggregates only values of database records corresponding to distinct keys by which the tables are joined, regardless of the cardinality of the joined tables. Related devices and systems are also provided.

Abstract: A system and method for querying a database is disclosed. Database tables are represented as nodes in a model. Each node is associated with at least one leaf. The nodes can be interconnected with one another. A model input is received by a server from a client device, the model input including a starting node, one or more leaves, and optionally one or more filters. A query is executed against a database based on the model input. A subsequent query can be generated by selecting a result of the first query. Also disclosed is a technique for cancelling queries.

Abstract: A system and method for facilitating service representatives' self-scheduling of work. Work may be released for a given work period (e.g., one week) in multiple rounds, with the period being broken into multiple timeslots, each timeslot having one or more seats for representatives. A representative may be limited as to the number of timeslots he can commit to in a given scheduling round. A representative operates a user interface to access his personalized schedule, which indicates the status of each timeslot through different appearances (e.g., colors, line patterns). The representative commits to timeslots that have work available for which he is qualified, and the schedule is updated in real-time as work availability changes. Seats may be distributed among multiple virtual rooms in a timeslot, and a representative may need to be qualified to sit in a special room.

Abstract: A distributed work force of selected candidate evaluators is used to quickly and efficiently provide multiple evaluations of a candidate for a skill position. Candidate information is provided to multiple candidate evaluators in a distributed work force. Review information is received from the multiple candidate evaluators comprising an evaluation score for one or more candidate attributes and a ranking is generated for the candidate relative to other candidates for the skill position based on the received review information.

Abstract: Development system with visual designer tools (Designers) are described for generating and modifying program code. During system operation, a user employs the Designers to visually create an application program and generate a source file. Moreover, the user can proceed to edit the file with a text editor and then return to the Designers to edit the form visually. Each Designer is a bi-directional or "two-way" tool: the user can modify a form either visually with a Designer, or by editing the generated code in a source (text) file with a text editor. The user can use both techniques interchangeably--switching at will. All changes which occur in Designers are reflected in the generated code and vice versa.

Abstract: A system of the present invention includes a relational database management system (RDBMS) having a hypertext report writing module. Methods are described for automatically recognizing relations between reports which are generated from the same or related database tables. The system automatically embeds (or assists the user in embedding) appropriate hypertext links so that information from one report may be cross-referenced immediately with information in another, related report. Drill-down hypertext reports of increasing level of detail are illustrated. In addition to drill-down reports, the system may create comprehensive hypertext reports for automatically tying together information which is related through underlying table relations but which ordinarily appears in different reports. By automatically placing hypertext links or cross-indexes between reports, the system ties together relatable information into a single, cross-indexed hypertext report.

Abstract: A system of the present invention includes a relational database management system (RDBMS) having a hypertext report writing module. Methods are described for automatically recognizing relations between reports which are generated from the same or related database tables. The system automatically embeds (or assists the user in embedding) appropriate hypertext links so that information from one report may be cross-referenced immediately with information in another, related report. Drill-down hypertext reports of increasing level of detail are illustrated. In addition to drill-down reports, the system may create comprehensive hypertext reports for automatically tying together information which is related through underlying table relations but which ordinarily appears in different reports. By automatically placing hypertext links or cross-indexes between reports, the system ties together relatable information into a single, cross-indexed hypertext report.