The China Biographical Database User’s Guide

Michael A. Fuller

Revised Version 3.6

July 26, 2024

© China Biographical Database Project: Harvard University, Academia Sinica, Peking University

Table of Contents

• Preface
• Introduction
• Chapter 1. Relational Databases
  • A. Relational Database and the Organization of Complex Data
  • B. Rules for Structuring Data in a Relational Database
  • C. Relational Databases and the Interactions of Complex Data
• Chapter 2. The Structure of CBDB
  • A. An Overview of the Entities in the Database
  • B. Details of Entities
  • Summary of Tables in CBDB
• Chapter 3. CBDB Tools for Analysis
  • A. The Navigation Pane
  • B. The Browser
  • C. Query by Method of Entry
  • D. Query Associations
  • E. Query Office Holding
  • F. Query Kinship
  • G. Query Social Networks
  • H. Query Pair-wise Association
  • I. Query Place Association
  • J. Query Status
  • K. Query Texts and Roles
  • L. Looking up Data on a Group of Individuals
• Chapter 4. Advanced Query Techniques
  • A. Kinship Networks for Jinshi-degree Holders in Putian
  • B. Using the Access Query Designer
• Appendices
  • A. Installing the MS Access Files
  • B. Updating the Visual Basic Environment
  • C. Installing the SQLite CBDB Database on a Mac
  • D. Kinship Simplification Table
  • E. Change Log for CBDB