Oracle International Corporation

Salesforce, Inc.

Salesforce Com, Inc.

Ashok Shivarudraiah

Douglas N Surber

Jean De Lavarene

Garret Frederick Swart

Tong Zhou

Sarah Flamion

Jamin Hall

Vineeth Anand Nair

Kasia Fichtner

Matthew Westover

Lakshmi Srinivas Parimi

Alan Mathias Hoffman

Nigel Wallace Menger

Neil Raymond Parsons

Pamela Sue Walquist

Mark Dilman

Wei Ming Hu

Leonid Novak

Vidya Hegde

Ilya Taranov

Edward Shirk

Cetin Ozbutun

Aaron M Popelka

Mark Jungerman

David Kriebel

Narender Ramasahayam

Mitchell Loudenbeck

Praveen Savur

Sumit Garg

Kuassi Mensah

Paul Lo

Wei Hu

A method for data processing includes displaying, at a user interface, a plurality of attributes that are defined by a data model configured for a tenant of a multi-tenant system. The plurality of attributes includes a one-to-many attribute that is configured to support multiple inputs and a direct attribute configured to support a single input. The method may further include receiving a selection of a first one-to-many attribute for defining an expression for identifying a segment of entities. The method may further include activating, for selection at the user interface, a subset of the attributes based on each attribute of the subset being dependent on the first attribute. The method may further include receiving an indication of the expression, executing a database query to identify the segment of entities, and transmitting, to a content communication system, an indication of the segment of entities.

Declarative entity segmentation

A system and method is described for database split generation in a massively parallel or other distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table.

System and method for dynamic database split generation in a massively parallel or distributed database environment

A method for data processing includes identifying, for communication of a content object, a segment of entities based at least in part on a selection of a first attribute at a user interface. The first attribute may be selected from attributes defined by a data model and configured for a tenant of a multi-tenant system. The method further includes activating a set of attributes of the plurality of attributes based at least in part on the identified segment of entities and the data model. The method further includes, receiving a selection of a second attribute of the set of attributes, identifying, for the segment of entities, a set of inputs corresponding to the selected second attribute, and transmitting, to a content communication system for distribution of the content object, an indication of a plurality of entity identifiers corresponding to the segment of entities and the set of inputs.

Declarative segment attribute activation

In accordance with an embodiment, described herein are systems and methods for providing direct access to a sharded database. A shard director provides access by software client applications to database shards. A connection pool (e.g., a Universal Connection Pool, UCP) and database driver (e.g., a Java Database Connectivity, JDBC, component) can be configured to allow a client application to provide a shard key, either during connection checkout or at a later time; recognize shard keys specified by the client application; and enable connection by the client application to a particular shard or chunk. The approach enables efficient re-use of connection resources, and faster access to appropriate shards.

System and method for providing direct access to a sharded database

A system and method is described for database split generation in a massively parallel or distributed database environment including a plurality of databases and a data warehouse layer providing data summarization and querying functionality. A database table accessor of the system obtains, from an associated client application, a query for data in a table of the data warehouse layer, wherein the query includes a user preference. The system obtains table data representative of properties of the table, and determines a splits generator in accordance with one or more of the user preference or the properties of the table. The system generates, by the selected splits generator, table splits dividing the user query into a plurality of query splits, and outputs the plurality of query splits to an associated plurality of mappers for execution by the associated plurality of mappers of each of the plurality of query splits against the table.

System and method for generating size-based splits in a massively parallel or distributed database environment

In accordance with an embodiment, the system enables access to a sharded database using a cache and a shard topology. A shard-aware client application connecting to a sharded database can use a connection pool (e.g., a Universal Connection Pool, UCP), to store or access connections to different shards or chunks of the sharded database within a shared pool. As new connections are created, a shard topology layer can be built at the database driver layer, which learns and caches shard key ranges to locations of shards. The shard topology layer enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk.

System and method for providing access to a sharded database using a cache and a shard technology

A method for data processing includes identifying, for communication of a content object, a segment of entities including entities of a first entity class of a plurality of entity classes defined by a data model that is configured for a tenant of a multi-tenant system, where the data model defines relationships between entity classes of the plurality of entity classes. The method may further include activating for selection at a user interface at least one second entity class that is related to the first entity class based on the relationships and identifying a set of additional entities of the second entity class from the remaining entities that are related to the segment of entities as defined by the data model. The method may include transmitting to a content communication system an indication of the plurality of entity identifiers corresponding to a modified segment of entities that includes the additional entities.

Segment activation on related entities

In accordance with an embodiment, described herein is a system and method for use of immutable accessors with dynamic byte arrays. In accordance with an embodiment, a database driver provides access by software applications executing at an application server to data at a database, including associating a result set cache manager with a pool of result set caches. Each result set cache can be associated with one or more immutable accessors. In response to receiving a request from an application, to access a set of data, the set of data from the database is received into a particular result set cache. In response to receiving a subsequent request for a same set of data, from a same or another application using a same or another database connection, access is provided to the immutable accessor associated with the particular result set cache, for use in accessing the data therein.

System and method for use of immutable accessors with dynamic byte arrays

System and method for consistent reads between tasks in a massively parallel or distributed database environment

Growing community of inventors

Fremont, CA, United States of America

Ashok Shivarudraiah