Does Your Database Live Up To The Expectations Of It’s User’s?

There are many points when it comes to the success of an organization. According to some, communication is the most important thing that keeps an organization intact, others think that it is driven by innovation. Whether it is about communication, producing results or innovations, it all depends on the database administrators who are striving to take the organization towards success.  Apart from their efforts, a well designed project management system will help in enhancing an individual’s performance.

There are five ways in which it can be ensured that the database itself and the database project management is exactly in accordance with the client’s expectations.


One thing that is common in sophisticated databases offering a variety of functions such as event registration, membership dues processing, invoicing, publication sales, fundraising, exhibit management is process. When you are kick starting a new database or an upgrade, you must carefully review all your business processes. This will help you in identifying if you have any inefficient or improper procedures in place. If there are any, then you must discuss them with your software developer. You must sit and analyze, as it is possible that your developer must be thinking of some other ideas that are different from yours that you have in mind. This will in the long run help you in making the databases useful.


In order to achieve perfect database project management, proper training and documentation is required from the database administrators end that will help in executing the business plans well. With a database consultant who acquires the knowledge of your processes, it will become a lot easier to document them and develop the training materials.


Garbage in, garbage out is the term that is normally used to refer to the information that is stored in your database. Supposing that the information kept in the database is not accurate or uniformly entered and no amount of reporting or consulting will give the data you need. This is the time period where the data standards should be religiously followed.

In order to develop useful and accurate management reports it is important that you adhere strictly with the data standards. Because it is the data standards, only that will clearly exhibit how to enter data. Moreover, they would also explain which fields are required to be entered and what must be entered to complete a record.


The type of data is totally dependent on the industry or the profession your company serves. This only will let us know that how frequently data in your database changes. If over the year, no updating is done, then there are chances that your databases might contain 50% incorrect information. So, what should be done to make the database project management uniform? In simple terms, data collection should be made continuous. You may go for other methods as well for data updation. The point to be noted here is that, data is an entity for your organization that needs to be frequently updated.


In order to achieve consistent effectiveness, you must know thoroughly what is needed from your database. It all comes under the umbrella of effective database project management; the several functions that a database must provide such as

  • Content management comprising of address, phone, fax and email
  • Membership tracking and invoicing
  • Volunteering activity and much more

Knowing what your needs are at present and in the future will take you a long way leading to an effective database creation.

Why upgrade to Oracle Database version 12C

Oracle database version 12C is by far the most important Oracle release in the last 10 years. Its advanced capabilities promote better performance, increased scalability, and easier data management. For the enterprise, this translates into significant cost savings, reduced risk, and increased flexibility. The Oracle 12C means different things to different people. It all depends on which areas you are looking at, as there are improvements in many areas.

Below are some of the top mose notable  features in the 12C database.

Top 12 Features of Oracle 12C Summarized.
01. Pluggable Databases Through Database Consolidation:

Oracle is doing every thing to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this feature. There is a radical change and a major change in the core database architecture through the introduction of Container Databases also called CBD and Pluggable Databases (PDB). The memory and process is owned by the Container Database. The container holds the metadata where the PDBs hold the user data. You can create upto 253 PDBs including the seed PDB.

In a large setup, it is common to see 20 or 30 different instances running in production environment. With these many instances, it is a maintenance nightmare as all these instances have to be separately

•RAC Enabled
•Backed up and
•Data Guarded.

With Pluggable Databases feature, you just have to do all this for ONE single instance. Without this feature, prior to 12C, you would have to create separate schemas and there is always a thread of security how much ever the isolation we build into it. There are problems with namespace conflicts, there is always going to be one public synonym that you can create. With PDBs you can have a separate HR or Scott schema for each PDB, separate Emp, Dept Tables and separate public synonyms. Additionally, 2 PDBs can talk to each other through the regular DB Link feature. There is no high startup cost of creating a database any more. Instead of one instance per day, the shift is into one instance per many databases. For the developer community, you can be oblivious of all this and still continue to use the PDBs as if it were a traditional database, but for the DBAs the world would look like it has changed a lot.

Another cool feature is, you can allocate a CPU percentage for each PDB.

Another initiative being, it has announced a strategic tieup with during the first week of July 2013.


02. Redaction Policy:

This is one of the top features in Oracle 12C. Data Redaction in simple terms means, masking of data. You can setup a Data Redaction policy, for example SSN field in a Employee table can be masked. This is called redaction. From Sql Develop you can do this by going to the table: Employee->Right click on Security Policy->click on New->click on Redaction Policy->Enter SSN. When you do a select * from employee, it will show that the SSN is masked.
The new data masking will use a package called DBMS_REDACT. It is the extension to the FGAC and VPD present in earlier versions. By doing this, whoever needs to view the data will be able to see it where as the other users will not be able to view it.


03. Top N Query and Fetch and offset Replacement to Rownum:

With the release of Oracle Database 12c, Oracle has introduced this new SQL syntax to simplify fetching the first few rows. The new sql syntax “Fetch First X Rows only” can be used.


04. Adaptive Query Optimization and Online Stats Gathering:

With this feature, it helps the optimizer to make runtime adjustments to execution plan which leads to better stats. For statements like CTAS (Create Table As Select) and IAS (Insert As Select), the stats is gathered online so that it is available immediately.


05. Restore a Table easily through RMAN:

Earlier if you had to restore a particular table, you had to do all sorts of things like restoring a tablespace and or do Export and Import. The new restore command in RMAN simplifies this task.


06. Size Limit on Varchar2, NVarchar2, Raw Data Types increased:

The previous limit on these data types was 4K. In 12C, it has been increased to 32,767 bytes. Upto 4K, the data is stored inline. I am sure everyone will be happy with this small and cute enhancement.


07. Inline PL/SQL Functions and Procedures:

The in line feature is extended in Oracle 12C. In addition to Views, we can now have PL/SQL Procedures and Functions as in line constructs. The query can be written as if it is calling a real stored procedure, but however the functions do not actually exist in the database. You will not be able to find them in ALL_OBJECTS. I think this will be a very good feature for the developers to explore as there is no code that needs to be compiled.


08. Generated as Identity/Sequence Replacement:

You can now create a col with ‘generated as identity’ clause. Thats it. Doing this is equivalent to creating a separate sequence and doing a sequence.nextval for each row. This is another handy and a neat feature which will help developer community. This is also called No Sequence Auto Increment Primary Key.


09. Multiple Indexes on a Single Column:

Prior to 12C, a column cant be in more than one index. In 12C, you can include a column in B-tree index as well as a Bit Map index. But, please note that only one index is usable at a given time.


10. Online Migration of Table Partition or Sub Partition:

You can very easily migrate a partition or sub partition from one tablespace to another. Similar to how the online migration was achieved for a non-partitioned table in prior releases, a table partition or sub partition can be moved to another tablespace online or offline. When an ONLINE clause is specified, all DML operations can be performed without any interruption on the partition|sub-partition which is involved in the procedure. In contrast, no DML operations are allowed if the partition|sub-partition is moved offline.


11. Temporary UNDO:

Prior to 12C, undo records generated by TEMP Tablespace is stored in the undo tablespace. With Temp undo feature in 12C, temp undo records can be stored in temporary table instead of UNDO TS. The benefit is – reduced undo tablespace and reduced redo log space used.

SQL> ALTER SYSTEM SET PGA_AGGREGATE_LIMIT=0; –disables the hard limit


12. In Database Archiving:

This feature enables archiving rows within a table by marking them as inactive. These inactive rows are in the database and can be optimized using compression but are not visible to the application. These records are skipped during FTS (Full Table Scan).


Other Features:

Advanced Replication and Streams are Dead. It is being replaced with Oracle Golden Gate.

Invisible Columns. You can now have a invisible column in a table. When a column is defined as invisible, the column won’t appear in generic queries

PGA Aggregate Limit setting:

In 12c, you can set a hard limit on PGA by enabling the automatic PGA management, which requires PGA_AGGREGATE_LIMIT parameter settings. Therefore, you can now set the hard limit on PGA by setting the new parameter to avoid excessive PGA usage.

DDL Logging:

The DDL statements will automatically get recorded in xml/log file if ENABLE_DDL_LOGGING is set to True. ALTER SYSTEM|SESSION SET ENABLE_DDL_LOGGING=TRUE

Big Data – What is it All About

In the easiest manner Big Data can be described based on the 3 V’s. These are elaborated as:

Volume – Very large amount of data, specifically in 100’s of Terabytes.

Variety – data in a range including both unstructured and semi-structured.

Velocity – the generation or consumption of data at a particular rate.

In other words, Big Data can be collectively defined as the term used for very large and potentially complex data sets that are even difficult to handle without traditional tools and applications such as the Relational Database Management Systems.

How Big Data Can Help Us?

Big Data can contribute in the following ways:

  • Creating transparency
  • Enabling experimentation to discover needs
  • Exposing variability and improving performance
  • Innovating new business models, products and services
  • Replacing/supporting human decision making with automated algorithms
  • Segmenting populations to customize actions


Big Data And Business Analysis


Big data is used to analyze business trends and marketing segmentation in a business customer’s database. When it comes to Big Data users, then we see that those internet firms providing search facilities are also its users availing the data being fed to all of the connected devices. Keeping in consideration Big Data popularity in today’s technological world there has been huge coverage made in this regard involving those companies that provide Big Data software and services.

What happens when such a technology comes into view?

A new technology comes into the limelight and all the viewers, the tech types get excited about it of what more could be done to mature the technology. Moreover the money types become excited about how much money they would be able to make. The hundreds of thousands of blogs all need something latest to write about and publish on their websites. Eventually this would be a lot help in bringing an impact in Google rankings.

With numerous benefits of Big Data there are still many companies that do not utilize a genuine use of Big Data.

Let’s Dig In To See Two Of The Practical Benefits Of Big Data:

Negotiate with the Consumers

In today’s technical world, the buyers that come to you have already a lot of things in mind that they expect and they also want to be sincerely thanked for it. With Big Data you will be able to set your standards in a more vocal manner which will let the clients engage in a one-on-one real time conversation. And if it’s not this, then they will leave you in the blink of an eye.

Take for example, the profile of a customer who arrives at a bank. Big Data will play an important role in this, allowing to check the profile of the customer in real-time.

Re-build Your Products

With Big Data you will be able to understand how others perceive your products so, that you will know how to adapt and market them. It will assist you in testing thousands of different variations in computer aided design so that you may gauge about the changes related to material costs, lead times and performance. You will then be able to enhance the efficiency of production process.

All in all, you will be able to gather deep insights with the help of Big Data. There used to be times when you needed to analyze large amount of data and you had to approach the IT specialists for it. And by the time the requested information was given it was no longer useful. Now with Big Data, systems can be developed and tools can be used that are interactive and dynamically virtual thus allowing the business users to analyze, view and benefit from the data

Catch A Glimpse Of Some Amazing Facts About Linux!!

Linus Torvald never knew that his own creation; a personal project of a free operating system would become so popular one day with numerous users preferring Linux and considering it the best among many. What was done with the integration of GNU components to make a functional Operating System, is today among the top choices of the developers.

Below mentioned are some of the amazing facts about Linux that will amaze the both Linux users and the non-users as well!!

Some Amazing Facts About Linux

  • Way back when Linux project begun, it occupied only 65 KB. Today, there are 10 million lines of source code in even a single Linux kernel.
  • The New York Stock Exchange is powered by Linux.
  • Linux is also used extensively by the department of Defence of the US. Furthermore, the nuclear submarines of the state are also run by nuclear submarines.
  • Most of the tech giants Google, Amazon and Facebook for their web and cloud services favor Linux. In fact, they consider Linux as their first choice.
  • To all those who think that once they start using Linux, they will be stuck in one operating system, they are actually unaware of a great plus point. Linux can be used side by side with Microsoft Windows on the same computer using a software called Cooperative Linux (coLinux).
  • Linux is used in Japan’s bullet trains in order to maintain and manage the sophisticated Automatic Train Control System. Moreover, inside Toyota, the In-Vehicle-Infotainment technology (IVI) and other automobiles Linux Platform is used.
  • With the passage of time when it was first put in the open source category, Linux has expanded exponentially. In total Linus Torvald’s codes, account for only 2% of the codes present in the kernel.
  • Behind Linux being called as the King of Supercomputing, is the reason that Linux comes among the 500 fastest supercomputers of the world.
  • Once you think of becoming a developer or when you kick start your education leading to graduation, you are taught mostly the basics including the C language. Have you ever wondered why is that so? It is because the major part of code in Windows, Linux and Mac is written in C language. This is the reason that when you plan on becoming a developer you are first taught the basics.
  • It is on the Linux kernel upon which the best smartphones such as Android and Maemo are built.
  • Linux with its capabilities has managed to have a special place in Hollywood. The amazing visual effects that were observed in Titanic and Avatar were developed in 3D applications on the Linux platform.

Aforementioned were some facts about Linux, that are enough to amaze us that behind the fulfillment of much bigger things is Linux whose following keeps on increasing day by day.

Oracle Database – It’s Popularity and Merits!!

There are many other databases used by different organizations and for different purposes. But today, the most widely used databases are Oracle and MS SQL Server. These are considered as the best and the most popular in terms of transactions and the organizations that utilize them in most of the database projects.

Effective and efficient database management solutions are granted to the users through its products such as Oracle 8i, 9i up to 11g. Organizations who are looking for long term database management solutions find Oracle as the best because of its durability, trustworthy, crash free, its effectiveness etc thereby putting less load on the server.

Why is Oracle Popular?

Developed by the world’s largest and the most respectful enterprise solution provider and software company, Oracle database has become widely popular with its variety of database products that are also compatible with all the other versions. Its feature of product interconnection and compatibility with every version in front of clients is considered to be as the most impressive one.

The Numerous Advantages Of Oracle Database Include:

Satisfaction Of Customers

Oracle databases, being backward compatible gives the system the opportunity of upgrading their systems. Moreover, it also provides efficient and low cost updates. It can be said that the biggest merit of using Oracle database is its belief in customer satisfaction. The customer’s satisfaction is considered as the target, according to which in new versions of Oracle databases new impressive features are introduced.

It’s functionality

Being used in mostly all the corporation level applications, Oracle database’s practical usage, is the feature many organizations count on. As a pioneer database in the banking industry, it is used by world’s top 10 banks, thereby making the operations as smooth as possible. Providing a combination of high-level technology and integrated business solutions depicts its best functionality and thus making it perfect for all those corporations that have to handle large amounts of data efficiently.


Whenever stuck with demanding tasks, it is Oracle that delivers excellent performance proving its reliability. Oracle databases, passed the ACID tests for databases (a test that ensures data integrity), also proves that these are the best databases that are considered highly reliable when it is about the integrity of data storage.

Flashback Technology

For any system, the most important thing is not to lose the stored data at any cost. And if in case the data is lost then Oracle’s flashback technology gives you the advantage of efficient recovery of the data that is either deleted or lost. All the human errors are eliminated with the help of flashback technology and the database recovery time is also increased. All in all, with this process an organization or company will experience smoothness in management and as well in the administrative process.