Table of Contents

Section Page
From the Author3
Preface4
Introduction7
What You Will Get Out of This Book13
Table of Contentsi
Chapter 1 — Foundations of Corporate Intelligence1
1.010 Why Organizations Lose Knowledge1
1.020 Introduction to the Corporate Intelligence System4
1.030 What This Platform Delivers9
1.040 Why AI Answers Succeed or Fail14
1.050 Understanding Search Structure and Metadata21
Chapter 2 — Why Businesses Struggle to Find Answers28
2.010 Too Many Files Too Little Access28
2.020 Tribal Knowledge Dependency30
2.030 Repeated Questions Repeated Costs35
Chapter 3 — Why Generic AI Often Fails in Business41
3.010 Public AI vs Private Knowledge41
3.020 Hallucinations and Unsupported Answers44
3.030 Why Retrieval Beats Guessing48
Chapter 4 — The Corporate Intelligence System52
4.010 What the System Actually Does52
4.020 From Question to Answer (End-to-End Flow)55
4.030 Why This System Works When Others Fail59
4.040 Key Capabilities of the System62
Chapter 5 — System Design Philosophy65
5.010 Consistent Program Structure65
5.020 Common Variables and Data Patterns68
5.030 Standardized Database Access72
5.040 Security Model and Access Control75
5.050 Why Consistency Matters at Scale78
Chapter 6 — System Implementation Patterns83
6.010 From Creativity to Controlled Consistency83
6.020 Use of Model Programs85
6.030 Standard Program Startup89
6.040 Composer and Dependency Requirements94
6.050 Session Management and Namespace Control98
6.060 Standardized CRUD and Database Access101
6.070 Common Routines and Shared Logic105
6.080 Menu, Navigation, and Search Patterns109
6.090 Help and Documentation Integration113
Chapter 7 — Books Chapters and Sections118
7.010 Why Structured Books Matter118
7.020 Creating Chapters123
7.030 Creating Screens as Sections127
7.040 Creating Procedures as Sections130
Chapter 8 — Writing Better Manuals133
8.010 Writing for Search and AI133
8.020 Descriptive Writing vs Conceptual Writing138
8.030 Procedure Writing Standards141
8.040 Section Writing Standards143
Chapter 9 — Document Ingestion and Preparation147
Introduction147
9.010 PDFs DOCX and Legacy Files149
9.020 API Instructions Handling154
9.030 Cleanup Before API158
9.040 Chunking and Segmentation164
9.050 File Size Control169
9.060 API Load Management172
9.070 File Chunks API Chunks Chunk Creation Vectoring175
9.080 Failure Handling and Partial Processing179
9.090 Other Documents Ingestion and Requirements181
Chapter 10 — How Search Really Works186
10.010 Inverted Index Fundamentals186
10.030 Why Speed Matters197
10.050 Production vs Demo Behavior203
Chapter 11 — Metadata Weighting and Synonyms208
Introduction208
11.010 Metadata Signals213
11.020 Synonym Tables222
11.030 Hybrid Retrieval227
11.040 Intent Interpretation240
11.050 Normalization and Misspellings243
11.060 Relationship-Aware Retrieval245
11.070 Graph-Enhanced RAG250
11.080 Spreadsheet Context Expansion256
11.090 Contextual Neighbor Chunk Selection263
11.100 Relationship Weighting and Retrieval Scoring269
Chapter 12 — Building the AI Chat Agent275
12.010 Chat Agent Features275
12.020 Session Design287
12.030 User Request Vectoring and Chunk Selection Algorithms291
12.040 Memory and History295
12.050 Standard JSON to send User Question for API302
12.060 Conversation Lifecycle311
12.070 Summary System Persistence Design321
12.080 Debugging and Cost Tracking323
Chapter 13 — Security Governance and Scaling329
13.010 Security System Design329
13.020 Permissions333
13.030 Maintenance336
Chapter 14 — Overall System Architecture340
14.010 System Layers Overview340
14.020 Data Flow End-to-End343
14.030 Component Responsibilities346
14.040 Boundaries and Abstractions349
Chapter 15 — Engineering Lessons and Failed Designs353
Introduction353
15.010 Lessons From Failed Designs355
15.020 API Drift and False Success357
15.030 File Conversion and API Overload360
15.040 Chunk Size and Stability Lessons362
15.050 Memory Limits and Serialization Issues364
15.060 Backup and System Load Constraints367
Conclusion369
Appendix 1 - Header and Screen Help Management - Code372
Index378