BITS PilaniPilani | Dubai| Goa | Hyderabad

Data Health Monitoring

By: Neelesh Palod, Shivalik Sen, Praveen Sharma, Pearly Khare

PS2: Ramco Systems Ltd.

By: Pearly Khare, Abhinav Jain, Neelesh Palod, Shivalik Sen, Praveen SharmaPS II- Ramco Systems

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Data Health Monitoring Tool

• This tool will be used to execute consistency queries, transaction statistics, month end

reconciliations and generate reports. Phase 1 – Consistency Queries

• The consistency report is used as a measure of Data Health. It checks for inconsistent

data in the database.

• It uses the set of consistency queries that compare the master table with other tables

to find discrepancy in data.

• It is important to keep data discrepancy and inconsistencies at a minimum to reduce

query times, errors, faulty outputs,

• Transaction statistics is used to know about the frequency of the component of the

aviation product, used by the costumer, user load, etc.

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Sign In

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Dashboard

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Consistency Report

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Consistency Report

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Consistency Report Results

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Transaction Statistics

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Transaction Statistics Results

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

About

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Admin Site

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Admin Dashboard

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Authentication- User

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Add User

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Master- Business Component

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Add Customer

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Add Modules

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Sign Out

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Design

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Design

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Design

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Design

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

• Django is a free and open source web application framework, written in Python, which follows the model view–controller (MVC) architectural pattern.

• A web application framework (WAF) is a software framework that is designed to support the development of dynamic websites, web applications, web services and web resources.

• Model–view–controller (MVC) is a software architectural pattern for implementing user interfaces.

• Django’s primary goal is to ease the creation of complex, database-driven websites.

• Python is used throughout, even for settings, files, and data models.

Coding

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

• Model layer: Django provides an abstraction layer (the “models”) for structuring and manipulating the data of your Web application.

• View layer: Django has the concept of “views” to encapsulate the logic responsible for processing a user’s request and for returning the response.

• Template layer: The template layer provides a designer-friendly syntax for rendering the information to be presented to the user .

• Server arrangements: Django officially supports four database backends: PostgreSQL, MySQL, SQLite, and Oracle. Microsoft SQL Server can be used with django-mssql but only in Microsoft operating systems.

Django Key Features

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956

Data Analysis

• Phase two program

• Data analysis on a big data scale might be needed here. If in house servers not able to handle – we will look at Hadoop/Hive options.

• Data mining needed to spot trends in Data Health – redundancies, inconsistencies, etc

• Trends predictable or not – spikes can be predicted based on event sequence algorithms

• In first phase – plan to introduce an intermediate level time domain analysis for inconsistencies, redundancies – spot trends, spikes, etc

BITS Pilani, Deemed to be University under Section 3 of UGC Act, 1956