DDBSP Basic Package: Data Storage, Retrieval, Plotting and Export
This essential component of the Dortmund Data Bank Software Package (DDBSP) provides data storage, data input editors, retrieval, graphical representation, import/export for all data banks including complete data directory and demo versions of all non-licensed data banks.
DDBSP Basic Package includes the full set of DDBSP programs except:
- pure component property regression
- predictive methods (UNIFAC, mod. UNIFAC, ASOG, PSRK, VTPR, COSMO-SAC, COSMO-RS(Ol))
- mixture data regression
- process synthesis tools
Other parts of DDBSP are included as restricted versions only:
- mixture data simultaneous regression Recval (superlight version with ideal and Margules models)
- pure component property estimation Artist (free version with several simple estimation methods)
It allows to build up in-house literature and experimental property databases as all software tools used at DDBST for input and data test are included. Private data banks can be used from any number of computers as long as these have access to a valid software license. Access to the data can be restricted to individual users and groups.
Major parts of the DDBSP - Basic Package are described below:
Dortmund Data Bank
The program Dortmund Data Bank allows to search for experimental data for specific mixtures or literature references. If the Predictive Methods Add-On is available, data can also be loaded from model predictions.
Instead of selecting the components from the DDB, process simulation files (Aspen Plus, ProII) can be selected and the component lists are automatically imported. The database query is entered into the following dialog:
- storage and retrieval of data to/from data files
- export to 3rd party software like Excel or process simulation software (via IK-CAPE-ppdx, Aspen inp format)
- 2- and 3-dimensional data visualization
- data output in form of tables
Data Editors for Pure Component and Mixture Data
Convenient data editors are available for pure component and mixture data as well as for supporting basic data. The following dialog shows the data entry program for mixture data:
Literature Data Bank LEAR
DDBSP contains the literature data bank software LEAR specifically developed at DDBST. Besides many other features it allows to easily link individual references to multiple files (e.g. pdf, xls, ...). LEAR can handle any number of data bank files. In case of the DDB literature data bank, LEAR contains more than 120,000 references. The following figures show a typical query result and the dialog for an individual reference:
Parameter Data Bank ParamDB
A multi purpose parameter data bank (ParamDB) is delivered with DDBSP-Basic Package. ParamDB can hold all kinds of single value or model parameter sets and contains export filters for process simulation software. As with other data bank files, a public and private data bank is used to separately store data sets of DDBST and customers. The following dialog shows a typical data set:
Interfacing via OLE/COM
A large part of the functionality of DDBSP can be called from other programs via the COM interface. It is thus simple to select compounds from Excel using the standard compound selection dialog of the DDB and to import the different pure component properties for user specific calculations. Artist property estimations for all properties and models are available via simple calls from e.g. Excel VBA.