You are currently on Marc Grange's website.
This site is an update to my former site "marc-grange.net" which is no longer available.
The information on these pages is addressed to anyone wishing to apply and use database techniques. Various examples are taken from the field of Social Sciences, but the SQL language training and the database design method presented hereafter, relate to all the fields that imply an effective management of data.
As a practitioner, developer and teacher, I have used and taught databases and computer science for over 30 years.
Knowledge of database design, relational data model and SQL is essential in order to follow this presentation. For readers who do not have the knowledge but would like to address these different areas, please refer to the columns on these pages:
The purpose of the presentation is to introduce some interesting applications of databases in the field of humanities. The use of a data model to structure information, here the relational model, allows to work with SQL language for the extraction and production of relevant information relating to the studied field. This "generic" approach utilizes DBMS (DataBases Management Systems) properties to avoid developing specific applications. Four examples, linked to the humanities and social sciences, will be presented successively:
|- In Sociology||: Processing of surveys|
|- In Demography||: Relationships modelling|
|- In Psychology||: Affinity relationships|
|- In Geography||: Networks modeling|
Each example will go through the following steps:
- Presentation of the data in connection with the problem: construction of the data dictionary.
- Structuring of information: production of the data diagram.
- Presentation of queries representative of the area under investigation.
- Interactive processing of queries, on a "test" database, in SQL language.