home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Black Box 4
/
BlackBox.cdr
/
w3_apps
/
winsql11.arj
/
README.DOC
< prev
Wrap
Text File
|
1991-09-26
|
15KB
|
332 lines
General Information Page 1 of 6
Orion SQL For Windows
Release 1.1 - September 1991
GENERAL INFORMATION
Copyright (c) 1991 by Stellar Industries
All Rights Reserved
Release 1.1 Enhancements
Orion SQL For Windows Release 1.1 adds several new features:
** INDEX CAPABILITY
Adding indices to tables greatly enhances performance. A
simple SELECT which extracts 5 records from a table of
3000 takes 10.6 seconds without an index. The same
SELECT statement takes only 0.6 seconds when there is an
index on the table.
While indices may be created at any time, we recommend
that you create indices immediately after you create
their base tables, otherwise CREATE INDEX has to read and
rewrite all data which is already in the table.
The syntax for creating an index is: "CREATE INDEX
<IndexName> ON <TableName> (<column name>, <column name>,
...)"
The syntax for dropping an index is: "DROP INDEX
<IndexName> ON <TableName>"
** GENERAL PERFORMANCE IMPROVEMENT
Even without using indices, Orion SQL For Windows Release
1.1 has significant performance improvements over Release
1.0 (minimum 3 to 6 fold) as evidenced by the timings
below. These queries are available to you in the
EXAMPLES.ZIP file.
+--------------------------------------------+
| release: | 1.0 | 1.1 |
|--------------------+-----------+-----------|
| QUERY15.SQL | 6.0 sec. | 1.4 sec. |
|--------------------+-----------+-----------|
| QUERY16.SQL | 5.1 sec. | 1.9 sec. |
+--------------------------------------------+
(80386 33MHz, 17 msec IDE disk, HYPERDISK disk cache)
General Information Page 2 of 6
** OTHER ENHANCEMENTS
o As the transaction journal grows in size it may now
be checkpointed: all committed transactions are
backed up to any media you choose leaving a nearly
empty journal (only available on the registered
version).
o A new data type: "VARCHAR <data type>" for the
CREATE TABLE statement.
o The Registration Reminder is removed from Query
Editor.
Unpacking and Installation Instructions
Orion SQL For Windows is provided as a single compressed file.
(WINSQL11.ZIP). The contents of WINSQL11.ZIP are defined in
the included PACKING.LST file.
Efficient operation of SQL For Windows requires that you use a
disk cache manager (such as MicroSoft's SMARTDRV.SYS). For
superior performance use a disk cache manager which also
caches disk writes, such as Norton Disk Cache (available with
Norton Utilities) or Hyperdisk Disk Accelerator (available as
shareware from HyperWare*). We at Stellar Industries
recommend Hyperdisk Disk Accelerator with which we observe a
three to six fold performance enhancement verses SMARTDRV.SYS.
Hyperdisk is available on many BBS's as HYDK421.ZIP.
Documentation for these disk cache managers should be
carefully reviewed. Utilizing SMARTDRV.SYS instead of
HyperDisk, the above timings become:
+--------------------------------------------+
| release: | 1.0 | 1.1 |
|--------------------+-----------+-----------|
| QUERY15.SQL | 20.0 sec. | 4.7 sec. |
|--------------------+-----------+-----------|
| QUERY16.SQL | 22.0 sec. | 8.4 sec. |
+--------------------------------------------+
The importance of a good disk cache manager and thoughtful
database design including the use of indices (where
appropriate) cannot be over emphasized.
In order to properly install SQL For Windows on your computer
you will need to perform the following steps:
____________________
* HyperWare, RR#1 Box 91, Pall Mall, TN 38577; voice: (615)
864-6868; BBS: 8N1 (HST, V.32, V.22bis): (615) 864-6871
General Information Page 3 of 6
1) Move DBA.EXE, DBA.HLP, QE.EXE and QE.HLP to the directory
in which you keep windows programs. This is usually the
'c:\windows' directory.
2) Make two new directories. One will be for the Orion
Database Administrator's files (we recommend naming it
'database'), the other will be for your queries and data
(we recommend naming it 'data'). You can use the MS-DOS
'mkdir' command to do this.
3) Unpack EXAMPLES.ZIP (contained within WINSQL11.ZIP).
This file contains both sample queries and an import file
to load some sample data into the database. We recommend
putting these files in your 'data' directory.
4) Use your favorite editor (NOTEPAD.EXE will suffice) to
modify the windows initialization file WIN.INI. This
file can usually be found in the 'c:\windows' directory.
Add the following lines:
[OrionDba]
AutoStart=0
DatabasePath=c:\database
DataFilePath=c:\data
FileNameDatabaseDump=c:\temp\orion.dmp
Suspend=0
[OrionQe]
Acknowledge=1
AutoStart=0
DataFilePath=c:\data
OpenNew=0
UserName=SYSTEM
UserPassword=ORION
WarnOnClose=1
As DBA.EXE and QE.EXE automatically add some of these
lines if they do not already exist, be sure you are not
adding duplicate entries. If you edit WIN.INI before
running DBA.EXE or QE.EXE you don't have to worry.
These entries have the following meanings:
[OrionDba] Identifies a block of entries as
belonging to the Orion Database
Administrator.
AutoStart Set to '0' or '1'. When set to '1'
causes the Orion Database
Administrator to automatically start
the database as soon as you start the
program.
General Information Page 4 of 6
DatabasePath Set to the path you want the database
files to reside in. Make sure to
create this directory before starting
the Orion Database Administrator. We
recommend naming it 'database'.
DatafilePath Set to the path you want to use as
the default for import and export
operations. We recommend naming it
'data'.
FileNameDatabaseDump Set to the full file name of
the file you want the Orion Database
Administrator to use for the 'dump'
operation.
Suspend Set to '0'.
[OrionQe] Identifies a block of entries as
belonging to the Orion Query Editor.
Acknowledge Set to '0' or '1'. When set to '1'
causes the Orion Query Editor to
display an informational dialog box
every time a query completes.
AutoStart Set to '0' or '1'. When set to '1'
causes the Orion Query Editor to
automatically start the Orion
Database Administrator if it is not
already running.
DataFilePath Set to the path you want to use as
the default for file operations. We
recommend naming it 'data'.
OpenNew Set to '0' or '1'. When set to '1'
causes the Orion Query Editor to
automatically create a new 'pad' when
the Query Editor first starts.
UserName Set to 'SYSTEM'. This identifies the
default user name.
UserPassword Set to 'ORION'. This identifies the
default user password.
WarnOnClose Set to '0' or '1'. When set to '1'
causes the Orion Query Editor to
prompt the user for a file name
before closing a pad which contains
text not yet saved to disk.
General Information Page 5 of 6
SQL For Windows also relies upon the international date
and time settings. The Windows defaults are fine and you
can leave them alone. If you've changed them, don't
worry, time stamps are saved in binary and not converted
to international format until used for output. If you're
interested, we recommend the following settings:
[intl]
iDate=0
iTime=0
s1159=AM
s2359=PM
International date and time settings are most easily
changed via Microsoft's Windows Control Panel. Select
the "International" icon then click on either "date" or
"time".
5) Use Microsoft's Program Manager to create a new program
group:
a) select 'File', 'New'
b) select 'Program Group', 'OK'
c) Enter description: 'Orion', group file: 'ORION'
d) select 'OK'
6) Use Microsoft's Program Manager to create two new program
items:
a) select 'File', 'New'
b) select Program Item, 'OK'
c) Enter description: 'Dba', command line: 'DBA.EXE'
d) select 'OK'
e) select 'File', 'New'
f) select Program Item, 'OK'
g) Enter description: 'Qe', command line: 'QE.EXE'
h) select 'OK'
7) Start the Orion Database Administrator by clicking on the
'Dba' Icon in the Microsoft Program Manager. When the
Orion Database Administrator's window appears select
'Toolbox' from its menu. Select the 'Install' entry,
this will install the database in the directory
identified by the 'DatabasePath' setting described above.
General Information Page 6 of 6
8) You may now exit ('Exit' is in the 'File' menu) the Orion
Database Administrator. SQL For Windows is completely
installed.
Examples
You will probably want to run our examples to familiarize
yourself with the operation of SQL For Windows.
1) Start the Orion Database Administrator by clicking on the
'Dba' Icon in the Microsoft Program Manager. When the
Orion Database Administrator's window appears select
'Control' from its menu. Select the 'Start' entry, this
will start the database.
2) Start the Orion Query Editor by clicking on the 'Qe' icon
in the Microsoft Program Manager. When the Orion Query
Editor's window appears select 'File' from its menu. Now
select the 'Open' entry and open the file CREATE.SQL.
This is one of the files contained in EXAMPLES.ZIP. When
its text appears in a pad select the menu commands
'Database', 'Execute' (or hit control/x). This query
creates the tables of the example database.
3) Now go to the Orion Database Administrator and select the
menu commands 'File', 'Import'. Select the file
EXAMPLE.DAT. This is one of the files contained in
EXAMPLES.ZIP. The 'Import' loads the data in EXAMPLE.DAT
into the tables you created with CREATE.SQL.
4) You can now execute any of the sample queries contained
in EXAMPLES.ZIP. Go to the Orion Query Editor, open a
file (for example QUERY01.SQL) and execute it. Files
which contain select statements will cause the Orion
Query Editor to open a new pad and place the data as text
into the new pad. You may then edit the data and/or save
it to a file using the 'File', 'Save As' commands.
5) To remove the sample data from the database just execute
the SQL 'drop table' statements in the DROP.SQL file.
6) You are now ready to write your own SQL statements and
create your own database.
Stellar Industries: (714) 861-7885
3335 S. Falcon Ridge Road
Diamond Bar, CA 91765