Databases
StackOverflow2013
Postsdbo
POMySQL/Maria build view matching abbreviations to full description
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMySQL/Maria build view matching abbreviations to full description
    primarykey
    data
    text
    <p>First, i do not control the data i'm managing. It comes in from a client in a spreadsheet &amp; i'm making what i can of it. i'm actually taking a tangled mess &amp; trying to normalize it as best i can.</p> <p>i'm using MariaDB 5.5.30, InnoDB table formats.</p> <p>One of my project requirements calls for an item description, which is comprised of "standard" abbreviations (at least within their company), to be presented in search results. Users may not know all the abbreviation definitions, so their initial idea was a separate search box to look up an abbreviation. Instead, i'd like to let the user hover/click on abbreviations in-line and see a tool-tip of the definition.</p> <p>i know this would involve a view of some kind that matches abbreviations within the description to the abbreviations table to get the definitions. i'm also aware of the overhead this potentially creates.</p> <p>i'm looking for suggestions for a relatively efficient way to do this (view, routine, etc.). Even if it means building a static table tying the item to records providing the definitions...</p> <pre><code>| ITEMS | |--------------------------------------| | Item ID | Desc | |--------------------------------------| | 1 | CHOC CONG DR DRP 18" 25ct. | |--------------------------------------| | ABBREVIATIONS | |----------------------------------| | Abbr ID | Abbr | Definition | |----------------------------------| | 1 | CHOC | Chocolate | | 2 | CONG | Congestion | | 3 | DR | Delayed-Release | | 4 | DRP | Drops | |----------------------------------| </code></pre> <p>Abbreviations can appear in the Item Description in almost any combination. Only the pieces of the description matching an abbreviation would have a tooltip. Unfortunately, some abbreviations are multiple words and others are shorter than 4 characters.</p> <p>If doing this would be painful for performance, i'm willing to go back to their original idea. But in the interest of a unified interface, i thought this would be nice.</p> <p>Any (constructive) suggestions are appreciated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. UScautionbug
    1. UScautionbug
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload