liveBook · Manning

Explaining method

As explained in AI for Everyday IT

The explaining method is a prompting approach that describes a desired database query conversationally and provides contextual examples.

The explaining method turns a database-query need into a conversational prompt. Describe the goal, provide a basic query or table schema, and show sample output so the chatbot has useful context. section 10.6.2

A practical explaining prompt can include:

  • The starting SELECT statement or relevant schema. section 10.6.2
  • A sample result showing how the data currently appears. section 10.6.2
  • A plain-language transformation request, such as converting values ending in M or G into numeric megabytes. section 10.6.2

Memory configuration query

A prompt can provide a query over server name, database name, memory settings, and physical memory, then show a row containing values such as 2000M and 6G. The resulting SQL uses common table expressions to convert units and calculate memory in use; review complex generated queries carefully.

How AI for Everyday IT covers it

How deep it goes
Explains prompt ingredients and demonstrates generated SQL, but stops short of guaranteeing correctness or covering query internals.
Examples
Demonstrates Oracle memory settings, M-to-megabyte conversion, G-to-megabyte conversion, and total-memory calculations.
What it assumes
Assumes a basic query, schema, or data dictionary, while helping newcomers organize an unclear database request.
What you can do after
Apply it via a chatbot to request better-contextualized database queries and inspect the resulting SQL before use.
How it connects
Connects prompting with instructing, database schemas, data dictionaries, DDL, sample output, and SQL queries.
Cover of AI for Everyday IT
liveBookmanning.com
Read AI for Everyday IT on liveBook Get the book at manning.com

This explainer was generated by Manning's knowledge graph from the text of AI for Everyday IT. The section links point to the parts of the book it draws on.