[dba-Tech] database

Jim Lawrence accessd at shaw.ca
Mon Jan 28 00:57:24 CST 2013


Hi Shamil:

It was good fortune that all the pieces fell into place at the right moment
and there was MS Access 1.1. It had a very small foot-print, considering it
had to perform on Windows which had a huge resource requirements.

I was currently doing much of my work in the new FoxPro. It had blown away
all the competition because it full compiled into a stand-alone application
and it had the new Rushmore sorting algorithm...it was the fastest by far.

When Microsoft bought up Foxpro, it was obvious what the systems people at
MS wanted; the patents on this incredible software break-through and the
technology was immediately put into Access version 2 and the rest is
history. I immediately started learning Access.

You must admit, for the desktop Windows computer the best small database
ever created was Access 7. It brought so much work to the company that I was
then working for. We went from a development team of one person, myself but
only part-time to seven full-time programmers. For the next two years it was
the most profitable section in the company...after leaving I continued
working on numerous government contracts and private sales....most FEs were
MS Access but the BE was abandoned in favour of MS SQL and Oracle.

In summary, the ten years from 1990 to 2000 saw more great PC databases come
and go. So you are saying maybe missing Dataflex was a good miss. 

Jim 

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov
Shamil
Sent: Sunday, January 27, 2013 2:08 PM
To: Discussion of Hardware and Software issues
Subject: Re: [dba-Tech] database


Hi Jim --

<<<
Too bad I never had a chance to try it out.
>>>
AFAIU you mean DataFlex? (I suppose it wasn't a bad luck you haven't had a
chance to work with it.)
I have worked with DataFlex MS DOS within year 1993.
By that time DataFlex have had already used so called 4GL Object Oriented
proprietary programming language.
That was a kind of "Object Cobol" - resulting in a very verbose code.
Yes, it was a powerful OOP 4GL and development system, maybe too powerful to
be true for that time: when I switched to MS Access 1.1 because of my that
time main customer request - that was a shock as MS Access 1.1 was "object
based" and it (MS Access) doesn't have any features to create custom classes
etc.
DataFlex, I suppose, was too late with its Visual DataFlex version - and MS
Access "crushed" it and PowerBuilder, and Borland's Paradox and dBase, and
Clipper, and FoxBase... on MS Windows desktop platform.

DataFlex has a notion of Dataset - a set of related tables - datamodel
subset. That Dataset can be "bound" to UI and it is providing a very
powerful data manipulation operations - that was a unique(?) feature for
middle 90-ies of the last century and it's still rather unique I suppose.

DataFlex wasn't an MS SQL based DBMS - one would better think of it as
having Network Data Model ( http://en.wikipedia.org/wiki/Network_model ).

Thank you.

-- Shamil


Воскресенье, 27 января 2013, 11:51 -08:00 от "Jim Lawrence"
<accessd at shaw.ca>:
>Hi Stuart:
>
>That is impressive. Too bad I never had a chance to try it out.
>
>Those were the "Gold Rush" days of computers. The database and systems
>market was growing like crazy then. Anyone smart and willing to work hard
>could turn a really good buck...obviously you did.
>
>CPM, huh...first DOS, but was multi-user capabilities. If Microsoft had not
>been so struck on being different all their slashes could have been the
>right way, their system would have been multi-user and network ready.
Worked
>with CPM, on government managers' Kypros (the precursor of the laptop...it
>was as heavy and big as a PC but came with a suit-case handle so it was
>portable). If you know CPM well, then UNIX and now Linux would seem like
>home. 
>
>One of my contracts was working on an ancient accounting system for the
>government from 1992 to 2000. The database was called DC/2. (Interesting
>aside: the database was originally commissioned and then sold by a mortuary
>company out of Chicago...a good location for that type business...very high
>volumes.) Its language was like a macro assembler code; OP code, Operand
and
>value. Returns and loops were just offsets pushed into the local stack,
>followed but a return OP code. No real-time keys or indexes, those tasks
>were over-night batch files. The system had thousands of users and was the
>back-bone of two of the largest government ministries. We were on call
24x7.
>The system was originally on an IBM Mainframe, using a version of CPM, then
>it was migrated to a VAX, using VMS (the first modern virtual UNIX), then
it
>migrated to DataPoint on UNIX servers and finally to Linux servers. I
>understand that it has now been abandoned (R.I.P) and replaced by an Oracle
>DB with their PL/SQL language and their GUI FE but of course it is running
>on Linux. 
>
>Things sure move fast in the computer world. 
>
>Jim

<<< skipped >>>
>
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com




More information about the dba-Tech mailing list