Dbm (discuter | contributions) (→SQLfast) |
Dbm (discuter | contributions) |
||
| Ligne 37 : | Ligne 37 : | ||
*'''Availability''': Free of charge. Expected release date of beta: first quater 2014. | *'''Availability''': Free of charge. Expected release date of beta: first quater 2014. | ||
*'''References and resources''': | *'''References and resources''': | ||
| − | : | + | **Jean-Luc Hainaut. <u>SQLfast Tutorial - First pages</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', pages 1-14, PReCISE Research Center publication, 2014. [[http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tutorial-1st-Pages.pdf [full text]] |
| + | |||
===DB-MAIN=== | ===DB-MAIN=== | ||
| Ligne 116 : | Ligne 117 : | ||
===VisiComp=== | ===VisiComp=== | ||
*'''Type''': Graphical computer simulator | *'''Type''': Graphical computer simulator | ||
| − | *'''Description''': VisiComp (name inspired by VisiCalc) is a graphical simulator for an educational computer. This computer has a very simple architecture: a main memory of up to 100 cells (each accomodating a signed 5-digit number), the standard handful of registers (P-counter, instruction register, logical register, accumulator + its extension register), 37 instructions organized into 7 instruction families, 10 addressing modes, a sequential input device, a sequential output device, bootstrap (kind of MBR). The simulator also includes a monitor that manages and controls all the parts of the computer (interactive + script interpreter), configuration files, input file loader, etc. The computer has been used to illustrate architecture and programming principles such as Von Neuman architecture, basic program structures, I/O buffering, recursion, relocatable programs, bootstrapping | + | *'''Description''': VisiComp (name inspired by VisiCalc) is a graphical simulator for an educational computer. This computer has a very simple architecture: a main memory of up to 100 cells (each accomodating a signed 5-digit number), the standard handful of registers (P-counter, instruction register, logical register, accumulator + its extension register), 37 instructions organized into 7 instruction families, 10 addressing modes, a sequential input device, a sequential output device, bootstrap (kind of MBR). The simulator also includes a monitor that manages and controls all the parts of the computer (interactive + script interpreter), configuration files, input file loader, etc. The computer has been used to illustrate architecture and programming principles such as Von Neuman architecture, basic program structures, I/O buffering, recursion, relocatable programs, bootstrapping and even a complete business application (order management and invoicing with 3 files, almost as powerful as SAP!) The simulator and its additional components required at runtime no more than 12 KB (12,000 bytes!) in RAM. It was developed in TRS-80 Basic then in CP/M Basic. |
*'''Requirements''': TRS-80 Model 1 - Level 2 (16 KB RAM); CP/M; BASIC language processor; | *'''Requirements''': TRS-80 Model 1 - Level 2 (16 KB RAM); CP/M; BASIC language processor; | ||
*'''Date''': 1982 | *'''Date''': 1982 | ||
| Ligne 123 : | Ligne 124 : | ||
*'''References and resources''': | *'''References and resources''': | ||
**Jean-Luc Hainaut, ''THE VISIBLE COMPUTER - A graphical computer simulator''. Technical report, 1982. 75 pages. [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/The-Visible-Computer/The-Visible-Computer.pdf [full text]] This document results from the scanning of poorly printed pages. It is incomplete and probably includes too many errors. In addition, it will probably be considered fairly naive. Consider that it was written 30 years ago and that computer technology has considerable evolved since then, to such an extent that is has become quite complex and impossible to describe in detail to plain lay readers. | **Jean-Luc Hainaut, ''THE VISIBLE COMPUTER - A graphical computer simulator''. Technical report, 1982. 75 pages. [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/The-Visible-Computer/The-Visible-Computer.pdf [full text]] This document results from the scanning of poorly printed pages. It is incomplete and probably includes too many errors. In addition, it will probably be considered fairly naive. Consider that it was written 30 years ago and that computer technology has considerable evolved since then, to such an extent that is has become quite complex and impossible to describe in detail to plain lay readers. | ||
| − | **Source code available on paper | + | **Source code available on paper. |
| + | **'''Note''': just for the fun, I have developed a new graphical interface for Visicomp in Python/Tkinter. It would take no more than 2-3 weeks to add the logic behind. Anyone interested? | ||
| Ligne 134 : | Ligne 136 : | ||
*'''Availability''': source code (but I must search floppy disks for it). | *'''Availability''': source code (but I must search floppy disks for it). | ||
*'''References and resources''': | *'''References and resources''': | ||
| − | **'''[TR86-01]'''Jean-Luc Hainaut, ''NDBS - A simple database system for small computers''. Technical report, 1986. 144 pages. [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/NDBS/NDBS.pdf [full text]] This text has been recovered from various materials written in the eighties (Mac Word documents) and roughly assembled into a unique FrameMaker document. The result would require in-depth polishing, but, to be frank, I currently have no spare time to carry out this task. Sometimes in the near future perhaps ! | + | **'''[TR86-01]'''Jean-Luc Hainaut, ''NDBS - A simple database system for small computers''. Technical report, 1986. 144 pages. [http://www.info.fundp.ac.be/~dbm/Documents/Ouvrages/NDBS/NDBS.pdf [full text]] This text has been recovered from various materials written in the eighties (Mac Word documents) and roughly assembled into a unique FrameMaker document. The result would require in-depth polishing, but, to be frank, I currently have no spare time to carry out this task. Sometimes in the near future perhaps! |
===SQL-Script Interpreter=== | ===SQL-Script Interpreter=== | ||
*'''Type''': Interpreter for an SQL-based scripting language | *'''Type''': Interpreter for an SQL-based scripting language | ||
| − | *'''Description''': Empty Access application (*.mdb) that allows users to execute SQL scripts on any database. Includes a simple dialog box with two buttons: select a script file and execute it. For information, MS Access provides two ways to execute SQL statements: as Access queries (simple but single queries only) and embedded in VB programs (powerful but complex). This tool allows one to execute in one click a script made up of a sequence of SQL statements, but also much more complex scripts with variables, macros, loops, alternatives and interaction with users. | + | *'''Description''': Empty Access application (*.mdb) that allows users to execute SQL scripts on any database. Includes a simple dialog box with two buttons: select a script file and execute it. For information, MS Access provides two ways to execute SQL statements: as Access queries (simple but single queries only) and embedded in VB programs (powerful but complex). This tool allows one to execute in one click a script made up of a sequence of SQL statements, but also much more complex scripts with variables, macros, loops, alternatives and interaction with users. This application has been frozen in 2012 since the development of SQLfast (see above). |
*'''Requirements''': Microsoft Access | *'''Requirements''': Microsoft Access | ||
*'''Date''': 2005-2011+ | *'''Date''': 2005-2011+ | ||
<Retour à la page d'accueil / Back>
Sommaire |