Dozie & Associates

Postgres and Oracle are among the most popular and widely used RDBMS. Both systems have similar features and different features that make them unique to any environment or business setting.  In this series I will cover both systems but will not go in depth into their Administrative side Similarities  Both systems supports JDBC connection protocols which can be utilized to connect to java based applications like Oracle JDeveloper. For data manipulation, To_Char, To_Number, To_Date & To_Timestamp , concat (|| ||),  Upper and Initcap which are utilized in Oracle based database can also be used in Postgres. Sequence is utilized in both Databases to generate unique identifiers for primary key based columns. With Oracle 12c, identity column was introduced as an alternate for sequence. B tree  based indexes are utilized in both database systems for Primary key columns utilized for unique columns. Difference There quite difference with Oracle PLSQL Syntax and

I have worked with both Oracle and SQL Server since 2009.  In my previous position at Motorola Solutions, I had the great opportunity to work on both environment.  Listed below are some of  their key features but not the complete list. SQL Server   Utilizes TSQL Statement. One instance with  multiple database.   Utilizes Linked Server to other RDBMS and Excel which  can allow  limited PLSQL Statements when connecting to Oracle based platform .  Has two types Triggers which are   After and Instead.   Data Manipulation  can be extracted or altered using Datepart(), DateDiff(),   DateAdd() or  Getdate().  User Defined Functions(UDF)  can return datatype or table.  Stored Procedures are executed. Tables can be created using the  Create table statement or Select into Table_Name from Table_Name, view_Name or UDF_Name statements. Simple XML(SQL Server 2008)  features (  XML AUTO, XML RAW , XML EXPLICIT etc) to transform data both structured and unstructured dat

Data Warehouse, Database Migration and Database Development utilize  Extract Transform Load (ETL) Technologies to clean and restructure data prior to loading into the final environment. Database Management Systems (DBMS) not  Relational Database Management Systems (RDBMS) may consist files and XML  files generated from internal and external systems  with various format.Poorly designed RDBMS may contain errors from internal and external  applications makes it hard to utilized the data for reporting purpose. Same applications utilized for ETL like  Talend or SSIS  can also be utilized for Extract Load Transform (ELT) but the concept varies both implementation  and design  ELT can be used when moving data from platform that are manufactured by the same vendor but is a newer version with the same datatype and environment. ELT can also be utilized when working on a large data. The entire data can be extracted from the source like a Data Warehouse or existing