What's New in Version 4.5?

• PostgreSQL RDBMS Support - ScreenAble Solutions is excited about adding this advanced open-source database system to our list of supported relational database management systems. With 75 tables, 17 views and 95 stored procedures currently in ScreenAble's database schema, this was not a small task. However, we believe that this addition will greatly expand our potential user base. The widespread use of PostgreSQL in AI and various web services has rapidly improved its capabilities and user community resources. As with Oracle and SqlServer, we offer consulting services to support "best practices" for RDBMS administration.
• Substance_Lot Queries - The SUBSTANCE_LOT identifier in ScreenAble represents the specific sourcing of a test substance. Addition of this query class to the SearchAble interface will allow improved tracking of specific lots. Any of the three substance identifiers may be used in lot queries as a row-limiting option.
• Substance Registry Improvements - Major improvements to the chemical registration system of ScreenAble have been made. Several of these made possible by the adoption of an INCHI-centric treatment of text-based molecular descriptors. Molecular information is supplied to this system using either INCHI or SMILES string formats. When available, the string is used to populate the mol_formula, canonical smiles, mol_file, inchi and inchi_key molecular descriptor fields of the SUBSTANCE table. Although a SUBSTANCE_ID must be unique, it has always been possible to register a molecular structure to more than one identifier. While there are valid reasons for doing this, in many cases it happened because the system had no easy way to check this condition. The inchi_key field remedies this and now warnings with a count of prior usage are generated. If desired, previous entries can be specified during the review process. It is also now possible to specify new substances using data supplied to the substance_lot records.

As always, ScreenAble Solutions is committed to providing its Customers with the best technology available for their Discovery Screening analytics. Watch this space for future developments!