Oracle International Corporation

Allison Waingold

Aman Namait

Andrew Witkowski

Mohamed Zait

Rafi Ahmed

Bhaskar Ghosh

Dinesh Das

Martin Roth

Xin Jiang

John S Kowtko

Max Schireson

Techniques are provided for delaying evaluation of expensive expressions in a query. Expensive expressions in the query are established by cost information or by looking up a list of known expensive expressions for a match. After an execution plan is determined by using the early evaluation technique, one or more equivalent execution plans is established. The one or more equivalent execution plans may include both a type of execution plans that delay evaluation of expensive expressions and a type of execution plans that do not. In addition, the one or more equivalent execution plans may include both parallelized and non-parallelized alternatives to the execution plan identified by the early evaluation technique. Finally, based on a set of criteria, which may include comparing cost information among all the equivalent execution plans generated thus far, the best execution plan is chosen for the query.

Delaying evaluation of expensive expressions in a query

A method of and system for evaluating contacts stored in data source. In one embodiment the method allows a user to define a data format; allows a user to define a plurality of rules intended to operate on and assess a quality of data formatted according to the data format; map data identifying a plurality of contacts from the data source to the data format; and execute the plurality of rules on the mapped data to produce a set of analyzed data that allows evaluation of potential contacts according to an assessed quality of the data.

Data quality analyzer

A method and system automatically creates and operates a web application from a spreadsheet without the need for specialized programming. The web application includes a guided data entry process created from spreadsheet worksheets. The web application interfaces with a database application, so that model data may be retrieved for analysis. The web application implements the model as a calculator data defining the relationships between the model values. A rendering data defines the appearance of the model values in the web application. A instance data includes the model values for an instance of the web application. A calculation engine calculates model values. A layout engine creates display information from the calculator, rendering, and instance data set. The rendering data includes objects having display methods for creating display information in accordance with its object type. Object types include inputs, outputs, and user interface elements.

Web application generator for spreadsheet calculators

Users can create computational models in a spreadsheet application and automatically apply the model to data stored in a relational database. By importing a sample of the data from a database table into the spreadsheet application, users can build spreadsheet models that perform analysis and computations on the sample data. Once the model is complete, the spreadsheet model is translated into an SQL format model understood by the database. The SQL model can operate on the entire data set in the database, rather than just the sample data used to construct the model. The SQL model and its associated data are stored in the database, and the model can be executed on a different sets of data. A web browser based front-end allows model users to access the SQL model via a web browser, eliminating the need for model users to have a spreadsheet application.

Spreadsheet to SQL translation

Growing community of inventors

Sunnyvale, CA, United States of America

Allison Waingold