Asynchronous search for big objects

    公开(公告)号:US11615105B2

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

    申请号:US16442409

    申请日:2019-06-14

    Abstract: Techniques and systems for completing a database query. A time to complete a synchronous query in response to receiving an original database query is estimated by a database management system provided by one or more computing devices. A synchronous database query corresponding to the original database query is performed with the database management system if the estimated time to complete the synchronous query is less than a pre-selected threshold time. One or more asynchronous queries corresponding to the original database query are performed with the database management system if the estimated time to complete the synchronous query is greater than the pre-selected threshold time. A result, whether from a synchronous query or one or more asynchronous queries, is stored in an object within a non-relational database system.

    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.

    RULES-BASED SYNCHRONOUS QUERY PROCESSING FOR LARGE DATASETS IN AN ON-DEMAND ENVIRONMENT

    公开(公告)号:US20190042573A1

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

    申请号:US15665529

    申请日:2017-08-01

    Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating rules-based synchronous query processing for large datasets in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method comprises detecting, by a rules-management server computing device, at least one of efficient classes and inefficient classes associated with a query, and designating a set of rules to the query, where one or more of the set of rules are designated to the query to prevent the inefficient classes from being processed or allow the query to fail fast. The method may further include executing the query without processing the inefficient classes such that results are generated within a predictable amount of time, where executing includes accessing contents of one or more portions of a database as identified by the set of rules, and transmitting the results in response to the query.

    Techniques for data retention
    17.
    发明授权

    公开(公告)号: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.

    METHOD AND SYSTEM FOR CLEANING DATA IN A CUSTOMER RELATIONSHIP MANAGEMENT SYSTEM
    18.
    发明申请
    METHOD AND SYSTEM FOR CLEANING DATA IN A CUSTOMER RELATIONSHIP MANAGEMENT SYSTEM 有权
    在客户关系管理系统中清理数据的方法和系统

    公开(公告)号:US20140081908A1

    公开(公告)日:2014-03-20

    申请号:US13773383

    申请日:2013-02-21

    CPC classification number: G06F17/30345 G06F17/30303

    Abstract: Systems and methods are provided for cleaning data in a customer relationship management system. A system receives a plurality of records from an on-demand system. The system identifies a record from the plurality of records that matches a stored record for a customer relationship management system. The system determines whether to update the stored record using the identified record. The system updates the stored record using the identified record in response to a determination to update the stored record using the identified record.

    Abstract translation: 提供了系统和方法来清理客户关系管理系统中的数据。 系统从点播系统接收多个记录。 系统识别与客户关系管理系统的存储记录相匹配的多个记录中的记录。 系统使用识别的记录确定是否更新存储的记录。 响应于使用识别的记录来更新存储的记录的确定,系统使用所识别的记录来更新所存储的记录。

    TECHNIQUES FOR DATA RETENTION
    19.
    发明申请

    公开(公告)号: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.

    Application programming interface representation of multi-tenant non-relational platform objects

    公开(公告)号:US10579691B2

    公开(公告)日:2020-03-03

    申请号:US15717780

    申请日:2017-09-27

    Abstract: Disclosed are examples of systems, apparatus, methods and computer program products for providing application programming interface representation for multi-tenant non-relational database objects. A database system maintains a multi-tenant non-relational database associated with a number of enterprises, a number of records, and a number of data objects for each of the enterprises. A request is received from a user to retrieve a description of a data object from the number of data objects, and in response, the system determines that the data object is defined to be used in associated with a non-relational database, then retrieves a metadata model representing the data object. The system determines that at least one field of the data object is part of a composite key for the data object, then provides data object information to the user, including information about the composite key.

Patent Agency Ranking