When you're working solo, switching from disk to RAM is a huge win. But if you're sharing data with a team, the benefits go even further! Ask yourself one question about whatever database software you're using now...
Outdated Client/Server Network Model?
When you're working solo, switching from disk to RAM is a huge win. But if you're sharing data with a team, the benefits go even further! Other database programs use a centralized server approach to sharing data, an approach that fails to take advantage of the computing power available on the network. In contrast, the Panorama Enterprise Server system uses a mesh/synchronization approach to spread the load across the network while dramatically slashing the delays usually associated with many common database tasks.
The Enterprise system works like a formation of fighter jets teamed with an aerial tanker. Instead of hoarding all of the data on the central server, the Enterprise system distributes complete, redundant copies of the shared data across the network mesh. Operations that don't involve other clients (searching, sorting, analysis, reports, etc.) are performed independently at lightning speed in each client's local RAM. The server is only involved for coordinating data flow across the mesh, managing record locking and updating clients as necessary. Only changes flow across the mesh, lightening the load on the server and network. Just as fighter jets detach to perform their missions, a Panorama client can even disconnect from the network and continue working even when completely offline and detached — perfect for road warriors. Each user's offline changes are synchronized automatically when returning to the network.
(with a Disk Based Security Blanket)
The Panorama Enterprise Server is RAM based for blazing speed, but it also keeps a disk based transaction journal for full data recovery after any kind of system interruption (power failure, etc.). The transaction journal is a simple sequential file with minimal impact on performance.
Every Panorama client keeps a full copy of each open database in RAM for fast searching, sorting, reports, etc. The server only gets involved when data is modified, managing record locking and updating clients as necessary. This increases performance two ways:
Panorama Enterprise Server is powerful, but it's also easy to setup and use. Installation and initial server configuration usually takes less than five minutes, and once set up, the server can easily be monitored and managed from any client on the network. Creating custom Panorama databases is so easy that anyone can and has done it: business owners, teachers, pilots, researchers, musicians, writers, volunteers and many more. Once you've created a database sharing it on the server is super simple — three clicks and you're done!
Traditional client/server systems are completely inoperable without a network connection. Panorama gives you the option of roaming off-line while still retaining access to your databases for browsing, reports and even modification and updates. In other words, users can view and edit databases even when they don't have a network connection — ideal for road warriors. Offline changes are automatically synchronized with the server when the client re-connects to the network. Because both client and server are RAM based this synchronization is extremely fast. If there are any synchronization conflicts (same record edited both offline and by another user) they can be resolved automatically or manually on a field-by-field basis.
Panorama's WYSIWYG form design tools can automatically build HTML/CSS forms for database web access and upload them to the server. Many common web database applications can be built with no programming at all. For fully customized applications, Panorama provides a comprehensive programming language that includes rich text and tag manipulation capabilities. Server side programs are automatically uploaded to the server and a built in simulator/debugger allows developers to debug programs on their development machine before they are uploaded.
When publishing database content on the web the Panorama Enterprise Server works as a back end to the built-in industrial strength Apache server included with OS X and OS X Server. No modifications to the Apache configuration files are required. (You can also use any other UNIX web server that supports Apache style CGI's.)
Panorama Enterprise brings web hosted data right to you desktop. Working with web data couldn't be easier — database changes made on any client (for example price list changes) immediately show up on the web server, while changes made via the web (for example incoming shopping cart orders) automatically show up on client desktops. No extra programming for database maintenance is required - authorized users work with Panorama's intuitive user interface to access and edit web published databases just as if those databases were on their local computers.
In a mission critical environment testing must be kept separate from your live production servers, but once testing is complete you'll need to rapidly and accurately "clone" programming changes to the live server. The Panorama Enterprise Server automatically handles all of this for you. You can easily set up cloned database pairs, then automatically transfer programming changes when ready. All testing is done on a safe sandbox server, with data kept completely separate from the production environment. Once revisions are tested and ready to go, Panorama Enterprise Server will take care of transferring the changes for you. This can even be done without taking the live production server off-line — no downtime at all! (Note: This feature requires the purchase of two copies of the Panorama Enterprise Server software.)
All Panorama Enterprise Server configuration and managemant can be handled remotely from the anywhere in the world — you never need to physically touch the server. Adding and removing databases, updating program logic and graphics, managing security, changing server options, it's all done with easy to use GUI wizards built into every Panorama client. (Of course only authorized administrators are allowed to perform management functions.) For web applications, Panorama Enterprise Server also supports Google Analytics, making it easy to learn about where your web visitors come from and how they interact with your site.
When hardware or software problems occur, Panorama Enterprise Server works to make sure that downtime is minimal. To make sure that you're in the loop, the server can automatically send e-mails to notify you about any problems. The server automatically recovers after any kind of system interruption, bringing all databases and sessions right back to where they were. The Panorama Enterprise Server also includes built-in first level backup that automatically backs up "live" databases without shutting down the server. (Databases are backed up to a local drive. We recommend a secondary backup system to make offline copies of the data.)
We're making some pretty bold claims for Panorama's revolutionary RAM based approach — it will save you money, help you work faster, promote teamwork both in the office and in the field, all while reducing frustration. That all goes double when you're on a tight deadline. But don't take our word for it — download the fully functional extended trial version and see for yourself!
Go ahead, the keys are yours! Build one database or a hundred - there's no limit to the size or sophistication of the applications you can build. Create forms and reports, import data, write programs ... you can even set up a server and share databases on your LAN or even across the web. Everything you need is included — both client and server software, documentation, and dozens of example databases. See for yourself what it feels like to push the RAM based data accelerator pedal all the way to the floor!