Technology Solutions

Oracle Database and Options

Nowadays, the most valuable entity for the organizations is “data” besides human sources. Organizations reach their customers and produce income through the data. They also prepare reports for which they are obliged to submit by making use of the data for certain governmental institutions. Therefore, data is now considered as a commercial entity for the organizations. Therefore, the organizations are responsible for the integrity, accessibility and security of the data. In order to turn such data into a source of income, relational databases are currently used. Oracle, producing the world’s first Relational Database System in 1979, became the pioneer in this regard. Oracle, which has allowed the organizations to manage their data, which is a valuable entity for them, since that day until the present, has kept its leadership as the most preferred and used database management system in almost all business sectors.

Oracle Database

Oracle, which presented the first cloud system designed database Oracle Database 12c two years ago, offers numerous advantages to its customers with more than 500 new features by the new database compared to the previous version. Oracle Database 12c offers a new multi-tenant architecture on a fast, scalable and secure database. By offering new features such as database consolidation, automated data optimization, deep defense based security, maximum accessibility, efficient database management and easier data analyzing as well as enhanced versions of the existing features, Oracle Database 12c lightens the workload of the organizations by providing them convenience.

Please follow the link below to get more information about Oracle Database 12c.

Oracle Database Options

Oracle offers database options which involve conveniences on many regards such as extra security, management easiness and compliance with international auditing standards for the corporate data. These database options provide a great deal of added values, such as extra security against internal or external threats, traceability and reporting features as well as storing the data in a correct way, saving disk space, accessing faster, enhancing BT on audits such as SOX, BDDK, BTK PCI etc. and reducing the risk against security gaps, to the sensitive corporate data.

Please follow the link below to get more information about Oracle Database Options.

Audit Vault & DB Firewall

One of the numerous features of AVDF (Audit Vault & DB Firewall) that it can be used both on Oracle and non-Oracle databases is the key factor for the organizations, which give importance to the data security, to prefer it. Via AVDF, desired audit data can be acquired not only from hundreds of databases but also from operating systems, file servers and many similar resources. According to the Data Breach Investigation Report provided by Verizon in 2012, 98 percent of total stolen data was taken from the databases. 84 percent of data stealing actions from the databases were carried out through intentional or unintentional internal attacks. And 97 percent of such data steal can be prevented through basic controls and solutions. Not only that it prevents such attacks with AVDF, Oracle makes the database a secure environment with numerous traceability and reporting features such as by which users and to which tables or data the attacks were carried out. For instance; inquiries about sensitive data or data that is now wanted to be accessed by everyone such as credit card or personnel salary information kept on an Oracle or non-Oracle database can be prevented against certain user accesses. Such inquiries can be blocked via DB Firewall before reaching the database and reported providing information about when and by which user it is intended. Additionally, unchanged and changed states of certain tables on which certain users make changes are also kept. By running reports compliant with many audit procedures such as SOX, PCI-DSS, HIPAA and DPA, which are included in AVDF, data security can be measured according to these criteria and customized reports can be generated. Relevant warning mechanisms can be determined and automatically delivered to intended users. The reports in these mails optionally can be attached to the mails or shared through a link within the mail to avoid mail box space usage. With Audit Vault & DB Firewall, provisions against many invisible or unpredictable security gaps are made and environments such as databases, operating systems and file servers that have critical importance for the organizations are secured further.

Please follow the link below to get more information about Audit Vault & DB Firewall.

DB Vault

Oracle Database Vault is a security product which can limit, trace and report an authorized user’s access to, update and manipulation of the application data. Oracle DB Vault, which targets the security of the application data rather than database security, can make customizations according to policies such as SOD (Segregation of Duties) while securing the application data. Oracle DB Vault is also a certified solution especially for Oracle E-Business Suite, Oracle PeopleSoft, Siebel CRM and SAP applications and it can limit the authorizations of the database users by numerous criteria. For example; it secures the data on a detailed level by preventing unauthorized access by IP addresses, application names, determined time periods authentication methods. Oracle DB Vault’s security controls consist of realms, command rules, factors, segregations of duties and reports. To manage these security controls, reports created through a user friendly management console can be monitored and traced. Oracle DB Vault parses the duties on a database through 3 different responsibilities that are security management, account management and database management. Therefore, while determining and managing realms, command rules and factors, the user responsible for security management cannot run inquiries about application data on a database. And the user responsible for the database management can access the results of the application data inquiries according to the rules set up and configured by the user who is responsible for the security management. Apart from that, the database administrator performs his duties such as backing up, patch applying and performance management. And the user responsible for account management has the authority to create, delete and edit user accounts. Therefore, with Oracle DB Vault, authorizations of database users are limited by certain standards, thus providing data security, and the risks that authorized database users carry are minimized.

Please follow the link below to get more information about DB Vault.


One of the resources that increase most rapidly and for which time is consumed for management in IT organization nowadays is the data of the organization. When it is considered that data of the organizations are at Terabyte and Petabyte levels, processes such as writing on and reading from the tables which include such big data is beginning to cause performance problems. Therefore, the technologies that enable easier management of the rapidly increasing data and quicker access to this data have begun to be preferred more by the ITs today.

Oracle Partitioning separates tables and indices of organizations that include big sizes into smaller and easily manageable pieces and provides high performance and availability with the concept Partition, Fragment and Manage More Comfortably. Oracle Partitioning as an option for Oracle Database 11g Enterprise Edition offers a comprehensive choice of partitioning methods including range, interval, hash, list and composite. Additionally, it allows combined partitioning of two methods such as order date and region or customer and region type. For example, when mobile phone bill of July is queried for a telecommunication company that has 10 million customers in July and when it is considered that the bill table contains the bill information of the previous months of the same year, it will try to bring the related bill from among a total of 70 million bills of 10 million subscribers. However, if portioning is made basing on the months in the related table, query will be made among 10 million records for only July. Therefore, much lower CPU will be used and more performance will be ensured.

Oracle Partitioning ensures dramatic time gains in reporting processes by employing in Datawarehouse systems that are used particularly for reporting by organizations. In addition, it minimizes the consumed effort while increasing the database performance for deleting in partitioned tables with big data by quicker and higher performance operations than the non-partitioned tables. By means of Oracle Partitioning, storage areas are used more efficiently and cost-effectively, and much quicker access of organizations to data with higher performance is ensured by maximizing optimization of tables that affect database performance.

You can visit the following link for online assessment of your database storage management.

Please follow the link below to get more information about Oracle Partitioning.

Data Masking

Oracle Data Masking offers data privacy and protection by masking vulnerable data of organizations with specific templates to prevent viewing of unauthorized people. The data of the live system that are not desired to be viewed by everyone such as credit card number, social security number or salary information are replaced with realistic values and use of the data out of the live system are taken under protection. Direct use of vulnerable live system data for development and test studies is not preferred by the organizations and it does not comply with data security control articles.

With Oracle Data Masking, live system data can be masked with specific masking rules or a rule created for an organization and development can be made on a simulation of the live system with the live data. At the same time, data security is ensured while performing correct quality and healthy tests by means of test studies.

By this means, organizations comply with many regulations such as COBIT, Sabarnes-Oxley, PCI DSS and HIPAA. Oracle Data Masking detects data dependencies and automatically groups the criteria such as ‘foreign key’ as vulnerable data. Masking rules determined by the organization are saved and automatically applied to every new created test and development environments and provides effort advantage by minimizing the tasks that must be carried out manually by the database managers. Oracle Data Masking can also be used in other databases than Oracle database such as IBM DB2 and Microsoft SQL Server.

Please follow the link below to get more information about Oracle Data Masking.

Oracle Advanced Compression

Rapidly growing data sizes and necessity for quick access to data for operational continuity has become a subject for IT departments for which serious effort and expenses must be made. Increase of demand towards using the data in parallel with the increasing data creates risks on system performances and requires management. Oracle Advanced Compression offers compression features at network, disk and database levels and brings benefits two to four times for all data and application software types. Oracle Advanced Compression presented optionally with Oracle 11g database allows high performance data compression with its new feature OLTP Table Compression. With this new feature, in addition to allowing compression of irregular data such as SecureFile, it can compress backup data such as RMAN and Data Pump and Redo Log transport files included in Data Guard configuration. Performance problems encountered in many compression technologies when reading by opening detail or when writing by opening compressed table are prevented in Oracle Advanced Compression by reading or writing without opening the table. By this means, performance problems are not encountered and, as the table that is read and written has fewer blocks, performance improvement is usually observed. Compression at network level, which is one of the features of Oracle Advanced Compression, solves the performance problems arising from inadequate bandwidth particularly in systems with Data Guard use to a great extent. By means of Data Guard, redo information created by transactions is compressed and sent from the live system to remote database. With compressed redo information, less network traffic develops and replica transaction speed increases. By means of Oracle Advanced Compression database option, maximum compression and disk space are ensured with outstanding compression algorithm in network, disk and database, while it brings performance increase in reading and writing transactions in compressed tables unlike its competitors.

Please follow the link below to get more information about Oracle Advanced Compression.