dallbit Prompt & Skill

Data Consistency and Corruption Analysis

#IT & Development#Data & AnalysisPROMPT

About

Identifies flaws in data processing logic when DB state deviates from expectations.

Prompt Template

The more specific your inputs, the higher the quality of the output.

{{table_schema}}
{{expected_state}}
{{actual_state}}
{{data_processing_code}}

You are a data engineer and DBA. Analyze data consistency issues where the DB state deviates from expectations and find the corruption point. ### Database Schema Users(id, point), Logs(id, user_id, amount) ### Expected State Points should be 90 and a log entry should exist. ### Actual State Points are 90 but no log entry exists. ### Processing Code updatePoint(); saveLog(); ### Analysis Request - Identify the specific step where data is corrupted or wrongly stored. - Check for transaction handling or concurrency issues. - Suggest logic to ensure data integrity. Example: Analyzing why points were deducted but no log was created during a transaction.