Search

Susan Marie Kotsovolos

from Mountain View, CA
Age ~59

Susan Kotsovolos Phones & Addresses

  • Mountain View, CA
  • 1319 Eaton Ave, San Carlos, CA 94070 (650) 593-3114
  • 1541 Laurel St, San Carlos, CA 94070
  • 1717 Valley View Ave, Belmont, CA 94002 (650) 593-3114 (650) 593-4920
  • San Francisco, CA
  • San Mateo, CA
  • 1319 Eaton Ave, San Carlos, CA 94070 (650) 704-6022

Work

Company: Oracle 1993 to 2010 Position: Director

Interests

Cooking • Exercise • Electronics • Investing • Home Improvement • Reading • Crafts • Gourmet Cooking • Music • Automobiles • Movies • Collecting • Home Decoration

Emails

Industries

Computer Software

Resumes

Resumes

Susan Kotsovolos Photo 1

Susan Kotsovolos

View page
Location:
1319 Eaton Ave, San Carlos, CA 94070
Industry:
Computer Software
Work:
Oracle 1993 - 2010
Director

Versant Object Tech 1992 - 1993
Software Engineer

Object Systems 1988 - 1992
Software Engineer
Interests:
Cooking
Exercise
Electronics
Investing
Home Improvement
Reading
Crafts
Gourmet Cooking
Music
Automobiles
Movies
Collecting
Home Decoration

Publications

Us Patents

Techniques For Efficient Integration Of Text Searching With Queries Over Xml Data

View page
US Patent:
7305414, Dec 4, 2007
Filed:
Apr 5, 2005
Appl. No.:
11/099918
Inventors:
Anand Manikutty - Foster City CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
James Warner - Mountain View CA, US
Rohan Angrish - Redwood City CA, US
Vikas Arora - San Francisco CA, US
Susan Kotsovolos - San Carlos CA, US
Ravi Murthy - Fremont CA, US
Wesley Lin - West Covina CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707102
Abstract:
A method and apparatus for rewriting a database command containing an embedded XML expression such that the rewritten database command recites a text function, in lieu of the embedded XML expression, is provided. Advantageously, a DBMS may take advantage of the efficiencies in storing XML data within the database, while avoiding the generation of unnecessary XML elements in processing the query when the XML elements contribute nothing to the outcome of the query. Cost-base or rule-based analysis may be performed to determine how to rewrite a received database command. The database server may functionally evaluate the text function or may use an index defined on a column of the database. The text function may function as a primary filter or may reference a column upon which an index is defined, wherein the index operates at the same or higher level than a column being referenced in the embedded XML expression.

Techniques For Partial Rewrite Of Xpath Queries In A Relational Database

View page
US Patent:
7386568, Jun 10, 2008
Filed:
Nov 8, 2004
Appl. No.:
10/984471
Inventors:
James W. Warner - Mountain View CA, US
Zhen Hua Liu - San Mateo CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Anand Manikutty - Foster City CA, US
Rohan Angrish - Redwood City CA, US
Vikas Arora - San Francisco CA, US
Susan M. Kotsovolos - San Carlos CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707102
Abstract:
Techniques are described for executing queries that have XPath sections that specify unmappable paths. The techniques involve splitting the unmappable paths into (1) a mappable path fragment, and (2) an unmappable path fragment. After an unmappable path has been split into a mappable path fragment and an unmappable path fragment, the XPath section is replaced with a replacement XPath section. The replacement XPath section specifies two operations: a “mappable operation” that is based on the mappable path fragment, and an “unmappable operation” that is based on the unmappable path fragment. The portion of the replacement XPath section that specifies the mappable operation is rewritten to access underlying relational structures. Consequently, when the rewritten query is executed, a smaller amount of XML data needs to be materialized to evaluate the unmappable path fragment than would otherwise have been required to evaluate the original unmappable path.

Query Duration Types

View page
US Patent:
7512599, Mar 31, 2009
Filed:
Jan 29, 2004
Appl. No.:
10/767501
Inventors:
Qin Yu - San Mateo CA, US
Adiel M. Yoaz - Foster City CA, US
Subramanian Muralidhar - Fremont CA, US
Visar Nimani - Redwood City CA, US
Susan Kotsovolos - San Carlos CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 7/00
G06F 17/30
US Classification:
707 4, 707 3, 707102
Abstract:
A request to execute a query is received in a database system. In response, the database system determines that a collection of data elements to be returned by the query corresponds to a first data structure not defined within a type dictionary of the database system. The database system obtains attribute values that describe respective data fields within the first data structure, and records, within the type dictionary, a first data type definition that specifies the data fields described by the attribute values.

Efficient Evaluation Of Queries Using Translation

View page
US Patent:
7516121, Apr 7, 2009
Filed:
Sep 22, 2004
Appl. No.:
10/948523
Inventors:
Zhen Hua Liu - San Mateo CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Anand Manikutty - Foster City CA, US
James Warner - Mountain View CA, US
Hui X. Zhang - Fremont CA, US
Vikas Arora - San Francisco CA, US
Susan M. Kotsovolos - San Carlos CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707 3, 707 2, 707 4
Abstract:
Techniques are provided for processing a query including receiving the query, where the query specifies certain operations; determining that the query includes a first portion in a first query language and a second portion in a second query language; generating a first in-memory representation for the first portion; generating a second in-memory representation for the second portion; generating a third in-memory representation of the query based on the first in-memory representation and the second in-memory representation; and performing the certain operations based on the third in-memory representation.

Techniques For Efficiently Storing And Querying In A Relational Database, Xml Documents Conforming To Schemas That Contain Cyclic Constructs

View page
US Patent:
7523131, Apr 21, 2009
Filed:
Feb 10, 2005
Appl. No.:
11/056312
Inventors:
James W. Warner - Mountain View CA, US
Abhyudaya Agrawal - San Francisco CA, US
Hui Zhang - Fremont CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Ravi Murthy - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Nipun Agarwal - Santa Clara CA, US
Vikas Arora - San Francisco CA, US
Susan M. Kotsovolos - San Carlos CA, US
Anand Manikutty - Foster City CA, US
Rohan Angrish - Redwood City CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/00
US Classification:
707102, 707 4, 715234
Abstract:
To associate XML data objects (“child objects”), stored in rows of relational or object-relational tables, with the appropriate XML data objects (“parent objects”) from which the child objects descend, tables that contain child objects (“out-of-line” tables) are constructed with an additional column. In one embodiment, this column stores values that identify the root objects, in the appropriate table, from which the respective child objects descend. Hence, the root object from which any given object descends is traceable by following the respective value back to the corresponding root object. In one embodiment, this column stores values that identify the complete XML hierarchical path, through multiple tables, back to the root object from which the respective child objects descend. Consequently, XML query language queries against XML documents stored in such tables can be rewritten as SQL queries against the data in the tables, even in the presence of cyclic constructs.

Migrating Temporary Data Of A Session

View page
US Patent:
7634512, Dec 15, 2009
Filed:
Apr 4, 2007
Appl. No.:
11/732844
Inventors:
Yujie Cao - Redwood Shores CA, US
Tugrul Bingol - Foster City CA, US
Geeta Arora - Union City CA, US
Harmeek Singh Bedi - Foster City CA, US
Susan M. Kotsovolos - San Carlos CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707202, 707203, 713182
Abstract:
A technique for migrating (e. g. , “copying” or “moving”) temporary data from one session to another session is provided. While executing a workload associated with a particular session, session state is created. A subset of the session state comprises large objects that are referred to as “temporary data. ” Thus, temporary data is stored in a database (instead of in the database server) and is normally deleted when the particular session is deleted. To avoid this deletion when the session state is migrated to a different session, the temporary data, in one embodiment, is saved in an external storage that is separate from the database. An external table is created in the external storage and stores the temporary data. Location information to access the external table is provided to the other session.

Techniques Of Efficient Xml Meta-Data Query Using Xml Table Index

View page
US Patent:
7644066, Jan 5, 2010
Filed:
Mar 31, 2006
Appl. No.:
11/394878
Inventors:
Muralidhar Krishnaprasad - Fremont CA, US
Zhen Hua Liu - San Mateo CA, US
Hui Joe Chang - Fremont CA, US
Vikas Arora - San Francisco CA, US
Susan M. Kotsovolos - San Carlos CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707 3
Abstract:
XML table indexes provide a more efficient mechanism for searching data stored in aggregate form. XML table indexes are a set of tables created to project out in column form commonly sought metadata from stored XML documents. By projecting the data includes into column form, queries on the XML documents can be efficiently processed as they can leverage the enhanced functionality provided by the database tables. The XML table indexes may use aliases, partitioning, constraints and other functions to further improve query flexibility and performance.

Processing Queries Against One Or More Markup Language Sources

View page
US Patent:
7668806, Feb 23, 2010
Filed:
Sep 22, 2004
Appl. No.:
10/948536
Inventors:
Zhen Hua Liu - San Mateo CA, US
Muralidhar Krishnaprasad - Fremont CA, US
Anand Manikutty - Foster City CA, US
James Warner - Mountain View CA, US
Qin Yu - Belmont CA, US
Hui X. Zhang - Fremont CA, US
Karuna Muthiah - Redwood City CA, US
Ying Lu - Sunnyvale CA, US
Vikas Arora - San Francisco CA, US
Susan M. Kotsovolos - San Carlos CA, US
Assignee:
Oracle International Corporation - Redwood Shores CA
International Classification:
G06F 17/30
US Classification:
707 3, 707 4, 707 10, 707102, 70710401, 707200
Abstract:
Techniques are provided for processing a query, including receiving the query, where the query specifies certain operations to be performed, including (a) a first set of one or more operations that are to be performed on a markup language data source and (b) a second set of one or more operations that are to be performed on a second data source. Then it is determined that a first server that manages the markup language data source is capable of performing the first set of operations. A request is sent to the first server to perform the first set of operations. A response is received, where the response contains results of performing the first set of operations on the markup language data source. Finally, results are generated for the query based at least in part on the results of performing the first set of operations.
Susan Marie Kotsovolos from Mountain View, CA, age ~59 Get Report