Dissolution methods database with BCS and BE v. 1.2.3.2

contains data: USP dissolution methods, FDA dissolution methods, FDA bioequivalence references, Drug Delivery Foundation 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. Source filters - control from which source information will be retrieved. Just check/uncheck required sources. The search will retrieve information only from selected sources.
  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

Source name
Used edition // Abbreviation on site
Date of update/review Number of entries Source coverage (%)
Drug Substances and Dietary Supplements Names
- // -
2018-08-05 1317 -
United States Pharmacopoeia Dissolution Methods Database
USP 41 // USP
2018-08-12 1730 100%
U.S. Food and Drug Administration Dissolution Methods Database
- // FDA
2018-08-12 1317 100%
Japanese Pharmacopoeia XVII
JP 17 // JP 17
2017-08-03 306 100%
FDA Bioequivalence References
- // FDA BE Refs
2018-09-18 1635 100%
United States Pharmacopoeia Dietary Supplements
USP 38 // USP DS
2017-08-03 63 100%
Drug Delivery Foundation Biopharmaceutical Classification System Database
- // DDF BCS
2018-08-05 360 100%
International Pharmaceutical Federation Biowaiver Monographs
- // BW
2018-08-05 49 100%

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.

16.08.2018 - version 1.2.3
  • Updated FDA BE database.
07.08.2018 - version 1.2.2
  • Fixed JS load problem.
06.08.2018 - version 1.2.1
  • "TSRL inc BCS" was changed to "DDF BCS"
05.08.2018 - version 1.2
  • Updated USP, FDA, and Biowaiver Monographs databases.
  • Added the table with the detailed information on sources of the database. [Special thanks to Geoffrey Grove for the idea.]
25.08.2017 - version 1.1 (beta)
  • Updated FDA BE database.
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.