Showing posts with label Software Development. Show all posts
Showing posts with label Software Development. Show all posts

Wednesday 18 June 2014

Export MS Access to MySQL with SnapShots

Create a Database in Ms Access
Open Microsoft Access and Create/Open a database which you want to export.
Create a Database in Ms Access




Export Ms Access Table into Excel Format
After opening the database, create a table and populate the fields which you want to insert into mysql database

Export Ms Access Table into Excel Format


Import Excel File into MySql Database
Open the database in Mysql and click on export button. Select the excel file and select option export ms access to mysql  and click on Go Button
Import Excel File into MySql Database




Friday 23 May 2014

What is Streaming Servers, Streaming Protocol and Port Protocol

Streaming Servers: It is server which is more powerful in-terms of RAM, ROM, Processing & Disk spaces. These server kept the video/audio files and able to sent the video/audio in form of small packet(in right order) to the client machine bypass the webserver. 

Cleint Machhine Request the video/video to webserver => webserver sent the request to streaming server => Streaming server send the response in form of small packet to the clinet machine (By Passing the WebServer)

Why we need streaming server:

  • HTTP, FTP and TCP protocols  send the data in form of packets and reassembled later means first download full data in browser then play. In this case user have to wait  more time. where as in streaming server video playing and streaming simultaneouly. 
  • Streaming Server is more fast & better as compare to WebServer(Non-streaming Server).
  • Different Streaming Server use different type of protocol to enhance their speead and performace.


Web Server can re-send lost or damaged packets, and they allow randomly ordered packets to be reassembled later. This is convenient for downloading files and surfing the Web if Web traffic slows down or some of your packets disappear, you'll still get your file. But these protocols won't work as well for streaming media. With streaming media, data needs to arrive quickly and with all the pieces in the right order

PORT: PROTOCOL
20: File Transfer Protocol (FTP)
21: Secure File Transfer Protocol (SFTP)
22: Secure Shell (SSH)
25: Simple Mail Transfer Protocol (SMTP)
80: Hypertext Transfer Protocol (HTTP)
110: Post Office Protocol (POP3)
143: Internet Message Access Protocol (IMAP)
194: Internet Relay Chat (IRC)
443: Hypertext transfer Protocol Secure (HTTPS)
465: Simple Mail Transfer Protocol Secure (SMTPS)


Streaming Protocol
Apple HLS (HTTP Live Streaming)
RTMP, RTMPT, RTMPS, RTMPE, RTMPTE, Flash
Adobe HTTP Dynamic Streaming (HDS)
MS-WMSP (Windows Media HTTP Streaming Protocol), Windows Smooth Streaming, MMS, MMSH
RTSP, RTP, UDP
MPEG-DASH (HTTP)


Wednesday 14 May 2014

Project Management Tips- Way to Successful project

Project Management Tips- Way to Successful project

Project Flow and Structure

Project Structure and flow must be clear to project manager, developer and client to avoid any problem in future. When basic flow will be clear to each of team then success rate of project will be increased. Use http://www.balsamiq.com/products/mockups to create the flow diagram and get approvel from client and make the aware of each member.

Keep communications: 
Keep the communication with client at-least weekly basis and  get the approvel of task done in whole week. Understanding must be good betweeen the team and client. If possible, each developer should be involved in communication.


Track of Project Status:
Track the current status of project by daily, weekly, to check that project in right direction.


Support to Developer:
Project manager must support and encourage his developer for each good work. So that team process in good way.




Thursday 20 March 2014

Web Technology Important Links - Create SiteMap - Monitor Website - SEO Health - All Google API - Blogspot Assistance links

Following are Important Links which are used in Web Technology Fields.

http://www.xml-sitemaps.com/
Get all the Public URL of webpage. You can download/view the URL's in form of CSV, XML, TXT and HTML.

http://www.labnol.org/internet/google-web-scraping/28450/
Scrap the content of public web-pages in csv in one click.

http://newrelic.com/server-monitoring
Monitor your server Error including ajax error. Get Notification by email of error. You can monitor the performance of your website.

http://seositecheckup.com/
Check SEO Health of your website.

http://gtmetrix.com/
Test Website Speed and Performance Optimization.

http://sandbox.ternarylabs.com/porthole/
Access Iframe from another Iframe

http://loadimpact.com
Check web server load

http://www.timeanddate.com/date/duration.html
Calculate duration between two dates

http://www.timeanddate.com/worldclock/converter.html
Time Zone Converter – Time Difference Calculator

https://code.google.com/apis/ajax/playground/
The AJAX Code Playground is an educational tool to show code examples for various Google Javascript APIs

https://www.flickr.com/services/api/misc.urls.html
flickr images having different size

http://benalman.com/projects/jquery-postmessage-plugin/
Cross Domain Communication from JavaScript

http://randomuser.me/
Unlimited free user detail with photos

http://www.gingersoftware.com/grammarcheck

Check the Grammar of description

http://smallseotools.com/plagiarism-checker/

Check the Uniqueness of  Description

http://www.feedthebot.com/tools/alt/
Check Alt Tag missing for images in website.


https://dev.twitter.com/rest/reference/get/users/show
Twitter API

http://www.browserstack.com/ 
Test your website for cross browser compatibility on real browsers. Instant access to multiple desktop and mobile browsers.

https://www.branah.com/text-to-image

Easily create an image online from text or HTML. The text to image converter supports multiple languages. You can use your own background image and font.

http://blog.slashpoundbang.com/post/12975232033/google-news-search-parameters-the-missing-manual
Google News API Parameter


For Blogger.com Only

http://www.theblogwidgets.com/2009/08/change-title-tags-in-blogger-for-more.html
Change the Title of every post of blog


http://www.helpfulbloggertips.com/2013/03/blogger-create-custom-error-404-page.html
Custom Redirect Page


http://blogtimenow.com/blogging/create-add-custom-robots-txt-file-blogger-crawl-index/
Update Robots.txt file of blog


http://helplogger.blogspot.in/2012/03/how-to-add-related-posts-widget-to.html
Add Related Post


http://techmarshal.blogspot.in/2013/02/simple-blogger-related-post-widget-without-thumbnail-text-only.html
Add Related Post - Without thumbnail


http://www.blogs911.com/2013/08/limiting-number-of-posts-in-labels-page.html
Limit the Number of post in Blogger Label

How to Add Numbered Page Navigation Widget for Blogger

http://helplogger.blogspot.in/2014/04/how-to-add-numbered-page-navigation-widget-for-blogger.html




Thursday 2 January 2014

Domain Name Server

DNS is simple it just changes IP Address to human readable. 

How to get the Ip address from the website Name
http://whois.net/domain-name-ip-address/


array dns_get_record ( string $hostname [, int $type = DNS_ANY [, array &$authns [, array &$addtl ]]] )
Fetch DNS Resource Records associated with a hostname
Fetch DNS Resource Records associated with the given hostname.

<?php
$result 
dns_get_record("php.net");print_r($result);?>

host The record in the DNS namespace to which the rest of the associated data refers. class dns_get_record() only returns Internet class records and as such this parameter will always return IN. type String containing the record type. Additional attributes will also be contained in the resulting array dependant on the value of type. See table below. ttl "Time To Live" remaining for this record. This will not equal the record's original ttl, but will rather equal the original ttl minus whatever length of time has passed since the authoritative name server was queried.

Friday 7 June 2013

Systems Development Life Cycle (SDLC)


SDLC stands for Software Development Life Cycle. 

It is series of process that followed to be make a software successful. In software development, if you follow the process of SDLC, the chance of success of project increase.

Today In IT Industries most of the companies including MNC follow this process. It help to complete the project on timely and with higher success rate.



Benefits of the SDLC Process

The intent of a SDLC process it to help produce a product that is cost-efficient, effective and of high quality. Once an application is created, the SDLC maps the proper deployment and decommissioning of the software once it becomes a legacy. The SDLC methodology usually contains the following stages: Analysis (requirements and design), construction, testing, release, and maintenance (response).






Following are the main steps of SDLC

1. Preliminary Analysis: The objective of phase 1 is to conduct a preliminary analysis, propose alternative solutions, describe costs and benefits and submit a preliminary plan with recommendations.Conduct the preliminary analysis: in this step, you need to find out the organization's objectives and the nature and scope of the problem under study. Even if a problem refers only to a small segment of the organization itself then you need to find out what the objectives of the organization itself are. Then you need to see how the problem being studied fits in with them.Propose alternative solutions: In digging into the organization's objectives and specific problems, you may have already covered some solutions. Alternate proposals may come from interviewing employees, clients , suppliers, and/or consultants. You can also study what competitors are doing. With this data, you will have three choices: leave the system as is, improve it, or develop a new system.Describe the costs and benefits.

2. Systems analysis, requirements definition: Defines project goals into defined functions and operation of the intended application. Analyzes end-user information needs.

3. Systems design: Describes desired features and operations in detail, including screen layouts, business rules, process diagrams, pseudocode and other documentation.

4. Development: The real code is written here.
Integration and testing: Brings all the pieces together into a special testing environment, then checks for errors, bugs and interoperability.

5. Acceptance, installation, deployment: The final stage of initial development, where the software is put into production and runs actual business.

6. Maintenance: What happens during the rest of the software's life: changes, correction, additions, moves to a different computing platform and more. This is often the longest of the stages.

Wednesday 5 June 2013

Normalization Denormalization different form of normalization

Question: What is Normalization?
Answer: Normalization is a process in relational database where fields and tables are organized to reduce the redundancy and dependency by dividing the larger tables and linking them.

Question: Why We use Normalization?
Answer: We use Normalization to organized the data and reduce the redundancy and dependency.

Question: What happen, if we don't do Normalization?
Answer: Following are the pros, if we don't normalization.
  • Redundancy
  • Heavy database
  • Incorrect database
  • Queries take much time to execute.

Question: What is Denormalization?
Answer: This is the process by with DBA(database admin) attempt to optimize the performance of the database by adding in redundant OR grouped data. The advantages to this is that the data is stored in one table are faster, as opposed to multiple smaller tables where need to multiple joins.

Answer: There are 5 types of Normation i.e 1NF, 2NF, 3NF, 4NF and 5NF.
We can achieve upto 4NF (4NF is very rare)

Question: What are different form of normalization?
Answer: Following are the different form of normalization.
1NF
Rule1: Each table cell should contain single value. Like (if user have two phone no then both phone number can't be in one column must have two records for this)
Rule2: Each Record needs to be unique.

2NF
Rule1: Must follow 1NF
Rule2: Extract the filed that are non-key columns and place into separate table and releate both table with primary key concept.

3NF
Rule1: Must follow 2NF
Rule2: Has no transitive functional dependencies
example: table  fields are 
zip, cityname, statename
In addition, you may wish to instead have separate City and State tables, with the City_ID in the Zip table and the State_ID in the City table.

BCNF
Rule1: Must follow 3NF
Rule2: All table can have only one primary key.


Saturday 1 June 2013

Binary Search Tree

Binary Search Tree
In computer science, a Binary Search Tree (also known as ordered or sorted binary tree) is a node-based binary data structure which has the following properties.









  • The left subtree of a node contains only nodes with keys less than the node's key.
  • The right subtree of a node contains only nodes with keys greater than the node's key.
  • The left and right subtree must each also be a binary tree.
  • There must be no duplicate nodes.


In Following case, We use Binary Search Tree
They can be used as a quick way to sort data. Insert data into a binary search tree at O(log(n)). Then traverse the tree in order to sort them.

Binary Search Tree Example in PHP
/** Create Node Class **/
class Node
{
 public $parent = null;
 public $left = null;
 public $right = null;
 public $data = null;
 
 public function __construct($data)
 {
  $this->data = $data;
 }
 
 public function __toString()
 {
  return $this->data;
 }
}

/** Create BinarySearchTree Class **/ 
class BinarySearchTree
{
 protected $_root = null;
 
 protected function _insert(&$new, &$node)
 {
  if ($node == null) {
   $node = $new;
   return;
  }
 
  if ($new->data <= $node->data) {
   if ($node->left == null) {
    $node->left = $new;
    $new->parent = $node;
   } else {
    $this->_insert($new, $node->left);
   }
  } else {
   if ($node->right == null) {
    $node->right = $new;
    $new->parent = $node;
   } else {
    $this->_insert($new, $node->right);
   }
  }  
 }
 
 protected function _search(&$target, &$node)
 {
  if ($target == $node) {
   return 1;
  } else if ($target->data > $node->data && isset($node->right)) {
   return $this->_search($target, $node->right);
  } else if ($target->data <= $node->data && isset($node->left)) {
   return $this->_search($target, $node->left);
  }
 
  return 0;
 }
 
 public function insert($node)
 {
  $this->_insert($node, $this->_root);
 }
 
 public function search($item) 
 {
  return $this->_search($item, $this->_root);
 }
}
 
/* Add Data in Nodes **/
$node1 = new Node(43);
$node2 = new Node(52);
$node3 = new Node(44);
$node4 = new Node(47);
$node5 = new Node(65);
 
/* Create Object **/
$obj = new BinarySearchTree();
 
$obj->insert($node1);
$obj->insert($node2);
$obj->insert($node3);
$obj->insert($node4);
$obj->insert($node5);

Wednesday 22 May 2013

Defination of SOLID DRY KISS UX

Defination of SOLID DRY KISS UX

SOLID Single responsibility, Open-closed, Liskov substitution, Interface segregation and Dependency inversion
Create a system that is easy to maintain and extend over a time to time.


DRY : Don't Repeat Yourself
Develop a functionalities that need not to change but can be extend the functionalists. 


KISS : Keep It Simple Stupid
Coding standard must be maintain and approach do simple, so that every developer must be able to understand at one glance.

UX : User Experience


Wednesday 8 May 2013

Design Patterns

Design Patterns

Design patterns: It is optimized, reusable solutions to the programming problems. 
It is not just a class or library, It is technique to get the easy solution of complicated problems.


Following are Design Pattern used in Software Industry.

Factory Pattern: This pattern is used to create the multiple object from a single function.

For example, see below code.

abstract class Button {
 protected $_html;
 
 public function getHtml()
 {
  return $this-&gt;_html;
 }
}

class ImageButton extends Button {
 public $_html = '<input height="60" name="image" src="rainbow.gif" type="image" width="60" />';
}

class InputButton extends Button {
 public $_html = '<input name="button" type="button" value="Input Button" />';
}

class FlashButton extends Button {
 public $_html = '<embed height="#" src="filename.swf" width="#"></embed>';
}
  
class mybutton{
  static function factory($buttonObj='InputButton'){
    $obj = new $buttonObj();
    return $obj-&gt;_html; 
  
  }  
}  

/** get buttons by factory patter **/
echo mybutton::factory('ImageButton');
echo mybutton::factory('InputButton');
echo mybutton::factory('FlashButton');


In Factory pattern, like factory you can create number of object and each perform different task.


Singleton Pattern: In this pattern, only one instance survive in whole page. If you try to create another object then it will not let you do this.

For example, see below code.
class Login
{
 private static $instance;
 
 public static function getInstance()
 {
  if( is_null(self::$instance) ) {
   self::$instance = new self();
  }
  return self::$instance;
 } 
  /**
     * Singleton pattern implementation makes "new" unavailable
     *
     * @return void
     */
    protected function __construct()
    {}

    /**
     * Singleton pattern implementation makes "clone" unavailable
     *
     * @return void
     */
    protected function __clone()
    {}
  

}
$obj = Login::getInstance(); 
 
Only one instance exist, in whole page.


The observer pattern:  In this pattern there are two objects i.e Observer and Observable.
Observable have a method that add Observer. When the observable object changes, it sends a message to the registered observers.

For example, see below code.
 
interface IObserver
{
  function onChanged( $sender, $args );
}

interface IObservable
{
  function addObserver( $observer );
}

class UserList implements IObservable
{
  private $_observers = array();

  public function addCustomer( $name )
  {
    foreach( $this-&gt;_observers as $obs )
      $obs-&gt;onChanged( $this, $name );
  }

  public function addObserver( $observer )
  {
    $this-&gt;_observers []= $observer;
  }
}

class UserListLogger implements IObserver
{
  public function onChanged( $sender, $args )
  {
    echo( "'$args' added to user list\n" );
  }
}

$ul = new UserList();
$ul-&gt;addObserver( new UserListLogger() );
$ul-&gt;addCustomer( "Tester " );  


Strategy Design Pattern: It is also known as the policy pattern. In strategy pattern algorithms are extracted from complex classes so they can be replaced easily. A Strategy defines a set of algorithms that can be used interchangeably.

For Example: 
Modes of transportation to an airport is an example of a Strategy Pattern. There are Several options available such as driving one's own car, taking a taxi, Bus,scooter etc. Traveler can use any of above to reach the airport, he can use single one to go to airport(By Hire taxi) OR can use two or more depend on requirement.



Front Controller Pattern: There is single entry point in this design pattern. Means all action of application have to go through in single file/function.
Example : Cakephp and zend framework uses the front controller design pattern. As all url goes through index.php file in webroot / public folder .

Monday 6 May 2013

Waterfall model

Question: What is Waterfall Model?
Answer: Sequential design process, often used in software development process, in which process is seen as flowing steadily downwards ( like a waterfall ).


Question: What are the main steps in waterfall model?
Answer: Following are the main steps in water fall model.

1. Requirements specification: Make a list of sections/modules / functionality which need to develop.

2. Design: Create a mock-up and make a output design (Looks after completion)

3. Construction (implementation or coding): Start the Development

4. Integration: When one module is complete, then integrate with main modules OR integrate all the modules

5. Testing and debugging: After integration modules, test them properly in all ways (like check in all browser with different operting  system)

6. Installation: Setup the software where client want.

7. Maintenance: Start the maintenance OR enhancement.



Simple Ways to understand the Waterfall Model

Saturday 4 May 2013

Agile Software Development - Principle of Agile Software Development - Agile means quick in movement.

Agile is way to develop the software and satisfy the customer by delivering the product on time.


Following are the way of Agile Software development.
  • Develop functionality 1 => Integrate and test
  • Develop functionality 2 => Integrate and test
  • Develop functionality 3 => Integrate and test
  • Demo Release and Test
  • Get Client Feedback
  • Do the Changes
  • System Testing
  • All functionalists completed, Delivered to client else go ahead above process


Principle of Agile Software Development 
  • Satisfy the Customer
  • Welcome the changes by customer.
  • Delivered on time
  • Business people and developer must work together means proper communication between them.
  • face-to-face conversation between team members.
  • Continuous work, No gap in work