Patents Assigned to AtScale, Inc.
-
Patent number: 11899665Abstract: A query engine or compute engine receiving a query request identifies a plurality of data sources for satisfying a query request, and determines, from among multiple data sources, one or more fields likely to incur substantial computational demands in processing the query request. Pre-positioning aggregation logic moves the determined fields one data source to another data source for positioning the moved fields to a single data source from which the query result will be computed.Type: GrantFiled: November 18, 2021Date of Patent: February 13, 2024Assignee: AtScale, Inc.Inventors: Rouzbeh Safaie, Joseph Barefoot, Trystan R. Leftwich
-
Patent number: 11853283Abstract: The present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for dynamic aggregate generation and updating for high performance querying of large datasets. Certain embodiments are directed to technological solutions for determining at least one aggregate of selected virtual cube attributes (e.g., measures, dimensions, etc.) describing a virtual multidimensional data model of a subject database, and generating an aggregate table and a set of aggregate metadata for the aggregate. In some embodiments, an aggregate database statement configured to operate on the subject database can be issued to generate the aggregate table and/or aggregate metadata. Further, the aggregate can be dynamically determined responsive to receiving a database statement configured to operate on the virtual multidimensional data model representing the subject database.Type: GrantFiled: November 8, 2022Date of Patent: December 26, 2023Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David Ross
-
Patent number: 11537610Abstract: Techniques are presented for applying fine-grained client-specific rules to divide (e.g., chunk) data statements to achieve cost reduction and/or failure rate reduction associated with executing the data statements over a subject dataset. Data statements for the subject dataset are received from a client. Statement attributes derived from the data statements are processed with respect to fine-grained rules and/or other client-specific data to determine whether a data statement chunking scheme is to be applied to the data statements. If a data statement chunking scheme is to be applied, further analysis is performed to select a data statement chunking scheme. A set of data operations are generated based at least in part on the selected data statement chunking scheme. The data operations are issued for execution over the subject dataset. The results from the data operations are consolidated in accordance with the selected data statement chunking scheme and returned to the client.Type: GrantFiled: December 9, 2017Date of Patent: December 27, 2022Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David P. Ross, Daren Drummond
-
Patent number: 11494362Abstract: The present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for dynamic aggregate generation and updating for high performance querying of large datasets. Certain embodiments are directed to technological solutions for determining at least one aggregate of selected virtual cube attributes (e.g., measures, dimensions, etc.) describing a virtual multidimensional data model of a subject database, and generating an aggregate table and a set of aggregate metadata for the aggregate. In some embodiments, an aggregate database statement configured to operate on the subject database can be issued to generate the aggregate table and/or aggregate metadata. Further, the aggregate can be dynamically determined responsive to receiving a database statement configured to operate on the virtual multidimensional data model representing the subject database.Type: GrantFiled: January 2, 2020Date of Patent: November 8, 2022Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David Ross
-
Patent number: 11394716Abstract: Techniques for determining user authorization to access data in dynamically generated database structures are presented. A method can commence upon receiving database statements from a user that is authorized to access a set of data in a database. A physical plan derived from the received database statements to operate on the database is inspected for references to dynamically generated data structures such as aggregates. A modified physical plan having no aggregates and/or other altered database structures is used to issue low latency database statements to operation on the database for verifying user access authorization to the underlying data. In some cases, the foregoing database statements are based on a virtual multidimensional data model. In other cases, a low latency directive is included in the modified physical plan to facilitate a low latency authorization response.Type: GrantFiled: January 2, 2020Date of Patent: July 19, 2022Assignee: AtScale, Inc.Inventor: Sarah Gerweck
-
Patent number: 11019073Abstract: Techniques are presented for efficiently provisioning application-agnostic resource access to a variety of applications without modification to the native access control mechanisms of the applications and without transmission of a user's credentials over the network. A user of an application is authenticated by an authorization provider. An access token for the authenticated user is generated. A session password is generated based at least in part on the access token. The session password is applied by the user to the native access control mechanism of an application to facilitate access to resources (e.g., set of subject data) by the application. The resource access is achieved without modification to the native access control mechanism of the application and without transmission of the credentials (e.g., username, password, etc.) of the user over the network.Type: GrantFiled: March 6, 2018Date of Patent: May 25, 2021Assignee: AtScale, Inc.Inventors: Matthew Baird, David Vigdor Schreibman, Gaurav Nitin Shetti
-
Patent number: 10929361Abstract: Techniques are presented for rule-based selection of alternate data sources for multidimensional data statements. A virtual multidimensional data model is implemented to represent datasets that are accessed at various data sources. Derivative cubes generated from the virtual multidimensional data model are structured to have a respective data source metadata layer that is populated at data statement execution time to identify a target data source. Data source selection rules are established to map the attributes of data statements to target data sources. The data source selection rules are evaluated subject to data statement attributes derived from detected data statements to dynamically select target data sources for the data statements. The derivative cubes codify, in their respective data source metadata layers, a unique set of data source attributes identifying the target data sources. The derivative cubes are accessed to facilitate execution of the data statements on datasets at the target data sources.Type: GrantFiled: July 23, 2017Date of Patent: February 23, 2021Assignee: AtScale, Inc.Inventors: Sarah Gerweck, DaRen Drummond, Matthew Baird
-
Patent number: 10783014Abstract: Techniques are presented for performing enhanced real-time data statement monitoring and control without requiring modifications to data analysis client applications or data storage environments. A data statement processing layer is implemented between the data analysis client applications and the data storage environments. A data statement management agent interacts with an event bus in the data statement processing layer. The data statement management agent accesses event objects on the event bus that are generated during the processing of data statements. Rules are applied to select particular event objects. The selected event objects are transformed into event messages that are delivered to the client applications to monitor the processing of the data statements. Control commands received from the client application are transformed into event objects that are issued to the event bus to control the processing of the data statement.Type: GrantFiled: December 4, 2018Date of Patent: September 22, 2020Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David P. Mariani, Matthew Baird, Josh Klahr, David Schreibman
-
Patent number: 10713248Abstract: Techniques are presented for rule-based selection of query engines for performing data operations on a variety of datasets stored in heterogeneous data storage environments. Data statements for a subject dataset are mapped to a logical data structure representation of the subject dataset to formulate a logical plan for the data statements. The data statements are analyzed to derive a set of statement attributes associated with the data statements. Query engine attributes describing the query engines available to query various instances of the subject dataset are accessed. A set of query engine selection rules are evaluated subject to the statement attributes and/or the query engine attributes to dynamically select a target query engine for the data statements. A physical plan structured for the target query engine is generated from the logical plan. The physical plan is executed on the target query engine to perform data operations on the subject dataset.Type: GrantFiled: July 23, 2017Date of Patent: July 14, 2020Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David Ross, David P. Mariani, Matthew Baird
-
Publication number: 20200142895Abstract: The present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for dynamic aggregate generation and updating for high performance querying of large datasets. Certain embodiments are directed to technological solutions for determining at least one aggregate of selected virtual cube attributes (e.g., measures, dimensions, etc.) describing a virtual multidimensional data model of a subject database, and generating an aggregate table and a set of aggregate metadata for the aggregate. In some embodiments, an aggregate database statement configured to operate on the subject database can be issued to generate the aggregate table and/or aggregate metadata. Further, the aggregate can be dynamically determined responsive to receiving a database statement configured to operate on the virtual multidimensional data model representing the subject database.Type: ApplicationFiled: January 2, 2020Publication date: May 7, 2020Applicant: Atscale, Inc.Inventors: Sarah Gerweck, David Ross
-
Publication number: 20200137069Abstract: Techniques for determining user authorization to access data in dynamically generated database structures are presented. A method can commence upon receiving database statements from a user that is authorized to access a set of data in a database. A physical plan derived from the received database statements to operate on the database is inspected for references to dynamically generated data structures such as aggregates. A modified physical plan having no aggregates and/or other altered database structures is used to issue low latency database statements to operation on the database for verifying user access authorization to the underlying data. In some cases, the foregoing database statements are based on a virtual multidimensional data model. In other cases, a low latency directive is included in the modified physical plan to facilitate a low latency authorization response.Type: ApplicationFiled: January 2, 2020Publication date: April 30, 2020Applicant: Atscale, Inc.Inventor: Sarah Gerweck
-
Patent number: 10530779Abstract: Techniques for determining user authorization to access data in dynamically generated database structures are presented. A method can commence upon receiving database statements from a user that is authorized to access a set of data in a database. A physical plan derived from the received database statements to operate on the database is inspected for references to dynamically generated data structures such as aggregates. A modified physical plan having no aggregates and/or other altered database structures is used to issue low latency database statements to operation on the database for verifying user access authorization to the underlying data. In some cases, the foregoing database statements are based on a virtual multidimensional data model. In other cases, a low latency directive is included in the modified physical plan to facilitate a low latency authorization response.Type: GrantFiled: March 31, 2018Date of Patent: January 7, 2020Assignee: AtScale, Inc.Inventor: Sarah Gerweck
-
Patent number: 10528540Abstract: The present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for dynamic aggregate generation and updating for high performance querying of large datasets. Certain embodiments are directed to technological solutions for determining at least one aggregate of selected virtual cube attributes (e.g., measures, dimensions, etc.) describing a virtual multidimensional data model of a subject database, and generating an aggregate table and a set of aggregate metadata for the aggregate. In some embodiments, an aggregate database statement configured to operate on the subject database can be issued to generate the aggregate table and/or aggregate metadata. Further, the aggregate can be dynamically determined responsive to receiving a database statement configured to operate on the virtual multidimensional data model representing the subject database.Type: GrantFiled: November 19, 2015Date of Patent: January 7, 2020Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David Ross
-
Patent number: 10467250Abstract: The present disclosure provides a detailed description of techniques for data model design collaboration using semantically correct collaborative objects. Certain embodiments comprise detecting various interaction events from designers collaborating on designing a virtual multidimensional data model to generate unit of work objects characterizing certain design transactions invoked by the interaction events. The unit of work objects are used to determine a set of committed modifications to the virtual multidimensional data model design for broadcasting to the collaborating designers. Some embodiments comprise unit of work objects based on various multidimensional data model rules, syntactic rules, semantic rules, and/or other criteria to determine valid committed modifications. Other embodiments comprise unit of work objects from multiple design transactions that are merged to determine the committed modifications.Type: GrantFiled: December 14, 2015Date of Patent: November 5, 2019Assignee: AtScale, Inc.Inventors: Matthew Baird, James Lai
-
Patent number: 10185607Abstract: Techniques are presented for performing enhanced real-time data statement monitoring and control without requiring modifications to data analysis client applications or data storage environments. A data statement processing layer is implemented between the data analysis client applications and the data storage environments. A data statement management agent interacts with an event bus in the data statement processing layer. The data statement management agent accesses event objects on the event bus that are generated during the processing of data statements. Rules are applied to select particular event objects. The selected event objects are transformed into event messages that are delivered to the client applications to monitor the processing of the data statements. Control commands received from the client application are transformed into event objects that are issued to the event bus to control the processing of the data statement.Type: GrantFiled: July 23, 2017Date of Patent: January 22, 2019Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David P. Mariani, Matthew Baird, Josh Klahr, David Schreibman
-
Patent number: 9946780Abstract: The present disclosure provides improved systems, methods, and computer program products suited to address the issues with legacy approaches. Specifically, the present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for interpreting relational database statements using a virtual multidimensional data model.Type: GrantFiled: February 6, 2017Date of Patent: April 17, 2018Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David P. Mariani
-
Patent number: 9948655Abstract: Techniques for determining user authorization to access data in dynamically generated database structures are presented. A method can commence upon receiving database statements from a user that is authorized to access a set of data in a database. A physical plan derived from the received database statements to operate on the database is inspected for references to dynamically generated data structures such as aggregates. A modified physical plan having no aggregates and/or other altered database structures is used to issue low latency database statements to operation on the database for verifying user access authorization to the underlying data. In some cases, the foregoing database statements are based on a virtual multidimensional data model. In other cases, a low latency directive is included in the modified physical plan to facilitate a low latency authorization response.Type: GrantFiled: April 15, 2016Date of Patent: April 17, 2018Assignee: AtScale, Inc.Inventor: Sarah Gerweck
-
Patent number: 9600554Abstract: The present disclosure provides improved systems, methods, and computer program products suited to address the issues with legacy approaches. Specifically, the present disclosure provides a detailed description of techniques used in systems, methods, and in computer program products for interpreting relational database statements using a virtual multidimensional data model.Type: GrantFiled: March 23, 2015Date of Patent: March 21, 2017Assignee: AtScale, Inc.Inventors: Sarah Gerweck, David P. Mariani