Transformation of Data Using Relational Database System :

• NAKAZATO Hideki

  Department of Sociology, Faculty of Letters<BR>Konan University

Bibliographic Information

Other Title

• リレーショナル・データベースによる定型データの作成
• リレーショナル・データベースによる定型データの作成--宗門改帳の統計分析のために
• リレーショナル データベース ニ ヨル テイケイ データ ノ サクセイ シュウモンアラタメチョウ ノ トウケイ ブンセキ ノ タメニ
• ―宗門改帳の統計分析のために―
• Toward a Statistical Analysis of Japanese Historical Population Registers

Abstract

     The purpose of this article is to introduce the effective use of a relational database management system (RDBMS) in statistical analysis of Shumon Aratame Cho (population registers = SAC).<BR>     First, the data structure of SACs is compared with that of the questionnaires for the Third National Survey on Household Changes. Secondly, I explain the features of the RDBMS and examine some early uses of the system in historical studies, combing data from various sources. The main body of the paper is a detailed explanation of SQL statements to obtain the variables necessary for estimating the proportion and transition rates of coresidence of people with their children, using the SAC database. I also suggest the potential of RDBMS for achieving effective use of questionnaires in sociological research.

Journal

• Sociological Theory and Methods

  Sociological Theory and Methods 19 (2), 197-212, 2004

  Japanese Association For Mathematical Sociology

Keywords

• relational database
• SQL
• population registers

Details

• CRID: 1390001205165940352
• NII Article ID: 110000991721
• NII Book ID: AN10096921
• DOI: 10.11218/ojjams.19.197
• ISSN: 18816495
• ISSN: 09131442
• NDL BIB ID: 7150726
• Web Site: http://id.ndl.go.jp/bib/7150726
• Web Site: https://ndlsearch.ndl.go.jp/books/R000000004-I7150726
• Text Lang: ja
• Data Source:
  • JaLC
  • NDL
  • CiNii Articles
  • KAKEN
• Abstract License Flag: Disallowed