Cloud Computing – Profit From IT

Many companies are benefiting from “Cloud Computing”, which involves running software and storing data on remote servers rather than on local computers. Major players in this domain are well established companies such as VMWare, Google, SalesForce, Amazon, EMC, NetApp, IBM, Parallels, Citrix, Microsoft and Oracle have been working very hard to develop innovative products and making Cloud Computing agile and reliable.

Companies using traditional servers can achieve substantial savings when adopting Cloud Computing. As we progress with technology, the myth about Cloud Computing security issues are being addressed and we are now at a point where we can trust our data to reside on virtual servers, miles away from our office. Savings accrued from cloud computing can be invested in business development. This is mainly applicable to small and medium size companies where the business can concentrate their efforts on their core competencies.

There are four models of Cloud Computing deployments. The Public Cloud, aka External Cloud, is the traditional Cloud Computing where resources are self-served over the internet and processing power is billed as an on-required basis. In other words, you pay for what you use. This is where Amazon elastic offerings come in play. The second model is the Community Cloud where several organizations have similar requirements and can share the same infrastructure. SalesForce and Google’s Gov Cloud are the major players in this model. The third model is the Hybrid Cloud where a mix of Public Cloud is combined with managed dedicated servers. This model is used for PCI compliance where the web application is in the cloud and the database server which contains personal information is hosted on a managed dedicated server. The fourth model is the Private Cloud where the server is hosted remotely on a private network and is not shared with other organization. This model is not sought to provide major cost savings but due to the remote private network, organizations minimize their risks from data lost. VMWare, Citrix and Parallels are the main players in this model where a single server can be used to host consolidated servers and savings generated by spending less on hardware and hydro bills.

Resources form Optimal Data Group can help your organization achieve major operational savings by reviewing your infrastructure and recommending the Cloud Computing model that fits your need. For more information, we can be reached at info@optimal.ca

Be the first to comment - What do you think?  Posted by ProAdmin - August 21, 2015 at 11:20 am

Categories: Business Optimization   Tags: , , , , , ,

Oracle Archive log

Often time when we work with test databases, a fullĀ  backup of the database would be available. Depending on the test required, most of the time, we do not need to have ongoing ARCHIVELOG. We can reduce the number of I/O and processing time on the test database server by turning the ARCHIVELOG off.

In order to turn this option off, we can follow these steps:

Step 1: Connect as internal (as sysdba)

Step 2: shutdown immediate;

Step 3: startup mount;

Step 4: alter database noarchivelog;

Step 5: alter database open;

Optionally, you can restart the database and check the value in V$DATABASE

SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;

LOG_MODE
------------
NOARCHIVELOG

Be the first to comment - What do you think?  Posted by ProAdmin - May 12, 2014 at 10:59 am

Categories: Database Optimization   Tags:

Optimizing Oracle11g with Result_Cache

Oracle11g comes with a lot of new features to help improve database performance. One of the feature that can be used to drastically improve performance is the Result_Cache option.

Used wisely, the Result_Cache can improve queries to commonly used tables such as Cities and Countries lookup tables. On one of our project, we used Result_Cache option to retrieve a list of active medical doctors and we were able to achieve 30X performance improvement compared to not using that option.

The Result_Cache option is an indicator to command Oracle to store the result set in memory (SGA) as long as there is no change in the data. The initial query will take longer to return data compared to subsequent queries which will fetch the result set from memory.

Oracle11g Rel2 has some minor enhancement made to the command issued to handle the Result_Cache. Oracle has simplified the command and developers do not have to worry about having to keep track of the specific tables used in functions. Namely the Relies_On command is no longer required in Rel2.

Sample Oracle functions and SQL statements can be reviewed from Oracle’s AskTom http://www.oracle.com/technology/oramag/oracle/07-sep/o57asktom.html

or on ToadWorld’s Steven Feuerstein blog http://www.toadworld.com/Experts/StevenFeuersteinsPLSQLExperience/TrainingandPresentations/PLSQLNewFeatures/tabid/161/Default.aspx#Oracle11g

If you would like to comment on this blog or contact me personally, I can be reached at mike_blogger@optimal.ca

Be the first to comment - What do you think?  Posted by ProAdmin - August 21, 2010 at 1:09 am

Categories: Database Optimization   Tags: