Spaces:
Running
Running
| <html lang="en"> | |
| <head> | |
| <meta charset="UTF-8" /> | |
| <meta name="viewport" content="width=device-width, initial-scale=1" /> | |
| <title>Computer Science Batch 03 - Database Systems - Programming Framework Analysis</title> | |
| <style> | |
| body { | |
| font-family: 'Times New Roman', Times, serif, 'Arial Unicode MS'; | |
| margin: 0; | |
| background: #ffffff; | |
| color: #000000; | |
| line-height: 1.6; | |
| font-size: 12pt; | |
| } | |
| .container { | |
| max-width: 1000px; | |
| margin: 0 auto; | |
| padding: 1.5rem; | |
| } | |
| h1, h2, h3 { | |
| color: #000000; | |
| margin-top: 1.5rem; | |
| margin-bottom: 0.75rem; | |
| } | |
| h1 { | |
| font-size: 18pt; | |
| text-align: center; | |
| } | |
| h2 { | |
| font-size: 16pt; | |
| border-bottom: 2px solid #000; | |
| padding-bottom: 0.5rem; | |
| } | |
| h3 { | |
| font-size: 14pt; | |
| } | |
| p { | |
| margin-bottom: 1rem; | |
| text-align: justify; | |
| } | |
| .figure { | |
| margin: 2rem 0; | |
| text-align: center; | |
| border: 1px solid #ccc; | |
| padding: 1rem; | |
| background: #f9f9f9; | |
| } | |
| .figure-caption { | |
| margin-top: 1rem; | |
| font-style: italic; | |
| text-align: left; | |
| } | |
| .mermaid { | |
| background: white; | |
| padding: 1rem; | |
| border-radius: 4px; | |
| } | |
| .navigation { | |
| margin: 3rem 0; | |
| padding: 1rem; | |
| background: #f8f9fa; | |
| border-radius: 8px; | |
| } | |
| .nav-links { | |
| display: flex; | |
| flex-wrap: wrap; | |
| gap: 1rem; | |
| justify-content: center; | |
| } | |
| .nav-link { | |
| color: #007bff; | |
| text-decoration: none; | |
| padding: 0.5rem 1rem; | |
| border: 1px solid #007bff; | |
| border-radius: 4px; | |
| transition: all 0.3s ease; | |
| } | |
| .nav-link:hover { | |
| background: #007bff; | |
| color: white; | |
| } | |
| .footer { | |
| margin-top: 3rem; | |
| padding: 1rem; | |
| background: #f8f9fa; | |
| border-radius: 8px; | |
| text-align: center; | |
| } | |
| .contact-info { | |
| margin-top: 1rem; | |
| } | |
| .contact-info p { | |
| margin: 0.25rem 0; | |
| text-align: center; | |
| } | |
| </style> | |
| <script src="https://cdn.jsdelivr.net/npm/mermaid@10.6.1/dist/mermaid.min.js"></script> | |
| <script> | |
| mermaid.initialize({ | |
| startOnLoad: true, | |
| theme: 'default', | |
| flowchart: { | |
| useMaxWidth: false, | |
| htmlLabels: true, | |
| curve: 'linear', | |
| nodeSpacing: 30, | |
| rankSpacing: 30, | |
| padding: 10 | |
| }, | |
| themeVariables: { | |
| fontFamily: 'Arial Unicode MS, Arial, sans-serif' | |
| } | |
| }); | |
| </script> | |
| </head> | |
| <body> | |
| <div class="container"> | |
| <h1>Computer Science Batch 03 - Database Systems - Programming Framework Analysis</h1> | |
| <p>This document presents database systems processes analyzed using the Programming Framework methodology. Each process is represented as a computational flowchart with standardized color coding: Red for triggers/inputs, Yellow for structures/objects, Green for processing/operations, Blue for intermediates/states, and Violet for products/outputs. Yellow nodes use black text for optimal readability, while all other colors use white text.</p> | |
| <h2>1. Database Design Process</h2> | |
| <div class="figure"> | |
| <div class="mermaid"> | |
| graph TD | |
| A1[Requirements Analysis] --> B1[Database Design Method] | |
| C1[Entity Relationship] --> D1[Data Modeling] | |
| E1[Schema Design] --> F1[Database Design Analysis] | |
| B1 --> G1[Conceptual Design] | |
| D1 --> H1[Logical Design] | |
| F1 --> I1[Physical Design] | |
| G1 --> J1[Entity Identification] | |
| H1 --> K1[Attribute Definition] | |
| I1 --> L1[Index Design] | |
| J1 --> M1[Relationship Mapping] | |
| K1 --> L1 | |
| L1 --> N1[Performance Optimization] | |
| M1 --> O1[Normalization Process] | |
| N1 --> P1[Storage Optimization] | |
| O1 --> Q1[Database Design Process] | |
| P1 --> R1[Database Design Validation] | |
| Q1 --> S1[Database Design Verification] | |
| R1 --> T1[Database Design Result] | |
| S1 --> U1[Database Design Analysis] | |
| T1 --> V1[Database Design Parameters] | |
| U1 --> W1[Database Design Output] | |
| V1 --> X1[Database Design Analysis] | |
| W1 --> Y1[Database Design Final Result] | |
| X1 --> Z1[Database Design Complete] | |
| style A1 fill:#ff6b6b,color:#fff | |
| style C1 fill:#ff6b6b,color:#fff | |
| style E1 fill:#ff6b6b,color:#fff | |
| style B1 fill:#ffd43b,color:#000 | |
| style D1 fill:#ffd43b,color:#000 | |
| style F1 fill:#ffd43b,color:#000 | |
| style G1 fill:#ffd43b,color:#000 | |
| style H1 fill:#ffd43b,color:#000 | |
| style I1 fill:#ffd43b,color:#000 | |
| style J1 fill:#ffd43b,color:#000 | |
| style K1 fill:#ffd43b,color:#000 | |
| style L1 fill:#ffd43b,color:#000 | |
| style M1 fill:#ffd43b,color:#000 | |
| style N1 fill:#ffd43b,color:#000 | |
| style O1 fill:#ffd43b,color:#000 | |
| style P1 fill:#ffd43b,color:#000 | |
| style Q1 fill:#ffd43b,color:#000 | |
| style R1 fill:#ffd43b,color:#000 | |
| style S1 fill:#ffd43b,color:#000 | |
| style T1 fill:#ffd43b,color:#000 | |
| style U1 fill:#ffd43b,color:#000 | |
| style V1 fill:#ffd43b,color:#000 | |
| style W1 fill:#ffd43b,color:#000 | |
| style X1 fill:#ffd43b,color:#000 | |
| style Y1 fill:#ffd43b,color:#000 | |
| style Z1 fill:#ffd43b,color:#000 | |
| style M1 fill:#51cf66,color:#fff | |
| style N1 fill:#51cf66,color:#fff | |
| style O1 fill:#51cf66,color:#fff | |
| style P1 fill:#51cf66,color:#fff | |
| style Q1 fill:#51cf66,color:#fff | |
| style R1 fill:#51cf66,color:#fff | |
| style S1 fill:#51cf66,color:#fff | |
| style T1 fill:#51cf66,color:#fff | |
| style U1 fill:#51cf66,color:#fff | |
| style V1 fill:#51cf66,color:#fff | |
| style W1 fill:#51cf66,color:#fff | |
| style X1 fill:#51cf66,color:#fff | |
| style Y1 fill:#51cf66,color:#fff | |
| style Z1 fill:#51cf66,color:#fff | |
| style Z1 fill:#b197fc,color:#fff | |
| </div> | |
| <div style="margin-top: 1rem; display: flex; flex-wrap: wrap; gap: 0.5rem; justify-content: center;"> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#ff6b6b;"></span>Triggers & Inputs | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#ffd43b;"></span>Database Design Methods | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#51cf66;"></span>Database Design Operations | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#74c0fc;"></span>Intermediates | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#b197fc;"></span>Products | |
| </div> | |
| </div> | |
| <div class="figure-caption"> | |
| <strong>Figure 1.</strong> Database Design Process. This database systems process visualization demonstrates database design methodologies and schema optimization. The flowchart shows requirements inputs and entity relationships, database design methods and data modeling, database design operations and schema design, intermediate results, and final database design outputs. | |
| </div> | |
| </div> | |
| <h2>2. Query Processing Process</h2> | |
| <div class="figure"> | |
| <div class="mermaid"> | |
| graph TD | |
| A2[Query Input] --> B2[Query Processing Method] | |
| C2[Query Parsing] --> D2[Query Optimization] | |
| E2[Query Execution] --> F2[Query Processing Analysis] | |
| B2 --> G2[SQL Parser] | |
| D2 --> H2[Query Optimizer] | |
| F2 --> I2[Execution Engine] | |
| G2 --> J2[Syntax Analysis] | |
| H2 --> K2[Cost Based Optimization] | |
| I2 --> L2[Query Plan Execution] | |
| J2 --> M2[Semantic Analysis] | |
| K2 --> L2 | |
| L2 --> N2[Result Generation] | |
| M2 --> O2[Query Plan Generation] | |
| N2 --> P2[Performance Monitoring] | |
| O2 --> Q2[Query Processing Process] | |
| P2 --> R2[Query Processing Validation] | |
| Q2 --> S2[Query Processing Verification] | |
| R2 --> T2[Query Processing Result] | |
| S2 --> U2[Query Processing Analysis] | |
| T2 --> V2[Query Processing Parameters] | |
| U2 --> W2[Query Processing Output] | |
| V2 --> X2[Query Processing Analysis] | |
| W2 --> Y2[Query Processing Final Result] | |
| X2 --> Z2[Query Processing Complete] | |
| style A2 fill:#ff6b6b,color:#fff | |
| style C2 fill:#ff6b6b,color:#fff | |
| style E2 fill:#ff6b6b,color:#fff | |
| style B2 fill:#ffd43b,color:#000 | |
| style D2 fill:#ffd43b,color:#000 | |
| style F2 fill:#ffd43b,color:#000 | |
| style G2 fill:#ffd43b,color:#000 | |
| style H2 fill:#ffd43b,color:#000 | |
| style I2 fill:#ffd43b,color:#000 | |
| style J2 fill:#ffd43b,color:#000 | |
| style K2 fill:#ffd43b,color:#000 | |
| style L2 fill:#ffd43b,color:#000 | |
| style M2 fill:#ffd43b,color:#000 | |
| style N2 fill:#ffd43b,color:#000 | |
| style O2 fill:#ffd43b,color:#000 | |
| style P2 fill:#ffd43b,color:#000 | |
| style Q2 fill:#ffd43b,color:#000 | |
| style R2 fill:#ffd43b,color:#000 | |
| style S2 fill:#ffd43b,color:#000 | |
| style T2 fill:#ffd43b,color:#000 | |
| style U2 fill:#ffd43b,color:#000 | |
| style V2 fill:#ffd43b,color:#000 | |
| style W2 fill:#ffd43b,color:#000 | |
| style X2 fill:#ffd43b,color:#000 | |
| style Y2 fill:#ffd43b,color:#000 | |
| style Z2 fill:#ffd43b,color:#000 | |
| style M2 fill:#51cf66,color:#fff | |
| style N2 fill:#51cf66,color:#fff | |
| style O2 fill:#51cf66,color:#fff | |
| style P2 fill:#51cf66,color:#fff | |
| style Q2 fill:#51cf66,color:#fff | |
| style R2 fill:#51cf66,color:#fff | |
| style S2 fill:#51cf66,color:#fff | |
| style T2 fill:#51cf66,color:#fff | |
| style U2 fill:#51cf66,color:#fff | |
| style V2 fill:#51cf66,color:#fff | |
| style W2 fill:#51cf66,color:#fff | |
| style X2 fill:#51cf66,color:#fff | |
| style Y2 fill:#51cf66,color:#fff | |
| style Z2 fill:#51cf66,color:#fff | |
| style Z2 fill:#b197fc,color:#fff | |
| </div> | |
| <div style="margin-top: 1rem; display: flex; flex-wrap: wrap; gap: 0.5rem; justify-content: center;"> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#ff6b6b;"></span>Triggers & Inputs | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#ffd43b;"></span>Query Processing Methods | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#51cf66;"></span>Query Processing Operations | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#74c0fc;"></span>Intermediates | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#b197fc;"></span>Products | |
| </div> | |
| </div> | |
| <div class="figure-caption"> | |
| <strong>Figure 2.</strong> Query Processing Process. This database systems process visualization demonstrates query optimization and execution strategies. The flowchart shows query inputs and parsing, query processing methods and optimization, query processing operations and execution, intermediate results, and final query processing outputs. | |
| </div> | |
| </div> | |
| <h2>3. Transaction Management Process</h2> | |
| <div class="figure"> | |
| <div class="mermaid"> | |
| graph TD | |
| A3[Transaction Initiation] --> B3[Transaction Management Method] | |
| C3[Concurrency Control] --> D3[Lock Management] | |
| E3[Recovery Process] --> F3[Transaction Management Analysis] | |
| B3 --> G3[ACID Properties] | |
| D3 --> H3[Two Phase Locking] | |
| F3 --> I3[Deadlock Detection] | |
| G3 --> J3[Atomicity Enforcement] | |
| H3 --> K3[Consistency Checking] | |
| I3 --> L3[Isolation Management] | |
| J3 --> M3[Durability Guarantee] | |
| K3 --> L3 | |
| L3 --> N3[Serializability] | |
| M3 --> O3[Checkpoint Process] | |
| N3 --> P3[Log Management] | |
| O3 --> Q3[Transaction Management Process] | |
| P3 --> R3[Transaction Management Validation] | |
| Q3 --> S3[Transaction Management Verification] | |
| R3 --> T3[Transaction Management Result] | |
| S3 --> U3[Transaction Management Analysis] | |
| T3 --> V3[Transaction Management Parameters] | |
| U3 --> W3[Transaction Management Output] | |
| V3 --> X3[Transaction Management Analysis] | |
| W3 --> Y3[Transaction Management Final Result] | |
| X3 --> Z3[Transaction Management Complete] | |
| style A3 fill:#ff6b6b,color:#fff | |
| style C3 fill:#ff6b6b,color:#fff | |
| style E3 fill:#ff6b6b,color:#fff | |
| style B3 fill:#ffd43b,color:#000 | |
| style D3 fill:#ffd43b,color:#000 | |
| style F3 fill:#ffd43b,color:#000 | |
| style G3 fill:#ffd43b,color:#000 | |
| style H3 fill:#ffd43b,color:#000 | |
| style I3 fill:#ffd43b,color:#000 | |
| style J3 fill:#ffd43b,color:#000 | |
| style K3 fill:#ffd43b,color:#000 | |
| style L3 fill:#ffd43b,color:#000 | |
| style M3 fill:#ffd43b,color:#000 | |
| style N3 fill:#ffd43b,color:#000 | |
| style O3 fill:#ffd43b,color:#000 | |
| style P3 fill:#ffd43b,color:#000 | |
| style Q3 fill:#ffd43b,color:#000 | |
| style R3 fill:#ffd43b,color:#000 | |
| style S3 fill:#ffd43b,color:#000 | |
| style T3 fill:#ffd43b,color:#000 | |
| style U3 fill:#ffd43b,color:#000 | |
| style V3 fill:#ffd43b,color:#000 | |
| style W3 fill:#ffd43b,color:#000 | |
| style X3 fill:#ffd43b,color:#000 | |
| style Y3 fill:#ffd43b,color:#000 | |
| style Z3 fill:#ffd43b,color:#000 | |
| style M3 fill:#51cf66,color:#fff | |
| style N3 fill:#51cf66,color:#fff | |
| style O3 fill:#51cf66,color:#fff | |
| style P3 fill:#51cf66,color:#fff | |
| style Q3 fill:#51cf66,color:#fff | |
| style R3 fill:#51cf66,color:#fff | |
| style S3 fill:#51cf66,color:#fff | |
| style T3 fill:#51cf66,color:#fff | |
| style U3 fill:#51cf66,color:#fff | |
| style V3 fill:#51cf66,color:#fff | |
| style W3 fill:#51cf66,color:#fff | |
| style X3 fill:#51cf66,color:#fff | |
| style Y3 fill:#51cf66,color:#fff | |
| style Z3 fill:#51cf66,color:#fff | |
| style Z3 fill:#b197fc,color:#fff | |
| </div> | |
| <div style="margin-top: 1rem; display: flex; flex-wrap: wrap; gap: 0.5rem; justify-content: center;"> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#ff6b6b;"></span>Triggers & Inputs | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#ffd43b;"></span>Transaction Management Methods | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#51cf66;"></span>Transaction Management Operations | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#74c0fc;"></span>Intermediates | |
| </div> | |
| <div style="display:inline-flex; align-items:center; gap:.5rem; padding:.25rem .5rem; border-radius: 999px; border: 1px solid rgba(0,0,0,.08); background:#fff;"> | |
| <span style="width: 12px; height: 12px; border-radius: 2px; border:1px solid rgba(0,0,0,.15); background:#b197fc;"></span>Products | |
| </div> | |
| </div> | |
| <div class="figure-caption"> | |
| <strong>Figure 3.</strong> Transaction Management Process. This database systems process visualization demonstrates transaction control and recovery mechanisms. The flowchart shows transaction inputs and concurrency control, transaction management methods and lock management, transaction management operations and recovery processes, intermediate results, and final transaction management outputs. | |
| </div> | |
| </div> | |
| <div class="navigation"> | |
| <h3>Navigation</h3> | |
| <div class="nav-links"> | |
| <a href="computer_science_index.html" class="nav-link">← Back to Computer Science Index</a> | |
| <a href="computer_science_batch_02.html" class="nav-link">← Previous: Software Engineering</a> | |
| <a href="computer_science_batch_04.html" class="nav-link">Next: Computer Networks →</a> | |
| <a href="index.html" class="nav-link">Programming Framework Home</a> | |
| </div> | |
| </div> | |
| <div class="footer"> | |
| <p><strong>Generated using the Programming Framework methodology</strong></p> | |
| <p>Each flowchart preserves maximum detail through optimized Mermaid configuration</p> | |
| <div class="contact-info"> | |
| <p><strong>Gary Welz</strong></p> | |
| <p>Retired Faculty Member</p> | |
| <p>John Jay College, CUNY (Department of Mathematics and Computer Science)</p> | |
| <p>Borough of Manhattan Community College, CUNY</p> | |
| <p>CUNY Graduate Center (New Media Lab)</p> | |
| <p>Email: gwelz@jjay.cuny.edu</p> | |
| </div> | |
| </div> | |
| </div> | |
| </body> | |
| </html> | |