Database Activity Regulation via Human Verification

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Existing methods to prevent automated systems like web crawlers and bots from overwhelming database resources often interfere with legitimate user experiences, as they can be intrusive and degrade performance.

Innovation Solution

Implementing a system that sets usage rate limits for database activities based on monitoring periods and confidence intervals, requiring human verification only when excessive usage is detected, thereby allowing legitimate human activity while constraining automated systems.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Object-affected harmful factors

If existing techniques for preventing automated activity are implemented, then automated systems are discouraged, but legitimate user experience is degraded

Engineering Contradiction:
Improveautomated activity impactVSAvoiduser experience
Core Design Contradiction:
Object-affected harmful factorsVSEase of operation

Solution Approach 1:

The patent applies local quality by implementing differentiated rate limiting thresholds for different users and database activities. Legitimate users receive higher thresholds while automated systems are constrained by lower thresholds, allowing the system to treat different sources differently based on their actual behavior patterns rather than applying a uniform restriction

Inventive Principle:
Principle #3Local quality

Solution Approach 2:

The patent introduces an intermediary verification mechanism that acts as a mediator between rate limiting and user access. When usage patterns suggest automated activity, the system introduces verification challenges as an intermediary step to distinguish legitimate users from automated systems, rather than directly blocking access

Inventive Principle:
Principle #24Intermediary (Mediator)

2Productivity

If rate limiting is applied to all users, then automated systems are constrained, but legitimate user requests are also blocked

Engineering Contradiction:
Improvedatabase activity rate controlVSAvoidlegitimate access availability
Core Design Contradiction:
ProductivityVSReliability

Solution Approach 1:

The patent implements dynamic rate limiting thresholds that adjust based on user behavior patterns, historical data, and verification results. The system continuously adapts the allowed usage rates for different users and activities, allowing legitimate users to maintain high productivity while automatically constraining automated systems that exhibit suspicious patterns

Inventive Principle:
Principle #15Dynamics

Solution Approach 2:

The patent incorporates feedback mechanisms where the system monitors database activity patterns, user responses to verification challenges, and usage rate deviations. This feedback is used to dynamically adjust rate limiting thresholds and verification requirements, ensuring that legitimate users experience minimal disruption while automated systems are effectively constrained

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS9245145B2Methods and systems for regulating database activity
Publication Date: 2016.01.26 SALESFORCE INC
  • US9245145B2 patent drawing
  • US9245145B2 patent drawing
  • US9245145B2 patent drawing

AI summary

Methods and systems are provided for regulating access to a database by a server. One exemplary method involves the server receiving one or more requests for an activity with respect to the database and determining an attempted usage for the activity over a monitoring period by a source of the requests. When the attempted usage exceeds an allowed usage of the activity for the monitoring period, the server provides a human verification test to the source and thereafter initiates the activity with respect to the database in response to receiving a satisfactory human verification response to the human verification test from the source.