Apogee 4GL And Filehandler

·  The Ultimate in Database Management
·  Network/Relational Model
·  Fast! – Easy to Use!
·  Single or Multi-User
·  Client/Server or Non-Client Options
·  100% Portable between:
   Microsoft Windows/NT, MS-DOS, Xenix, Solaris, Unix, AIX
·  File Types:
   Index, Random, Variable Length, Hashed, Threaded
·  ODBC and JDBC Compatible
·  Compatible with BRI J-Pro Java Development System for
   Internet and Network Appliance Applications
·  File Maintenance Utilities
·  File Information Definition Structures

APOGEE DATABASE ENGINE

History:

The Apogee Database engine has been developed, maintained, improved, and owned by Binary Research Inc. since 1989. Apogee’s precursor is a Database engine named QPro 4 which was developed in early 1980's.The Apogee Database Engine has been ported to over 80 different platforms and operating systems over the years. Some of these Operating Systems have included DOS, PC-MOS, Concurrent DOS, Turbo-Dos, ATT Unix V5, SCO, Ultrix, AIX, HP-Unix, Solaris, OS/2, Windows 3.1, 95, 98, and Windows NT. The Apogee Database Engine is written in C.

In technical terms, Apogee is what is called a B-Tree ISAM file handler. Apogee is unique because it uses a FID (File Information Definition) table to keep the data table structure. By using this approach, it is much easier and less expensive to make changes to the data structure. Apogee makes it easy to work with the file handler because the data files are completely ASCII. No special binary characters are embedded in the file. In addition, the indexes are kept in a single separate file. This sophisticated database structure has been proven over time to provide the fastest possible access to data. Apogee has the features of the most popular database engines
available, including various type of file structures such as Random Access and Index types.

Apogee has the ability to create up to thirteen separate index keys. These keys allow the programmer to give the user a great deal of flexibility and scalability, as well as optimum performance on any given platform

Technical differences between Relational vs Network/Relational Database
Apogee is a Network/Relational database engine, which is designed to maximize transaction processing speed versus the more limited performance of Relational Databases. If necessary, Apogee can be readily converted to a Relational-type database. Both of these theoretical designs
are based on research performed by the IBM Corporation over the past 40 years.

SQL Client to Server

Apogee’s Client/Server data engine has all the features of the Non-Client but it communicates differently with the data files. Client/Server systems are usually employed in applications with large numbers of users. Using this approach, the Application program requests a set of data with the qualifications of that desired data. On a separate machine, Apogee Server is running and polling the network via ODBC (Open Data Base Connectivity) for requests. The request is received by the Server and the query is performed until all records are found. At that point the information is passed back through the network to the Client.

Client/Server Pros Client/Server Negatives

The Server runs in Single-user mode Much slower development due to interface and can Cache the request
Intense demand on Server processor allowing for faster processing
Can be very slow depending on queries
Very low chance of getting file
Must have dedicated high performance Server index corruptions

Apogee Features:

16 bit & 32 bit versions
No of Records : Unlimited
Size of Rows: 32,255 Characters
Maximum number of Keys: 13
Operating System Support:
Non Client Engine
DOS, PC-MOS, Concurrent DOS, Turbo-
Dos, ATT Unix V5, SCO, Ultrix, AIX,
HPUnix, Solaris, OS/2, Windows 3.1, 95,
98, Windows NT
Client/Server Engine
Windows 3.1, 95, 98, Windows NT
Client/Server Interface support:
ODBC SQL 2.0
Column types supported:
String
Julian date
Integer
Numeric
Case Sensitive
Support:
Record locking - Byte level
Automatic record counter
Roll Backs (Non-client only)
Memo
Data Arrays
Data Alignment
Multi-columns to create a key
Data encryption key
Multiple language character support
FID (File Information Definitions table)
File Types - ACSII:
Index
Random
Variable length
Hashed
Thread
Utilities:
FID Editor
File Maintenance
Database Designer

Sample of over 10,000 users that have used the Apogee Database engine:

John Deere Insurance
T.J. Lipton Tea Port of Guam Authority
Tropicana UNLV
US Dept. of Education Moline Police Department
US Naval Weapons Toms River Police Department
Royal Air Force Smith Filter Corporation
US Air Force IBG
Chevron Jaguar Information Systems
TVA Water Authority M&B Group
New Mexico Prison System Showlow Police Department
ABC Consultants Hatrak Associates
Triangle Electric Inc. King Financial
MO Clinic Franklin-Potter Associates
Whitford Corp. University of PA
Happy Harry’s Temple University
Kimberly Clark Naval Ordinance Station
Purchasing Associates Inc. Johns Hopkins University
Hatfield Quality Meats CTR
Pillsbury Hanes Hosiery
Macy Catalog Coca-Cola
Mohawk Knitting mills Tyson Foods
PA Dept of Child Welfare Georgia Tech
Paychecks Inc. Scholarship Software
Rosenbergers Dairies BellSouth
Raish Enterprises Walt Disney World Company
GPS Transportion Dixie Lee’s
Barter System Inc. W.R. Grace
Victor Print Citicorp
Shelby Systems GRD Ltd.
Physician Network Abacus Computer
Toms River Water Authority NFL
Admiral Integration Cajun Electric Power Corp.
Cooper Associates Plains Resources
Avon Products Trammell-Crow Residential
OBOS Shell Development
Movers Specialty Service J.Q. Turner & Associates
Monarch Farms Timesolve Systems LTD
Niagara County Court System Elmar
Red Cross of Montreal Southern CA Peranente Med. Grp
Reed Software Montague & Associate
CM Trucking Autosoft
Upper Bucks Technical School Automotive Software Corp
Dayton School District Kaiser Hospital
Bancmark Honeywell


© 2017  Binary Research Inc.

Phone: 800.523.5990
809 N Bethlehem Pike, Spring House Square Blg. B Rear, Lower Gwynedd, PA 19002

Privacy  |  Legal