From unstructured data to application

Imagine that you have this kind of texts:

Alpert of Metz – 11th-century – France – Medieval writers
Aimoin of Fleury – c. 960 – c. 1010 – France – Medieval writers
Amulo Lugdunensis (Archbishop of Lyon) – 9th-century – France – Medieval writers
Amulo Lugdunensis (Archbishop of Lyon) – 9th-century – France / Carolingian Empire – Medieval writers
Andrew of Fleury – 11th-century – France – Medieval writers
Angelomus of Luxeuil – 9th-century – Francia / France – Medieval writers

Vitsentzos or Vikentios Kornaros or Vincenzo Cornaro – c. 1553 – c. 1614 – Kingdom of Candia / Crete / Greece – Renaissance

Adrianus of Tyre – c. 113 – c. 193 – Greece / Roman Empire – Ancient & Classical writers

How transform this unstrcutured data to make an application that search like in the picture below ( just the R from CRUD )?

Detailing  the tools:

1.  Transforming data: Excel + VBA – to parse from the text the name, country / countries , years period  movement and generate insert  /stored procedurees call

2. Storing+ retrieving data: Sql Server – creating tables and stored procedures to insert / retrieving data

3. Acessing data: .NET Core – to make WebAPI to export as WebAPI HTTP endpoints t

4. Display data:

5. Deploy:

  • RedfHat OpenShift to deploy site
  • Azure to have sql server on the web

Hours or work ~ 20 . And hey, it works!