Multi-tenancy for structured query language (SQL) and non structured query language (NoSQL) databases

    公开(公告)号:US10664487B2

    公开(公告)日:2020-05-26

    申请号:US16112538

    申请日:2018-08-24

    Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.

    TECHNIQUES FOR DATA RETENTION
    3.
    发明申请
    TECHNIQUES FOR DATA RETENTION 审中-公开
    数据保留技术

    公开(公告)号:US20150142751A1

    公开(公告)日:2015-05-21

    申请号:US14542357

    申请日:2014-11-14

    Abstract: Managing data in a multitenant environment having a relational database and a non-relational database. A set of one or more policies for data retention corresponding to data stored in the relational database environment is received. The policies for data retention are defined on a tenant-by-tenant basis within the multitenant environment. The policies are deployed to data in the relational database on a tenant-by-tenant basis within the multitenant environment. Data to be copied from the relational database to the non-relational database is identified. The data to be copied in the non-relational database is stored while maintaining tenant isolation so that data belonging to the respective tenants is not accessible by other tenants when stored in the non-relational database.

    Abstract translation: 在具有关系数据库和非关系数据库的多租户环境中管理数据。 接收一组用于与存储在关系数据库环境中的数据相对应的用于数据保留的策略。 数据保留政策是在多租户环境中按租户方式进行定义的。 这些策略在多租户环境中以租户为单位部署到关系数据库中的数据。 识别从关系数据库复制到非关系数据库的数据。 要在非关系数据库中复制的数据被存储,同时保持租户隔离,使得属于相应租户的数据在存储在非关系数据库中时不被其他租户访问。

    MULTI-TENANCY FOR STRUCTURED QUERY LANGUAGE (SQL) AND NON STRUCTURED QUERY LANGUAGE (NOSQL) DATABASES

    公开(公告)号:US20210011911A1

    公开(公告)日:2021-01-14

    申请号:US16883810

    申请日:2020-05-26

    Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.

    Techniques for data retention
    7.
    发明授权

    公开(公告)号:US10176235B2

    公开(公告)日:2019-01-08

    申请号:US14542357

    申请日:2014-11-14

    Abstract: Managing data in a multitenant environment having a relational database and a non-relational database. A set of one or more policies for data retention corresponding to data stored in the relational database environment is received. The policies for data retention are defined on a tenant-by-tenant basis within the multitenant environment. The policies are deployed to data in the relational database on a tenant-by-tenant basis within the multitenant environment. Data to be copied from the relational database to the non-relational database is identified. The data to be copied in the non-relational database is stored while maintaining tenant isolation so that data belonging to the respective tenants is not accessible by other tenants when stored in the non-relational database.

    TECHNIQUES FOR DATA RETENTION
    8.
    发明申请

    公开(公告)号:US20230084317A1

    公开(公告)日:2023-03-16

    申请号:US18049117

    申请日:2022-10-24

    Abstract: Systems and techniques for managing data in a relational database environment and a non-relational database environment. Data in the relational database environment that is static and to be maintained beyond a preselected threshold length of time is identified. The data is copied from the relational database and stored in the data the non-relational database. Access to the data is provided from the non-relational database via a user interface that accesses both the relational database and the non-relational database.

    MULTI-TENANCY FOR STRUCTURED QUERY LANGUAGE (SQL) AND NON STRUCTURED QUERY LANGUAGE (NOSQL) DATABASES

    公开(公告)号:US20180365299A1

    公开(公告)日:2018-12-20

    申请号:US16112538

    申请日:2018-08-24

    Abstract: Techniques and structures for providing a multitenant environment having both a relational database and a non-relational database. A database query is received with at least one server computing device providing a multitenant environment having a relational database system and a non-relational database system, the database query in a format corresponding to the relational database system. The query is parsed with the at least one server computing device to find one or more components of the query directed to data stored in the non-relational database system. One or more components of the query directed to data stored in the non-relational database system are converted to one or more scans of the non-relational database system. Results from the query of the relational database system and results from the one or more scans of the non-relational database system are collected. The results from the query and the results of the one or more scans to a combined result are combined. The combined results are provided to a client entity.

Patent Agency Ranking