CWE-1049: Excessive Data Query Operations in a Large Data Table

BaseIncomplete

The product performs a data query with a large number of joins and sub-queries on a large data table.

View on MITRE
Back to CWE Lookup

Extended Description

While the interpretation of "large data table" and "large number of joins or sub-queries" may vary for each product or developer, CISQ recommends a default of 1 million rows for a "large" data table, a default minimum of 5 joins, and a default minimum of 3 sub-queries.

Technical Details

Structure
Simple
Vulnerability Mapping
ALLOWED

Applicable To

Languages
Not Language-Specific
Platforms

Source-backed guidance

Additional facts reviewed against primary or authoritative security sources.

Detect imprecise mappings involving CWE-1049

Review mappings to CWE-1049, Excessive Data Query Operations in a Large Data Table, with MITRE's mapping and navigation criteria. Flag any selection that points to a View or Category, remains at a higher abstraction than the available evidence supports, or ignores relevant parent, child, peer, and alternative entries. Treat those findings as mapping-quality defects, correct them before publication, and retain the comparison trail for repeatable audits.

CWE Mapping and Navigation GuidanceMITRE CWE

Prevent CWE-1049 through an SSDF control plan

Use NIST SSDF practices to make prevention of CWE-1049, Excessive Data Query Operations in a Large Data Table, an explicit development outcome. Translate the CWE definition into security requirements and design constraints, choose safer implementation patterns and toolchain checks, and define acceptance evidence before release. Feed every confirmed occurrence back into the requirements, design review, and coding rules so the same root cause is removed across the product rather than patched in one location.

NIST SP 800-218 Secure Software Development FrameworkNational Institute of Standards and Technology

Triage CWE-1049 against known exploitation evidence

Use CISA's Known Exploited Vulnerabilities catalog to test whether a vulnerability mapped to CWE-1049, Excessive Data Query Operations in a Large Data Table, has evidence of exploitation in the wild. Confirm the CVE-to-CWE root-cause mapping independently before attaching the example, then capture the affected product, required action, and remediation deadline. A missing KEV match is not evidence that the weakness is unexploited, and a KEV entry must not be generalized to every occurrence of this CWE.

Known Exploited Vulnerabilities CatalogCybersecurity and Infrastructure Security Agency

Validate CWE-1049 with root-cause mapping checks

Apply MITRE's root-cause mapping quick tips to CWE-1049, Excessive Data Query Operations in a Large Data Table. Confirm the finding describes the causal weakness rather than an impact or attack pattern, compare the abstraction and mapping notes with plausible alternatives, and have a second reviewer challenge the selection. Preserve the evidence and reasoning so recurring defects can be measured against one consistent identifier.

CVE to CWE Root Cause Mapping Quick TipsMITRE CWE

Frequently Asked Questions

What is CWE-1049: Excessive Data Query Operations in a Large Data Table?+

CWE-1049: Excessive Data Query Operations in a Large Data Table is a Common Weakness Enumeration (CWE) entry maintained by MITRE. The product performs a data query with a large number of joins and sub-queries on a large data table. While the interpretation of "large data table" and "large number of joins or sub-queries" may vary for each product or developer, CISQ recommends a default of 1 million rows for a "large" data table, a default minimum of 5 joins, and a default minimum of 3 sub-queries.

What are the security consequences of Excessive Data Query Operations in a Large Data Table?+

If exploited, CWE-1049 (Excessive Data Query Operations in a Large Data Table) it can compromise Other, leading to outcomes such as Reduce Performance.

Which programming languages are affected by Excessive Data Query Operations in a Large Data Table?+

CWE-1049 commonly affects Not Language-Specific. Note that weaknesses are often language-agnostic patterns, so secure coding practices apply broadly.

What is the difference between a CWE and a CVE?+

A CWE (Common Weakness Enumeration) like CWE-1049 describes a category of software weakness — the underlying flaw type. A CVE (Common Vulnerabilities and Exposures) identifies a specific, real-world vulnerability in a particular product. In short, a CWE is the kind of mistake, and a CVE is an instance of that mistake being found in software.

Learn More

Advertisement