Structure Query Language Base 5.0 from Gupta technologies, Inc. offers plug-and-play scalability across DOS, OS/2, UNIX, and Net Ware platforms.
This base can run under local area network manager, local area network server, VINES, 3+Open, and Net Ware 2.11, using Net BIOS, operating system/2′s Named Pipes, or TCP/IP protocols to handle communications, between clients and server. Structure Query Language base 5.0 also comes in a net Ware loadable module version that runs on a Net Ware 3.11 system, which supports the protocols as an alternative to using Net BIOS as the transport mechanism. Database routers are provided for data operating system, windows, and operating system/2 clients.
In the case of Structure Query Language base net Ware loadable module, users can employ the same machine as both a Structure Query Language server database and a network server. Prior to the Structure Query Language base 5.0 net Ware loadable module availability, Gupta recommended that users install base on a dedicated dos operating system or Operating system S/2 machine.
Structure Query Language base 5.0 includes a query optimizer, which can drastically reduce the time required to compile and execute complex queries, including multilevel joins and nested queries. The server performs a series of complex algorithms in order to determine the fastest and most cost-effective method for returning the response to a query.
Structure Query Language base 5.0 can support large databases and easily handle partitioned databases that span multiple disk drives and contain hundreds of gigabytes of the data. Support for partitioned database improves performance and increase capacity when working with large databases.
Across to databases that span multiple disk partitions or volumes is handled through storage groups that manage one or more database areas, which are portions of the actual data that reside in a single partition or volume. Applications access the database using the storage group name instead o the actual area names; an area can be part of multiple storage groups as well. Space allocation in the different areas is handled automatically and can grow and shrink dynamically.
Optimized for graphical application, Structure Query Language base 5.0 includes:
1) Scroll cursors, which permit users to browse back and forth through multiple sets of data records and update them in any order or at any time.
2) Isolation level support for the isolation levels implemented in IBM’s DB2 and Operating System S/2 Data Base Manager, Structure Query Language Base 5.0 adds two additional levels-release and lock, and read only to allow users of graphical applications to scroll through and update data with the highest possible level of concurrency.
3) Cursor context preservation, which allows database cursors to be used after a commit occurs, is eliminating the need to re-establish application cursors for each commit.
4) Binary large objects support.
5) Read-only database support, including those on Compact Disk Read Only Memory.
Security has also been enhanced through the encryption of database and user passwords. Passwords are encrypted when they are on the server and also prior to transmission from the client to the server.
Recent Comments