Valentina Office Server description
Valentina Office Server is an incredibly fast business ready database server.

Valentina Office Server is an Incredibly Fast and Robust application The reason why Windows and Macintosh developers have used Valentina technology for years. Its fast, fast, fast, even when handling millions of records.

Office Server doesn’t care if it’s serving your internal network or your website – its serving you! No artificial IP address limitations. No artificial limits on the number of hosted database files.

Office Server is not priced by processor, “user CALs” or other non-standard forms that make you think you are overpaying. Office Server is priced by numbers of unnamed connections, or with unlimited connections with Office Server Unlimited.

Easy to Set Up, Query and Administer on Your Network. A free copy of Valentina 2 Administrator is included with every commercial copy of Valentina 2 Office Server. Beta versions of VS.Admin are freely downloadable by anyone.

Your IT people can use plugins to build custom solutions for use with Office Server. Every popular development tool on Windows and MacOS X is supported! Use multi-platform tools like Java, REALbasic, Director and Revolution to deploy clients on any desktop or server apps running under Windows or MacOS X. Deploy clients on one platform, and Office Server on a different platform.

ValentinaSQL is SQL92 compliant, which means you can query your databases using SQL, the common language of databases. If your IT team has any experience with databases, they can leverage everything they already know to get going with Office Server.

Here are some key features of "Valentina Office Server":

· Easy to Use
· Easy Installation - Valentina Server is distributed with an installer for Mac OS X and Windows (2000, XP, Vista), making installation as easy as few mouse click.
· Easy Configuration - with the help of ini-file you can change parameters and configuration of any Valentina Server.
· Auto-IP Configuration (Bonjour) - Valentina Server registers self in the Bonjour Service if it presents on the computer. After this any VClient can do auto-configuration of IP.
· Low Cost-of-Ownership - easy to use GUI tools, overall intelligent design of Valentina Server makes its administration to be easy task eliminating the need in expensive consultants and database administrators.
· Power
· Speed - Valentina is blazingly fast - comparisons with most popular database servers indicate at least a 3-5 times advantage for Valentina, and in some categories up to 10-100+ times faster.
· Multi-threaded Design - Valentina Server incorporates the most advanced and effective threading model based on the “pool of threads”. In contrast to “thread per connect” model it provides a better performance when a lots of connections present.
· Event Scheduler - you can create EVENTS scheduled to be executed once or periodically. An event can be any SQL command, e.g. “BACKUP DATABASE” or stored procedure.
· Hot backup - you can scheduler backups of database(es) using event Scheduler of Valentina Server.
· Triggers - Valentina SQL has triggers. This allows you to develop logic and reduce network traffic.
· Stored Procedures - Valentina Server supports stored procedures according to SQL standard with some extentions. This allow you to keep business logic on the server and reduce network traffic.
· Network Protocol
· Packet Based Protocol - in contrast to many DBMS products, VServer uses a packet based protocol. This design allow solve in elegant way few tasks such as compression of packets, versioning of command packets, auto-generation of sources.
· Versioning Of Commands - Valentina protocol signs each command by a version. This allows to have very flexible mechanism that allow work newer/older clients with newer/older servers.
· Compression of Packets - VServer/VClient are able do auto-compression of any packet that is greater of some size (1Kb). This significantly increases performance because affect many commonly used case-sensitive operations, e.g. client-side cursors.
· Compression of Pictures - although the Valentina protocol includes compression of packets, it can achieve even better results for pictures as each VClient is powered by algorithms to compress OS bitmaps.
· Connection
· Disconnect on Client Idle - Valentina Server can disconnect a client that has idle longer than the timeout specified in the ini-file.
· Secure Connections (SSL) - to enable SSL, just specify in the ini file the SSL port and provide the two keys that Valentina Server will use.
· Any Encoding of Connection - while not each language/IDE supports UTF16 directly, you will have UTF8 or ANSI strings. With Valentina Server this is not a problem since it can handle a client connection in any encoding.
· Easy Administration
· Valentina Studio - this advanced application allows you to connect to Valentina Server and achieve whatever you need in an easy to use, visual paradigm: browse/modify schema, browse/modify records, execute SQL queries, administrate users, see server info, change server parameters,
· Development Tools
· Interfaces - you can access Valentina Server using any API/IDE that Valentina supports: C/C++/C#, Objective-C, COM, Director, .NET, PHP, REALbasic, Revolution. The same server can manage different clients from different platforms, simultaneously.
· Client-side LogFile - all Valentina ADKs can produce log files during your calls to ADK methods. You can see as detailed output as parameters, return values and error codes.
· Server-side LogFile - allow you monitor execution of VServer. You can assign in the ini-file VerboseLevel of log file to control how many output will be generated.
· Live Mode - you can run Valentina Server from terminal (MAC) or command window (WIN) to be able see live mode log messages. Very useful during development.
· Warning LogFile - one more (optional) log file that collect information about not fatal errors during work of engine AND profiling of SQL commands that allows you to see a bottleneck in your queries and improve them.
· PRINT expr – you can use this SQL command to do debugging printing of any expression from e.g. a stored procedure.
· SQL Cursors
· Client-side Cursors - for queries that return small result you can use client-side cursors (read-only) that copy found data into memory of client computer and free server.
· Server-side Cursors - allow you create result of query on server side without moving of Megabytes of data via network into client memory. Multiple cursors can be opened and used simultaneously by each database client.