178 lines
8.5 KiB
HTML
178 lines
8.5 KiB
HTML
<!DOCTYPE html>
|
|
|
|
<html lang="en">
|
|
<head>
|
|
<meta charset="utf-8"/>
|
|
<meta content="IE=edge" http-equiv="X-UA-Compatible"/>
|
|
<meta content="width=device-width, initial-scale=1.0" name="viewport"/>
|
|
<link href="https://git.tylconsulting.it/thothii-docs/skills/" rel="canonical"/>
|
|
<link href="../img/favicon.ico" rel="shortcut icon"/>
|
|
<meta content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=0" name="viewport"/>
|
|
<title>Reviewed workflow - ThothII Docs</title>
|
|
<link href="../css/bootstrap-3.3.7.min.css" rel="stylesheet"/>
|
|
<link href="../css/font-awesome-4.7.0.css" rel="stylesheet"/>
|
|
<link href="../css/base.css" rel="stylesheet"/>
|
|
<link href="../css/highlight.css" rel="stylesheet"/>
|
|
<link href="../stylesheets/extra.css" rel="stylesheet"/>
|
|
<!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries -->
|
|
<!--[if lt IE 9]>
|
|
<script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
|
|
<script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script>
|
|
<![endif]-->
|
|
<script src="../js/jquery-3.2.1.min.js"></script>
|
|
<script src="../js/bootstrap-3.3.7.min.js"></script>
|
|
<script src="../js/highlight.pack.js"></script>
|
|
<base target="_top"/>
|
|
<script>
|
|
var base_url = '..';
|
|
var is_top_frame = false;
|
|
|
|
var pageToc = [
|
|
{title: "ThothII operating workflow", url: "#_top", children: [
|
|
{title: "Workflow principles", url: "#workflow-principles" },
|
|
{title: "F1: clarification", url: "#f1-clarification" },
|
|
{title: "F2: Memory", url: "#f2-memory" },
|
|
{title: "F3: rewriting", url: "#f3-rewriting" },
|
|
{title: "F4: Evidence", url: "#f4-evidence" },
|
|
{title: "F5: schema", url: "#f5-schema" },
|
|
{title: "F6: CTE plan", url: "#f6-cte-plan" },
|
|
{title: "F7: final SQL", url: "#f7-final-sql" },
|
|
{title: "F8: Memory promotion", url: "#f8-memory-promotion" },
|
|
{title: "Available gates", url: "#available-gates" },
|
|
{title: "Resume and reopening", url: "#resume-and-reopening" },
|
|
]},
|
|
];
|
|
|
|
</script>
|
|
<script src="../js/base.js"></script>
|
|
<script src="../javascripts/layout-init.js"></script>
|
|
</head>
|
|
<body>
|
|
<script>
|
|
if (is_top_frame) { $('body').addClass('wm-top-page'); }
|
|
</script>
|
|
<div class="container-fluid wm-page-content">
|
|
<a name="_top"></a>
|
|
<div aria-label="navigation" class="row wm-article-nav-buttons" role="navigation">
|
|
<div class="wm-article-nav pull-right">
|
|
<a class="btn btn-xs btn-default pull-right" href="../guida-utente/">
|
|
Next
|
|
<i aria-hidden="true" class="fa fa-chevron-right"></i>
|
|
</a>
|
|
<a class="btn btn-xs btn-link" href="../guida-utente/">
|
|
User guide
|
|
</a>
|
|
</div>
|
|
<div class="wm-article-nav">
|
|
<a class="btn btn-xs btn-default pull-left" href="../product-overview/">
|
|
<i aria-hidden="true" class="fa fa-chevron-left"></i>
|
|
Previous</a><a class="btn btn-xs btn-link" href="../product-overview/">
|
|
Product overview
|
|
</a>
|
|
</div>
|
|
</div>
|
|
<h1 id="thothii-operating-workflow">ThothII operating workflow<a class="headerlink" href="#thothii-operating-workflow" title="Permanent link">¶</a></h1>
|
|
<p>ThothII guides every question through eight phases. The model proposes the work, the reviewer
|
|
makes decisions at gates, and the system records persistent artifacts and decisions.</p>
|
|
<div class="mermaid">flowchart LR
|
|
Q["Question"] --> F1["F1 Clarification"]
|
|
F1 --> F2["F2 Memory"]
|
|
F2 --> F3["F3 Rewriting"]
|
|
F3 --> F4["F4 Evidence"]
|
|
F4 --> F5["F5 Schema"]
|
|
F5 --> F6["F6 CTE plan"]
|
|
F6 --> F7["F7 SQL"]
|
|
F7 --> F8["F8 Promotion"]
|
|
F8 --> DONE["Finalized session"]
|
|
</div>
|
|
<h2 id="workflow-principles">Workflow principles<a class="headerlink" href="#workflow-principles" title="Permanent link">¶</a></h2>
|
|
<ul>
|
|
<li>The model proposes; the reviewer approves, corrects, or rejects.</li>
|
|
<li>The session ledger records every material decision.</li>
|
|
<li>Persisted state is the source of truth.</li>
|
|
<li>A phase advances only when its artifacts and gates are complete.</li>
|
|
<li>Resume rebuilds context from persisted artifacts, not from the conversation.</li>
|
|
</ul>
|
|
<h2 id="f1-clarification">F1: clarification<a class="headerlink" href="#f1-clarification" title="Permanent link">¶</a></h2>
|
|
<p>The system identifies the ambiguity most likely to change the meaning of the question and presents
|
|
one decision at a time. Mutually exclusive interpretations use a single choice; multiple valid
|
|
answers use a multiple choice.</p>
|
|
<h2 id="f2-memory">F2: Memory<a class="headerlink" href="#f2-memory" title="Permanent link">¶</a></h2>
|
|
<p>The system proposes Memory items that fit the question. Selected items enter the current session
|
|
context; unselected items remain available for future questions.</p>
|
|
<h2 id="f3-rewriting">F3: rewriting<a class="headerlink" href="#f3-rewriting" title="Permanent link">¶</a></h2>
|
|
<p>The system rewrites the question explicitly using the approved clarifications. The reviewer checks
|
|
the resulting question and its assumptions before continuing.</p>
|
|
<h2 id="f4-evidence">F4: Evidence<a class="headerlink" href="#f4-evidence" title="Permanent link">¶</a></h2>
|
|
<p>The system retrieves Evidence from the active corpus and presents citations and provenance. The
|
|
reviewer decides which items apply to the question.</p>
|
|
<h2 id="f5-schema">F5: schema<a class="headerlink" href="#f5-schema" title="Permanent link">¶</a></h2>
|
|
<p>Tables, columns, relationships, and filters are linked to the approved meaning of the question.
|
|
The summary closes the phase when the question, assumptions, and DWH elements are consistent.</p>
|
|
<h2 id="f6-cte-plan">F6: CTE plan<a class="headerlink" href="#f6-cte-plan" title="Permanent link">¶</a></h2>
|
|
<p>The query is broken into named CTEs with a purpose, dependencies, tables, filters, and output
|
|
columns. The reviewer sees each step before the system produces the final SQL.</p>
|
|
<h2 id="f7-final-sql">F7: final SQL<a class="headerlink" href="#f7-final-sql" title="Permanent link">¶</a></h2>
|
|
<p>The system produces <code>sql_final.sql</code>, checks it against the approved plan, and presents the artifact
|
|
to the reviewer. A correction can reopen the CTE plan without discarding decisions that remain valid.</p>
|
|
<h2 id="f8-memory-promotion">F8: Memory promotion<a class="headerlink" href="#f8-memory-promotion" title="Permanent link">¶</a></h2>
|
|
<p>At the end of the session, the system proposes reusable Memory cards, including the approved
|
|
solved question. The reviewer selects and edits the additions or updates to retain in the
|
|
workspace's Memory archive, or declines them all. The session is then finalized.</p>
|
|
<h2 id="available-gates">Available gates<a class="headerlink" href="#available-gates" title="Permanent link">¶</a></h2>
|
|
<table>
|
|
<thead>
|
|
<tr>
|
|
<th>Gate</th>
|
|
<th>Use</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
<tr>
|
|
<td>Single choice</td>
|
|
<td>Only one interpretation can be valid</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Multiple choice</td>
|
|
<td>Several items can be valid at the same time</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Artifact confirmation</td>
|
|
<td>Approval of a document or phase result</td>
|
|
</tr>
|
|
<tr>
|
|
<td>Phase confirmation</td>
|
|
<td>Explicitly closes a phase</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
<h2 id="resume-and-reopening">Resume and reopening<a class="headerlink" href="#resume-and-reopening" title="Permanent link">¶</a></h2>
|
|
<p>A resumed session returns to its last incomplete phase. Reopening invalidates only the decisions
|
|
and artifacts that depend on the changed point; the rest of the work remains valid.</p>
|
|
<br/>
|
|
<div aria-label="navigation" class="row wm-article-nav-buttons" role="navigation">
|
|
<div class="wm-article-nav pull-right">
|
|
<a class="btn btn-xs btn-default pull-right" href="../guida-utente/">
|
|
Next
|
|
<i aria-hidden="true" class="fa fa-chevron-right"></i>
|
|
</a>
|
|
<a class="btn btn-xs btn-link" href="../guida-utente/">
|
|
User guide
|
|
</a>
|
|
</div>
|
|
<div class="wm-article-nav">
|
|
<a class="btn btn-xs btn-default pull-left" href="../product-overview/">
|
|
<i aria-hidden="true" class="fa fa-chevron-left"></i>
|
|
Previous</a><a class="btn btn-xs btn-link" href="../product-overview/">
|
|
Product overview
|
|
</a>
|
|
</div>
|
|
</div>
|
|
<br/>
|
|
</div>
|
|
<footer class="container-fluid wm-page-content">
|
|
<p>Documentation built with <a href="https://www.mkdocs.org/">MkDocs</a> using <a href="https://github.com/gristlabs/mkdocs-windmill">Windmill</a> theme by Grist Labs.</p>
|
|
</footer>
|
|
<script type="module">import mermaid from "https://unpkg.com/mermaid@10.4.0/dist/mermaid.esm.min.mjs";
|
|
mermaid.initialize({});</script></body>
|
|
</html> |