{"id":{"repo_id":"mcmaster","oai_identifier":"oai:macsphere.mcmaster.ca:11375/6573"},"canonical_url":"https://search.ndltd.org/etd/mcmaster/oai:macsphere.mcmaster.ca:11375/6573","repository":{"repo_id":"mcmaster","name":"McMaster University","base_url":"https://macsphere.mcmaster.ca/server/oai/request"},"display":{"title":"Architectural Features of WCRC - A Data Base Computer","abstract":"<p>Several data base machine architectures have been proposed in the past few years. The next generation of these machines must support different data models on the same physical data simultaneously as envisaged in the ANSI/X3/SPARC report or the coexistence model.</p> <p>This thesis presents the architectural features of one such data base machine called Well Connected Relational Computer (WCRC). The overall architecture and the facilities to the user as well as the DBA have been described. A framework for the conceptual level and detailed design of the internal level are reported. The algorithms for schema conversion and view translation have been developed. The conceptual level language, WCRL is extended to accommodate data definition, data manipulation and storage definition facilities. A high level language, DBAL, is developed for the DBA. Two binary storage structures (Pseudo Canonical Partitions (PCP's - Options I and II) have been reported for storing the data at the internal level. They radically differ from the conventional n-ary relational storage structure. A machine oriented language (WCRML) is developed to directly execute the data base instructions in hardware on the PCP storage structures. The basic hardware organization of the internal level along with special hardware units for some data base functions such as join and sort have been reported. Finally, a performance evaluation of WCRC storage structures has been presented. The results indicate that WCRC requires lesser storage and offers faster query response time when compared to architectures based on n-ary relation storage.</p>","abstract_html":"&lt;p&gt;Several data base machine architectures have been proposed in the past few years. The next generation of these machines must support different data models on the same physical data simultaneously as envisaged in the ANSI/X3/SPARC report or the coexistence model.&lt;/p&gt; &lt;p&gt;This thesis presents the architectural features of one such data base machine called Well Connected Relational Computer (WCRC). The overall architecture and the facilities to the user as well as the DBA have been described. A framework for the conceptual level and detailed design of the internal level are reported. The algorithms for schema conversion and view translation have been developed. The conceptual level language, WCRL is extended to accommodate data definition, data manipulation and storage definition facilities. A high level language, DBAL, is developed for the DBA. Two binary storage structures (Pseudo Canonical Partitions (PCP&#x27;s - Options I and II) have been reported for storing the data at the internal level. They radically differ from the conventional n-ary relational storage structure. A machine oriented language (WCRML) is developed to directly execute the data base instructions in hardware on the PCP storage structures. The basic hardware organization of the internal level along with special hardware units for some data base functions such as join and sort have been reported. Finally, a performance evaluation of WCRC storage structures has been presented. The results indicate that WCRC requires lesser storage and offers faster query response time when compared to architectures based on n-ary relation storage.&lt;/p&gt;","abstract_has_math":false,"creators":["Dumpala, Surya R."],"institution":null,"degree_name":null,"degree_level":null,"degree_discipline":null,"degree_department":"Electrical Engineering","school":null,"contributors":[],"advisors":["Arora, Sudhir K."],"committee_chairs":[],"committee_members":[],"year":1981,"date_issued":"1981-03","date_published":"1981-03","updated_at":"2026-11-18T19:33:38Z","subjects":["Electrical and Electronics"],"languages":[],"rights":[],"rights_urls":[],"identifier_entries":[{"key":"dc:identifier.uri","label":"Identifier URI","values":["https://doi.org/10.71548/14634"],"render_values":[{"text":"https://doi.org/10.71548/14634","href":"https://doi.org/10.71548/14634","code":true}]},{"key":"dc:identifier.other","label":"Dc Identifier Other","values":["opendissertations/188","1426","907617"],"render_values":[{"text":"opendissertations/188","href":null,"code":true},{"text":"1426","href":null,"code":true},{"text":"907617","href":null,"code":true}]}],"person_identifier_entries":[]},"links":{"outbound_url":"http://hdl.handle.net/11375/6573","outbound_label":"Handle","outbound_source":"dc:identifier.uri","record_url":"http://hdl.handle.net/11375/6573","record_label":"Repository record","record_kind":"handle","record_source":"dc:identifier.uri","download_url":null,"download_label":null,"download_source":null,"access_status":null,"embargo_until":null,"access_note":null},"source_record":{"url":"https://macsphere.mcmaster.ca/server/oai/request?verb=GetRecord&metadataPrefix=dim&identifier=oai%3Amacsphere.mcmaster.ca%3A11375%2F6573","prefix":"dim"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor.advisor","label":"Advisor","values":["Arora, Sudhir K."]},{"key":"dc:contributor.department","label":"Department","values":["Electrical Engineering"]},{"key":"dc:creator","label":"Author","values":["Dumpala, Surya R."]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date.accessioned","label":"Dc Date Accessioned","values":["2014-06-18T16:36:05Z"]},{"key":"dc:date.available","label":"Dc Date Available","values":["2014-06-18T16:36:05Z"]},{"key":"dc:date.created","label":"Dc Date Created","values":["2009-07-22"]},{"key":"dc:date.issued","label":"Date","values":["1981-03"]},{"key":"dc:type","label":"Dc Type","values":["thesis"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["Electrical and Electronics"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier.other","label":"Dc Identifier Other","values":["opendissertations/188","1426","907617"]},{"key":"dc:identifier.uri","label":"Identifier URI","values":["http://hdl.handle.net/11375/6573","https://doi.org/10.71548/14634"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description.abstract","label":"Abstract","values":["<p>Several data base machine architectures have been proposed in the past few years. The next generation of these machines must support different data models on the same physical data simultaneously as envisaged in the ANSI/X3/SPARC report or the coexistence model.</p> <p>This thesis presents the architectural features of one such data base machine called Well Connected Relational Computer (WCRC). The overall architecture and the facilities to the user as well as the DBA have been described. A framework for the conceptual level and detailed design of the internal level are reported. The algorithms for schema conversion and view translation have been developed. The conceptual level language, WCRL is extended to accommodate data definition, data manipulation and storage definition facilities. A high level language, DBAL, is developed for the DBA. Two binary storage structures (Pseudo Canonical Partitions (PCP's - Options I and II) have been reported for storing the data at the internal level. They radically differ from the conventional n-ary relational storage structure. A machine oriented language (WCRML) is developed to directly execute the data base instructions in hardware on the PCP storage structures. The basic hardware organization of the internal level along with special hardware units for some data base functions such as join and sort have been reported. Finally, a performance evaluation of WCRC storage structures has been presented. The results indicate that WCRC requires lesser storage and offers faster query response time when compared to architectures based on n-ary relation storage.</p>"]},{"key":"dc:description.degree","label":"Dc Description Degree","values":["Master of Engineering (ME)"]},{"key":"dc:title","label":"Title","values":["Architectural Features of WCRC - A Data Base Computer"]},{"key":"others:access_status","label":"Others Access Status","values":["open.access"]}]}],"canonical_facts":{"dc:contributor.advisor":["Arora, Sudhir K."],"dc:contributor.department":["Electrical Engineering"],"dc:creator":["Dumpala, Surya R."],"dc:date.accessioned":["2014-06-18T16:36:05Z"],"dc:date.available":["2014-06-18T16:36:05Z"],"dc:date.created":["2009-07-22"],"dc:date.issued":["1981-03"],"dc:description.abstract":["<p>Several data base machine architectures have been proposed in the past few years. The next generation of these machines must support different data models on the same physical data simultaneously as envisaged in the ANSI/X3/SPARC report or the coexistence model.</p> <p>This thesis presents the architectural features of one such data base machine called Well Connected Relational Computer (WCRC). The overall architecture and the facilities to the user as well as the DBA have been described. A framework for the conceptual level and detailed design of the internal level are reported. The algorithms for schema conversion and view translation have been developed. The conceptual level language, WCRL is extended to accommodate data definition, data manipulation and storage definition facilities. A high level language, DBAL, is developed for the DBA. Two binary storage structures (Pseudo Canonical Partitions (PCP's - Options I and II) have been reported for storing the data at the internal level. They radically differ from the conventional n-ary relational storage structure. A machine oriented language (WCRML) is developed to directly execute the data base instructions in hardware on the PCP storage structures. The basic hardware organization of the internal level along with special hardware units for some data base functions such as join and sort have been reported. Finally, a performance evaluation of WCRC storage structures has been presented. The results indicate that WCRC requires lesser storage and offers faster query response time when compared to architectures based on n-ary relation storage.</p>"],"dc:description.degree":["Master of Engineering (ME)"],"dc:identifier.other":["opendissertations/188","1426","907617"],"dc:identifier.uri":["http://hdl.handle.net/11375/6573","https://doi.org/10.71548/14634"],"dc:subject":["Electrical and Electronics"],"dc:title":["Architectural Features of WCRC - A Data Base Computer"],"dc:type":["thesis"],"others:access_status":["open.access"]},"updated_at":"2026-11-18T19:33:38Z"}