Database Technologies

Customers who moved/migrated their database from Oracle to PPAS frequently ask for Global Temporary Table in PPAS. Currently, PPAS doesn't support Global Temporary tables. However, there is a way user can achieve this functionality in PPAS. Before we continue with the implementation, lets first understand characteristics of Global Temporary Table. Following are the important characteristics of Global Temporary Table. 1. Global Temporary Table gives predefined structure for storing data. 2. It's an unlogged table which means any activity on this table will not be logged. 3. The data in a global temporary table are private, such that data inserted by a session can only be accessed by that session. Based on the above characteristics of Global Temporary Table AKA GTT, we can define similar kind of work by using the following method: 1. Create UNLOGGED TABLE in PPAS, which activity won't be logged. 2. Create Row Level Security in such a way that session should be...

Security has always been a great concern of Enterprises. Especially, if you have crucial information stored in the database, you would always prefer to have high security around it. Over the years, technologies have evolved and provided better solutions around it. If you have very sensitive information, people try to keep this information encrypted so, that in case, somebody gets access of the system, then they cannot view this information, if they are not authorized. For managing sensitive information, Enterprises use multiple methods: 1. Encrypting specific information. If you are PPAS users, you would like to use DBMS_CRYPTO package which provides a way of encrypting sensitive information in databases. For more information, please refer following link: http://www.enterprisedb.com/docs/en/9.4/oracompat/Database_Compatibility_for_Oracle_Developers_Guide.1.178.html# For PostgreSQL, users can use pgcrypto module. 2. Transparent Data Encryption (TDE) is anot...