|
Ol� pessoal,
Este artigo foi publicado na
revista Visual Studio Magazine, � sobre o SQLBase 8.5.
o artigo pode ser lido no endere�o
http://www.fawcette.com/vsm/2004_03/magazine/departments/firstlooks/page3.aspx
ou abaixo:
Cut Database-Management Costs Posted January 12, 2004 Gupta Technologies' SQLBase 8.5 is a full-featured database management system for Windows and NetWare that focuses on reducing the total cost of database ownership. SQLBase comes with a full set of administrative tools and database-connectivity options. It implements standard SQL, including the SQL99 extended join capabilities. SQLBase integrates its administrative tools�a server-management console, a connectivity manager, and SQLTalk�into a unified SQLConsole utility (see Figure 1). SQLTalk enables you to pass SQL commands to a SQLBase database. SQLTalk also implements extended SQL commands for viewing server statistics, formatting SQL reports, and tracing stored procedures. SQLTalk is similar to SQL Server's Query Analyzer, and SQLConsole is similar to Enterprise Manager. SQLTalk and SQLConsole give you the tools you need to manage databases, but they require you to be more comfortable with SQL's Data Definition Language than you need to be when you use the Microsoft products. SQLBase implements far fewer functions through point-and-click interfaces than SQL Server. SQLBase supports SQL99 syntax, so it allows the NATURAL JOIN as well as the INNER JOIN and OUTER JOIN clauses. The NATURAL JOIN allows you to use a foreign key to join two tables without specifying the key in the clause. For example, if you use the Dept_Id foreign key to join Employee to Department, the NATURAL JOIN uses the Dept_Id key without requiring you to type it in. Gupta supplies a .NET data provider with SQLBase, as well as drivers for OLE DB, ODBC, and JDBC. The database is relatively easy to use from either VS.NET or VB6. SQLBase minimizes administrative and support costs in several ways. It extends its file sizes automatically when necessary. It's designed to recover from system failures automatically and maintain database integrity with minimal database administrator (DBA) intervention. SQLBase also provides a silent-installation capability that's ideal for integration with turn-key applications. Gupta Technologies' support staff is knowledgeable, prompt, and helpful. The documentation is solid, and SQLBase comes with a number of simple examples showing how to access the database within an application. All of this makes SQLBase ideal if you create standalone applications and want the capabilities of a full relational database without requiring your customers to hire DBAs. You might also want to look into SQLBase if you work with distributed systems. Its ease of maintenance and installation could be crucial in supporting an application that's deployed to numerous servers. You'll find yourself doing more scripting to create database objects, but this isn't a bad thing when you're creating multiple database servers. About the Author SQLBase 8.5 |
