scholarly journals Comparison of NoSQL Database Performance with SQL Server Database on Online Airplane Ticket Booking

2020 ◽  
Vol 4 (2) ◽  
pp. 64
Author(s):  
Nadea Cipta Laksmita ◽  
Erwin Apriliyanto ◽  
I Wayan Pandu ◽  
Kusrini Rini
Keyword(s):  
Sql Server ◽  
Web Browser ◽  
Travel Agents ◽  
Testing Method ◽  
Database Server ◽  
Database Table ◽  
Nosql Database ◽  
Sql Database ◽  
Sql Server Database ◽  
To Come

<em>Flight ticket booking services have become more advanced, where bookings can be made through the android / iOS application and through a web browser, ticket reservations, no longer have to come to travel agents or come to the airport to book plane tickets. In this study using an online ticket booking database where one database uses the NoSQL database and another database uses SQL Server. The purpose of this research is to test the performance of NoSQL speed with SQL Server with the Insert, Delete and Select commands. The testing method uses 100 records, 500 records, 1000 records, and 5000 records, with each record being tested four times and then taken on average. The results of this study are that the NoSQL database Insert command has a speed 4 times faster than the SQL Server database for under 500 records, whereas above 500 NoSQL database records 5 times slower, the Delete NoSQL database command has a speed 3 times faster than the SQL database Server, and the command Select 1 NoSQL database table 55 times faster than SQL Server databases, while 2 NoSQL database tables are 18 times slower than SQL Server databases, while 3 NoSQL database tables are 10 times slower than SQL Server databases, whereas 4 database tables NoSQL is 16 times slower than SQL Server databases.</em>

The Research of the Second Class Credit in the Credit System

2014 ◽  
Vol 989-994 ◽  
pp. 5209-5212
Author(s):  
Shuang Liang Yao ◽  
Shuang Tong Wang
Keyword(s):  
Sql Server ◽  
Campus Network ◽  
Credit System ◽  
Development Environment ◽  
Credit Reporting ◽  
High Security ◽  
Sql Database ◽  
System Flow ◽  
Sql Server Database ◽  
Flow Diagrams

In order to solve the problem of the second class credit reporting in manual states, we use the system flow diagrams and case diagrams to analysis the needs of users, and use ER diagrams to introduce the SQL database。This article designs the system of the second class credit reporting based on the campus network. The system uses C # as the development language, SQL Server database as a background and Microsoft Visual Studio 2010 as the development environment, with high security and stability.

scholarly journals Implementasi Cloud Computing Menggunakan Metode Pengembangan Sistem Agile

2015 ◽  
Vol 1 (1) ◽  
pp. 29-37
Author(s):  
Much Aziz Muslim ◽  
Nur Astri Retno
Keyword(s):  
Cloud Computing ◽  
Sql Server ◽  
Database Server ◽  
Sql Database ◽  
Windows Server

Cloud computing merupakan sebuah teknologi yang menyediakan layanan terhadap sumber daya komputasi melalui sebuah jaringan. Sumber daya yang di sediakan di dalam cloud computing meliputi mesin, media penyimpanan data, sistem operasi dan program aplikasi. Fitur dari cloud computing dipercaya akan jauh lebih hemat dan memuaskan. Masalah yang muncul adalah bagaimana mengimplementasi Cloud Computing dengan menggunakan Windows Azure Pack dan bagaimana provisioning Windows Azure Pack SQL Database. Fokus pada penelitian ini adalah pada proses deploying dan provisioning SQL Database Server. Pengimplementasian cloud computing menggunakan metode pengembangan sistem agile dengan langkah-langkah meliputi perencanaan, implementasi, pengujian (test), dokumentasi, deployment dan pemeliharaan. Untuk menjalankan proses tersebut kebutuhan perangkat yang dipersiapkan meliputi perangkat keras seperti PC Server Cisco UCS C240 M3S2, Hardisk 8753 GB, 256 GB RAM, bandwith minimal 1 Mbps dan kebutuhan perangkat lunak meliputi Windows Server 2012 R2, VMM, Windows Azure Pack, IIS, SQL Server 2012 dan Web Patform Installer. Hasil dari implementasi cloud computing menggunakan metode pengembangan sistem agile adalah terbentuknya sebuah sistem cloud hosting provider dengan menggunakan Windows Azure Pack dan SQL Server 2012 sebagai sistem utama dan pengelolaan database menggunakan Microsoft SQL Server Management

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

Digital Bookstore

2021 ◽  
Vol 9 (VII) ◽  
pp. 1326-1337
Author(s):  
Amey Thakur
Keyword(s):  
Programming Languages ◽  
Web Application ◽  
Credit Card ◽  
Sql Server ◽  
Data Sets ◽  
Frequent User ◽  
Web Browser ◽  
Book Store ◽  
Different Types ◽  
Online Book

The project's main goal is to build an online book store where users can search for and buy books based on title, author, and subject. The chosen books are shown in a tabular style and the customer may buy them online using a credit card. Using this Website, the user may buy a book online rather than going to a bookshop and spending time. Many online bookstores, such as Powell's and Amazon, were created using HTML. We suggest creating a comparable website with .NET and SQL Server. An online book store is a web application that allows customers to purchase ebooks. Through a web browser the customers can search for a book by its title or author, later can add it to the shopping cart and finally purchase using a credit card transaction. The client may sign in using his login credentials, or new clients can simply open an account. Customers must submit their full name, contact details, and shipping address. The user may also provide a review of a book by rating it on a scale of one to five. The books are classified into different types depending on their subject matter, such as software, databases, English, and architecture. Customers can shop online at the Online Book Store Website using a web browser. A client may create an account, sign in, add things to his shopping basket, and buy the product using his credit card information. As opposed to a frequent user, the Administrator has more abilities. He has the ability to add, delete, and edit book details, book categories, and member information, as well as confirm a placed order. This application was created with PHP and web programming languages. The Online Book Store is built using the Master page, data sets, data grids, and user controls.

Research of Load Balancing Based on NOSQL Database

2014 ◽  
Vol 602-605 ◽  
pp. 3371-3374
Author(s):  
Peng Wang ◽  
Yan Qi
Keyword(s):  
Load Balancing ◽  
Distributed Storage ◽  
Storage System ◽  
Sql Server ◽  
Distributed Storage System ◽  
Nosql Database ◽  
Consistent Hashing ◽  
Cache Hit Ratio ◽  
Hashing Algorithm ◽  
Balancing Principle

The NOSQL database to support data and high concurrent read and write,scalability and high availability features in a distributed storage system which has been applied widely. In this paper, through the research of load balancing in distributed storage system,and it proposes the consistent hashing algorithm and the virtual node strategy, in order to improve the load balancing of the system and increase the cache hit ratio. For the load balancing principle of NOSQL and SQL Server, analysis and comparison of the experimental data.The result shows that, with the increase of the number of virtual nodes, the cache hit ratio of NOSQL is higher than the cache hit ratio of SQL Server.

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