Valentina Studio Manages Complex Data Easily
Valentina Studio Admin is one tool that lets you accomplish so many things with your data, quickly and easily. Valentina Studio covers all the bases in managing both local and remote database operations. This must-have development utility is available on Windows and Mac OS X.
Valentina Studio Admin is the one tool you need to work with your databases- locally and on a remote server. Valentina Studio Admin lets you manage Valentina databases at the highest, administrative level, as well as at the lowest level of browsing and editing records and modifying database properties.
- Set Up and Connectivity Tools. You can easily import existing databases for conversion to Valentina using XML, text of ODBC connectivity, create new databases and set custom parameters using property inspectors, create, modify and drop tables, fields and calculated fields. Do it all locally or on a remote server - on Windows and Mac OS X.
- Visualize Your Data. Built in diagramming works you work with relational and object-relational data in a more meanful way. Valentina Diagrams make it easier to move to the Valentina database model.
- Run Complex Queries Easily and Securely. Use the visual Query Builder to build complex queries, store your scripts for later execution and more. Supports SSL connections to database servers and managing encrypted databases, tables, fields. Work with views, triggers and stored procedures easily.
- Get at Your Data. Browse your data easily in a spreadsheet view, preview stored pictures, edit multi-line text. The unique Related Data Editor lets you easily get to linked records in one mouse click and do SET operations on the linked records.
- Administration and Utility Tools. Work with remote Valentina Servers and register/unregister databases, add/remove users and check server status. Clone, duplicate, defragement, reindex and diagnose databases easily. Execute SQL and XML data dumps.
Top Ten Features of Valentina Driven Solutions
- Cross-Platform. Available on Mac OS X (PPC and Intel), Windows and Linux.
- Valentina SQL. SQL 92 and 2003 secifications + object extensions
- Supports Every Major Tool. Every major development tool has a native driver.
- Modern Database. Object-relational in synch with modern programming paradigms and highly customizable file format.
- Well Supported. Online documentation, loads of example code and free community mailing list.
- Ultra-Fast Database. Benchmarked in the field between five to hundreds of times faster than comparable products.
- Best Unicode. UTF-8 and UTF-16 native formats for best international support.
- Super Secure Encryption. 448-bit Blowfish encryption.
- Locked or Unlocked Media. Locked media -CD/DVD/HDVD or unlocked, local and server capable..
- XML/Text Import/Export. XML for data and schema.
- Add Views | Properties | Procedures Menu, Buttons and Dialogs. You can now accelerate your development by quick access to creating new Views, Properties and Procedures from the tool bar or through menu items Add View, Add Property, Add Procedure.
- Database Diagramming: Search. You can now search for terms within a database diagram using a Search field, and go to the result.
- Database Diagramming: Print Diagram. You can now print (to a single page) the current diagram.
- Database Diagramming: Save Diagrams to Different Database. You can now save your diagrams and import them into other databases.
- Resizing All Columns in Column View in Schema Editor. You can now resize all of your columns at once in the Schema Editor Column View.
- Visual SQL Builder: Write Complex Conditions in a Single Filter Cell. Great productivity enhancer for working with complex queries.
- Server Properties. Valentina databases are becoming more object-oriented in order to follow modern programmatic trends. Using SQL, you can now read and read/write properties of a Valentina Server database.
The following properties are read/write properties:
- BACKLOG
- BONJOURENABLE
- BONJOURPROTOCOLNAME
- BONJOURSERVICENAME
- CACHESIZE
- DISABLEDNS
- FLUSHEACHDATACHANGES
- LOGTOCONSOLE
- LOGTOFILE
- LOGCONNECTIONTRAFFIC
- MAXCLIENTTIMEOUT
- PORT
- PORT_HTTP
- PORT_SSL
- SCHEDULEENABLE
- SYSTEMCATALOG
- SSL_CERTIFICATE
- SSL_PRIVATEKEY
- THREADS
- USEOLDPASSWORDS
- VERBOSELEVEL
The following properties are read only:
- CONNECTIONSAVAILABLE
- CONNECTIONSMAX
- VERSION
Group By with Roll Up. Valentina 3.5 and higher supports Group By with Roll Up - using the modifier Roll Up. Normally, when you make a Group By query, you get back data that you might otherwise need to query. For example, lets say you want to query your total sales for each month in a year. A Group By without this modifier would return a number for each month. A Group By with Roll Up can automatically return the total sales for the entire year.
OR with fields from different JOIN tables. OR between fields from different join tables is now supported, making such syntax possible: FROM T1 join T2 ON T1.id = T2.ptr AND T1.f > v1 AND T2.f4 < v3 ... WHERE.
SQL SHOW VKEYWORDS. Lists all keywords supported by the engine.
SQL SHOW VIDENTS. Lists current IDENTs of database. Used for auto-completion of Valentina Studio.
Improvements
The following issues reported by engineers and customers were improved or fixed in this release. You can get more detail by entering the issue number in our reporting system.
- 0002468: [Other] Clone under certain circumstances would have unexpected results.
- 0002771: [Join of Tables] Join on String Methods under certain circumstances would have unexpected results.
- 0002604: [Indexes] Initial search on index by words method can be slow.
- 0002716: [Triggers] "Before-update" trigger usage can have unexpected results.
- 0002748 | 0002703: [SQL] Stored procedures returns unexpected results in certain circumstances.
- 0002708: [SQL Nodes] Incorrect case results inside SP in certain circumstances.
- 002709: [SQL] "set var = select f1 from t1 WHERE false" can produce unexpected results in certain circumstances.
- 0002796: [SQL] Predicate in join clause should be applied strictly before join.
- 0002863: [SQL] max(length()) under certain circumstances would have unexpected results.
- 0002878: [Other] Set|Drop Primary Key for Server Connection. Fixed.
- 0002848: [Data Editor] Bring to front condition.
- 0002849: [Diagrams] Deleting fields in diagrams.
- 0002872: [Application Menu] File > Dump Database > XML layout.
- 0002866: [SQL Editor] Auto-completion on Mac OS X text.
- 0002661: [SQL Editor] German Umlauts on Mac OS X.
- 0002834: [Schema Editor] Finding more than one Bonjour databases.
- 0002833: [Schema Editor - Tree View] Open | Close Bonjour database.
- 0002822: [Diagrams] Comments wrapping issue.
- 0002816: [SQL Editor] Auto-completion on events.
- 0002775: [Property Inspector] Using illegal field names.
- 0002678: [Stored Procedures] Refreshing text of stored procedures.
- 0002735: [Import/Export] Loading SQL dumps from Valentina Server.
- 0002740: [Data Editor] Add records issue.
- 0002599: [Contextual Menu] Contextual menus on Mac OS X appearance.
- 0001569: [Application Menu] Schema Browser Column headers appearance.
- 0002736: [Other] Quit issues in specific circumstances.
- 0002714: [Other] Choosing Clear Recent files unexpected outcome.
- 0002672: [SQL Dictionary] Missing Entry.
- 0002739: [Schema Editor] Error on Drop Table in certain circumstances.
- 0002749: [VServer Admin] Unregistering a database in certain circumstances has unexpected outcome.
- 0002750: [Other] Closing a database in certain circumstances has unexpected outcome.
- 0002756: [Schema Editor - Column View] Fixed appearance.
- 0002670: [Events/Sheduler] 10-minute demo limit timeout message had unexpected outcome.
Existing users, 
Advanced Search
Reviews 
Troubleshooting 
Usage Tips 
Developer Notes 
Commentary 
Featured Reviews
Pete, good question.… - Version: 1.9.7, 2/25/2003 05:00AM PST 
