Kim Nguyen Hargett - Ramona CA, US Stephen A. Brobst - Henderson NV, US Pieter Lessing - Los Angeles CA, US William A. Matera - Farmingdale NJ, US Mark L. Crosby - Venice CA, US Lily W. Young - Escondido CA, US
Assignee:
NCR Corp. - Dayton OH
International Classification:
G06F 17/00
US Classification:
707100, 7071041
Abstract:
A logical data model (LDM) design methodology that utilizes common or shared subject areas, developed for applications across two or more industries, in the design and construction of data warehouse solutions and logical data models for specific customers. The development and use of shared subject areas provides for more effective new LDM development through re-use of common elements and quicker deployment of horizontal applications on all industries.
Database System Having A Service Level Goal Responsive Regulator
Douglas Brown - Rancho Santa Fe CA, US Stephen Brobst - Henderson NV, US Anita Richards - San Juan Capistrano CA, US Todd Walter - San Diego CA, US
Assignee:
Teradata US, Inc. - Dayton OH
International Classification:
G06F 9/46 G06F 7/00
US Classification:
718103, 707713, 707718, 707720
Abstract:
A database system includes a regulator subsystem that is configured to attempt to satisfy service level goals of multiple workloads that are executing in the database system. The regulator subsystem is configured to monitor execution of a particular request belonging to a particular workload and to assign, at plural event intervals, corresponding priority levels to the particular request based on the monitored execution.
Database System Having A Regulator That Performs Workload Regulation Based On Optimizer Estimates
Douglas Brown - Rancho Santa Fe CA, US Stephen Brobst - Henderson NV, US Anita Richards - San Juan Capistrano CA, US Todd Walter - San Diego CA, US
Assignee:
Teradota US, Inc. - Dayton OH
International Classification:
G06F 9/46 G06F 7/00
US Classification:
718103, 718104, 707718, 707719, 707720
Abstract:
A database system includes an optimizer to generate resource estimates regarding execution of a request in the database system, and a regulator to monitor execution of a request and to adjust a priority level of the request based on the monitored execution and based on the resource estimates provided by the optimizer.
Eliminating Inner Joins Based On A Temporal Relationship Constraint
Bhashyam Ramesh - Secunderabad, IN Stephen A. Brobst - Henderson NV, US
Assignee:
Teradata US, Inc. - Dayton OH
International Classification:
G06F 17/30 G06F 17/00
US Classification:
707609, 707802, 707803
Abstract:
A query is received. It is determined that the query includes an inner join between a parent table and a child table. It is determined that the following relationships exist between the parent table and the child table: referential integrity (“RI”) between a primary key attribute (pk) in the parent table and a foreign key attribute (fk) in the child table, where “attribute” is defined to mean one or more columns, and a temporal relationship constraint (“TRC”) between a period attribute in the parent table and a TRC-attribute in the child table, the TRC-attribute being a date or time attribute. It is determined that the query does not access any attribute in the parent table other than the pk. It is determined that the query specifies an equality predicate of the form pk=fk. It is determined that the query selects a snapshot from the parent using a predicate of the form parent.
A database-management system (DBMS) initiates execution of an incoming database query according to an initial query-execution plan that identifies an expected path for execution. Then, at some point after execution of the query has begun, the DBMS concludes that execution has not proceeded along the expected path and, in response, chooses an alternative query-execution plan for continued execution of the query.
Seamless Integration Between Object-Based Environments And Database Environments
Awny Al-Omari - Cedar Park TX, US Louis Benton Landry - Dayton OH, US Stephen Andrew Brobst - Las Vegas NV, US Donald Raymond Pederson - San Diego CA, US Todd Walter - Mississauga, CA Oliver Ratzesberger - Mississauga, CA
International Classification:
G06F 16/25 G06F 16/23 G06F 16/9038 G06F 9/54
Abstract:
An Application Programming Interface (API) processes object storage requests in an object storage format that are received from client applications. A mapper maps the object storage formatted requests into database statements and executes the statements within a database management system. Results returned from the statements are mapped by the mapper to object-storage constructs and provided to the API in object storage format. The object storage formatted requests are provided from the API to the client applications to satisfy the original client applications' requests.
Presidential Council of Advisors on Science and Technology Jun 2010 - Jul 2012
Networking and Information Technology R and D Working Group Member
Ehealthdirect Oct 1999 - Aug 2003
Technology Advisor
Sampo Technologies & Systems Oct 1999 - Aug 2003
Founder and Managing Partner
Tanning Technology Oct 1993 - Feb 2000
Co-Founder and Chief Technology Officer
Strategic Technologies & Systems Jun 1983 - Oct 1999
Founder and Managing Partner
Education:
Massachusetts Institute of Technology 1983 - 1993
Mit Sloan School of Management 1990 - 1992
University of California, Berkeley 1980 - 1983
Milpitas High School 1976 - 1980
Skills:
Data Warehousing Business Intelligence Big Data Enterprise Architecture Architecture Data Modeling Enterprise Software Analytics Etl Databases Data Warehouse Architecture It Strategy Architectures Agile Methodologies Cloud Computing Solution Architecture Business Development Crm Program Management Predictive Analytics Database Design Business Analysis Data Mining Software Project Management Sql Saas Master Data Management Data Integration Data Quality Professional Services Business Analytics Data Warehouse Pre Sales Performance Tuning Information Architecture Hadoop
Interests:
Volleyball Teaching International Travel Chess Photography Hiking Music Scrabble Science and Technology Ultimate Frisbee