Richard D. Dettinger

Bio: Richard D. Dettinger is an academic researcher from IBM. The author has contributed to research in topics: Query optimization & Sargable. The author has an hindex of 43, co-authored 255 publications receiving 5876 citations. Previous affiliations of Richard D. Dettinger include Airbnb.

Application portability and extensibility through database schema and query abstraction

Abstract: The present invention generally is directed to a system, method and article of manufacture for accessing data independent of the particular manner in which the data is physically represented. In one embodiment, a data repository abstraction layer provides a logical view of the underlying data repository that is independent of the particular manner of data representation. A query abstraction layer is also provided and is based on the data repository abstraction layer. A runtime component performs translation of an abstract query into a form that can be used against a particular physical data representation.

Secure database access through partial encryption

Abstract: The present invention generally is directed to systems, methods, and articles of manufacture for securing sensitive information involved in database transactions. Embodiments of the present invention selectively encrypt only portions of transactions involving sensitive data, thereby reducing or eliminating the processing overhead resulting from wastefully encrypting non-sensitive data. The sensitive data may be identified by a document. The document may be accessed by a requesting entity to determine which portions of a query should be encrypted prior to sending the query to a database server over a network. The document may also be accessed by a database server to determine which portions of query results should be encrypted prior to sending the query results to the requesting entity over the network.

Method and apparatus for managing instant messaging

Abstract: An instant messaging system having logic for managing IM messages and an intelligent queuing mechanism. One aspect of the present invention is a method for selectively filtering instant messages, comprising receiving an instant message and analyzing the instant message to generate a priority score. Another aspect of the present invention is a graphical user interface for an instant messaging application, comprising at least one visible conversation pane for displaying relatively higher priority conversations, and at least one minimized conversation pane representing relatively lower priority conversations to the at least one minimized conversation panel.

Graphical user interface for building queries with hierarchical conditions

Abstract: The present invention generally provides methods, systems and articles of manufacture for programmatically providing a user interface for creating queries. In one embodiment, graphical user interface content which defines a graphical user interface is provided. The graphical user interface comprises (i) a region for displaying conditions of a query; and (ii) a first graphical element for initiating a process of combining two or more conditions of the query together with logic values to form a complex condition. In another embodiment, the graphical user interface further comprises a second graphical element for initiating a process of separating two or more conditions of a complex condition.

Method and system for providing aggregate data access

Abstract: A method and apparatus for defining and processing aggregate data is disclosed. Using database abstraction techniques, a set of logical fields may be used to compose queries of a set of underlying physical data sources. In one embodiment, a logical field may represent an aggregate data value calculated from the elements appearing in a column of a relational table in an underlying physical data source. The elements may be divided into to subsets to calculate multiple aggregate values. An abstract derived entity is a data object present in a database abstraction model that may be accessed as though it were a relational table contained in an underlying physical data source. In one embodiment, columns of the table defined by the abstract derived entity may be populated with aggregate data values joined to other data as specified by a composition rule included in the definition of the abstract derived entity.

Mobile terminal and method for controlling the same

Abstract: A mobile terminal including a body; a touchscreen provided to a front and extending to side of the body and configured to display content; and a controller configured to detect one side of the body comes into contact with one side of an external terminal, display a first area on the touchscreen corresponding to a contact area of the body and the external terminal and a second area including the content, receive an input of moving the content displayed in the second area to the first area, display the content in the first area, and share the content in the first area with the external terminal.

Methods And Systems For Managing Data

Abstract: Systems and methods for managing data, such as metadata. In one exemplary method, metadata from files created by several different software applications are captured, and the captured metadata is searched. The type of information in metadata for one type of file differs from the type of information in metadata for another type of file. Other methods are described and data processing systems and machine readable media are also described.

Automated Generation of Dynamic Data Entry User Interface for Relational Database Management Systems

Abstract: Computer software for, computer apparatus for, and a method of automatically generating a user interface for a relational database comprising extracting schema information from the relational database and automatically generating corresponding schema and user interface metadata, storing the metadata in a repository, and automatically developing from the metadata a user interface appropriate to the relational database.

Method and Apparatus for Penetrating tissue

Abstract: A body fluid sampling system for use on a tissue site includes a single drive force generator. A plurality of penetrating members are operatively coupled to the force generator. The force generator moves each of the members along a path out of a housing with a penetrating member exit, into the tissue site, stops in the tissue site, and withdraws out of the tissue site. A flexible support member couples the penetrating members to define a linear array. The support member is movable and configured to move each of the penetrating members to a launch position associated with the force generator.

Custom entities and fields in a multi-tenant database system

Abstract: Systems and methods for hosting variable schema data such as dynamic tables and columns in a fixed physical database schema. Standard objects, such as tables are provided for use by multiple tenants or organizations in a multi-tenant database system. Each organization may add or define custom fields for inclusion in a standard object. Custom fields for multiple tenants are stored in a single field within the object data structure, and this single field may contain different data types for each tenant. Indexing columns are also provided, wherein a tenant may designate a field for indexing. Data values for designated fields are copied to an index column, and each index column may include multiple data types. Each organization may also define custom objects including custom fields and indexing columns. Custom objects for multiple tenants are stored in a single custom object data structure. The primary key values for the single custom object table are globally unique, but also include an object-specific identifier which may be re-used among different entities.