Difference between Centralized Version Control and Distributed Version Control

Mahesh Parahar
Updated on 27-Nov-2019 07:51:49

8K+ Views

Centralized Version ControlCentralized Version Control is a version control system using server/client model and server contains all the history of source code.Distributed Version ControlDistributed Version Control is a version control where each client can have same copy of source code as server has and both server and client maintain history of source code.Following are the important difference between Centralized Version Control and Distributed Version Control.Sr. No.KeyCentralized Version ControlDistributed Version Control1WorkingIn CVS, a client need to get local copy of source from server, do the changes and commit those changes to centeral source on server.In DVS, each client can have a ... Read More

Difference between SQL and PL/SQL

Mahesh Parahar
Updated on 27-Nov-2019 07:32:03

14K+ Views

SQL, Structural Query Language is a standard database language which is used create, maintain and retrieve the relational database whereas PL/SQL, Procedural Language extension to SQL, it extends SQL and provide it procedural capabilities.Following are the important differences between SQL and PL/SQL.Sr. No.KeySQLPL/SQL1DefinitionSQL, is Structural Query Language for database.PL/SQL is a programming language using SQL for a database.2VariablesSQL has no variables.PL/SQL has variables, data types etc.3Control StructuresSQL has no FOR loop, if control and similar structures.PL/SQL has FOR loop, while loop, if controls and other similar structures.4OperationsSQL can execute a single operation at a time.PL/SQL can perform multiple operation at ... Read More

Difference between Oracle and SQL Server

Mahesh Parahar
Updated on 27-Nov-2019 07:29:32

8K+ Views

Both Oracle and SQL Server, both are relational database management systems or RDBMS.Following are the important differences between Oracle and SQL Server.Sr. No.KeyOracleSQL Server1Developed ByOracle Server is owned by Oracle.SQL Server is developed by Microsoft.2Procedural LanguageOracle uses PL/SQL.SQL Server uses T-SQL.3UsageOracle is complex to use.SQL Server is simple to use.4OS SupportWindows, Linux, Solaris, HP-UX and OS X.Windows and Linux.5Database SharingUsers can share databases.Users cannot share databases.6PackageOracle supports Packages.SQL Server has no concept of packages.7PowerfulOracle is more powerful than SQL Server.SQL is way less powerful than Oracle.Read More

Difference between MySQL and MongoDB

Mahesh Parahar
Updated on 27-Nov-2019 07:27:28

676 Views

MySQL is a relational database. MongoDB is NoSQL Database.Following are the important differences between MySQL and MongoDB.Sr. No.KeyMySQLMongoDB1Owned/Developed ByMySQL is owned by Oracle.MongoDB is developed by MongoDB Inc.2Data StorageMySql stores data in tabular format as records in table.MongoDB stores records as documents.3LanguageSQL, Structured Query Language is used to query database.Dynamic Schema. Predefined structure is defined for incoming data.4Design ObjectivesNo efficient replication and Sharding available.High availability, Scalability, Replication and Sharding are inbuilt.5TermsMongoDB uses Collection, Document, Field, Embedded Document, Linking etc.MySQL uses Table, Row, Column, Joins etc.6Data StorageMySQL stores data in forms of records in table.MongoDB stores data in form of JSON ... Read More

Difference between MySQL and SQL Server

Mahesh Parahar
Updated on 27-Nov-2019 07:21:59

7K+ Views

Both MySQL and SQL Server, both are relational database management systems or RDBMS. MySQL is open source and is free to use whereas SQL Server is licensed product of Microsoft.Following are the important differences between MySQL and SQL Server.Sr. No.KeyMySQLSQL Server1Owned/Developed ByMySQL is owned by Oracle.SQL Server is developed by Microsoft.2Language supportMySql supports programming languages like C++, Java and has running support for Perl, TCL and Haskel.SQL Server supports programming languages like C++, Java, Ruby, Visual Basic, Delphi, R.3Storage SpaceMySql needs less amount of operational storage space.SQL Server needs large amount of operational storage space.4Query CancellationMySql does not support midway ... Read More

Difference between RDBMS and HBase

Mahesh Parahar
Updated on 27-Nov-2019 07:20:14

3K+ Views

Both RDBMS and HBase, both are database management systems. RDBMS uses tables to represent data and their relationships. HBase is a column-oriented dbms and it works on top of Hadoop Distributed File System (HDFS).Following are the important differences between RDBMS and HBase.Sr. No.KeyRDBMSHBase1DefinitionRDBMS stands for Relational DataBase Management System.HBase has no full form.2SQLRDBMS requires SQL, Structured Query Language.HBase does not need SQL.3SchemaRDBMS has a fixed schema.HBase has no fixed schema.4OrientationRDBMS is row oriented.HBase is column oriented.5ScalablityRDBMS faces problems in scalablity.HBase is highly scalable.6NatureDBMS is static in nature.HBase is dynamic in nature.7Data RetrievalRDBMS data retrieval is slow.HBase data retrieval is fast.8RULERDBMS ... Read More

Difference between RDBMS and OODBMS

Mahesh Parahar
Updated on 27-Nov-2019 07:16:47

10K+ Views

RDBMS and OODBMS are database management systems. RDBMS uses tables to represent data and their relationships whereas OODBMS represents data in form of objects similar to Object Oriented Programming.Following are the important differences between RDBMS and OODBMS.Sr. No.KeyRDBMSOODBMS1DefinitionRDBMS stands for Relational DataBase Management System.OODBMS stands for Object Oriented DataBase Management System.2Data ManagementData is stored as entities defined in tabular format.Data is stored as objects.3Data ComplexityRDBMS handles simple data.OODBMS handles large and complex data.4TermAn entity refers to collection of similar items having same definition.An class refers to group of objects having common relationships, behaviors and properties.5Data HandlingRDBMS handles only data.OODBMS handles ... Read More

Difference between OOP and POP

Mahesh Parahar
Updated on 27-Nov-2019 07:04:54

18K+ Views

OOPOOP, refers to Object Oriented Programming and its deals with objects and their properties. Major concepts of OOPs are −Class/objectsAbstractionEncapsulationPolymorphismInheritancePOPPOP, refers to Procedural Oriented Programming and its deals with programs and functions. Programs are divided into functions and data is global.Following are the important differences between OOP and POP.Sr. No.KeyOOPPOP1DefinitionOOP stands for Object Oriented Programing.POP stands for Procedural Oriented Programming.2ApproachOOP follows bottom up approach.POP follows top down approach.3DivisionA program is divided to objects and their interactions.A program is divided into funtions and they interacts.4Inheritance supportedInheritance is supported.Inheritance is not supported.5Access controlAccess control is supported via access modifiers.No access modifiers are ... Read More

Difference between MD5 and SH1

Mahesh Parahar
Updated on 27-Nov-2019 06:55:02

921 Views

MD5 and SH1 are hashing algorithms. MD5 is much faster than SH1Following are the important differences between MD5 and SH1.Sr. No.KeyMD5SH11DefinitionMD5 stands for Message Digest.SHA stands for Secure Hash Algorithm.2Supported LengthMD5 can have 128 bits length of digest message.SHA can have 160 bits length of digest message.3SpeedMD5 is faster than SHA.SHA is slower than MD5.4ComplexityMD5 is simple than SHA.SHA is quiet complex than MD5.5SecurityMD5 provides poor security.SHA provides balanced security.6Crack CodeIf one want to seek two messages having same identical message digest, 264 operations to be performed.If one want to seek two messages having same identical message digest, 280 operations ... Read More

Difference between UMA and NUMA

Mahesh Parahar
Updated on 26-Nov-2019 12:20:48

8K+ Views

UMA and NUMA are shared memory models. Multiprocessors are divided among these type of categories. In UMA, Uniform Memory Access, a single memory controller is used and it is applicable for general purpose applications and time sharing applications. In NUMA, Non-Uniform Memory Access, multi memory controllers are used. NUMA is suitable for real-time applications and time critical applications.Following are the important differences between UMA and NUMA.Sr. No.KeyUMANUMA1DefinitionUMA stands for Uniform Memory Access.NUMA stands for Non Uniform Memory Access.2Memory ControllerUMA has single memory controller.NUMA has multiple memory controllers.3Memory AccessUMA memory access is slow.NUMA memory accsss is faster than UMA memory.4BandwidthUMA has ... Read More

Advertisements