Back to results
US 2019/0172068 A1Published application
Method and system for implementing a crm quote and order capture context service
AssigneeOracle International Corporation
InventorsMark David LEWIS, Jianfeng TAI, David WANG, Ying WANG, Re LAI
Life of this patent
Estimating the term…
Abstract
Disclosed is an improved approach for implementing enterprise software systems that addresses the above-described problems with existing systems. The present approach provides an effective and efficient way for defining schemas for services, and to define how to map the schema to particular transactional contexts.
Claims27
A computer implemented method implemented with a processor, comprising:
- defining a canonical schema that pertains to declarative schema representations for an enterprise application, the canonical schema comprising a set of data objects in a database of general database transaction applicability mappable for a specific database transaction usage;
- implementing a user interface to map the canonical schema to a specific database transaction usage;
- mapping the canonical schema to the specific database transaction usage through a configuration of user interface portions in the user interface without software code being coded to configure the canonical schema, wherein mapping the canonical schema to the specific database transaction usage comprises:
- defining, for the specific database transaction usage, a subset of data objects within the set of data objects in the canonical schema;
- and
- defining, for the specific database transaction usage, how to query and update the subset of data objects in the database;
- and
- using the subset of the canonical schema as an input of the specific database transaction usage or an output of the specific database transaction usage by:
- identifying a group of declarative schema representations to map to the specific database transaction usage;
- identifying, for a declarative schema representation from among the group of declarative schema representations, the attributes that are required by the specific database transaction usage;
- determining whether an entity from the subset of data objects maps to a view object or a service;
- upon determination that the entity maps to the view object, performing, for the declarative schema representation from among the group of declarative schema representations, a single query to the view object specified in the mapping that dedupes search keys before executing the single query;
- and
- upon determination that the entity from the subset of data objects maps to a query service, executing, for the declarative schema representation from among the group of declarative schema representations, the query service conforming to a standard service interface defined by the input or the output of the specific database transaction usage specified in the mappings.
11 more elements
A computer program product embodied in a non-transitory computer readable medium, the computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute a method comprising:
- defining a canonical schema that pertains to declarative schema representations for an enterprise application, the canonical schema comprising a set of data objects in a database of general database transaction applicability mappable for a specific database transaction usage;
- implementing a user interface to map the canonical schema to a specific database transaction usage;
- mapping the canonical schema to the specific database transaction usage through a configuration of user interface portions in the user interface without software code being coded to configure the canonical schema, wherein mapping the canonical schema to the specific database transaction usage comprises:
- defining, for the specific database transaction usage, a subset of data objects within the set of data objects in the canonical schema;
- and
- defining, for the specific database transaction usage, how to query and update the subset of data objects in the database;
- and
- using the subset of the canonical schema as an input of the specific database transaction usage or an output of the specific database transaction usage by:
- identifying a group of declarative schema representations to map to the specific database transaction usage;
- identifying, for a declarative schema representation from among the group of declarative schema representations, the attributes that are required by the specific database transaction usage;
- determining whether an entity from the subset of data objects maps to a view object or a service;
- upon determination that the entity maps to the view object, performing, for the declarative schema representation from among the group of declarative schema representations, a single query to the view object specified in the mapping that dedupes search keys before executing the single query;
- and
- upon determination that the entity from the subset of data objects maps to a query service, executing, for the declarative schema representation from among the group of declarative schema representations, the query service conforming to a standard service interface defined by the input or the output of the specific database transaction usage specified in the mappings.
11 more elements
A system, comprising:
- a processor;
- and
- a memory comprising a computer code executed using the processor, in which the computer code implements:
- defining a canonical schema that pertains to declarative schema representations for an enterprise application, the canonical schema comprising a set of data objects in a database of general database transaction applicability mappable for a specific database transaction usage;
- implementing a user interface to map the canonical schema to a specific database transaction usage;
- mapping the canonical schema to the specific database transaction usage through a configuration of user interface portions in the user interface without software code being coded to configure the canonical schema, wherein mapping the canonical schema to the specific database transaction usage comprises:
- defining, for the specific database transaction usage, a subset of data objects within the set of data objects in the canonical schema;
- and
- defining, for the specific database transaction usage, how to query and update the subset of data objects in the database;
- and
- using the subset of the canonical schema as an input of the specific database transaction usage or an output of the specific database transaction usage by:
- identifying a group of declarative schema representations to map to the specific database transaction usage;
- identifying, for a declarative schema representation from among the group of declarative schema representations, the attributes that are required by the specific database transaction usage;
- determining whether an entity from the subset of data objects maps to a view object or a service;
- upon determination that the entity maps to the view object, performing, for the declarative schema representation from among the group of declarative schema representations, a single query to the view object specified in the mapping that dedupes search keys before executing the single query;
- and
- upon determination that the entity from the subset of data objects maps to a query service, executing, for the declarative schema representation from among the group of declarative schema representations, the query service conforming to a standard service interface defined by the input or the output of the specific database transaction usage specified in the mappings.
14 more elements
Dependencies are inferred from the claim text.