Posts

Showing posts with the label pl-sql-reserved-words

HBASE Vs. RDBMS Top Differences You can Unlock Now

Image
HBASE in the Big data context has a lot of benefits over RDBMS. The listed differences below make you understandable why HBASE is popular in Hadoop (or Bigdata) platform. Let us check one by one quickly. HBASE Vs. RDBMS Differences Random Accessing HBase handles a large amount of data that is store in a distributed manner in the column-oriented format while RDBMS is systematic storage of a database that cannot support a random manner for accessing the database. Database Rules RDBMS strictly follow Codd's 12 rules with fixed schemas and row-oriented manner of database and also follow ACID properties. HBase follows BASE properties and implement complex queries. Secondary indexes, complex inner and outer joins, count, sum, sort, group, and data of page and table can easily be accessible by RDBMS. Storage From small to medium storage application there is the use of RDBMS that provide the solution with MySQL and PostgreSQL whose size increase with concurrency and performance.  Codd'

SQL PLSQL Top Reserved Keywords

Image
To become perfect in PL/SQL is an art. Knowing of top reserved words helps you to be a master in SQL. ... Top List of SQL, PLSQL Reserved Words. You Can Refer Before Writing Queries Before you start knowing reserved words, wait one moment. The reserved words are similar to the words that you use in normal SQL. A Video on Basic PL/SQL Related Posts 32 Complex SQL Queries popular e-book Introduction to SQL and PLSQL by Ruchin Jain