SQL Data Definition Statements

The Theta method attracted the attention of researchers and practitioners in recent years due to its simplicity and superior forecasting accuracy. Its performance has been confirmed by many empirical studies as well as forecasting competitions. In this article the Theta method is tested in short-term load forecasting problem. The load time series expressing multiple seasonal cycles is decomposed in different ways to simplify the forecasting problem. Four variants of input data definition are considered. The standard Theta method is uses as well as the dynamic optimised Theta model proposed recently. The performances of the Theta models are demonstrated through an empirical application using real power system data and compared with other popular forecasting methods.

Download Full-text

The two-level approach to data definition and space management in the LIS system implementation language

10.1145/800021.808286 ◽

1973 ◽

Cited By ~ 1

Author(s):

J. D. Ichbiah ◽

J. P. Rissen ◽

J. C. Heliard

Keyword(s):

System Implementation ◽

Space Management ◽

Data Definition

Download Full-text

Development of a customised data management system for a COVID-19-adapted colorectal cancer pathway

BMJ Health & Care Informatics ◽

10.1136/bmjhci-2020-100307 ◽

2021 ◽

Vol 28 (1) ◽

pp. e100307

Author(s):

Janice Miller ◽

Frances Gunn ◽

Malcolm G Dunlop ◽

Farhat VN Din ◽

Yasuko Maeda

Keyword(s):

Colorectal Cancer ◽

Data Management ◽

Management System ◽

Data Entry ◽

Large Data ◽

Data Management System ◽

Volume Data ◽

Visual Basic For Applications ◽

Resource Limited ◽

Data Definition

ObjectivesA customised data management system was required for a rapidly implemented COVID-19-adapted colorectal cancer pathway in order to mitigate the risks of delayed and missed diagnoses during the pandemic. We assessed its performance and robustness.MethodsA system was developed using Microsoft Excel (2007) to retain the spreadsheets’ intuitiveness of direct data entry. Visual Basic for Applications (VBA) was used to construct a user-friendly interface to enhance efficiency of data entry and segregate the data for operational tasks.ResultsLarge data segregation was possible using VBA macros. Data validation and conditional formatting minimised data entry errors. Computation by the COUNT function facilitated live data monitoring.ConclusionIt is possible to rapidly implement a makeshift database system with clinicians’ regular input. Large-volume data management using a spreadsheet system is possible with appropriate data definition and VBA-programmed data segregation. The described concept is applicable to any data management system construction requiring speed and flexibility in a resource-limited situation.

Download Full-text