Dissolution methods database with BCS and BE v. 1.1 (beta)

contains data: USP dissolution methods, FDA dissolution methods, FDA bioequivalence references, TSRL inc Biopharmaceutical Classification System, USP Dietary Supplements dissolution methods, JP dissolution methods, Biowaiver monographs.

Manual

Search

  1. Start typing a substance name in the Search field.
  2. All available in the database substances will immediately show in a dropdown list.
  3. Select required substance form a dropdown list (use up/down arrow keys for select and Enter key for confirm selection or use mouse).
  4. Selected substance will be added to query and will be appeared under the search field as blue label.
  5. If you want to exclude any substance from the query then click on crisscross near required substance.
  6. Click on Search button or press Enter. The results will appear below and view will be scrolled to it.

Important change
Now by default for each selected substance the search retrieves from database only monoproduct entries. Therefore, you can search any number of substances simultaneously and get summary results. If you would like include combinations of selected substances, please, use sidebar filters as described in section Sidebar filters.

Example:
You selected Abacavir and clicked search → the received results will contain only Abacavir Tablets.
You selected Abacavir and Lamivudine and clicked search → received results will contain Abacavir Tablets and Lamivudine Tablets.

Sidebar filters

The sidebar filters divided into 3 groups:

  1. Search filters - control how to retrieve information from database. The options below allow to include in search the combinations of selected substances.
    1. Any combination for each substance - check this option if you want to find any combinations of each selected substance. This option can be used for one or more selected substances.
      Example:
      You selected Acetaminophen, checked this option and clicked search → the received results will contain Isometheptene Mucate, Dichloralphenazone, and Acetaminophen Capsules; Acetaminophen Capsules; Acetaminophen, Chlorpheniramine, Dextromethorphan, and Phenylpropanolamine Capsules etc.
    2. Any combination of selected substances - check this option if you want to find any combinations that include selected substances but not limited by them.
      Example:
      You selected Acetaminophen and Codeine, checked this option and clicked search → the received results will contain Acetaminophen Capsules, Acetaminophen and Codeine Phosphate Capsules, but will not contain Acetaminophen, Chlorpheniramine, Dextromethorphan, and Phenylpropanolamine Capsules etc.
    3. Exact combination of selected substances - check this option if you want to find only combinations of selected substances. Selection of this option will lead to disable of previous two.
      Example:
      You selected Acetaminophen and Codeine, checked this option and clicked search → the received results will contain only Acetaminophen and Codeine Phosphate Capsules, Acetaminophen and Codeine Phosphate Oral Suspension, Acetaminophen and Codeine Phosphate Tablets, but will not contain monoproducts and other combinations.
  2. Database filters - control from which database information will be retrieved. Just check/uncheck required databases. The search will retrieve information only from selected databases.
  3. Table filters - control hiding or displaying empty dissolution parameters. If you want to compact tables view just check this option; as a result, any parameter that contains no data will be hided. Consequently, table will have 10 rows instead of 15 rows or 3 rows instead of 8 rows. You can unhide these rows at any time. Just uncheck this option.

In-table filters

These filters work in tables with more than 1 search result. If table contains more than 1 entry the button Show filters will appear under the header of this table. After you click on this button special filter fields with dropdown lists will appear in table header cells. Such filter fields will contain only unique values from the particular rows. To filter data in table, please, follow next steps:

  1. Click on the button Show filters near the required table (after that the button will change to Hide filters). The filter fields will appear in table header cells (like this ).
  2. Click on the required filter field and toggle checkboxes of desired values. Data in table will immediately filtered.
  3. The number of filtered items will appear near the filter button with green-colored text. For example, Filtered 2 items.
  4. You can apply filters simultaneously to any number of fields.
  5. In order to clean or hide all in-table filters click on Hide filters button. The data in table will restored to initial state.

Usage of in-table filters is useful if you got too many results. In such case you can limit their number in-place without making a new query.

Statistics

On the tab "Statistics" you can review the database data as a graphical representation. To do so, please, follow the next steps:

  1. In the field Database select required database.
  2. In the field Database parameter select required parameter and click Get statistics button.
  3. The loaded data will be plotted as a diagram.
  4. Some parameters have a large number of single values; therefore, diagram comes in a very long view. If you would like to shorten diagram view, please, use the third field Cut off if entries less then. For example, set value to 5 and only entries that greater or equal 5 will be plotted on diagram.

Some considerations

The interface is mobile ready, so you can comfortably use it on your mobile phone or tablet.
The database was tested in all modern browsers (latest Chrome, Firefox, Edge and IE 11). Internet Explorer < 9 is not supported. Sorry, it is 2017 year now :) Use modern browsers!


Additional infromation

During database development, I found in USP and FDA databases some typing errors in drug names. I corrected them and highlighted by yellow color. In addition, I introduced some other small changes:

USP:

  • Added column DOSAGE FORM
  • Normalized all monograph names particularly words first letter capitalization

FDA:

  • Normalized all monograph names particularly words first letter capitalization, slash spaces
  • All dosage forms converted to plural form and normalized
Here you can download Excel file with USP and FDA dissolution methods databases with my corrections download file.

Some statistics

The database includes data from next sources:

  • United States Pharmacopoeia // USP 1660 entries
  • U.S. Food and Drug Administration // FDA 1274 entries
  • Japanese Pharmacopoeia XVII // JP 17 306 entries
  • FDA Bioequivalence References // FDA BE Refs 1498 entries
  • United States Pharmacopoeia Dietary Supplements // USP DS 63 entries
  • TSRL inc Biopharmaceutical Classification System // TSRL inc BCS 360 entries

Looking for more detailed statistics? Get it below.




Planned features

Current version is beta, so some errors or bugs can occur. If you found one please report these by e-mail (see About page). I have planned many additional features, which will be implemented step by step. So the development will continue. In the list below presented some future improvements.

  • Search filters for each database to retrieve information by additional fields like apparatus, test, dosage form, medium, speed etc.
  • Rendering of structure formulas of substances from BCS database.

If you have any considerations about new features and improvements be free to contact me by e-mail. I am looking for new professional opportunities and contacts.

Also, be free to share this database with you friends and colleagues!

If you would like to support database development please donate.

03.08.2017 - version 1.1 (beta)
  • Added USP Dietary Supplements database (from USP 38).
  • Added JP 17 dissolution methods database.
  • Added links to biowaiver monographs (for all available substances on FIP web-site).
  • Added in-table filters.
  • Added filter to hide empty dissolution parameters.
  • Added detailed statistics with diagramms.
  • Updated FDA BE Refs database.
  • Code refactoring. Templates moved to object.
13.07.2017 - version 1.0.2 (beta)
  • Updated USP database.
03.07.2017 - version 1.0.2 (beta)
  • Fixed bug in dropdown list behavior.
01.07.2017 - version 1.0.1 (beta)
  • Added USP, FDA and FDA BE db ouput sorting by dosage form (default).
  • Added formula formatting in BCS output. (press Ctrl+F5 in your browser after page load)
25.06.2017 - version 1.0 (beta)
  • Initial release.