Abstract: A system and method for providing parallel result streams for database queries is provided. The system includes a network including a client, a server, and a database. The client executes an application and sends a query to the server. In response, the server compiles the query to produce a query plan, executes statements in the query plan and sends parallel result streams to the client.

Abstract: There is provided a computer-executed method of freeing memory. One exemplary method comprises receiving a message from a user process. The message may specify a virtual address for a memory segment. The virtual address may be mapped to the memory segment. The memory segment may comprise a physical page. The method may further comprise identifying the physical page based on the virtual address. Additionally, the method may comprise freeing the physical page without unmapping the memory segment.

Abstract: There is provided a computer-implemented method of modifying a query executing in a database management system. The method comprises sending a no-wait message for the query to a control broker. The method also comprises receiving a reply to the no-wait message from the control broker. The reply to the no-wait message specifies a modification to the query. Additionally, the method comprises performing the modification.

Abstract: An automated method to align column values to proper byte boundaries for rapid scanning in a parallel processing database system. A table definition is received having a logical order of fields. The fields are re-ordered to create a physical order of fields. The physical order of fields has fixed length fields having a same byte alignment requirement positioned adjacent to each other in descending order from largest size to smallest size, and wherein a first fixed length field in the physical order is aligned on a proper byte boundary. Other embodiments, aspects and features are also disclosed.

Abstract: There is provided a computer-implemented method of modifying a query executing in a database management system. The method comprises sending a no-wait message for the query to a control broker. The method also comprises receiving a reply to the no-wait message from the control broker. The reply to the no-wait message specifies a modification to the query. Additionally, the method comprises performing the modification.

Abstract: A method and system to automate software testing using sniffer side and browser side recording and a toolbar interface are described. In one embodiment, a system tests programming code associated with a website and creates a first test case. In another embodiment, the system includes a testing device having a test interface to enable a user to initiate a first test case and to store a first HTML representation and a first XML representation of encrypted web pages viewed during the first test case. In another embodiment, the system includes a sniffer server that operates as a proxy server for the website and stores a second HTML representation and a second XML representation of unencrypted web pages viewed during the first test case. The system may include a hosting server that hosts the website and receives the first and the second HTML and XML representations from the testing device and the sniffer server when the test case is terminated via the test interface.

Abstract: There is provided a computer-executed method of freeing memory. One exemplary method comprises receiving a message from a user process. The message may specify a virtual address for a memory segment. The virtual address may be mapped to the memory segment. The memory segment may comprise a physical page. The method may further comprise identifying the physical page based on the virtual address. Additionally, the method may comprise freeing the physical page without unmapping the memory segment.

Abstract: Simplifying benefits enrollment in an organization using an enterprise software. A benefits administrator configures plan instances as groups, and the user interface for (enrolling) end users is controlled according to the configuration. The plan instances are displayed as the configured groups, while the user navigates the displayed information to select the specific plans of interest in each displayed group. In an embodiment, each group is presented as a stop in a train, such that the user is forced navigate only successive groups in the train sequence.

Abstract: A method and system to reduce false positives within an automated software-testing environment using a comparator module, a filter application module, and a preview generator module is provided. In one exemplary embodiment, a method within a testing system for testing web pages associated with a current version website by automatically generating filter data by comparing differences between a plurality of iterations of a test case executed on a previous version website, automatically generating error data by executing the test case on the current version website, and detecting differences between the previous version and the current version of the website by applying filtering rules within the filter data to the error data to remove false positives.

Abstract: A system and method for providing parallel result streams for database queries is provided. The system includes a network including a client, a server, and a database. The client executes an application and sends a query to the server. In response, the server compiles the query to produce a query plan, executes statements in the query plan and sends parallel result streams to the client.

Abstract: Systems and methods to indicate whether to store a database query language module in a local directory or a global directory are disclosed. An application program can be created once, tested once, and deployed in separate environments. The database query language modules can be shared among a group of application programs running in a common environment. Separate query language modules can be maintained for each environment.

Abstract: A method and system to automate software testing using sniffer side and browser side recording and a toolbar interface are described. In one embodiment, a system tests programming code associated with a website and creates a first test case. In another embodiment, the system includes a testing device having a test interface to enable a user to initiate a first test case and to store a first HTML representation and a first XML representation of encrypted web pages viewed during the first test case. In another embodiment, the system includes a sniffer server that operates as a proxy server for the website and stores a second HTML representation and a second XML representation of unencrypted web pages viewed during the first test case. The system may include a hosting server that hosts the website and receives the first and the second HTML and XML representations from the testing device and the sniffer server when the test case is terminated via the test interface.

Abstract: A method and system to automate software testing using sniffer side and browser side recording and a toolbar interface are described. In one embodiment, a system tests programming code associated with a website and creates a first test case. In another embodiment, the system includes a testing device having a test interface to enable a user to initiate a first test case and to store a first HTML representation and a first XML representation of encrypted web pages viewed during the first test case. In another embodiment, the system includes a sniffer server that operates as a proxy server for the website and stores a second HTML representation and a second XML representation of unencrypted web pages viewed during the first test case. The system may include a hosting server that hosts the website and receives the first and the second HTML and XML representations from the testing device and the sniffer server when the test case is terminated via the test interface.

Abstract: An automated method to align column values to proper byte boundaries for rapid scanning in a parallel processing database system. A table definition is received having a logical order of fields. The fields are re-ordered to create a physical order of fields. The physical order of fields has fixed length fields having a same byte alignment requirement positioned adjacent to each other in descending order from largest size to smallest size, and wherein a first fixed length field in the physical order is aligned on a proper byte boundary. Other embodiments, aspects and features are also disclosed.

Abstract: A method and system to automate software testing using sniffer side and browser side recording and a toolbar interface are described. In one embodiment, a system tests programming code associated with a website and creates a first test case. In another embodiment, the system includes a testing device having a test interface to enable a user to initiate a first test case and to store a first HTML representation and a first XML representation of encrypted web pages viewed during the first test case. In another embodiment, the system includes a sniffer server that operates as a proxy server for the website and stores a second HTML representation and a second XML representation of unencrypted web pages viewed during the first test case. The system may include a hosting server that hosts the website and receives the first and the second HTML and XML representations from the testing device and the sniffer server when the test case is terminated via the test interface.

Abstract: A method and system to reduce false positives within an automated software-testing environment using a comparator module, a filter application module, and a preview generator module is provided. In one exemplary embodiment, a method within a testing system for testing web pages associated with a current version website by automatically generating filter data by comparing differences between a plurality of iterations of a test case executed on a previous version website, automatically generating error data by executing the test case on the current version website, and detecting differences between the previous version and the current version of the website by applying filtering rules within the filter data to the error data to remove false positives. In one embodiment, a merged image file may also be generated by overlaying an inverted image file of a first web page associated with the previous version website, and a non-inverted image file of a second web page associated with a current version website.

Abstract: Systems and methods to indicate whether to store a database query language module in a local directory or a global directory are disclosed. An application program can be created once, tested once, and deployed in separate environments. The database query language modules can be shared among a group of application programs running in a common environment. Separate query language modules can be maintained for each environment.

Abstract: A database management system includes an execution engine that, upon rollback of an aborted transaction, has the ability to set fields of the rows that are updated or deleted by the transaction prior to aborting. In particular, when a select, update or delete statement includes a “set on rollback” clause, the respective table access operator of the execution engine modifies the “before image” of each row that is stored by the transaction log manager. The modified before image includes the field updates specified by the set on rollback clause. If a transaction associated with the statement aborts, when the transaction log manager restores the before images of each row that was deleted or updated by the transaction, the restored before images include the field updates specified by the set on rollback clause.

Abstract: A structured query language (SQL) grouping and aggregation system and method that incorporates hash-based techniques, several overflow handling strategies and statistics-based process-selection criteria. The method can execute SQL group-by queries on distributed database tables or tables stored locally to the database management system (DBMS) processor executing the grouping method. Hash-based techniques allow groupings and aggregates to be generated on the fly through the use of partial aggregates maintained in primary memory. Where primary memory is limited, groups and aggregates are still generated for as many groups as can be maintained in primary memory, while various overflow procedures are provided for buffering ungrouped data and writing that data to an overflow disk file for later processing. In one overflow procedure, raw data from groups that cannot be aggregated in primary memory are buffered then written to the overflow disk file.