Patents by Inventor Janice Glowacki
Janice Glowacki has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 7680780Abstract: A method, system and article of manufacture for providing natural language support for users running queries against a multilingual database. One embodiment comprises identifying one or more physical values defined by physical data in the multilingual database for a query result associated with an executed query. At least one translation function configured to transform at least a portion of the identified physical values defined in one or more different natural languages into alternative values defined in a selected language is executed. From each executed translation function, a data structure mapping at least a portion of the identified physical values to translated values defined in the selected language is identified and the translated values defining the alternative values defined in the selected language are retrieved from each identified data structure. The query result associated with the executed query including the alternative values defined in the selected language is output.Type: GrantFiled: April 6, 2007Date of Patent: March 16, 2010Assignee: International Business Machines CorporationInventors: Richard D. Dettinger, Janice Glowacki, Frederick A. Kulack
-
Publication number: 20080249998Abstract: A method, system and article of manufacture for providing natural language support for users running queries against a multilingual database. One embodiment comprises identifying one or more physical values defined by physical data in the multilingual database for a query result associated with an executed query. At least one translation function configured to transform at least a portion of the identified physical values defined in one or more different natural languages into alternative values defined in a selected language is executed. From each executed translation function, a data structure mapping at least a portion of the identified physical values to translated values defined in the selected language is identified and the translated values defining the alternative values defined in the selected language are retrieved from each identified data structure. The query result associated with the executed query including the alternative values defined in the selected language is output.Type: ApplicationFiled: April 6, 2007Publication date: October 9, 2008Inventors: Richard D. Dettinger, Janice Glowacki, Frederick A. Kulack
-
Publication number: 20070276825Abstract: Embodiments of the present invention provide methods and systems for increasing the flexibility and reusability of parameterized queries. A user may be allowed to select and run a predefined query. If the query is a parameterized query, the user may be prompted to input one or more parameters. Embodiments of the invention allow the user to recommend a parameter that retrieves maximum or minimum results for the query instead of specifying a parameter. In response to such a user selection, a predefined parameter may be inserted as a parameter for the query. Alternatively, the query may be modified by changing or removing one or more query conditions to achieve the desired results.Type: ApplicationFiled: April 28, 2006Publication date: November 29, 2007Inventors: Richard Dettinger, Janice Glowacki, Daniel Kolz, Padma Rao, Marci Sperber, Shannon Wenzel
-
Publication number: 20070156668Abstract: Embodiments of the invention provide a mechanism for selecting an authorization filter to apply when executing a database query, based on the focus of the database query. Based on the focus specified for a given of the query, different conditions may be added during query processing to a database query. Doing so provides a flexible approach to managing data access requests where queries may focus on the same underlying data from many different perspectives.Type: ApplicationFiled: January 5, 2006Publication date: July 5, 2007Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Richard Dettinger, Janice Glowacki, Daniel Kolz
-
Publication number: 20070143245Abstract: A method, system and article of manufacture for managing presentation of query results. One embodiment comprises receiving, from a requesting entity, a query having at least (i) one result field for which data from one or more databases is to be returned, (ii) one or more conditions for filtering which of the data contained in the one or more databases is returned for each result field, and (iii) a conditions object defining at least one expression for at least one of the conditions. The query is executed against the one or more databases to obtain a query result having one or more data records. The query result is returned in a format relating the data records to respective expressions on the basis of which conditions the data records satisfy. Thereby, it is exposed which of the data records satisfy respective conditions having defined expressions in the conditions object.Type: ApplicationFiled: December 16, 2005Publication date: June 21, 2007Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Richard Dettinger, Janice Glowacki, Daniel Kolz, Padma Rao, Marci Sperber, Shannon Wenzel
-
Publication number: 20070083514Abstract: A method, system and article of manufacture for protecting sensitive data in databases and, more particularly, for managing access to sensitive data in a database. One embodiment comprises receiving a query against the data in the database comprising at least (i) a result field specification, and (ii) a sorting instruction. The method further comprises retrieving a result set from the database, and filtering the retrieved result set on the basis of predefined filtering rules to remove selected data from a selected result field of at least one data record included with the retrieved result set. The filtered result set is sorted according to the sorting instruction to produce the sorted result set, whereby the sorting is done independently of the removed selected data so that the sorted result set places the at least one data record at a position which is non-indicative of a value of the removed selected data.Type: ApplicationFiled: October 7, 2005Publication date: April 12, 2007Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Richard Dettinger, Janice Glowacki, Daniel Kolz, Padma Rao, Marci Sperber, Shannon Wenzel
-
Publication number: 20070027880Abstract: A method, system and article of manufacture for managing execution of queries against databases and more particularly for restricting access to sensitive data in underlying databases. One embodiment provides a method for managing access to sensitive data in a database. The method comprises receiving, from a requesting entity, a query against the data in the database. The query is executed against the database to obtain a result set. The method further comprises determining whether the result set includes sensitive data based on predefined sensitivity attributes associated with data in the result set. If so, a sensitivity rating is determined for the result set, and a predefined security action is preformed with respect to the result set on the basis of the determined sensitivity rating.Type: ApplicationFiled: July 28, 2005Publication date: February 1, 2007Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Richard Dettinger, Janice Glowacki, Daniel Kolz, Padma Rao, Marci Sperber, Shannon Wenzel
-
Publication number: 20060161528Abstract: Methods and a computer readable medium for updating query results are provided. In one embodiment, a stored query is modified to retrieve a selected subset of rows from stored query results without retrieving a remaining portion of the stored results. The modified query is executed, updated results are obtained from the modified query, and the updated results are displayed.Type: ApplicationFiled: January 20, 2005Publication date: July 20, 2006Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Richard Dettinger, Janice Glowacki
-
Publication number: 20060085437Abstract: A method, system and article of manufacture for managing relationships between database tables and, more particularly, for identifying and accurately describing relationships between tables in a database. One embodiment provides a method for identifying relationships between tables in a database. The method comprises receiving user input selecting a plurality of tables from the database. The plurality of tables is organized into a logical island defining a logical unit related to a particular logical entity. The method further comprises receiving user input identifying, for each of the plurality of tables, a table column containing information that identifies the particular logical entity in the table, whereby the identified table columns of different tables define logical relationships between the different tables in the logical island.Type: ApplicationFiled: October 14, 2004Publication date: April 20, 2006Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Mark Brodhun, Richard Dettinger, Janice Glowacki, Daniel Kolz