International AC: An Education Case on Continuous Monitoring SQL Server Data with ODBC-Linked Tables in Microsoft Access

2016 ◽  
Vol 13 (2) ◽  
pp. 195-213
Author(s):  
Sherwood Lane Lambert ◽  
Jon Holladay ◽  
Dawna M. Drum
Keyword(s):  
Faculty Member ◽  
Continuous Monitoring ◽  
Sql Server ◽  
Continuous Auditing ◽  
Microsoft Access ◽  
Database Administrator ◽  
Open Database Connectivity ◽  
Database Connectivity ◽  
Random Times

ABSTRACT This education case teaches students Continuous Auditing/Continuous Monitoring (CA/CM) using Open Database Connectivity (ODBC) connections from students' Microsoft Access (Access) to tables in Microsoft SQL Server (SQL Server). First, the institution's database administrator (DBA) imports the student tables provided with the Teaching Notes into the institution's SQL Server with read-only access. In Access, students create ODBC connections to the SQL Server student tables. Then, students create Access queries using the ODBC-linked tables to monitor for anomalies. During a scheduled week, the DBA, in coordination with the faculty member, enters anomalies in the SQL Server student tables at random times, and students run their Access queries to identify the anomalies.

scholarly journals Dissecting host-associated communities with DNA barcodes

2016 ◽  
Vol 371 (1702) ◽  
pp. 20150328 ◽  
Author(s):  
Christopher C. M. Baker ◽  
Leonora S. Bittleston ◽  
Jon G. Sanders ◽  
Naomi E. Pierce
Keyword(s):  
Species Interactions ◽  
Morphological Characters ◽  
South American ◽  
Dna Barcodes ◽  
Substantial Variation ◽  
East African ◽  
Pitcher Plant ◽  
Genome Data ◽  
Symbiotic Interactions ◽  
Database Connectivity

DNA barcoding and metabarcoding methods have been invaluable in the study of interactions between host organisms and their symbiotic communities. Barcodes can help identify individual symbionts that are difficult to distinguish using morphological characters, and provide a way to classify undescribed species. Entire symbiont communities can be characterized rapidly using barcoding and especially metabarcoding methods, which is often crucial for isolating ecological signal from the substantial variation among individual hosts. Furthermore, barcodes allow the evolutionary histories of symbionts and their hosts to be assessed simultaneously and in reference to one another. Here, we describe three projects illustrating the utility of barcodes for studying symbiotic interactions: first, we consider communities of arthropods found in the ant-occupied domatia of the East African ant-plant Vachellia ( Acacia ) drepanolobium ; second, we examine communities of arthropod and protozoan inquilines in three species of Nepenthes pitcher plant in South East Asia; third, we investigate communities of gut bacteria of South American ants in the genus Cephalotes . Advances in sequencing and computation, and greater database connectivity, will continue to expand the utility of barcoding methods for the study of species interactions, especially if barcoding can be approached flexibly by making use of alternative genetic loci, metagenomes and whole-genome data. This article is part of the themed issue ‘From DNA barcodes to biomes’.

Accessing Data From Multiple Heterogeneous Distributed Database Systems

2019 ◽  
pp. 192-219
Author(s):  
Shefali Trushit Naik
Keyword(s):  
System Parameter ◽  
Database Systems ◽  
Distributed Database ◽  
Sql Server ◽  
Distributed Database Systems ◽  
Data Source ◽  
Database Connectivity ◽  
Relational Database Management ◽  
Complete Process ◽  
Relational Database Management Systems

This chapter describes the method to retrieve data from multiple heterogeneous distributed relational database management systems such as MySQL, PostgreSQL, MS SQL Server, MS Access, etc. into Oracle RDBMS using Oracle's Heterogeneous Gateway Services. The complete process starting from downloading and installation of required software, creation of data source names using open database connectivity, modification of system parameter files, checking connections, creation of synonyms for tables of remote databases into oracle, creation of database links and accessing data from non-oracle databases using database links is explained in great detail. Apart from this, data manipulation in remote databases from Oracle and execution of PL/SQL procedures to manipulate data residing on remote databases is discussed with examples. Troubleshooting common errors during this process is also discussed.

Sign in / Sign up

Export Citation Format

Share Document