Posts

Showing posts from 2017

SQLite

Image
SQLite is a relational database management system contained in a C programming library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.   Read PPT here

Deadlock in DBMS

Image
In a database, a  deadlock  is a situation in which two or more transactions are waiting for one another to give up locks. For example, Transaction A might hold a lock on some rows in the Accounts table and needs to update some rows in the Orders table to finish. Read PPT Here

Database security and authorization

A privilege is a type of permission for an  authorization  name, or a permission to perform an action or a task. The privilege allows a user to create or access  database  resources. Privileges are stored in the  database  catalogs.... Read ppt here

An introduction to Neo4j

Image
Neo4j is the world's leading open source Graph Database which is developed using Java technology. It is highly scalable and schema free (NoSQL). Meet Neo4j : The graph database platform powering today's mission-critical enterprise applications, including artificial intelligence, fraud detection and recommendations. Credits: tutorialpoint.com Read PPT Here

MULTIPLE GRANULARITY DBMS

Granularity is the size of data item  allowed to lock. Multiple Granularity is the hierarchically  breaking up the database into portions which are lockable and maintaining the track of what to be lock and how much to be lock so that it can be decided very quickly either to lock a data item or to unlock a data item. Read ppt here

POSTGRESQL

Image
PostgreSQL , often simply Postgres , is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications.  READ PPT HERE

FIREBASE

Image
  Firebase is a mobile and web application development platform developed by Firebase, Inc. in 2011, then acquired by Google in 2014. READ PPT HERE

AMAZON WEB SERVICES(AWS)

Image
Amazon Web Services is a subsidiary of Amazon.com that provides on-demand cloud computing platforms to individuals, companies and governments, on a paid subscription basis with a free-tier option available for 12 months.   Read ppt here               CEO : Andy Jassy (Apr 2016–) Headquarters : Seattle, Washington, United States Founder : Amazon.com Founded : 2006 Subsidiaries : AWS Elemental , Thinkbox Software Inc. , MORE Parent organization : Amazon.com

Binary Decimal Octal and Hexadecimal number systems

Image
A number can be represented with different base values. We are familiar with the numbers in the base 10 (known as decimal numbers), with digits taking values 0,1,2,…,8,9. A computer uses a Binary number system which has a base 2 and digits can have only TWO values: 0 and 1. A decimal number with a few digits can be expressed in binary form using a large number of digits. Thus the number 65 can be expressed in binary form as 1000001. The binary form can be expressed more compactly by grouping 3 binary digits together to form an octal number. An octal number with base 8 makes use of the EIGHT digits 0,1,2,3,4,5,6 and 7. A more compact representation is used by Hexadecimal representation which groups 4 binary digits together. It can make use of 16 digits, but since we have only 10 digits, the remaining 6 digits are made up of first 6 letters of the alphabet. Thus the hexadecimal base uses 0,1,2,….8,9,A,B,C,D,E,F as digits. To summarize Decimal : base 10  Binary : b