Dbm (discuter | contributions) m (→SQLfast) |
Dbm (discuter | contributions) (→SQLfast) |
||
Ligne 31 : | Ligne 31 : | ||
:*reflexivity: an SQLfast script can generate, examine, modify and execute SQLfast scripts, including itself. | :*reflexivity: an SQLfast script can generate, examine, modify and execute SQLfast scripts, including itself. | ||
:*development and debugging tools | :*development and debugging tools | ||
− | *'''SQLfast tutorial'''. The SQLfast tutorial progressively introduces the reader to the basics of SQLfast, from elementary data manipulation through very short scripts to complex features such as metadata-based script generation, recursive programming and language extension. It also includes some representative applications: database creation and loading, database exploration, database migration, library management, interactive SQL interpreter, a photo album manager and browser, a statistics manager and viewer, a bill of material manager, a GIS (based on ESRI shapefiles), analysis of an undocumented database, topological sorting of a relational schema, GALOIS lattice generation, automatic GUI generation, automated SQL trainer, ontology-based text indexing and retrieval, Conway's Game of Life (cellular automata), Kings of France (tree processing), schema-less (NoSQL) databases, etc. Selected draft chapters are already available. | + | *'''SQLfast tutorial'''. The SQLfast tutorial progressively introduces the reader to the basics of SQLfast, from elementary data manipulation through very short scripts to complex features such as metadata-based script generation, recursive programming and language extension. It also includes some representative applications: database creation and loading, database exploration, database migration, library management, interactive SQL interpreter, a photo album manager and browser, a statistics manager and viewer, a bill of material manager, a GIS (based on ESRI shapefiles), analysis of an undocumented database, topological sorting of a relational schema, GALOIS lattice generation, automatic GUI generation, automated SQL trainer, ontology-based text indexing and retrieval, Conway's Game of Life (cellular automata), Kings of France (tree processing), schema-less (NoSQL) databases, SQL code injection, etc. Selected draft chapters are already available. |
− | *'''Requirements''': standard Python 2.7 distribution (first version developed for Windows platforms) | + | *'''Requirements''': standard Python 2.7 distribution (first version developed for Windows platforms, versions for Linux and Mac OS are in preparation) |
*'''Date''': 2012- | *'''Date''': 2012- | ||
*'''Status''': ongoing | *'''Status''': ongoing | ||
*'''Availability''': Free of charge. Expected release date of beta: first quarter 2014. | *'''Availability''': Free of charge. Expected release date of beta: first quarter 2014. | ||
*'''References and resources''': | *'''References and resources''': | ||
− | **Jean-Luc Hainaut. <u>SQLfast Database made easy - Tutorial and Case studies</u>, | + | **Jean-Luc Hainaut. <u>SQLfast Database made easy - Tutorial and Case studies</u>, 700 pages, PReCISE Research Center publication, draft version, 2014. |
**<u>SQLfast Tutorial - 1st pages and Table of contents</u>, from ''SQLfast Database made easy - Tutorial and Case studies'',PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto00-1st-pages.pdf [full text]] | **<u>SQLfast Tutorial - 1st pages and Table of contents</u>, from ''SQLfast Database made easy - Tutorial and Case studies'',PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto00-1st-pages.pdf [full text]] | ||
**<u>SQLfast Tutorial - 1. Introduction</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto01-Introduction.pdf [full text]] | **<u>SQLfast Tutorial - 1. Introduction</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto01-Introduction.pdf [full text]] | ||
**<u>SQLfast Tutorial - 2. Basic scripts</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto02-Basic-programs.pdf [full text]] | **<u>SQLfast Tutorial - 2. Basic scripts</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto02-Basic-programs.pdf [full text]] | ||
− | |||
**<u>SQLfast Tutorial - 4. Creating a database</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto04-Creating-a-DB.pdf [full text]] | **<u>SQLfast Tutorial - 4. Creating a database</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto04-Creating-a-DB.pdf [full text]] | ||
**<u>SQLfast Tutorial - 5. Updating data</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto05-Updating-data.pdf [full text]] | **<u>SQLfast Tutorial - 5. Updating data</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto05-Updating-data.pdf [full text]] | ||
**<u>SQLfast Tutorial - 6. More on variables</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto06-More-on-variables.pdf [full text]] | **<u>SQLfast Tutorial - 6. More on variables</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto06-More-on-variables.pdf [full text]] | ||
− | **<u>SQLfast Tutorial - | + | **<u>SQLfast Tutorial - 7. Taking decisions</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto07-Taking-decisions.pdf [full text]] |
− | **<u>SQLfast Tutorial - | + | **<u>SQLfast Tutorial - 8. Reading data</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto08-Reading-data.pdf [full text]] |
− | **<u>SQLfast Tutorial - | + | **<u>SQLfast Tutorial - 9. Looping - The final chapter</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto09-More-on-Loops.pdf [full text]] |
− | **<u>SQLfast Tutorial - | + | **<u>SQLfast Tutorial - 10. SQLfast expressions</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto10-Expressions.pdf [full text]] |
− | **<u>SQLfast Tutorial - | + | **<u>SQLfast Tutorial - 11. Output channels</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto11-Output-Channels.pdf [full text]] |
− | **<u>SQLfast Tutorial - | + | **<u>SQLfast Tutorial - 12. Dialogues</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto12-Dialogues.pdf [full text]] |
+ | **<u>SQLfast Tutorial - 13. Displaying data</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto13-Displaying-data.pdf [full text]] | ||
**<u>SQLfast Tutorial - 14. Advanced dialogues</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | **<u>SQLfast Tutorial - 14. Advanced dialogues</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | ||
**<u>SQLfast Tutorial - 15. Big data</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | **<u>SQLfast Tutorial - 15. Big data</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | ||
− | |||
**<u>SQLfast Tutorial - 16. Writing data tables - Part 1</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto16-Writing-tables-1.pdf [full text]] | **<u>SQLfast Tutorial - 16. Writing data tables - Part 1</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto16-Writing-tables-1.pdf [full text]] | ||
**<u>SQLfast Tutorial - 17. Writing data tables - Part 2</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto17-Writing-tables-2.pdf [full text]] | **<u>SQLfast Tutorial - 17. Writing data tables - Part 2</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto17-Writing-tables-2.pdf [full text]] | ||
Ligne 70 : | Ligne 69 : | ||
**<u>SQLfast Tutorial - 34. Geographic information systems</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | **<u>SQLfast Tutorial - 34. Geographic information systems</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | ||
**<u>SQLfast Tutorial - 35. Kings of France - Part 1</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto35-Kings-of-France-1.pdf [full text]] | **<u>SQLfast Tutorial - 35. Kings of France - Part 1</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto35-Kings-of-France-1.pdf [full text]] | ||
− | **<u>SQLfast Tutorial - 36. Kings of France - Part 2</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | + | **<u>SQLfast Tutorial - 36. Kings of France - Part 2</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto36-Kings-of-France-2.pdf [full text]] |
− | **<u>SQLfast Tutorial - 37. Text processing</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. | + | **<u>SQLfast Tutorial - 37. Text processing</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. |
**<u>SQLfast Tutorial - 38. Temporal databases</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | **<u>SQLfast Tutorial - 38. Temporal databases</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | ||
− | **<u>SQLfast Tutorial - 39. Schema-less databases</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | + | **<u>SQLfast Tutorial - 39. Schema-less databases (1)</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto39-Schemaless-DB(1).pdf [full text]] |
− | **<u>SQLfast Tutorial - Appendix 1. A basket of examples</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [full text] | + | **<u>SQLfast Tutorial - 40. Schema-less databases (2)</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto40-Schemaless-DB(2).pdf [full text]] |
− | **<u>SQLfast Tutorial - Appendix 2. SQLfast summary</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA2- | + | **<u>SQLfast Tutorial - 41. Schema-less databases (3)</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto41-Schemaless-DB(3).pdf [full text]] |
− | **<u>SQLfast Tutorial - Appendix 3. SQLite transactions</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast- | + | **<u>SQLfast Tutorial - 42. SQL code injection</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto42-SQL-injection.pdf [full text]] |
+ | **<u>SQLfast Tutorial - Appendix 1. A basket of examples</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA1-Basket-of-examples.pdf [full text]] | ||
+ | **<u>SQLfast Tutorial - Appendix 2. SQLfast summary</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA2-SQLfast-installation.pdf [full text]] | ||
+ | **<u>SQLfast Tutorial - Appendix 3. SQLfast summary</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA3-Summary.pdf [full text]] | ||
+ | **<u>SQLfast Tutorial - Appendix 4. SQL in a nutshell</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA4-SQL.pdf [full text]] | ||
+ | **<u>SQLfast Tutorial - Appendix 8. SQLite transactions</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA8-SQLite-Transactions.pdf [full text]] | ||
**<u>SQLfast Tutorial - Appendix 9. SQLfast internals</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA9-SQLfast-implementation.pdf [full text]] | **<u>SQLfast Tutorial - Appendix 9. SQLfast internals</u>, chapter from ''SQLfast Database made easy - Tutorial and Case studies'', PReCISE Research Center publication, draft version, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-TutoA9-SQLfast-implementation.pdf [full text]] | ||
<Retour à la page d'accueil / Back>
Sommaire |