Panorama combines the best elements of database and
spreadsheet technology into a single package, making
it an unparalleled tool for working with and
analyzing any kind of information. Like a
spreadsheet, Panorama is RAM based for speed and
flexibility, but with all of the data processing
power of a full blown database application. The short
video below demonstrates the benefits of this hybrid
database/spreadsheet technology in action. After
watching the video, download the
Panorama free trial and experience it for
yourself !

Panorama's unique hybrid database/spreadsheet
technology is perfect for any application that
requires storing, organizing and analyzing
information. Since 1988, customers all over the world
have been using Panorama for a wide variety of
applications — everything from custom accounting and
office management, medical research, project
management, event organizing, even managing thousands
of visual effects in blockbuster Hollywood
productions. Panorama scales from affordable single
user versions for individuals to large mutli-user/web
applications. Key features of Panorama include:

Lightning Fast RAM Based Speed— Like most spreadsheets,
Panorama bypasses the hard disk. All time sensitive
operations are performed completely in RAM,
including sorting, searching, analysis, data
restructuring, import and export. As a result, many
operations can be completed over 10,000 times
faster than disk based products, including normally
time consuming operations like splitting and
merging fields.

Super Efficient—
Panorama databases contain no indexes, so they are
extremely space efficient (high speed RAM operation
makes indexes unnecessary). In fact, Panorama
databases can typically store over 10,000 records
per megabyte of RAM, allowing Panorama to easily
handle databases up to several million records (the
exact capacity depends on the average amount of
data per record).

Live Preview—
When setting up a search, analysis or data
manipulation, Panorama instantly previews the
results as you type and click. The preview updates
in real time, so you can quickly and easily see how
different options interact with your actual data.
You'll see in advance exactly what's about to
happen to your data, so there are never any
unpleasant suprises after you press the Apply
button.

Deep Searching—
Panorama can easily search all fields in a database
or any combination of specific fields. Text fields
can be searched for complete or partial matches, or
even searched phonetically (for example Name
soundslike Guiterrez). Numbers and dates can be
searched using a variety of comparisons (equal
to, greater than, less than, within 10%, before,
after, by month, by year, etc.). Multiple
searches can be combined for very specific results,
and for advanced searching boolean formulas can be
included (for example Debit > Credit *
2.5). Your favorite searches can be stored for
later use, and of course for any search option, the
results are live previewed in real time as you
type. (Bonus: Right clicking on any
data cell pops up a menu with options for quickly
showing data similar to the current cell, for
example same name, same amount, same month,
etc.)

High Data Malleability— Panorama allows huge data sets to be
bent, reshaped or refactored at will. Fields can be
added, removed, rearranged, hidden, merged or split
at any time. Entire datasets can be rapidly altered
based on parsing/manipulation rules set up from
pop-up menus (advanced users can also use arbitrary
formula expressions). Typical examples include
swapping first and last names, extracting area
codes, removing extraneous punctuation, shifting
all or part of a field to upper or lower case, or
splitting combined addresses into separate city,
state and zip fields. Multiple parsing/manipulation
rules can be chained together for complex
transformations, and sets of parsing/manipulation
rules can be saved for later re-use. The effect of
all parsing/manipulation rules are live previewed
in real time as they are changed (actual database
manipulation occurs at 10k-50k records per
second).

Interactive Analysis—Panorama tools for interactive data
analysis include data outlines, crosstabs (pivot
tables), and charts. Data outlines are a unique
Panorama feature that summarize raw data in a
multi-level outline, with each higher level
corresponding to higher level categorizations of
the data (for example Date (by month) ->
Department -> Employee or State ->
City). The outline is interactive, so it can be
collapsed to show overall trends or selectively
expanded to reveal specific details at lower
levels. Summary levels in the outline can be
further processed by sorting or selection, make it
easy to answer questions like who were the top
five sales associates in each region last
quarter? or which sectors are growing the
fastest internationally? The outline
specifications can be changed at any time for
different analysese.

Flexible Import & Export— Panorama can transfer data
directly to or from spreadsheets (Excel or Numbers)
by drag and drop (Mac only) or via the clipboard
(Mac or Windows). Data can also be imported into
Panorama from text files (CSV or tab separated),
files containing HTML tables, and files in several
financial data formats (QIF, QFX and OFX).
Supported export formats include text files (CSV or
tab separated) and HTML. Data can be automatically
restructured as it is imported or exported to match
up with external programs (for example
re-arranging, merging or splitting fields as the
data is imported or exported).

Assisted Data Entry— With features like Clairvoyance™
(auto-complete), automatic capitalization, input
and output patterns, duplicate checking and default
values, Panorama can help make data entry a much
less tedious and error prone process. Panorama's
unique smart date feature allows input of
human friendly dates like today,
friday or last monday.

Fully Relational—Panorama's relational model supports one
record-to-one record links, range-to-one record
(shipping and tax tables, for example), and one
record-to-many records.

Drawing Tools—
Panorama's object based drawing tools allow you to
rapidly design and create windows, forms, labels,
custom reports, and web forms. Forms can be
customized with pushbuttons, checkboxes, radio
buttons, pop-up menus, lists, matrices, images and
movies, and you can also easily create elastic
forms that adjust automatically as the window
size changes.

Fully Programmable and Extensible— Automate repetitive tasks
by simply turning on Panorama's built in script
recorder. Recorded scripts can be played back at
any time, and can also be modified with a built in
script editor. Advanced users can customize scripts
using Panorama's extensive (and extensible)
programming language and debugging tools, and
scripts can also include embedded code written in
one of six popular scripting languates (AppleScript
(Mac only), shell scripts (UNIX or DOS), Perl,
Ruby, Python or PHP).

Crash Proof—
Panorama's Total Recall feature protects
your vital data from power failures and system
crashes. When Panorama is relaunched after a crash,
everything goes right back to where it was. All
databases, windows and variables are restored to
where you left off, so you can get right back to
work as if nothing had ever happened. If anything
goes wrong, we’ve got you covered - the most you
can lose is a few seconds of work.

Goof Proof— To
help protect you from yourself, Panorama keeps
snapshots of database history over time. Unsaved
changes can be immediately reversed with the
Revert to Saved command. For mistakes or
wrong turns made further back, the Time
Lapse feature can "roll back" the database to a
previous snapshot from minutes, hours, days or
weeks ago. You can even compare different snapshots
of a database to see how it has changed over hours,
days, weeks or months. (Time Lapse is
similar to Apple's Time Machine feature, but
is fully integrated with the database and keeps
snapshots based on database activity, rather than
at fixed intervals.)

Multi-User/Web Applications— Panorama Enterprise Server uses a
unique distributed mesh client/server
architecture that eliminates server and network
bottlenecks and allows off-line database
operation. The system keeps duplicate data sets
on the server and each client, with the server
managing synchronization and record locking. The
server handles data modification only, while
operations like sorting, searching and analysis
are performed in RAM on each client. Off-line
clients can access and (optionally) modify the
database, with automatic synchronization when
reconnecting to the server. The Panorama
Enterprise Server web publishing option works
with the Apache server on OS X or OS X Server to
allow access to Panorama databases from any web
browser.