Sql Assistant Part 3 Working With (Table Report)

This report will list table name and it's size,
In our company there is a table which is storing price-tick,of all symbols ,also storing Audit trail information,
which contained all the user activity information and market information etc, so periodically we need to check all the tables
SQL server also having very good report options, but I am using this , because it has some other reports use to analyse the DB.

This report will list table which don't have foreign-key, this report is very useful to cross check the table has missed any reference, useful while developing and debug the application

Report : Table has foreign key

Report : Table don't have constraints

Report : Table having any constraints

Outlook of Matrix Nexus

this image will express, implementation of Matrixnexus.

https://drive.google.com/open?id=

Deploying and Patch updates of Matrix Nexus

Deployment of MatrixNexus:
To publish our application, I used Windows MSI installer to create the packages, and we will upload this into our website, there are two types of updates we are giving which all are
1. MSI (Setup)
2. Patch updater
MSI Setup
This MSI setup is for e new users or those who want to install fresh copy of Nexus on their system. They can download it from our website and install it.

Patch Updater Path updater is, for the existing Matrix-Nexus customer , when ever we uploads new version, our existing Matrix nexus will check the current version and will automatically install the required updates. it has 3 stages, which all are
1.Checking version and checking the type of version
2.Checking scripts
3.Execute the scripts and update it.
Checking version and checking type of the version This is the essential part of the Patch-updater, this will check, current version of nexus, and will check the updated version of patch, if the patch is newer than the current one, it will check the type of patch. the type of patches are given below.
1.Mandatory
2.Not-Mandatory
if patch has mandatory updates, it will forcefully update all the updates , if the patch is not mandatory update, then will popup a Message Box, and will ask user to update the updates, and let the user to choose the option, he can either update it or can skip it.
In this case, each user can have different version,when ever they start the update process , it is not good thing to apply all updates to all version, because some of the user may have recently updated patches, which required less updates, some of them may uses older version so, they required full updates, this patch updater will analyse, collect complete information of the existing system, and it will use the script called MI-SCRIPT, as per that script it will update the existing system. MI-SCRIPT is a small script mechanism created by me handled the update process .
Example of MI-SCRIPT

Checking version

Updating patches

Rebooting nexus

Sql Assistant - Part 2 Working with Table

Note:
The following Database is not my company's official or part of my company's official database, the screenshot showing Northwind DB, which is a test Database available on Internet for testing purpose, and this demo is using SQL-EXPRESS Edition,
Listing all tables
once it connected with the Database , it will automatically list all the tables on it's left panel side.

Getting Structure
to get structure of the table, first we have to select the table, you can select it from the list showing on Left side panel, and by giving double-click , it will list the structure.

on the above picture ,you can see, this tools listing the information that contains
1.Col-name
2.Datatype
3.Size of the column
4.Constraints (by using this column, we can know,the table has reference )
5.Reference table name
6.Constraints name
7.Delete Action
8.Update Action

Listing NOT NULLS
On the second Tab , it is listing NOT NULL columns,

Listing Stored Procedures,Views and Functions that is using the selected table
you can see the third column listing all stored procedures,vies and functions using the selected table.

Listing Child Table
On Fourth column you can see, it is listing child tables, which is referring this table.

this tab contained following information:
1. Constraint name of current table primarykey
2. Foreign Key Column
3. Referencing table
4. Referencing column
5. Parent table
6. Parent table column
will continue...

Sql Assistant Part 1 - Overview

SQL Assistant I developed this tools for my personal use, this is multipurpose tools, first, we will talk about how to Analyse a table.Before start working with a table , I want to know the following things.

• Want to list Constraints of table(Primary Key and other)
• Want to list Constraints of table Not Null columns
• List of reference
• Need to know referred by
• List of Stored Procedure using the table
• List of Views using the table
• List of Function using the table

in one-line we can say dependencies of a Table. If we know that, that will give good idea to us to make better plan.

For that I have planned create a tool called SQL ASSISTANT

Features:

• It is providing read only access, which means, will not do Insert/Update/Delete anything.
• In a single mouse click, it will list the required information.

Implementation of Multi-thread Programming on MatrixNexus

MatrixNexus is created by using alot of Components and class libraries, Another important features of Matrixnexus is multi-threading, each thread is designed to do a special task, this technique allows, execute multiple programs at a same time , for an example see the images given below. The requirements were
1. system has to receive feeds from MDF server and concurrently it have to update watch-list
2. On interval basis system has to send request for Cash-balance, portfolio,current orders updates, concurrently let other threads allow to update the Portfolio , cash-balance ,current orders,watch-lists and ticker tapes. The system must not get hang or wait for any thread to finish it's task. It have to allow user to watch and place order without fail.

Multi-thread

COM and MatrixNexus

COM
Here I am going to explain, what all are the COM , I created for MatrixNexus.
Purpose of the COM are Re usability, Easy to Use, Ease to Debug , and reduce the code complexity etc.
MDF Client

This module is used connect with MDF server, this will send Authentication request to MDF server and will wait, once Authendicated it will send another request for get the feeds, purpose of this client module is, to get high speed data feeds from the MDF server and update the watch-list.
I used this for two Markets (ADX) and (DFM) market. This is reusable all over the world MDF connection are using same method, so,this is suitable for any Market
Features:

• It is using very less CPU usage,
  
• Has property to find Disconnection
  
• Suitable for any markets
  

Portfolio Grid

The requirement is show the portfolio of the users, user may have more stock on his portfolio, whenever the market price changes , at the sametime, the portfolio also will get update. This portfolio component has features to show GAIN/LOSS on a separate row, and it is a fixed-row, user doesn't required to scroll down to see the PROFIT/LOSS and GAIN/LOSS, this row will be always on TOP.
Blinker

Requirement is , need to show the status of current connection, as we know, when we working with network application , there is possibility to get disconnections, I designed this to show the status,whenever disconnection occur , it will change it color into read will start blink , mostly it will try to reestablish the connection, when fail, it will start blink, so I put name Blinker. When it starts blink, user can easily identify it, we are using two server for trade, one is for PRICE (used to get high speed MDF feeds) another one is TRADE ( used to manage order,portfolio,current cash-balance etc)
Stock Move /Price Bar

Requirement is when user select a symbol , we have to show the current price movement of selective symbol, this will help the user to analyse the symbol, I used the same tool to analyse all symbols in one click. Also I used this component for HTML report too.
Above Image showing using component on toolbar for selective symbol

now using same component with Datagridview for multiple symbols

Showing example usage of same component for HTML report

Display Board Terminal

Developed for AL-DHAFRA-EXCHANGE, (UAE), and my roll was Team Leader. Purpose of this application is to show the current rate of currency pair on display screen, it is using SQL server as backend . Each need has to show different prices and need to show currency based on demand,.
Features:- • Has centralized admin panel to control all branch • Has centralized control panel to manage users • Branch control to enable/ Disable branch • Customizable price for same currency for different branches • Customizable display of currency for different branch • If more currency need to show, page by page display is given.

MatrixNexus Trading Platform

Developed for AL-DHAFRA FINIANCIAL BROKERS L.L.C (UAE), and my roll was Team leader.
This is a trading terminal is similar to MatrixPro . It is using WEB API (XML/RPC) to handle request and response. For this trading terminal we have developed direct MDF client terminal to handle the very high speed price updates. Project is distributed by deploy able MSI.
Major module of Matrix Nexus 1. MI-Patch Updater 2. MI-Script Manager 3. MI-Version Manger 4. MI-Settings Manager 5. MI-MDF connector (inetClient) 6. NexusClient
MI-Patch Updater: • Used to identify and download the patch files from web , and will update the MatrixNexus Client components. • It is using MI-SCRIPT format to update the components, By using MI-SCRIPT , we can easily update selective version of running MatrixNexus Client, which will not affect other version of MatrixNexus.
MI-Script Manager: • It is a sub-component of MatrixNexus Client, used to execute MI-Script. • By using MI-Script, Updater can easily identify the running version MatrixNexus. • By using MI-Script, we can update selective version and selective files. So ,it is not necessary to uninstall/ re-install for every new release. • Using this kind of technique, the update size will be very less, and the update time will be very short. • MI-Script is simple script method, looks like javascript. It is providing decision block method to apply selective files update for different version.
MI-Version Manager: • This component controls the versions of MatrixNexus • Using this, we can forcefully enable/disable a specific version of MatrixNexus Client • Using this, we can forcefully update, all or a specific version of MatrixNexus Client
MI-Settings Manager: • Used to mange (save/retrieve) customized settings of each user on local system • It allows multiple user to save different customize setting on same system. • It will automatically apply the customized setting , based on user login
MI-MDF Handler: • I designed this as a component that works like WINSOCK • Used to connect with MDF (Meta Data Feed Server) server • Getting feeds from high speed MDF server and updates stock watch list • Retrieving XML based feed from server, extremely fast updating watch list and MBO,MBP depth window
MatrixNexusClient: • End user terminal for traders, that allows user to watch and place orders • Fastest and reliable online trading system. • Extremely fastest market price updates (because of MDF connection). • Lightweight application. • Online gain/loss and account statement reports. • Real-time and historical Charts • Live portfolio updates. • Supporting windows Xp/Vista/7/8/10 • Supporting 32 bit and 64 bit architecture • Has trend summary to find the trend • Supporting GTD/Daily Orders • Has ticker tape to show the current live trade • Live price and volume summary • Bilingual Arabic and English.

MatrixPro Trading Platform

This project is trading terminal for Dubai Financial Market (DFM) and Abu Dhabi Data Exchange market ADX developed for AL-DHAFRA FINANCIAL BROKER L.L.C , it has very good features to watch the market and trade on the market , some of the features are customize watch list, ticker tape, portfolio management, current order management, financial chart, depth window and ticker summary etc. Implementation of remote database connectivity by using 3 tire architecture. Achived: • Designed and coded enhancements. • Resolved internal and external defects. • Participated in daily scrums. Provided technical advice on bugs and enhancements. • Resolved customer issues working with the Support team. • I understood 3 tire architecture and implemented • I understood remote desktop connectivity • Implemented Multithreaded programming • I understood the session management and implementation • Creation of deployable MSI • Version Management Implemented