Projects:2020s2-7511 SQL Database for Experimental Metadata

Abstract here

Introduction

In earlier times, all the metadata about each experiment would be kept in laboratory notebooks. This method is reaching the end of its useful lifetime. There is too much data, and physical notebooks are not searchable by machine. If a later researcher studies the data, how are they going to know what it means? What sort of experiment was carried out? Who did the work? Where was it done? What were the objectives of the experiment? What code should be executed in order to process the data? The purpose of this project is to develop a relational database, which can be interrogated using Structures Query Language (SQL). The data will need to be harvested, re-formatted and checked using a scripting language. We are proposing the use of the Python3 programming language. Statistical post-processing of the data can be carried out in several languages, including MATLAB, Python3, or the “R” programming language. There are number of Open-Source SQL data base packages for the Linux operating system, including Bee Keeper, Libre Office BASE, and Keri. Python3 will run under Linux. The early parts of the project would involve programming in a Linux environment. In order to make the work realistic, students will measure a series of RC ladder circuits, using a Picoscope. This will generate large amounts of accurate sampled data, which will then need to be classified and processed. The experimental part of the project is safe and could be carried out off campus, in Adelaide. Remote students, outside of Adelaide, would have to concentrate on the software aspects of the project

Project team

Project students

• Ruoyun Zhou
• Zeyu Fu
• Junwen Zheng

Supervisors

• Dr Andrew Allison

Objectives

Set of objectives

Background

Electrical principles used

There are three laws are used in this project, Ohm’s Law, Kirchhoff’s Current Law and Kirchhoff’s Voltage Law respectively. Ohm’s Law is named for physicist Georg Ohm(1789-1854) from Germany. It aims to calculate the relationship between current, resistance and voltage in an electrical circuit. Voltage is the pressure that triggers flow of electrons, its unit is volt which is always abbreviated as (V). While current is the rate of electron flow, its unit is ampere or amp (A). The last variable is resistance which is the flow inhibitor, note that resistance is a constant as it is measured from the resistor, it does not change according to the voltage and current, resistor unit is ohm(). The formula of Ohm’s Law is voltage = current * resistance, which can be formulated as V=I*R in mathematics. From the formula if two variables values are known then the third one can be calculated by applying the mathematical formula. Ohm’s Law is undoubtably the easiest tool for circuit analysis, however, voltages and currents will not be easily obtained when it comes to analyse complex circuits such as T or bridge networks, therefore, Kirchhoff’s Circuit Law comes in place for the calculation. Kirchhoff’s Circuit Law is developed by a German physicist Gustav Kirchhoff back in 1845 where it consists of two law, KCL and KVL. Kirchhoff’s Current Law is used to cope with the current flows around a closed circuit while Kirchhoff’s Voltage Law is used to cope with the voltage sources present in a closed circuit. Kirchhoff’s Current Law is also referred as Kirchhoff’s First Law and it claims that “total current charge entering a junction or node is exactly equal to the charge leaving the node as it has no other place to go except to leave, as no charge is lost within the node”. The previous sentence can be summarised in a mathematical form as: I_exiting+I_entering=0. This Kirchhoff’s Current Law is known as Conservation of Charge. Note that the electrical terminology node refers to a junction of two or more current carrying paths or elements, e.g. components and cables. Kirchhoff’s Current Law will be applicable for parallel circuits analysis only if a closed circuit exist. Kirchhoff’s Voltage Law is Kirchhoff’s Second Law, it claims “in any closed loop network, the total voltage around the loop is equal to the sum of all the voltage drops within the same loop” which is also equivalent to zero. It can be seen in mathematical as the sum of all voltages in the loop must equivalent to zero. This is known as Conservation of Energy. All voltage will be looping in the same direction, it will be either positive or negative and eventually returning to the original starting point. The reason why the direction is important is if it is not the summation of all voltage will not be equivalent to zero. Whenever there is a phase angle there will be power component called reactive power, it is also referred as imaginary power, it is described in a unit called “volt-amperes reactive”, (VAr). The reactive power, Var, represents the products of amperes and volts which are out-of-phase with each other instead of representing the actual power. Reactive power is the fraction of electricity which alternate current equipment in order to help to sustain and establish the electric and magnetic fields required. Phase angle or phase shift between the current and voltage will affect the amount of reactive power present in an AC circuit. Reactive power is negative when it is “consumed” and it is positive when it is “supplied”. Nowadays, reactive power is adopted by majority types of electrical equipment which uses a magnetic field. For example, transformers, motors and generators. Reactive power is indispensable when overhead power transmission lines experienced reactive losses.

References

[1] a, b, c, "Simple page", In Proceedings of the Conference of Simpleness, 2010.

[2] ...