- Get link
- X
- Other Apps
Here is the HTML table representing the single source database dataset and how its structured data fuels both the Relationship View (Network) and the Timespan View (Chronological) using standard <table>, <tr>, <th>, and <td> tags.
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Dataset View Transformation Table</title>
<style>
body {
font-family: Arial, sans-serif;
background-color: #f8f9fa;
color: #212529;
padding: 20px;
}
h2 {
text-align: center;
color: #0d6efd;
margin-bottom: 20px;
}
.main-table {
width: 100%;
border-collapse: collapse;
background-color: #ffffff;
box-shadow: 0 4px 6px rgba(0,0,0,0.1);
margin-bottom: 30px;
}
.main-table th, .main-table td {
border: 1px solid #dee2e6;
padding: 10px 14px;
font-size: 13px;
text-align: left;
vertical-align: top;
}
.header-section {
background-color: #e9ecef;
font-weight: bold;
font-size: 14px;
color: #495057;
}
.header-sub {
background-color: #0d6efd;
color: #ffffff;
font-weight: bold;
text-align: center;
}
.header-sub-green {
background-color: #198754;
color: #ffffff;
font-weight: bold;
text-align: center;
}
.col-header {
background-color: #f1f3f5;
font-weight: bold;
}
.badge {
display: inline-block;
padding: 2px 6px;
border-radius: 4px;
font-size: 11px;
font-weight: bold;
}
.badge-rel { background-color: #e7f5ff; color: #1971c2; }
.badge-time { background-color: #ebfbee; color: #2b8a3e; }
.footer-note {
font-size: 12px;
color: #6c757d;
text-align: center;
margin-top: 10px;
}
</style>
</head>
<body>
<h2>Single Source Database: Dual-View Dataset Table</h2>
<!-- SECTION 1: RAW DATASET SCHEMA FROM SINGLE DATABASE -->
<table class="main-table">
<thead>
<tr class="header-section">
<th colspan="7">SECTION 1: RAW EVENT LOG & NODE DATASET (Single Database Source)</th>
</tr>
<tr class="col-header">
<th>Event_ID</th>
<th>Source_Node (Entity)</th>
<th>Target_Node (Related Entity)</th>
<th>Relationship_Type</th>
<th>Start_Timestamp</th>
<th>End_Timestamp</th>
<th>Phase_Category</th>
</tr>
</thead>
<tbody>
<tr>
<td>EVT_001</td>
<td>System_Alpha</td>
<td>User_Group_01</td>
<td>Afected_By</td>
<td>2026-03-01 08:00:00</td>
<td>2026-03-01 18:00:00</td>
<td>Initial Detection</td>
</tr>
<tr>
<td>EVT_002</td>
<td>System_Alpha</td>
<td>Database_Core</td>
<td>Causal_Link</td>
<td>2026-03-01 09:30:00</td>
<td>2026-03-03 12:00:00</td>
<td>Initial Detection</td>
</tr>
<tr>
<td>EVT_003</td>
<td>Process_B</td>
<td>Network_Node_4</td>
<td>Interconnection</td>
<td>2026-03-02 10:00:00</td>
<td>2026-03-05 15:00:00</td>
<td>Escalation Phase</td>
</tr>
<tr>
<td>EVT_004</td>
<td>Process_C</td>
<td>Process_D</td>
<td>Dependency_Chain</td>
<td>2026-03-04 14:00:00</td>
<td>2026-03-12 11:00:00</td>
<td>Remediation</td>
</tr>
<tr>
<td>EVT_005</td>
<td>System_Beta</td>
<td>Audit_Log_99</td>
<td>Entity_Interaction</td>
<td>2026-03-10 09:00:00</td>
<td>2026-03-30 17:00:00</td>
<td>Investigation</td>
</tr>
</tbody>
</table>
<!-- SECTION 2: TRANSFORMATION VIEWS (RELATIONSHIP VS TIMESPAN) -->
<table class="main-table">
<thead>
<tr>
<th colspan="4" class="header-sub">VIEW 1: RELATIONSHIP DATA (Network Structure)</th>
<th colspan="4" class="header-sub-green">VIEW 2: TIMESPAN DATA (Chronological Timeline)</th>
</tr>
<tr class="col-header">
<!-- Relationship Columns -->
<th>Entity Node</th>
<th>Connected Target</th>
<th>Connection Type</th>
<th>Network Metrics</th>
<!-- Timespan Columns -->
<th>Phase Name</th>
<th>Start - End Date</th>
<th>Duration</th>
<th>Chronological Insights</th>
</tr>
</thead>
<tbody>
<tr>
<!-- Row 1 Rel -->
<td><span class="badge badge-rel">Node</span> System_Alpha</td>
<td>User_Group_01</td>
<td>Direct Association</td>
<td>Degree: 5 | Edges: 12</td>
<!-- Row 1 Time -->
<td>Initial Detection</td>
<td>Mar 01 - Mar 03</td>
<td>2 Days</td>
<td><span class="badge badge-time">Event A</span> Dense Sequential Activity</td>
</tr>
<tr>
<!-- Row 2 Rel -->
<td><span class="badge badge-rel">Node</span> CORE_EVENTS</td>
<td>Affected_Systems</td>
<td>Causal Link</td>
<td>Degree: 18 | Edges: 45</td>
<!-- Row 2 Time -->
<td>Escalation Phase</td>
<td>Mar 03 - Mar 08</td>
<td>5 Days</td>
<td><span class="badge badge-time">Event B</span> Overlapping Events & Escalation</td>
</tr>
<tr>
<!-- Row 3 Rel -->
<td><span class="badge badge-rel">Node</span> Process_C</td>
<td>Process_D</td>
<td>Dependency Chain</td>
<td>Degree: 3 | Edges: 4</td>
<!-- Row 3 Time -->
<td>Remediation</td>
<td>Mar 08 - Mar 20</td>
<td>12 Days</td>
<td><span class="badge badge-time">Activity C</span> Parallel Task Chains</td>
</tr>
<tr>
<!-- Row 4 Rel -->
<td><span class="badge badge-rel">Node</span> System_Beta</td>
<td>Network Connections</td>
<td>Interconnection</td>
<td>Degree: 8 | Edges: 19</td>
<!-- Row 4 Time -->
<td>Investigation</td>
<td>Mar 20 - Mar 30</td>
<td>10 Days</td>
<td><span class="badge badge-time">Process D</span> System-Wide Milestones</td>
</tr>
</tbody>
<tfoot>
<tr class="col-header">
<td colspan="4"><strong>Focus:</strong> Visualizes <em>HOW</em> entities and nodes are linked (Structure & Topology)</td>
<td colspan="4"><strong>Focus:</strong> Visualizes <em>WHEN</em> occurrences happened (Duration & Sequence)</td>
</tr>
</tfoot>
</table>
<div class="footer-note">
This table converts single-database records with node associations and timestamps into structured dual-reporting views.
</div>
</body>
</html>
Comments