TABLE OF CONTENTS
CHAPTER NO TITLE PAGE NO.
BONAFIDE CERTIFICATE II
ACKNOWLEDGEMENT III
SYNOPSIS IV
TABLE OF CONTENTS V
1 INTRODUCTION 1
1.1 DESCRIPTION
1.2 EXISTING SYSTEM
1.3 PROBLEM DEFINITION
1.4 PROPOSED SYSTEM
1.5 ORGANIZATION OF THE PROJECT
2 LITERATURE REVIEW 4
2.1 NATURAL LANGUAGE TO SQL GENERATION 4
2.1.1 DESCRIPTION
2.1.2 MERIT
2.1.3 DEMERIT
2.2 FEW-SHOT LEARNING FOR TEXT-TO-SQL 5
2.2.1 DESCRIPTION
2.2.2 MERIT
2.2.3 DEMERIT
V
2.3 DYNAMIC TABLE SELECTION 5
2.3.1 DESCRIPTION
2.3.2 MERIT
2.3.3 DEMERIT
2.4 PROMPT OPTIMIZATION 6
2.4.1 DESCRIPTION
2.4.2 MERIT
2.4.3 DEMERIT
2.5 QUERY REPHRASING USING LLMs 7
2.5.1 DESCRIPTION
2.5.2 MERIT
2.5.3 DEMERIT
2.6 LANGCHAIN MEMORY FOR CONTEXT 8
RETENTION
2.4.1 DESCRIPTION
2.4.2 MERIT
2.4.3 DEMERIT
3 SYSTEM SPECIFICATION 9
3.1 SYSTEM REQUIREMENTS 9
3.1.1 HARDWARE REQUIREMENTS
3.2 SOFTWARE REQUIREMENTS 9
3.2.1 PACKAGES USED
4 METHODOLOGY 13
4.1 METHOD USED
4.2 ARCHITECTURE DESCRIPTION
4.3 MODULE DESCRIPTION
4.4 MODEL BUILDING
4.5 TRAINING
4.6 TESTING AND EVALUATION
4.7 TOOLS AND TECHNOLOGIES
4.8 DATASETS USED
5 IMPLEMENTATION AND RESULTS 21
5.1 IMPLEMENTATION 21
5.1.1 REQUIREMENTS
5.1.2 BACKEND IMPLEMENTATION CODE
5.1.3 FRONTEND IMPLEMENTATION CODE
5.2 OUTPUT 27
6 CONCLUSION 29
6.1 CONCLUSION
7 REFERENCES 30