Query intake for legacy databases

    公开(公告)号:US11995078B2

    公开(公告)日:2024-05-28

    申请号:US17529878

    申请日:2021-11-18

    申请人: Atscale, Inc.

    IPC分类号: G06F16/2453

    CPC分类号: G06F16/24534

    摘要: A query syntax analysis and postprocessing system and method receives a query request specifying values of a data type directed to a database without native support for the queried data type. A query engine or process for receiving a query request defined by a query syntax traverses the query request for a specification of an unsupported value or expression. In a large, distributed database environment, the query request may implicate multiple physical data stores, each having specific formats and recognized syntax. Values of unsupported or non-native types, or expressions that evaluate to an unsupported or non-native type, are identified and replaced with an expression that is recognized by the legacy database.

    HYBRID CODE COMBINING IMPERATIVE PROGRAMMING LANGUAGES WITH DECLARATIVE DATABASE OPERATIONS TO ACCOMPLISH ITERATIVE LOGIC

    公开(公告)号:US20240086156A1

    公开(公告)日:2024-03-14

    申请号:US18367188

    申请日:2023-09-12

    申请人: AtScale, Inc.

    IPC分类号: G06F8/35 G06F8/30 G06F16/242

    CPC分类号: G06F8/35 G06F8/31 G06F16/2425

    摘要: A hybrid code construct combines imperative and declarative semantics for leveraging complementary features for a relational database exchange optimized for declarative access driven by imperative direction for imposing iterative and conditional looping behavior. Databases responsive to a declarative command structure receive declarative code generated from an imperative code sequence. The imperative code is based on a language that allows conditional iteration for repetitive commands, which invoke the declarative command syntax within a controlled loop or iteration. Declarative syntax, while enjoying optimizations for high performance database access, does not lend itself well to iterative logic common for linear regression and training of ML models. The hybrid code allows efficient ML training while the dataset defining the model remains within the database and need not incur network transport for Al based usage.

    EMBEDDED AND DISTRIBUTABLE POLICY ENFORCEMENT

    公开(公告)号:US20220353298A1

    公开(公告)日:2022-11-03

    申请号:US17733028

    申请日:2022-04-29

    申请人: Atscale, Inc.

    IPC分类号: H04L9/40 G06F21/62 G06F9/54

    摘要: A network device for enforcing an authorization policy to a database includes identifying an authorization policy based on declarative designations of a set of objects, subjects and actions affected by an access request, and distributing the executable entity to a plurality if endpoints of a network of users. Each endpoint of the plurality of endpoints has one or more client applications. The endpoint embeds the executable entity in the client application, the executable entity responsive to access requests from the client application, and the endpoint node grants the access request based on evaluating the access request against the authorization policy, evaluating based only on instructions in the executable entity.

    QUERY INTAKE FOR LEGACY DATABASES

    公开(公告)号:US20220156263A1

    公开(公告)日:2022-05-19

    申请号:US17529878

    申请日:2021-11-18

    申请人: Atscale, Inc.

    IPC分类号: G06F16/2453

    摘要: A query syntax analysis and postprocessing system and method receives a query request specifying values of a data type directed to a database without native support for the queried data type. A query engine or process for receiving a query request defined by a query syntax traverses the query request for a specification of an unsupported value or expression. In a large, distributed database environment, the query request may implicate multiple physical data stores, each having specific formats and recognized syntax. Values of unsupported or non-native types, or expressions that evaluate to an unsupported or non-native type, are identified and replaced with an expression that is recognized by the legacy database.

    HIERARCHICAL DATACUBE QUERY PLAN GENERATION

    公开(公告)号:US20220012242A1

    公开(公告)日:2022-01-13

    申请号:US17368932

    申请日:2021-07-07

    申请人: AtScale, Inc

    摘要: A multidimensional database query engine processes a query request by forming a logical plan of subqueries for retrieving and assembling the data called for by the query request. A multi-pass analysis identifies a granularity of facts needed to fulfill the query request. A recursive analysis parses the query request and identifies components comprising the full query request. The analysis derives a subquery from each component, and identifies dependencies on other subqueries. The subqueries are arranged in a tree structure based on the dependencies. The tree represents subqueries as nodes, with query operations denoted by parent nodes for the dependent subqueries. The result is a hierarchical tree of subqueries associated based on operations between the subqueries and dependent subqueries descending from their parent subqueries.

    Application-agnostic resource access control

    公开(公告)号:US11019073B2

    公开(公告)日:2021-05-25

    申请号:US15913906

    申请日:2018-03-06

    申请人: AtScale, Inc.

    IPC分类号: H04L29/06 H04L29/08

    摘要: 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.

    Semantic layer generation
    7.
    发明授权

    公开(公告)号:US12079180B2

    公开(公告)日:2024-09-03

    申请号:US16022678

    申请日:2018-06-28

    申请人: AtScale, Inc.

    发明人: Dianne Wood

    摘要: Techniques are presented for generating semantic layers that are used to facilitate data analyses of subject datasets. The semantic layers are generated from data analysis configurations that characterize analysis environments pertaining to the subject datasets rather than from subject dataset metadata that is associated with the subject datasets. Data analysis attributes are extracted from configuration content objects that codify the data analysis configurations. A set of rules are accessed to facilitate mapping of the data analysis attributes to semantic model metadata that constitute the semantic layers. Some of the generated semantic layers comprise virtual data models. The virtual data models and/or recommendations associated with implementation of the semantic layers are presented to users. Certain portions of the semantic layers and/or the configuration content objects may be modified (e.g., in accordance with the implementation recommendations) to facilitate use of the semantic layers when performing data analyses of the subject datasets.

    Hierarchical datacube query plan generation

    公开(公告)号:US12026161B2

    公开(公告)日:2024-07-02

    申请号:US17368932

    申请日:2021-07-07

    申请人: AtScale, Inc.

    摘要: A multidimensional database query engine processes a query request by forming a logical plan of subqueries for retrieving and assembling the data called for by the query request. A multi-pass analysis identifies a granularity of facts needed to fulfill the query request. A recursive analysis parses the query request and identifies components comprising the full query request. The analysis derives a subquery from each component, and identifies dependencies on other subqueries. The subqueries are arranged in a tree structure based on the dependencies. The tree represents subqueries as nodes, with query operations denoted by parent nodes for the dependent subqueries. The result is a hierarchical tree of subqueries associated based on operations between the subqueries and dependent subqueries descending from their parent subqueries.

    PREFERRED STORAGE OF AGGREGATE DATA ITEMS
    9.
    发明公开

    公开(公告)号:US20230342360A1

    公开(公告)日:2023-10-26

    申请号:US18139077

    申请日:2023-04-25

    申请人: AtScale, Inc.

    摘要: A preferred aggregate store for a multidimensional database receives and stores intermediate data generated as part of a larger query for avoiding repetitive or redundant data retrievals incurring costly data paths. Aggregates include intermediate tables and sets of data, often generated from a join of two or more distinct data tables, combined for generating a query result. In the event an aggregate is called for, certain storage locations may be preferable to others due to network distance, fees for storage and processing, as in the case of cloud storage, or write accessibility. Designation of a preferred aggregate store ensures that aggregates called for by the query processing are stored in a beneficial location for cost and efficiency.

    SECURE DISTRIBUTION OF EMBEDDED POLICY

    公开(公告)号:US20220350900A1

    公开(公告)日:2022-11-03

    申请号:US17733035

    申请日:2022-04-29

    申请人: Atscale, Inc.

    摘要: An embedded policy takes the form of an executable entity local to the endpoint or end application attempting to access target data. The executable entity is compiled from a declarative remote policy based on objects, subjects and actions, and includes a library and API (Application Programming Interface) in conjunction with a client application seeking access according to the policy. Evaluation of appropriate access is resolved with a local function call to the executable entity, rather than a network message exchange, thus providing data target access according to the policy without incurring network latency.