Pick has emerged into the mid '90s with a powerful, open, production-level database management product that stands alone and is no longer tied to a proprietary operating system.
In D3, Pick has built a remarkably open, high-performance, nested relational MDBMS (multidimensional database management system) balancing the need of business users for OLAP (On-Line Analytical Processing) and generalised decision support, as well as on-line transaction processing.
D3 Server Release 7.0 is a multidimensional database management system designed to deliver high-performance database management on UNIX, NT, and Windows 95 platforms.
It is virtually indisputable that D3, as a production-level general-purpose database, supports the largest number of users on a single processor.
Compatibility features accommodate code and syntax written for both legacy Pick and "Pick-like" systems, going so far as to allow their code to coexist together.
Pick's extensible Open Systems File Interface provides the capability to quickly pull together vast amounts of non-Pick data from production sources, using the distributed power of D3 as the host environment.
Applications can be built melding together D3 and non-D3 data on either a local machine or over the network. In fact, an ODBC based client can make a single call to a D3 database which, in turn, can transparently access data from Oracle or any other SQL-based database.
The forgiving nature of the system tolerates inefficient use of the file structure. It was amazing to see how well a D3 database functioned even when poorly designed.
The D3 implementation on Windows NT and Windows 95 provides client and server functionality as well as the ability to define a fully distributed n-tier processing environment. In a distributed D3 environment, data is spread over a network with application modules consisting of existing Pick and newly written FlashBASIC and 32-bit Visual Basic 4 (VB4) code, executing on both local and remote business servers. Using Microsoft OLE (Object Linking and Embedding), remote automation capabilities distributed applications are easily deployed. A set of Visual BASIC 4 objects and OLE custom controls (OCX) that ship with the database, combined with D3 's IDE (Integrated Development Environment) extensions facilitate quick, rapid development (RAD) of distributed client/server applications.
Support for popular operating systems, especially UNIX, Win95, and Windows NT.
Interoperability features that include support for SQL, ODBC, OLE, and DCE, when combined with Pick's long-standing experience in the UNIX market and D3 7.0's support for Windows NT and 95, combine to make it a solid contender for the short list of any business seeking an open, high-performance, economical, user- and administrator-friendly database management system.