Welcome Guest | My Membership | Login

Tech Tip: Accounts, Namespaces, and Databases in Caché


If you are migrating from another MultiValue system to Caché, an introduction to some key terminology differences would be useful.

Like all MultiValue systems, Caché understands the concept of an ACCOUNT. Each ACCOUNT contains a VOC or MD (the terms are used interchangeably). Users can be configured to automatically LOGTO an ACCOUNT when they login, and with permission, LOGTO other accounts. When they LOGTO an ACCOUNT, an optional user or LOGIN script can run.

Except in a few cases where traditional OS files are used, Caché stores most data, such as MultiValue FILEs, in OS files named cache.dat. These are referred to as databases, and can hold multiple FILEs. Databases automatically expand as needed and very efficiently store data in optimized B-trees.

Users typically access multiple databases simultaneously. For example, Caché ships with a database that contains our system code, another that contains the documentation, and a third for temporary data that may need to be written to disk. Developers typically store their code in one database and user data in another, or a few.

When you first import a MultiValue account into Caché, all data and code for the ACCOUNT are stored in one database (cache.dat). Separating your code and data into distinct databases is highly recommended and will make installation and upgrade of production applications easier. A Namespace is the Caché term for a collection of databases under one name. Using multiple databases this way achieves the same result as Q-pointers without having different ACCOUNTS. Please note that Q-pointers are supported as well. From a MultiValue perspective, a Namespace and an ACCOUNT are synonymous.


Social Media Login

Use your existing social media logins to access your Membership/Subscription information.

Existing Magazine/Newsletter Subscriber (Quick Access)

If you are an existing International Spectrum subscriber, but have not registered with the website, please enter the Reference Code found on the magazine or in the e-mails you receive from us.

Magazine Reference Code location

Spectrum Login

New Subscriber

If you currently do not receive the Magazine or other emails from International Spectrum, select the "Subscribe" button below to create an new membership account.


Find out more about the different between the FREE and a Professional Membership at:
Compare Account Options


# # #          # # #          # # #


Related Articles

  • From The Inside November/December 2011

    Company: International Spectrum

    It's the end of the year — time to relax, family enjoyment, gift giving, and time to start planning for the year 2012.

  • 2011 MultiValue Industry End-of-Year Recap

    The year 2011 continued to provide us with a number of challenges — changing economic conditions (improvements and setbacks), changing technologies, and changing market demands. But within all times of change there also exist opportunities. We asked some of our MultiValue partners to share with us some of their accomplishments from this last year and what to look for in the next.

  • Indexes and System Migrations

    When migrating a MultiValue application from one platform to another, especially from an older legacy platform to one that is more modern, the major goals are to simply get it done, get it working, and get it working correctly. Too often, however, we forget that the new platform may provide capabilities that can give us a dramatic improvement in the performance of our application. Replacing or supplementing application-based cross-referencing with system-supplied indexing is one of those areas to be considered.

  • Replacing Legacy Reporting with U2 DataVu

    Company: Rocket Software Database: UniVerse

    Dull, monospaced type, text-only reports usually provide the necessary information and get the job done. But just like the antiquated green screen programs, the appearance of these reports invokes a negative reaction from both users and management, creating an impression of obsolescence in an otherwise robust application. UniVerse and UniData users have a number of options for modernizing these reports, one of the newest of which comes from their database supplier, Rocket Software.

  • Session Management with PHP

    Company: Precision Solutions

    As you begin to develop webbased MultiValue applications using a browser as the preferred user interface, one of the first changes in your thinking process has to be how your application communicates with the user. Unlike a traditional dedicated connection between user and server, web-based applications must deal with an ongoing series of non-persistent connections. How does your application know what you and the user were talking about a minute or two ago? Using the built-in capabilities of PHP, this article explores some of the issues of such session management.

Return to top