Database, Machine Learning & Artificial Intelligence

Machine Learning is automated learning through algorithms by machines or by computer systems. It'd data analytics technique and is a subset of Artificial Intelligence. It is a methodology that makes computer system or machine to learn from experience like how human beings do. In CRISP - DM the Cross-Industry Standard Process framework for Data Mining the fourth stage is the Modeling stage. In the Modeling stage Machine Learning Models are prepared.   And where the Machine Learning models are being used? Machine learning is applied where there is need for computer system to learn and to interpret without precoded programs. Machine Learning Models are used in Predictive analytics. In day today life we are asking Apple ’s Siri or Google Assistant in the mobile phone “Get me the route to Central Library” and we have the route map displayed on the screen from the current location. The mobile phone has recognized the voice and it responded. The process of recognizing vo...

What is NLP ? In previous article I was talking about Training Computer Systems or Machines like how we are training kids. The computer system or the Machine should perform the task based on the interaction with the human being and the instructions provided. These interaction can be in the form of inputs which are not precoded and can be given in the form of Text, Speech, Action, Gesture, sound etc., These are part of NLP or the Natural Language Processing and so Machines can not only receive processing instructions in the form of Machine Language but also in the form of Natural Language. Text for of Natural Language contains Words, Grammar, Sentences and also context that are powerful enough to change the meaning and the processing of same can be taken care by Lexical Processing. What is Lexical Processing ? Words are the building blocks of comprehension and properties the word represent provides primary data. The retrieval of these data is what Lexical Processing does. ...

Era of AI Rush started and like Gold Rush people of different walks of life are rushing towards Artificial Intelligence. Tremendous volume of d ata  laying across their fields and engineers of respective fields are there to mine the data, to interpret the data, to reach out the solution for existing problems and sometime to identify the future problems. Being a Database technocrats for the past 16 years and dealing with huge volume of real time data my curiosity towards AI keep raising these days. When there are millions and trillions of lines are being coded to get the data feed, data extracted, data cleaning, data analysis and in reports publishing, what is so different in AI? Isn ’t it just another set of programs? Before getting into the answer let us discuss a little more about human intelligence. One of my friends daughter who is around 1 year old started speaking. She has been taught   to identify fruits like Apple, Orange, Banana, Mango etc. I visited them re...

Recent discussion was how to recover a dropped table and various factors were touched upon and I thought of sharing my insights which may be useful for someone who is heading a largepool of DBA and Developers. For anyone who ’s into the IT industry and supporting production databases for more than 10 year would have came across various complex, challenging scenarios in BAU support or during database migration as access or performance issues. Table drop that too from production database is not something that would happen everyday and administrators with due diligence are managing databases. But we can’t write-off saying that the scenario never happens. When being reported about a table drop few hours from production database; as an accountable person you may need to update stakeholders who would be directly affected by the incident. Rather than reporting this as an incident, the recommendation is to suggest optimal solutions handy. Scenario : Table dropped from the datab...