Data modelling

tool: SQL Server

Purpose: 

A server-side software application that enables databases conformant to a relational data model to be created, managed and queried. Information, most commonly text may be stored as one or more records contained within a table. The table may exist in isolation or have some relationship to other tables. Information may be manipulated using a set of T-SQL or ANSI SQL commands. Several editions of SQL Server are available, including SQL Server Compact, Developer, Embedded, Enterprise, Evaluation, Express and Fast Track.

Features: 
  • Service Broker
  • Replication Services using transaction, merge, or snapshot replication
  • Analysis functionality to perform data mining, OLAP and other services
  • Report generation services
A&H use case 1 description: 
The Dafydd ap Gwilym project used an SQL Server 2000 database to store poetry written by the 14th Century Welsh poet, Dafydd ap Gwilym.
A&H use case 2 description: 
The Beazley Archive has used Microsoft SQL Server 2000 to publish a database of Athenian figure-decorated pottery created between 626BC and 300BC.
A&H use case 3 description: 
The Italian Academies project has used Microsoft SQL Server 2000 to store and publish information on Italian Academies of the late Renaissance and early modern periods (1530-1650) and their relationship to book production, printing and publishing in this period.
Publisher: 
Microsoft Corporation
Creator: 
Microsoft Corporation
lifecycleStage: 
Licence: 
Software/programming languages used: 
Alternate tool(s): 

MySQL, Oracle

Data structuring and enhancement: 

project: Person Data Repository of the 19th Century

The project “Construction of a repository for biographical data on historical persons of the 19th century” – short form: Person Data Repository – enhances the existing approaches to data integration and electronically supported research in biographies. It investigates connecting and presenting heterogeneous information on persons of the “long nineteenth century” (1789–1914). The project's aim is to provide a de-central software system for research institutions, universities, archives, and libraries that allows combined access on biographic information from different data pools. [read more]

project: In Transition: Selected Poems by the Baroness Elsa von Freytag-Loringhoven

In Transition: Selected Poems by the Baroness Elsa von Freytag-Loringhoven is an electronic edition of poetry by the Dadaist artist, performer, and poet Elsa von Freytag-Loringhoven. This scholarly edition comprises digital surrogates and transcriptions of multiple manuscript versions of twelve poems by Freytag-Loringhoven. Work on this digital edition began as part of the dissertation entitled "The Makings of Digital Modernism" by Tanya Clement. [read more]

project: Schenker Documents Online

The twentieth century's leading theorist of tonal music, Heinrich Schenker produced a series of innovative studies and editions between 1903 and 1935 and left behind a voluminous archive of correspondence, diaries and lessonbooks. Edited in near-diplomatic transcription and with English translations, these materials form the core of the edition, supported by additional documents relating to his life, and a set of "profiles" of people, places and organizations with which he came into contact. [read more]

project: DARIAH: Digital Research Infrastructure for the Arts and Humanities

Supporting and enhancing digitially enabled research. The Digital Research Infrastructure for the Arts and Humanities (DARIAH) aims to develop and maintain an infrastructure in support of ICT-based research practices across the arts and humanities, acting as a trusted intermediary between disciplines and domains. [read more]

project: Jane Austen's holograph fiction manuscripts: a digital and print resource

Jane Austen's fiction manuscripts are the first significant body of holograph evidence for any British novelist. They represent every stage of her writing career and a variety of physical states: working drafts, fair copies, and handwritten publications for private circulation. The manuscripts were held in a single collection until 1845, when at her sister Cassandra's death they were dispersed. [read more]

project: Corpus Vitrearum Medii Aevi (Phase II: Enhancing Stained Glass Studies)

The Corpus Vitrearum Medii Aevi (CVMA) is an international survey of stained glass. CVMA in Great Britain has so far published one hundred printed volumes to date in addition to the online publications which include a substantial image archive; a prototype digital publication of the stained glass in Norfolk; and an online magazine called 'Vidimus' (available at http://vidimus.org). Phase I of the CVMA digital publication project provided access to a digital Picture Archive, containing nearly 18,000 images of medieval stained glass. [read more]

project: Jonathan Swift Archive

The Jonathan Swift Archive makes available a searchable, digitized collection of texts of Swift’s prose from a great variety of early editions. The texts collected in the archive are documentary transcriptions of Swift's writings as they appear in their original printed editions. The aim has been to include first editions, and, wherever there has been authorial correction, emendation, revision, or alteration to the text in subsequent lifetime editions, to add transcriptions of these later witnesses. [read more]

project: Anglo-Saxon Language of Landscape (LangScape)

The aim of the LangScape Project is to make accessible over the web a rich body of material relating to the English countryside of a thousand years ago and more, using estate boundaries - detailed descriptions by those who lived in and worked the Anglo-Saxon landscape. The completed website - an electronic corpus of Anglo-saxon boundary clauses with extensive XML mark-up - will be a powerful research tool with applications within a broad range of academic disciplines. It will also be designed with a view to its ongoing development for public and schools use. [read more]

project: Catalogue of English Literary Manuscripts 1450-1700

A freely accessible on-line record of surviving manuscript sources for over 200 major British authors of the period 1450-1700. It will incorporate descriptions of many thousands of manuscript texts of poems, plays, discourses, translations, etc., as well as notebooks, annotated printed books, corrected proofs, promptbooks, letters, documents and other related manuscript materials, many hitherto unrecorded, found in several hundred public and private collections world-wide. [read more]

Pages