scholarly journals Performance analysis of relational databases Oracle and MS SQL based on desktop application

2018 ◽  
Vol 8 ◽  
pp. 263-269
Author(s):  
Grzegorz Dziewit ◽  
Jakub Korczyński ◽  
Maria Skublewska-Paszkowska
Keyword(s):  
Binary Data ◽  
Relational Databases ◽  
Database Systems ◽  
Database System ◽  
Sql Server ◽  
External Application ◽  
Oracle Database ◽  
Sql Server Database ◽  
Relational Database Systems ◽  
Mean Time

Comparison of efficiency is not a trivial phenomenon because of disparities between different database systems. This paper presents a methodology of comparing relational database systems in respect of mean time of execution individual DML queries containing subqueries and conjunction of tables. The presented methodology can be additionally accommodated to studies of efficiency in a range of database system itself (study of queries executed directly in database engine). The described methodology allows to receive statement telling which database system is better in comparison to another in dependency of functionalities fulfilled by external application. In the article the analysis of mean time of execution individual DML queries was performed.Two research hypotheses have been put forward: "Microsoft SQL Server database system needs less time to execute INSERT and UPDATE queries than Oracle database" and "Oracle database system needs less time to execute DML queries with binary data than SQL Server"

Data Security Monitoring of SQL Server Database

2013 ◽  
Vol 679 ◽  
pp. 143-146
Author(s):  
Zhang Hui ◽  
Li Qiang An ◽  
Peng Yue
Keyword(s):  
Data Security ◽  
Information Aggregation ◽  
Research Process ◽  
Database System ◽  
Sql Server ◽  
Important Data ◽  
Security Monitoring ◽  
Daily Work ◽  
Sql Server Database

Database system is information aggregation. So the security of database is very important. This paper describes the research process of tracking SQL server database data tampered. Now we can monitor the important data in daily work. And providing a guarantee for the safety, accuracy of database.

scholarly journals SNIP Light User Manual

2020 ◽  
Author(s):  
Andrew P. Tarko ◽  
Jose Thomaz ◽  
Mario Romero
Keyword(s):  
Data Storage ◽  
Traffic Safety ◽  
Road Safety ◽  
Cost Effective ◽  
Sql Server ◽  
University Center ◽  
Metropolitan Planning ◽  
Light User ◽  
Sql Server Database ◽  
Original Component

A systemic approach to identifying road locations that exhibit safety problems was provided by the Safety Needs Identification Program (SNIP and SNIP2) developed by the Purdue University Center for Road Safety (CRS). The new version SNIP Light has been developed to provide other uses with planning level traffic safety analysis capability for a wider range of uses including Metropolitan Planning Agencies (MPOs) who want the tool for planning cost-effective safety programs in their metropolitan areas. The SNIP Light reduces the demand of computing and data storage resources and replaces the SQL server database system an integrated module coded in-house which is considerably faster than the original component. Furthermore, certain proficiency required to install and use the old version is no longer needed thanks to the intuitive single-window interface and executing file operations in the background without the user’s involvement. Some operations, such as optimizing funding of safety projects, are removed to simplify the tool.

Design of PC Remote Monitoring System for Standby Generators

2014 ◽  
Vol 1039 ◽  
pp. 197-202
Author(s):  
Chuan Hong Zhou ◽  
Jin Jie Xiao ◽  
Wei Ren
Keyword(s):  
Monitoring System ◽  
Remote Monitoring ◽  
Interface Design ◽  
Database Design ◽  
Sql Server ◽  
Monitoring Device ◽  
Remote Monitoring System ◽  
Remote Server ◽  
Sql Server Database ◽  
Low Efficiency

Currently,some problems exist in the process of using standby generators, such as low efficiency,high cost and late service of artificial overhaul and maintenance.In order to overcome these problems, PC remote monitoring system is designed.This paper mainly introduces the structure composition,function,interface design and SQL Server database design of the system.In addition, the function of communication between the PC remote server and signal monitoring device was tested and the effect was desired

The Challenges of Checking Integrity Constraints in Centralized, Distributed, and Parallel Databases

2009 ◽  
pp. 365-377
Author(s):  
Hamidah Ibrahim
Keyword(s):  
Concurrency Control ◽  
Database System ◽  
Database Security ◽  
Integrity Constraints ◽  
Research Areas ◽  
Security Control ◽  
Software Integrity ◽  
Reliability Control ◽  
Semantic Errors ◽  
Or Applications

A vital problem that should be tackled in today’s database system is guaranteeing database consistency. Many techniques and tools have been devised to fulfill this requirement in many interrelated research areas such as concurrency control, security control, reliability control, and integrity control (Eswaran & Chamberlin, 1975; Grefen, 1993). Concurrency control deals with the prevention of inconsistencies caused by concurrent access by multiple users or applications to a database. Security control deals with preventing users from accessing and modifying data in a database in unauthorized ways. Reliability control deals with the prevention of errors due to the malfunctioning of system hardware or software. Integrity control deals with the prevention of semantic errors made by users due to their carelessness or lack of knowledge. This chapter is concerned only with integrity control.

A Research of Direction Expert System Technology for Aircraft Maintenance

2011 ◽  
Vol 403-408 ◽  
pp. 1692-1695
Author(s):  
Zhi Qiu ◽  
Shou Miao Yu ◽  
Zheng Wang
Keyword(s):  
Fault Diagnosis ◽  
Expert System ◽  
Web Service ◽  
Expert Knowledge ◽  
Sql Server ◽  
Aircraft Maintenance ◽  
System Technology ◽  
Sql Server Database ◽  
Database Technology

An direction expert system for aircraft maintain with expert knowledge graphical building, three layers distributed web service, distance fault diagnosis and gather experience ability is introduced here. It is developed based on Delphi 6.0 utilizing multilayer web service, CLIPS expert system and SQL SERVER database technology.

A portable real-time EEG signal acquisition and tele-medicine system

2020 ◽  
pp. 1-11
Author(s):  
Qiang Zhang ◽  
Peng Wang ◽  
Shanshan Li ◽  
Yonghao Jing
Keyword(s):  
Real Time ◽  
Sql Server ◽  
Signal Acquisition ◽  
Eeg Signal ◽  
Eeg Signals ◽  
Eeg Data ◽  
Sql Server Database ◽  
High Power Consumption ◽  
Machine Interface ◽  
Sd Card

Since electroencephalogram (EEG) signals contain a variety of physiological and pathological information, they are widely used in medical diagnosis, brain machine interface and other fields. The existing EEG apparatus are not perfect due to big size, high power consumption and using cables to transmit data. In this paper, a portable real-time EEG signal acquisition and tele-medicine system is developed in order to improve performance of EEG apparatus. The weak EEG signals are induced to the pre-processing circuits via a noninvasive method with bipolar leads. After multi-level amplifying and filtering, these signals are transmitted to DSP (TMS320C5509) to conduct digital filtering. Then, the EEG signals are displayed on the LCD screen and stored in the SD card so that they can be uploaded to the server through the internet. The server employs SQL Server database to manage patients’ information and to store data in disk. Doctors can download, look up and analyze patients’ EEG data using the doctor client. Experimental results demonstrate that the system can acquire weak EEG signals in real time, display the processed results, save data and carry out tele-medicine. The system can meet the requirement of the EEG signals’ quality, and are easy to use and carry.

Development of Electric Vehicle Remote Monitoring System's Server and Client Application

2014 ◽  
Vol 535 ◽  
pp. 26-31
Author(s):  
Zhi Zhong Li ◽  
Shi Chun Yang ◽  
Zi Tao Liu
Keyword(s):  
Electric Vehicle ◽  
Monitoring System ◽  
Remote Monitoring ◽  
Sql Server ◽  
Client Application ◽  
Electric Cars ◽  
Remote Monitoring System ◽  
Sql Server Database ◽  
Database Language ◽  
Client Needs

This paper analyzed the practical needs of remote monitoring of electric vehicle and illustrates the overall architecture of a remote monitoring system, and further developed a remote monitoring system of the Server and client application with the ASP.NET and Microsoft SQL Server database language, basically can meet the electric cars remote monitoring of the Server and client needs.

Sign in / Sign up

Export Citation Format

Share Document