What are the features and advantages of OBJECT ORIENTED PROGRAMMING[OOPS]?
Answers1. objects can easily be modified and added to a system there by reducing maintenance costs.
2. Better Modelling Techniques for real world examples than procedure.
What are the difference between abstract class and interface?
AnswersAbstract class: abstract classes are the class where one or more methods are abstract but not necessarily all method has to be abstract. Abstract methods are the methods, which are declare in its class but not define.
nterface: Interfaces are one type of class where all the methods are abstract. That means all the methods only declared but not defined. All the methods must be define by its implemented class.
What are the advantages of stored procedures, triggers, indexes?
AnswersA stored procedure is a set of SQL commands that can be compiled and stored in the server. Once this has been done, clients don't need to keep re-issuing the entire query but can refer to the stored procedure. This provides better overall performance because the query has to be parsed only once, and less information needs to be sent between the server and the client. You can also raise the conceptual level by having libraries of functions in the server. However, stored procedures of course do increase the load on the database server system, as more of the work is done on the server side and less on the client (application) side.
A trigger is effectively a type of stored procedure, one that is invoked when a particular event occurs.
Indexes are used to find rows with specific column values quickly.
Wednesday, December 9, 2009
Thursday, December 3, 2009
~~ Web Artitecture Stack ~~
Web artitecture stack consists of :
1.MYSQL/ATOMICS/SQL SERVERS
2.TOMCAT
3.APACHE
4.FIRST REQUEST
5.TALEND/MULE/->SOLR -> FOR ETL PROCESSES [EXTRACT TRANSFORM LOAD]
** SOLR:Solr is the popular, blazing fast open source enterprise search platform from the Apache Lucene project. Its major features include powerful full-text search, hit highlighting, faceted search, dynamic clustering, database integration, and rich document (e.g., Word, PDF) handling. Solr is highly scalable, providing distributed search and index replication, and it powers the search and navigation features of many of the world's largest internet sites.
Solr is written in Java and runs as a standalone full-text search server within a servlet container such as Tomcat. Solr uses the Lucene Java search library at its core for full-text indexing and search, and has REST-like HTTP/XML and JSON APIs that make it easy to use from virtually any programming language. Solr's powerful external configuration allows it to be tailored to almost any type of application without Java coding, and it has an extensive plugin architecture when more advanced customization is required.
1.MYSQL/ATOMICS/SQL SERVERS
2.TOMCAT
3.APACHE
4.FIRST REQUEST
5.TALEND/MULE/->SOLR -> FOR ETL PROCESSES [EXTRACT TRANSFORM LOAD]
** SOLR:Solr is the popular, blazing fast open source enterprise search platform from the Apache Lucene project. Its major features include powerful full-text search, hit highlighting, faceted search, dynamic clustering, database integration, and rich document (e.g., Word, PDF) handling. Solr is highly scalable, providing distributed search and index replication, and it powers the search and navigation features of many of the world's largest internet sites.
Solr is written in Java and runs as a standalone full-text search server within a servlet container such as Tomcat. Solr uses the Lucene Java search library at its core for full-text indexing and search, and has REST-like HTTP/XML and JSON APIs that make it easy to use from virtually any programming language. Solr's powerful external configuration allows it to be tailored to almost any type of application without Java coding, and it has an extensive plugin architecture when more advanced customization is required.
Wednesday, December 2, 2009
~~ APC vs Memcache ~~
APC: Alternative PHP Cache:Its goal is to provide a free, open, and robust framework for caching and optimizing PHP intermediate code.
To avoid the overhead of parsing and compiling the code every time pages are loaded.
** This is no distributed cache
Memcache: is a general-purpose distributed memory caching system.
It is often used to speed up dynamic database-driven websites by caching data and objects in memory to reduce the number of times an external data source.
Memcached's APIs provide a giant hash table distributed across multiple machines. When the table is full, subsequent inserts cause older data to be purged in least recently used (LRU) order.
To avoid the overhead of parsing and compiling the code every time pages are loaded.
** This is no distributed cache
Memcache: is a general-purpose distributed memory caching system.
It is often used to speed up dynamic database-driven websites by caching data and objects in memory to reduce the number of times an external data source.
Memcached's APIs provide a giant hash table distributed across multiple machines. When the table is full, subsequent inserts cause older data to be purged in least recently used (LRU) order.
Sunday, November 22, 2009
~~ SEO-Search Engine Optimisation ~~
SEO: Search Engine Optimisation
Process of improving the volume or quality of traffic to a web site.
Ex. Better Keywords, Meta Descriptions, Href Tags with Titles ...etc.
Process of improving the volume or quality of traffic to a web site.
Ex. Better Keywords, Meta Descriptions, Href Tags with Titles ...etc.
~~ Technologies to Know~~
Try to refresh myself from the keywords of some of technologies which
we use in day to day life.
MYSQL
1. DDL : Data Defination Language -statements are used to build and modify the structure of your tables and other objects in the database. Eg. CREATE/ DROP/ ADD COLUMN
2. DML: Data Manipulation Language- statements are used to work with the data in tables.Eg.
SELECT/INSERT/UPDATE/DELETE.
3.INDEXES: The main purpose of the index is to find rows quickly – without scanning whole
data set.Eg. BTREE:it allows to retrieve data in sorted form.
4. INNODB VS MYISAM:
InnoDB: we usually see clustering by primary key, caching data, higher concurrency.
5.Normalization is usually thought of as a process of applying a set of rules to your database design, mostly to achieve minimum redundancy in the data.
1NF/2NF/3NF.
ER model diagram: Entity Relational Diagrams:graphic that illustrates the interrelationships between entities in a database.
UML:Unified Modeling Language:UML offers a standard way to visualize a system's architectural blueprints.
SOLR/LUCENE
OOPS
PHP
AJAX:Asychorounsly Javascript and XML
we use in day to day life.
MYSQL
1. DDL : Data Defination Language -statements are used to build and modify the structure of your tables and other objects in the database. Eg. CREATE/ DROP/ ADD COLUMN
2. DML: Data Manipulation Language- statements are used to work with the data in tables.Eg.
SELECT/INSERT/UPDATE/DELETE.
3.INDEXES: The main purpose of the index is to find rows quickly – without scanning whole
data set.Eg. BTREE:it allows to retrieve data in sorted form.
4. INNODB VS MYISAM:
InnoDB: we usually see clustering by primary key, caching data, higher concurrency.
5.Normalization is usually thought of as a process of applying a set of rules to your database design, mostly to achieve minimum redundancy in the data.
1NF/2NF/3NF.
ER model diagram: Entity Relational Diagrams:graphic that illustrates the interrelationships between entities in a database.
UML:Unified Modeling Language:UML offers a standard way to visualize a system's architectural blueprints.
SOLR/LUCENE
OOPS
PHP
AJAX:Asychorounsly Javascript and XML
Saturday, October 10, 2009
~~ Dream comes true - - -Mine Actung Baby {BMW} ~~
What do dreams mean? Is there a reason for them? ...
Dreams can be funny – they can be sad. They can be scary – but also very happy..
Like Others, I too..dream of lot of things in mine life....one of them was
getting BMW...mine ACHTUNG BABY...
I still remember, when i was kid, playing with mine friends, one of them, have
automatic controlled cars ---yah of course toy car but was BMW model.
he was teasing me n mine friend about that car, and at that moment i told mine
friend, that one day i will going to ride it..in REAL.
I was kid at that time, didn't know that it was really going to be hard to get
mine dream fulfilled...it was Damn expensive ....
But still, something somewhere in mine heart, always is there..."TO OWN THIS
BEATIFULLLLLLLL BABY..'n' ride it."
I thanked GOD, that after almost 20 yrs, he granted mine wish ...and now i owned the DREAM MACHINE ..KILLER ...MINE OWN ACHTUNG BABY..:)

I day i stepped in, it was reallllllllly the most beautiful feeling i got after so
many year...that i have achieved something, which i never thought of completing
so quickly....THANK YOU GOD....
I will never going to forget this day...in mine life.
THE FEELINGS OF DREAMS COMES TRUE, REALLY CAN'T EXPRESS IN WORDS>>>>
KEEP DREAMING....MORE AND MORE... YOU SURLY GET THOSE DONE>>SOMETIME IN YOUR
LIFE...
AT LAST ...THANKING GOD...WATEVER HE DOES...HE DO IT FOR PURPOSE ...:)
Dreams can be funny – they can be sad. They can be scary – but also very happy..
Like Others, I too..dream of lot of things in mine life....one of them was
getting BMW...mine ACHTUNG BABY...
I still remember, when i was kid, playing with mine friends, one of them, have
automatic controlled cars ---yah of course toy car but was BMW model.
he was teasing me n mine friend about that car, and at that moment i told mine
friend, that one day i will going to ride it..in REAL.
I was kid at that time, didn't know that it was really going to be hard to get
mine dream fulfilled...it was Damn expensive ....
But still, something somewhere in mine heart, always is there..."TO OWN THIS
BEATIFULLLLLLLL BABY..'n' ride it."
I thanked GOD, that after almost 20 yrs, he granted mine wish ...and now i owned the DREAM MACHINE ..KILLER ...MINE OWN ACHTUNG BABY..:)
I day i stepped in, it was reallllllllly the most beautiful feeling i got after so
many year...that i have achieved something, which i never thought of completing
so quickly....THANK YOU GOD....
I will never going to forget this day...in mine life.
THE FEELINGS OF DREAMS COMES TRUE, REALLY CAN'T EXPRESS IN WORDS>>>>
KEEP DREAMING....MORE AND MORE... YOU SURLY GET THOSE DONE>>SOMETIME IN YOUR
LIFE...
AT LAST ...THANKING GOD...WATEVER HE DOES...HE DO IT FOR PURPOSE ...:)
Subscribe to:
Posts (Atom)