Abstract: In accordance with embodiments disclosed herein, there are provided mechanisms and methods for automating deployment of applications in a multi-tenant database environment. For example, in one embodiment, mechanisms include managing a plurality of machines operating as a machine farm within a datacenter by executing an agent provisioning script at a control hub, instructing the plurality of machines to download and instantiate a lightweight agent; pushing a plurality of URL (Uniform Resource Locator) references from the control hub to the instantiated lightweight agent on each of the plurality of machines specifying one or more applications to be provisioned and one or more dependencies for each of the applications; and loading, via the lightweight agent at each of the plurality of machines, the one or more applications and the one or more dependencies for each of the one or more applications into memory of each respective machine.

Abstract: Disclosed are some implementations of systems, apparatus, methods and computer program products for publisher and share action integration in a user interface (UI) for automated messaging. In some implementations, information is displayed in a first component and in a second component in a UI on a display. The first component is a publisher configured for composing and sharing messages on different communication channels using different share actions. The second component includes links to data items. When one of the data items is selected, a set of share actions for sharing the selected item using the publisher can be identified and displayed. When one of the displayed share actions is selected, it can be determined that the selected share action is applicable to one of the communication channels. A reference to the selected item can be provided in a message being composed in the publisher for sharing on the one communication channel.

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing a BY ORGID command term within a multi-tenant aware structured query language within a computing environment.

Abstract: In an example, a database system may be configured to validate relational database instructions using a plurality of validators. In some examples, validation may be pre-production for relational database instructions based on simulated user inputs and/or file, such as plan files (e.g., PL/SQL (procedural language/structured query language) files). In some examples, validation may be in production for relational database instructions based on system views of a database engine.

Abstract: A method for technical field service inventory management has been developed. A software platform manages product inventory for use by a field service technician. The platform creates objects for a work order, a product required, a location, an address/appointment, a product item, a product item transaction and a product item consumed. The product item consumed object is used to automatically update the status of product inventory as the product is used by the field service technician.

Abstract: In accordance with disclosed embodiments, there are provided systems, methods, and apparatuses for implementing conditional statement execution within a multi-tenant aware structured query language within a computing environment.

Abstract: Methods and systems for optimizing queries in a multi-tenant store are described. In one embodiment, such a method includes retrieving data from a multi-tenant database system having a relational data store and a non-relational data store, receiving a request specifying data to be retrieved, retrieving one or more locations of the data to be retrieved, generating a database query based on the request, in which the database query specifies a plurality of data elements to be retrieved, the plurality of data elements including one or more data elements residing within the non-relational data store and one or more other data elements residing within the relational data store, generating an optimized database query having an optimized query syntax that is distinct from a query syntax of the database query, and executing the optimized database query against the multi-tenant database system to retrieve the data.

Abstract: Embodiments regard security descriptors for record access queries. An embodiment of a method includes: receiving a record access query, the query regarding records for a certain one or more users at a certain access level; searching one or more sharing tables of entities in a computing environment for security descriptors, each security descriptor being associated with a set of one or more users having access to one or more records of a set of records at an access level; identifying any security descriptors in the one or more sharing tables that relate to the certain one or more users with at least the certain access level; and searching the one or more records associated with each of the identified security descriptors according to the record access query.

Abstract: A time series database system receives a request from a user device for first time series data within a first time range, the first time series data being a subset of second time series data within a second time range, the second time series data being stored in a persistent storage. The system determines whether all of the first time series data is stored in a memory. The system retrieves the second time series data from the persistent storage if all of the first time series data is not stored in the memory. The system stores the second time series data, excluding any part of the second time series data associated with a current time period, into the memory. The system causes the first time series data, being a subset of the second time series data retrieved from the persistent storage, to be outputted to the user device.

Abstract: A computer-implemented method in a document editing module is provided. The document editing module comprises a processor configured by programming instructions encoded in non-transient computer readable media. The method comprises providing, by the processor, contents of a document to a user interface; providing via the user interface, by the processor, an object that when selected indicates a desire to lock the document from editing by another document editing module or another instance of the document editing module for a fixed time period; and modifying, by the processor, one or more attributes of the document that indicate that the document is locked for editing and a fixed length of time the document is locked for editing when the object has been selected.

Abstract: Techniques are disclosed relating to invalidating keys in a cache. In some embodiments, a computer system may implement a cache for a data store, where the cache stores a data set and is organized such that a stored data item of the data set is specified by a corresponding key having one or more portions. The computer system may store metadata for the cache, where the metadata includes nodes organized in a hierarchy. The computer system may receive a request to invalidate one or more keys of the cache, and may invalidate a particular node within the metadata based on a key value corresponding to the request.

Abstract: In one embodiment, a stream processing system ingests data from one or more data sources and converts the data into an unbounded stream for an event stream processor. The stream processing system may include a first coordinating spout instance that is deployed at a first time, the first coordinating spout instance to instantiate one or more second spout instances and deploy said one more second spout instances at a second time that is later than the first time; the one or more second spout instances to: connect to the one or more data sources, respectively, and ingest a respective portion of the data from its respective one of the one or more data sources; and output messages based on the ingested portions of the data; wherein the unbounded stream for the event stream processor is based on the messages. Other embodiments may be disclosed and/or claimed.

Abstract: The disclosed technology for a hardware system to access a secure backend system uses non-volatile memory to hold encrypted secrets, volatile memory to hold decrypted secrets ready for use, a keys-for-all (K4A) server, and app servers running K4A clients. To access the backend system in production, each app server uses a decrypted secret and a certificate that identifies the app server and certifies its role and physical and logical location. At initialization of the app server, a K4A client is instantiated that launches and tracks processes, running on the app server, that are authorized to request decryption services. The K4A client responds to a decryption request from an authorized process, determined based on tracking of processes launched, by requesting decryption by a K4A server, using the certificate, and returns to the process, in volatile memory, a decrypted secret or a reference to the decrypted secret, decrypted by the K4A server.