Abstract: Systems and methods for query generation based on merger of subqueries are described. For example, methods may include accessing a first join graph representing tables in a database, wherein the first join graph has vertices corresponding to respective tables in the database and directed edges corresponding to join relationships; receiving a first query specification that references data in two or more of the tables of the database to specify multiple subqueries in a set of subqueries; checking that two or more subqueries from the set of subqueries have the same join graph; checking that the two or more subqueries have the same set of grouping columns; responsive, at least in part, to the two or more subqueries having the same join graph and the same set of grouping columns, merging the two or more subqueries to obtain a consolidated query.

Abstract: A system and method to collect an actions list of action sequences in an application leading to a predetermined resulting event, create pairs of the action sequences, apply a fitting alignment to the action sequence pairs to create fitted action sequence pairs, wherein non-matching data between fitted action sequences of each pair is replaced with gaps to ensure that the first and second fitted action sequences are of equal length and are aligned with one another with the gaps being located at index positions the fitted action sequences corresponding to index positions of non-matching data, and delete data, for each of the fitted action sequence pairs, corresponding to the gaps to create a critical sequence of actions for each of the fitted action sequence pairs representing, respectively, common actions of the fitted action sequences of each of the fitted action sequence pairs leading to the predetermined resulting event.

Abstract: Systems and methods for query generation based on a logical data model with one-to-one joins are described. For example, methods may include accessing a join graph representing tables in a database; receiving a first query; selecting a connected subgraph of the join graph that includes the two or more tables referenced in the first query; accessing an indication that a directed edge of the connected subgraph corresponds to a one-to-one join; modifying the connected subgraph based on the indication to obtain a modified subgraph; generating one or more leaf queries based on the modified subgraph; generating a query graph that specifies joining of results from queries based on the one or more leaf queries; invoking a transformed query on the database that is based on the query graph and the queries based on the one or more leaf queries.

Abstract: Systems, computer program products, and methods are described herein for providing data analysis and processing using graphical user interface position mapping identification is provided. The method includes receiving a plurality of data packets from a plurality of data sources. The data packets contain one or more data metrics associated with an entity. The method also includes causing a rendering of a user interface that presents one or more selectable icons for selecting data to use from the plurality of data packets. The method further includes receiving one or more user selections of the one or more selectable icons. The one or more user selections indicate one or more of the plurality of data sources to use for a generation of a report. The method further includes generating the report based on one of more of the plurality of data packets from the selected data sources of the plurality of data sources.

Abstract: An electrocardiogram (“ECG”) system is provided. The system includes an ECG device capable of receiving ECG signals from a lead system attached to the user. The ECG device then renders the ECG signals into ECG data, and transmits the ECG data to at least one of a user device, such as a smart phone, or a cloud-based storage system. The user device is capable of rendering the ECG data into an ECG graph, and displaying the ECG graph to the user on an application (“app”). The system also provides for a cloud-based storage system capable storing the ECG data and providing access to the ECG data to the user and to medical personal.

Abstract: An apparatus includes a memory and a processor. The processor collects from a database server, statistics indicating a performance of the server. The processor applies to the statistics, a machine learning algorithm configured to identify, based in part on the statistics, one or more issues affecting the performance of the database server. Applying the machine learning algorithm includes applying to the statistics, a regression algorithm trained to identify one or more candidate issues. Applying the machine learning algorithm also includes applying to the one or more candidate issues, a classification algorithm trained to classify each candidate issue as an issue of the one or more issues or a false positive. The processor additionally generates a script that, when executed, remediates the candidate issues of the one or more candidate issues classified by the classification algorithm as the issues of the one or more issues. The processor further executes the script.

Abstract: An apparatus includes a memory and a processor. The processor collects from a database server, statistics indicating a performance of the server. The processor applies to the statistics, a machine learning algorithm configured to identify, based in part on the statistics, one or more issues affecting the performance of the database server. Applying the machine learning algorithm includes applying to the statistics, a regression algorithm trained to identify one or more candidate issues. Applying the machine learning algorithm also includes applying to the one or more candidate issues, a classification algorithm trained to classify each candidate issue as an issue of the one or more issues or a false positive. The processor additionally generates a script that, when executed, remediates the candidate issues of the one or more candidate issues classified by the classification algorithm as the issues of the one or more issues. The processor further executes the script.

Abstract: An electrocardiogram (“ECG”) system is provided. The system includes an ECG device capable of receiving ECG signals from a lead system attached to the user. The ECG device then renders the ECG signals into ECG data, and transmits the ECG data to at least one of a user device, such as a smart phone, or a cloud-based storage system. The user device is capable of rendering the ECG data into an ECG graph, and displaying the ECG graph to the user on an application (“app”). The system also provides for a cloud-based storage system capable storing the ECG data and providing access to the ECG data to the user and to medical personal.

Abstract: A battery backup and charging device (BBCD) is described. The BBCD includes a battery, a charger coupled to the battery, AC prongs coupled to the charger, and a connection module adapted to connect the battery and charger to the mobile device. The charger may provide charging to the battery and an internal battery of the mobile device in parallel. The BBCD and mobile device may be enclosed in a single housing. The charger may include a planar transformer.