Mark R Theissen

US Patent:

20050251535, Nov 10, 2005

Filed:

May 4, 2004

Appl. No.:

10/838967

Inventors:

Mark Theissen - Orange CA, US
Robert Kirner - El Segundo CA, US
Lawrence White - Santa Monica CA, US
Andrew Atwal - Redondo Beach CA, US
Jesus Ortiz - Culver City CA, US

Assignee:

Accruent, Inc. - Santa Monica CA

International Classification:

G06F012/00

US Classification:

707200000

Abstract:

A scaleable abstraction control solution including an abstraction process and an abstraction system. The abstraction solution permits extraction, tracking, and management of data defined in one or more documents. The abstraction process can include double blind data abstraction. The abstracted data can be verified using a quality assurance process that can include statistical sampling, tracked random error insertion, and abstraction auditing. Data from documents can be abstracted into one or more customizable databases, forms, templates, or software.

US Patent:

20130086039, Apr 4, 2013

Filed:

Sep 28, 2012

Appl. No.:

13/631718

Inventors:

Brian Christopher Jew - Laguna Hills CA, US
Mark Robert Theissen - Orange CA, US

Assignee:

CIRRO, INC. - San Juan Capistrano CA

International Classification:

G06F 17/30

US Classification:

707717, 707E17131

Abstract:

The subject technology provides configurations for receiving a query for data stored across data systems in which the query is associated with a user. It is determined if the user has permission to execute an operation from the query at a data in which the operation is executed upon at least one table provided by the data system. The subject technology determines if the operation corresponds to a cache object in a cache registry if the user has permission. Each cache object is owned by a cache manager user. A view associated with the user is created that provides temporary access privileges to the cache object corresponding to the operation in which the cache object includes results of the operation executed in the query and the cache object is owned by the cache manager user. The results of the operation are then provided in the created view to the user.

US Patent:

20130086064, Apr 4, 2013

Filed:

Sep 28, 2012

Appl. No.:

13/631502

Inventors:

Brian Christopher JEW - Laguna Hills CA, US
Mark Robert THEISSEN - Orange CA, US

Assignee:

CIRRO, INC. - San Juan Capistrano CA

International Classification:

G06F 17/30

US Classification:

707736, 707E17122, 707E17014

Abstract:

A computer-implemented method for exploring external data sources includes selecting a first function from a function library in a spreadsheet application based on a first user input, designating a first data source for the first function based on a second user input, wherein the first data source comprises a first dataset stored externally to the spreadsheet application, and arranging a first cell formula comprising the first function and a first identifier for the first data source in a first cell of a spreadsheet. The method further includes selecting an output function from the function library based on a third user input, designating a source function's reference based on a fourth user input, designating an output location in the spreadsheet based on a firth user input, and arranging a second cell formula including the selected output function, the designated source function's reference and the designated output location in a second cell of the spreadsheet. The method further includes translating the first cell formula contained in the first cell referenced as the source function to the output function into a data query for a data engine in response to a refresh action and sending the data query to the data engine, wherein the data engine is configured to execute the data query against the first dataset.

US Patent:

20130091122, Apr 11, 2013

Filed:

Sep 28, 2012

Appl. No.:

13/631707

Inventors:

Brian Christopher Jew - Laguna Hills CA, US
Mark Robert Theissen - Orange CA, US

Assignee:

CIRRO, INC. - San Juan Capistrano CA

International Classification:

G06F 17/30

US Classification:

707718

Abstract:

The subject technology provides querying structured and unstructured data across disparate incompatible systems with a single language and connection point. Cost based optimizations are provided for executing the query. In some configurations, logical plans for executing a query are generated. For each of the logical plans, the subject technology generates a set of physical plans for executing the query on data systems, determines an execution cost for each physical plan from the physical plans, and selects a respective physical plan with a lowest determined execution cost among the determined execution cost for each physical plan. A physical plan is then selected for execution with a lowest execution cost among the selected respective physical plans of each of the logical plans. Data from an operation from the query may then be persisted and then used for generating a new set of logical and physical plans for executing a remaining set of operations from the query.