Abstract: The present disclosure relates to methods and systems for querying data in a data repository. According to a first aspect, this disclosure describes a method of querying a database, comprising: receiving, at a computing device, a plurality of keywords; determining, by the computer device, a plurality of datasets relating to the keywords; identifying, by the computer device, metadata for the plurality of datasets indicating a relationship between the datasets by examining an ontology associated with the datasets; providing, by the computer device, one or more suggested database queries in natural language form, the one or more suggested database queries constructed based on the plurality of keywords and the metadata; receiving, by the computing device, a selection of the one or more suggested database queries; and constructing, by the computer device, an object view for the plurality of datasets based on the selected query and the metadata.

Abstract: A user interface generation system and associated methods are disclosed for displaying nodes of a computer program or computation. The system may determine an ordering and position of elements for display. The ordering can include determining a first ancestor branch of a node associated with a stage with an earliest start time among the start times associated with the stages of a plurality of ancestor branches. This first ancestor branch may be designated as first in the ordering. A second ancestor branch may be determined from among the remaining ancestor branches having an stage with an earliest start time among the start times associated with the remaining stages. This second ancestor branch can be designated as second in the ordering.

Abstract: A user interface generation system and associated methods are disclosed for displaying nodes of a computer program or computation. The system may determine an ordering and position of elements for display. The ordering can include determining a first ancestor branch of a node associated with a stage with an earliest start time among the start times associated with the stages of a plurality of ancestor branches. This first ancestor branch may be designated as first in the ordering. A second ancestor branch may be determined from among the remaining ancestor branches having an stage with an earliest start time among the start times associated with the remaining stages. This second ancestor branch can be designated as second in the ordering.

Abstract: The present disclosure relates to methods and systems for querying data in a data repository. According to a first aspect, this disclosure describes a method of querying a database, comprising: receiving, at a computing device, a plurality of keywords; determining, by the computer device, a plurality of datasets relating to the keywords; identifying, by the computer device, metadata for the plurality of datasets indicating a relationship between the datasets by examining an ontology associated with the datasets; providing, by the computer device, one or more suggested database queries in natural language form, the one or more suggested database queries constructed based on the plurality of keywords and the metadata; receiving, by the computing device, a selection of the one or more suggested database queries; and constructing, by the computer device, an object view for the plurality of datasets based on the selected query and the metadata.

Abstract: Various systems and methods are provided that aggregate, analyze, and display health data for users. The system aggregates data stored in various databases. For example, the system retrieves data from these databases, maps the data to a set of common terms based on an ontology, and displays such information to an entity accessing the system. Rather than converting the data stored in the databases into a standardized format, the system includes a set of ontologies that provide a correlation between a first set of fields and a second set of fields. The system determines a correlation between a first field in the first set of fields and a second field in the second set of fields using the ontology, stores data retrieved from the database in a second database in association with the second field, and displays the data associated with the first field under the second field.

Abstract: Various systems and methods are provided that aggregate, analyze, and display health data for users. The system aggregates data stored in various databases. For example, the system retrieves data from these databases, maps the data to a set of common terms based on an ontology, and displays such information to an entity accessing the system. Rather than converting the data stored in the databases into a standardized format, the system includes a set of ontologies that provide a correlation between a first set of fields and a second set of fields. The system determines a correlation between a first field in the first set of fields and a second field in the second set of fields using the ontology, stores data retrieved from the database in a second database in association with the second field, and displays the data associated with the first field under the second field.

Abstract: Disclosed herein are systems and methods for joining datasets. The system may include one or more processors and a memory storing instructions that, when executed by the one or more processors. The processor may cause the system to perform determining at least a first database table to be annotated, the first database table including a set of columns and rows of a dataset. In some embodiments, the system may include determining at least one typeclass that applies to one or more columns included in the first database table, wherein the typeclass describes values stored in the one or more columns and annotating the one or more columns, wherein the annotated columns are associated with the typeclass.

Abstract: The present disclosure relates to methods and systems for querying data in a data repository. According to a first aspect, this disclosure describes a method of querying a database, comprising: receiving, at a computing device, a plurality of keywords; determining, by the computer device, a plurality of datasets relating to the keywords; identifying, by the computer device, metadata for the plurality of datasets indicating a relationship between the datasets by examining an ontology associated with the datasets; providing, by the computer device, one or more suggested database queries in natural language form, the one or more suggested database queries constructed based on the plurality of keywords and the metadata; receiving, by the computing device, a selection of the one or more suggested database queries; and constructing, by the computer device, an object view for the plurality of datasets based on the selected query and the metadata.

Abstract: Systems, methods, and non-transitory computer readable media are provided for validating data for integration. A file to be integrated into a dataset may be determined. The file may be characterized by a file name and metadata. Whether the dataset can be identified based on the file name and the metadata may be determined. Based on the dataset not being identifiable, information needed to identify the dataset may be requested. Based on the dataset being identifiable, the file may be routed for integration into the dataset.

Abstract: Systems, methods, and non-transitory computer readable media are provided for validating data for integration. A file to be integrated into a dataset may be determined. The file may be characterized by a file name and metadata. Whether the dataset can be identified based on the file name and the metadata may be determined. Based on the dataset not being identifiable, information needed to identify the dataset may be requested. Based on the dataset being identifiable, the file may be routed for integration into the dataset.

Abstract: The present disclosure relates to methods and systems for querying data in a data repository. According to a first aspect, this disclosure describes a method of querying a database, comprising: receiving, at a computing device, a plurality of keywords; determining, by the computer device, a plurality of datasets relating to the keywords; identifying, by the computer device, metadata for the plurality of datasets indicating a relationship between the datasets by examining an ontology associated with the datasets; providing, by the computer device, one or more suggested database queries in natural language form, the one or more suggested database queries constructed based on the plurality of keywords and the metadata; receiving, by the computing device, a selection of the one or more suggested database queries; and constructing, by the computer device, an object view for the plurality of datasets based on the selected query and the metadata.

Abstract: Systems and methods are provided that are useful for configuring data processing pipelines. During building of a dataset in a data processing pipeline, statistics can be calculated relating to the dataset.

Abstract: A first dataset from one or more databases and a second dataset from the one or more databases may be identified. The first dataset may contain first data while the second dataset may contain second data. A first relationship measure may be computed for the first dataset, where the first relationship measure is configured to represent the first data in a first condensed format. A second relationship measure may be computed for the second dataset, where the second relationship measure is configured to represent the second data in a second condensed format. A join key may be computed using the first relationship measure and the second relationship measure. The join key may represent a correspondence area between the first dataset and the second dataset. An interactive user interface element may be configured to display a graphical depiction of the correspondence area between the first dataset and the second dataset.

Abstract: Systems and methods are provided that are useful for configuring data processing pipelines. During building of a dataset in a data processing pipeline, statistics can be calculated relating to the dataset.

Abstract: The present disclosure relates to methods and systems for querying data in a data repository. According to a first aspect, this disclosure describes a method of querying a database, comprising: receiving, at a computing device, a plurality of keywords; determining, by the computer device, a plurality of datasets relating to the keywords; identifying, by the computer device, metadata for the plurality of datasets indicating a relationship between the datasets by examining an ontology associated with the datasets; providing, by the computer device, one or more suggested database queries in natural language form, the one or more suggested database queries constructed based on the plurality of keywords and the metadata; receiving, by the computing device, a selection of the one or more suggested database queries; and constructing, by the computer device, an object view for the plurality of datasets based on the selected query and the metadata.

Abstract: Disclosed herein are systems and methods for joining datasets. The system may include one or more processors and a memory storing instructions that, when executed by the one or more processors. The processor may cause the system to perform determining at least a first database table to be annotated, the first database table including a set of columns and rows of a dataset. In some embodiments, the system may include determining at least one typeclass that applies to one or more columns included in the first database table, wherein the typeclass describes values stored in the one or more columns and annotating the one or more columns, wherein the annotated columns are associated with the typeclass.

Abstract: A first dataset from one or more databases and a second dataset from the one or more databases may be identified. The first dataset may contain first data while the second dataset may contain second data. A first relationship measure may be computed for the first dataset, where the first relationship measure is configured to represent the first data in a first condensed format. A second relationship measure may be computed for the second dataset, where the second relationship measure is configured to represent the second data in a second condensed format. A join key may be computed using the first relationship measure and the second relationship measure. The join key may represent a correspondence area between the first dataset and the second dataset. An interactive user interface element may be configured to display a graphical depiction of the correspondence area between the first dataset and the second dataset.