Multi-Value, Pick, Raining Data, Tiger Logic

MultiValue database architecture means incredible performance, efficiency and reliability, and no one does it better than TigerLogic.

Formerly Pick Systems, the TigerLogic D3 database continues to mature and adapt to the current development environment in ways that create tremendous opportunities for existing and new users alike. With versions that run on almost any platform, including IBM AIX, Linux, Windows 2003 Server, TigerLogic has the multi-value solution to meet your needs. Zumasys is a premier TigerLogic reseller with more than 10,000 D3 users under support. Zumasys offers all of TigerLogic’s products, including the following:

D3--The D3 DBMS embodies the best and most desired features for developers and users. It is simple in its structure but allows for complex definitions of data structures and program logic. The built-in development environment allows applications to be rapidly prototyped, developed, and modified on the spot. Custom applications and on-site enhancements are common in the D3 community. Everything required for development is already in D3, making D3 much more than a typical database environment. Site administration requires a fraction of the staff of other environments of the same size - a large proportion of sites running D3 do not have an IT staff. D3 is developed and supported over the many environments indicated on these pages. All code and data easily migrates between environments without modification, so both developers and users can work on their platforms of choice. Other products from TigerLogic include connectivity tools like FlashCONNECT for web, the D3 Class Libraries, the Open Systems File Interface for Oracle and other environments, and XML technologies to exchange data with other XML-compliant programs or environments.

D3 9.0

mvEnterprise--The scalable solution for high-performance multivalue applications in UNIX. Quickly and easily port applications from other multivalue databases. Leverage the full capabilities of UNIX, with support for a wide variety of hardware peripherals and communication tools, including X.25, TCP/IP, uucp and Telnet. Improve multivalue performance with this efficient, high performance, scalable multivalue database. MvEnterprise® offers the ease of use and hierarchical power of the multivalue database model, with the performance and flexibility of UNIX. The Open Data Architecture and UNIX interoperability tools provide a seamless interface between mvEnterprise and UNIX. mvEnterprise features many enhancements for high-performance, effective administration and compatibility with other multivalue environments, providing a near-seamless migration from R83, OA, Ultimate, PRIME, REALITY and others

mvBase--The high-performance path for migrating multivalue applications to Windows NT/2000/XP Professional. mvBase for Windows is the database environment that offers the easiest high-performance path for MultiValue database developers and users to move their applications into a Windows Client/Server environment. mvBase is a multivalue-compliant Windows database environment which makes the migration of multivalue applications to a Windows client/server environment fast and easy. mvBase offers a high-performance multi-dimensional database engine including such features as multi-valued field and unlimited item size providing maximum flexibility for data organization. B-tree indexing provides enhanced performance for sorting and selecting data from BASIC applications.

Hot Backup:

Where system failure is a major concern, it is very important to incorporate IT strategies that significantly limit downtime. Hot Backup or Fault Tolerance solutions can dramatically reduce the financial costs involved as well as help protect a company’s valuable reputation.

Hot Backup is a D3 Unix software feature, which utilizes the D3 traditional transaction logging facilities. Selected transactions are transferred to the secondary D3 server, which acknowledges and processes the transactions, maintaining a copy of the database, ready to handle the workload should a system failure occur on the primary D3 server.

A secondary D3 server is required to be the same specification as the primary D3 server. Hot Backup’s secondary D3 server can be in any location, where a reliable TCP/IP (an industry standard communications protocol) network connection can be made between the two servers. If the primary D3 server fails, users can be switched immediately to the secondary D3 server, minimizing downtime to just the time taken to re-establish the users terminal connections on the secondary D3 server.

With Hot Backup, downtime can be virtually eliminated; the only possible data loss would be to the updates, which have not been successfully acknowledged by the secondary D3 server at the time of the system

TigerLogic D3 9.0 and mvBase 3.0:

The upcoming major release of D3 9.0 and mvBase 3.0 provides ease of integration for both .NET and Java development environments. D3 9.0 and mvBase 3.0 are free to any customer under a current Software Maintenance Agreement (SMA).

D3 9.0 and mvBase 3.0 will have the following functionality:

  • .NET API
  • Java API
  • XML for Multi-Valued Data
  • D3 Windows Hot Backup
  • Customer Requested Enhancements

.NET API for Multi-Value Data
This is a simplified .NET API that allows developers to build applications using the latest versions of Visual Studio .NET. This API can be used to develop applications in any Visual Studio .NET development language, including C#, C++ and Visual Basic.

Features include:

  • Supports the latest versions of Visual Studio .NET (2005 and above)
  • Execute a TCL command and capture the results
  • Execute an AQL query and return the results in a structured array
  • Call a Pick/BASIC subroutine and invoke a Windows application upon return
  • Support for file read, readu, write, writeu, delete, release, select, readnext, root, key
  • Support for multi-value functions: count, dcount, delete, extract, field, swap, insert, replace

Java API for Multi-Value Data
This API allows Java developers to build applications using their preferred Java IDE.

Features include:

  • Execute a TCL command and capture the results
  • Execute an AQL query and return the results a structured array
  • Call Pick/BASIC subroutines
  • Support for file read, readu, write, writeu, delete, release, select, readnext, root, key
  • Support for multi-value functions: count, dcount, delete, extract, field, swap, insert, replace

XML for Multi-Value Data
Exposes and processes your multi-value data as XML, utilizing TigerLogic's XDMS technology. The full potential of the XDMS product and its features can be utilized to map and retrieve multi-value data in XML, integrate multivalue data with other data sources, cache multi-value data and Web services to off-load backend database servers and support multi-value Web services.

Features include:

  • Provides XML views of multi-value data
  • Default XML mapping using existing Attribute Definition Items
  • XML schema mapping
  • TL XDMS XQuery engine access to multi-value data
  • Retrieval/update of multi-value data as XML
  • Calling Pick/BASIC subroutines as XQuery functions
  • Support for XQuery stored procedures
  • Support for Web services
  • XML persistence of multi-value data
  • Full-text indexing and searching
  • Multi-value data and Web service caching
  • Data integration with other applications

Additional D3 9.0 Enhancements

D3 Windows Hot Backup
With D3 9.0, D3 Windows will support the capability to replicate the D3 Windows FSI to provide a standby server for failover recovery.

Graphical Administration Console
A graphical administration tool for D3 9.0, built using the new .NET API:

  • Supports pluggable dlls so console can be extended without complete rebuild
  • Distributed with both client and server side source code to allow for further customization

Access Query Language Enhancements

  • U2 Compatible AQL Enhancements:
    • fmt – Changes the output format of a column on the fly (justification and width)
    • eval – Evaluate an expression on the fly – including translates
    • conv – Applies a conversion on the fly
  • Support for numeric indexes provides higher performance when selecting numeric data when using the >, >=, <, <= and # operators

D3 Windows Enhancements:

  • Login support for Windows authentication
  • Windows only printers
    • Supports the ability to use the graphics supported in the Windows Printer API

Additional mvBase 3.0 Enhancements

Basic runtime error logging

  • Global switch to turn logging on/off for all lines

Overflow CLAIM command

  • Recovers blocks of contiguous frames from linked overflow space

Enhanced TCL stacker to support arrow keys

  • Feature can be enabled or disabled on a per process basis

Windows only printers

  • Supports the ability to use the graphics supported in the Windows Printer API