Projects:2020s2-7511 SQL Database for Experimental Metadata - Revision history

A1702535: by Junwen

2021-06-04T06:19:46Z

by Junwen

A1702535: /* Topic 1 */

2021-06-04T06:15:40Z

‎Topic 1

A1702535: /* Background */

2021-06-04T06:15:08Z

‎Background

A1741862: /* Supervisors */

2020-09-02T04:05:43Z

‎Supervisors

A1741862: /* Project students */

2020-09-02T04:05:26Z

‎Project students

A1741862: /* Project students */

2020-09-02T04:04:59Z

‎Project students

A1741862: Created page with "Category:2020s2-7511 SQL Database for Experimental Metadata Category:Final Year Projects 7511 SQL Database for Experimental Metadata Abstract here..."

2020-09-02T04:04:22Z

Created page with "Category:2020s2-7511 SQL Database for Experimental Metadata Category:Final Year Projects 7511 SQL Database for Experimental Metadata Abstract here..."

New page

[[Category:2020s2-7511 SQL Database for Experimental Metadata]]
[[Category:Final Year Projects]]
[[Category:2020 s2|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
==== Advisors ====
*
*

=== Objectives ===
Set of objectives

== Background ==
=== Topic 1 ===

== Method ==

== Results ==

== Conclusion ==

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

[2] ...

@@ Line 34: / Line 34: @@
 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.
-== Method ==
+== Error Estimation ==
 == Results ==

@@ Line 25: / Line 25: @@
 == Background ==
-=== Topic 1 ===
+=== 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.

@@ Line 10: / Line 10: @@
 === Project team ===
 ==== Project students ====
-* <Student 1's name>
+* Ruoyun Zhou
-* <Student 2's name>
+* Zeyu Fu
-* <Student 3's name>
+* Junwen Zheng
 ==== Supervisors ====

@@ Line 15: / Line 15: @@
 ==== Supervisors ====
-Dr Andrew Allison
+* Dr Andrew Allison
 ==== Advisors ====
+*