Model-driven desktop integration framework

• US 9,772,987 B2
• Filed: 07/16/2014
• Issued: 09/26/2017
• Est. Priority Date: 09/20/2013
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Davis, Edmund Alexander, Bafuka, Freddy Nole, Logan, Shaun, Jin, Yuandi, Rowles, Brian
• Primary Examiner(s): Baderman, Scott
• Assistant Examiner(s): Level, Barbara
• Application Number:
  US14/333,105
• Publication Number:
  US 20150089350A1
• Time in Patent Office: 1,168 Days
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: G06F 16/90324 using system suggestions
• CPC Class Codes: G06F 3/04817 using icons graphical or visual programming using iconic symbols G06F8/34
• CPC Class Codes: G06F 3/0484 for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers working within desktop applications to create application-specific documents that integrate with web-based applications. Using a desktop integration framework, a developer can design documents having components that provide user interfaces to data associated with data models of the web-based applications. In one aspect, how a component looks and is configured can be dynamically driven at runtime based on metadata of its underlying data model.

Claims

1. A non-transitory computer-readable medium storing code that when executed by one or more processors associated with one or more computer systems configures the one or more processors for creating documents of desktop applications that act as user interfaces for web-based applications, the non-transitory computer-readable medium comprising:

code for selecting a document, wherein the document is selected from a web-based application, and wherein the document provides an interface to data provided by the web-based application, wherein contents of the document are configured to be rendered in a native application format associated with an application that includes or is in communication with a client side component of an enterprise application executed within an application development framework designed by the application development framework to include a view layer and a controller layer;

code for associating a user interface element with a portion of the contents of the document using the view layer and the controller layer, wherein the user interface element is a component of the application development framework and the portion of the contents of the document is linked with data associated with data models provided by the web-based application in communication with a server, side component of the application development framework designed by the application development framework to include a model layer;

code for mapping the user interface element to one or more of the data models provided by the web-based application, wherein the model layer exposes the data models to the view layer and controller layer such that the user interface element contributes at least a portion of data associated with the one or more data models provided by the web-based application to a user interface within the application, and wherein the user interface element contributes to the user interface at runtime based on the one or more data models;

code for generating metadata associated with the document based on the associating of the user interface element with the portion of the contents of the document and the mapping of the user interface element to the one or more data models provided by the web-based application and

code for initializing the document in the application with the user interface and the user interface element using the view layer, the controller layer, the model layer, and the metadata at runtime.

2. The non-transitory computer-readable medium of claim 1 wherein the code for mapping the user interface element to the one or more data models provided by the web-based application comprises code for configuring the user interface element to provide a corresponding view of the data based on a type of the data determined at runtime.

3. The non-transitory computer-readable medium of claim 1 wherein the code for mapping the user interface element to the one or more data models provided by the web-based application comprises code for configuring the user interface element with specific functionality allowing a user to interact with the data based on one or more aspects of the data determined at runtime.

4. The non-transitory computer-readable medium of claim 1 wherein the code for mapping the user interface element to the one or more data models provided by the web-based application comprises code for configuring the user interface element to provide a list of values derived from an entity modeled by the one or more data models at runtime.

5. The non-transitory computer-readable medium of claim 1 wherein the code for mapping the user interface element to the one or more data models provided by the web-based application comprises code for configuring the user interface element to provide a search interface enabling a user to search within a list of values derived from an entity modeled by the one or more data models at runtime.

6. The non-transitory computer-readable medium of claim 1 wherein the code for associating the user interface element with the portion of the contents of the document comprises code for associating a text box, label, button, list, table, radio button, checkbox, input widget, or output widget.

7. The non-transitory computer-readable medium of claim 1 wherein the code for creating the contents of the document in the native application format associated with the first application comprises code for creating a spreadsheet using a spreadsheet desktop application.

8. The non-transitory computer-readable medium of claim 1 wherein the code for creating the contents of the document in the native application format associated with the first application comprises code for creating a word processing document using a desktop publishing application.

9. The non-transitory computer-readable medium of claim 1 further comprising:

code for publishing the document and the metadata associated with the document to the web-based application such that the document becomes usable as a user interface to the web-based application.

10. The non-transitory computer-readable medium of claim 1 further comprising:

code for retrieving the document from the web-based application; and

code for rendering the document based on the document and the metadata associated with the document at runtime to determine how the user interface element contributes to the user interface.

11. The non-transitory computer-readable medium of claim 10 wherein the code for rendering the document comprises code for generating functionality that displays an interface in response to a user interaction that allows a user to select one or more values determined at runtime and that inputs a selection into the contents of the document.

12. The non-transitory computer-readable medium of claim 1 further comprising:

code for receiving a modification to the document in the portion of data contributed by the user interface element; and

code for updating the web-based application using the second application to reflect the modification.

13. A method comprising:

selecting, by a computer system, a document, wherein the document is selected from a web-based application, and wherein the document provides an interface to data provided by the web-based application, wherein contents of the document are configured to be rendered in a native application format associated with an application that includes or is in communication with a client side component of an enterprise application executed within an application development framework designed by the application development framework to include a view layer and a controller layer;

associating, by the computer system, a user interface element with a portion of the contents of the document using the view layer and the controller layer, wherein the user interface element is a component of the application development framework and the portion of the contents of the document is linked with data associated with data models provided by the web-based application in communication with a server side component of the application development framework designed by the application development framework to include a model layer;

mapping, by the computer system, the user interface element to one or more of the data models provided by a the web-based application, wherein the model layer exposes the data models to the view layer and controller layer such that the user interface element contributes at least a portion of data associated with the one or more data models provided by the web-based application to a user interface within the application, and wherein the user interface element contributes to the user interface at runtime based on the one or more data models;

generating, by the computer system, metadata associated with the document based on the associating of the user interface element with the portion of the contents of the document and the mapping of the user interface element to the one or more data models provided by the web-based application; and

initializing, by the computing system, the document in the application with the user interface and the user interface element using the view layer, the controller layer, the model layer, and the metadata at runtime.

14. A system comprising:

a processor; and

a memory storing a set of instructions which when execute by the processor configure the processor to;

select a document, wherein the document is selected from a web-based application, and wherein the document provides an interface to data provided by the web-based application, wherein contents of the document are configured to be rendered in a native application format associated with an application that includes or is in communication with a client side component of an enterprise application executed within an application development framework designed by the application development framework to include a view layer and a controller layer;

associate a user interface element with a portion of the contents of the document using the view layer and the controller layer, wherein the user interface element is a component of the application development framework and the portion of the contents of the document is linked with and data associated with data models provided by the web-based application in communication with a server side component of the application development framework designed by the application development framework to include a model layer;

map the user interface element to one or more of the data models provided by a the web-based application, wherein the model layer exposes the data models to the view layer and controller layer such that the user interface element contributes at least a portion of data associated with the one or more data models provided by the web-based application to a user interface within the application, and wherein the user interface element contributes to the user interface at runtime based on the one or more data models;

generate metadata associated with the document based on the associating of the user interface element with the portion of the contents of the document and the mapping of the user interface element to the one or more data models provided by the web-based application; and

initialize the document in the application with the user interface and the user interface element using the view layer, the controller layer, the model layer, and the metadata at runtime.