First steps

Tables

The dlexDB query interface page starts up with the query form for the Annotated types table. If you would like to query any other table, please select it from the table selection panel. Please read the documentation on tables to learn more about the contents of dlexDB's tables.

Query modes

There two basic ways to query these tables:

  • Filter query: With the filter query interface, you can browse through the table page by page, and apply one or more filters to reduce the results set. Thus you can retrieve a set of words with certain properties from dlexDB. The filter query interface is also the way to go if you want to look up just one word and get some information about it from the database.
  • List query: Let's say you've already compiled a list of words (e.g., your own research corpus) and you need to get some information from dlexDB for each token. Then you should upload your list to the list query interface (or enter it manually) and retrieve it back supplemented with the dlexDB variables you choose to see.

By default the query interface starts in filter query mode. If you would like to do a list query, please select List query from the Query mode selector on the right hand side below the table selection.

Filter query

In the center of the screen, a first query filter is shown. If you are working on the Annotated types table, this default filter is the Type filter. You can leave this filter empty for the moment and run your query by clicking Execute query.

Whenever you have executed a query, the results table appears right below the query filters. You can browse through this table page by page, choose another column for sorting (ascending or descending), and close columns that you don't need. Without any filters, the results table is identical to the base table – that is about 2.7 million rows for the Annotated types table.

The Type filter is one of the most common filters. Please enter a word to find entries with an orthographic form exactly matching your input. The result set will be only one row, or several rows if there's more than one part-of-speech tag for this orthographic form. In the case-insensitive query mode, there will be even more results.

With the Type filter, and with all other string input fields as well, you can use regular expressions. dlexDB recognizes your input as a regular expression if it is surrounded by slashes (/). For example, with /ein/ you will get all words containing /ein/, and with /^ein/ you will get all words beginning with ein. Please find a short introduction to regular expressions here.

Depending on which base table you are working on, dlexDB has many more filters to offer. Please find these in the tree structure (Filter selection) on the right hand side of the window. By clicking a checkbox you can activate a filter so that it will be displayed in the center of the window. However, as long as you have not entered any values in the input fields, the filter has no effect.

Using the Filter selection tree, you can also select additional variables only for output, without applying filters on them. Please activate the eye symbol in the tree next to the respective filter. After re-running your query, the selected variable will be shown in the results table as an extra column.

Please find more information here: