scholarly journals Performance Tests of Smart City IoT Data Repositories for Universal Linear Infrastructure Data and Graph Databases

2019 ◽  
Vol 1 (1) ◽  
Author(s):  
Michał Gorawski ◽  
Krzysztof Grochla
Keyword(s):  
Smart City ◽  
Graph Representation ◽  
Sql Server ◽  
Graph Database ◽  
Performance Tests ◽  
Data Repositories ◽  
Device Management ◽  
Linear Infrastructure ◽  
Sql Server Database ◽  
The Difference

Abstract The infrastructure managed by Smart City systems includes mainly linear structures, such as pipelines, electric power lines, railway lines, etc.. In this paper, we propose the transcription of linear infrastructure to graph representation and storing needed meta-data in a graph database, merged with the traditional relational database used for device management. Such an approach enables fast acquisition of data about infrastructure’s properties and allows merging information about the structure of the managed infrastructure with information devices’ properties and statistics. We develop a graph generator that generates virtual network basing on representative examples of linear infrastructure, incorporation of a data from existing metering systems with the generated structure, which automates the deployment and allows to evaluate the performance of Smart City monitoring and management system. We present results of performance tests that show and the creation time of graph database structures in Neo4j and the difference between the performance of the Microsoft SQL Server database and the Neo4j database in a few Smart City use cases. The results show that the use of the graph database to execute queries related to linear infrastructure allows decreasing the response time up to 9 times.

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

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.

The Research of Information Extraction in Information System from SQL Server Based on System Table

2013 ◽  
Vol 675 ◽  
pp. 35-38
Author(s):  
Huan Tong Chen ◽  
Wei Zheng ◽  
Yao Fei Chen ◽  
Ying Hua Ni
Keyword(s):  
Information System ◽  
Information Extraction ◽  
Visual Basic ◽  
Sql Server ◽  
Structure Information ◽  
Table Method ◽  
Basic Procedure ◽  
Sql Server Database ◽  
Internal Objects ◽  
Data Tables

This article describes the information extraction in information system from SQL Server. Through the system tables all information of SQL Server's internal objects in information system can be obtained, including databases, data tables, stored procedures and triggers and so on. Analysis the method of the object’s information extraction in information system. Describe the relationships of system tables in SQL Server through the graph and table in detail. A visual basic procedure using system table method is designed to achieve the table’s structure information for all user tables in specified SQL Server database. This method is more complete than the method based on ADOX.

Automatic Marking of SQL Server Based on SQL-DMO

2013 ◽  
Vol 303-306 ◽  
pp. 2369-2372
Author(s):  
Yao Fei Chen ◽  
Wei Zheng ◽  
Huan Tong Chen
Keyword(s):  
Information Acquisition ◽  
The Other ◽  
Skill Assessment ◽  
Sql Server ◽  
Object Model ◽  
Test Paper ◽  
Sql Server Database ◽  
Key Techniques

SQL Server skill assessment is deficient. This article describes the SQL Server object model SQL-DMO. Propose the process of SQL Server skill assessment: test paper generation, Skill assessment and Automatic marking. Analysis two key techniques of skill assessment based on SQL-DMO. One is getting operating information based on SQL-DMO. The other is automatic marking for Skill and Operation. Besides, automatic marking rules for database object creating, modifying and deleting are focused on. The author uses SQL-DMO method to realize database object information acquisition, and implement automatic marking for SQL Server database skill assessment.

Study on Network Process System of Engine

2007 ◽  
Vol 10-12 ◽  
pp. 34-38
Author(s):  
Li Hua Dong ◽  
Jian Huang ◽  
X.H. Xing ◽  
L.G. Wang
Keyword(s):  
Manufacturing Process ◽  
Sql Server ◽  
Advanced Manufacturing ◽  
Network System ◽  
Network Economy ◽  
Core Competitiveness ◽  
Network Process ◽  
Sql Server Database ◽  
Process System ◽  
Manufacturing Mode

Network manufacturing, with the development of network economy, is advanced manufacturing mode. It’s applied widely. The engine manufacturing process of advanced motor company is studied and analyzed in this paper. The network system of engine manufacturing process is designed, which is based on the platform of .NET and SQL Server database. The network manufacturing of engine is realized. It reduces production cost and improves company’s core competitiveness. Carrying out the system’s parted purview management, it’s safe and credible.

Sign in / Sign up

Export Citation Format

Share Document