Big Data

Without doubt, “big data” is the hottest topic in enterprise IT since cloud computing came to prominence five years ago. And the most concrete technology behind the big data trend is Hadoop.

Most enterprises are at least experimenting with Hadoop, and the potential for transformative business improvement is real.

Big data analytics is an over-hyped, poorly-defined and over-used term.  Despite that, and despite the challenges outlined above, I believe that for many businesses, the opportunities presented by the big data revolution are as significant and fundamental as those presented by e-commerce 15 years ago.  Companies (particularly retailers) should be bold and determined in reacting to these challenges.

Posted in Cloud Computing, Database Technologies, Emerging Trends | Tagged , | Leave a comment

Oracle Database License price with OEM

Product Named-User License Processor License
Oracle Database Server
Standard Edition One $180 $5,800
Standard Edition $350 $17,500
Enterprise Edition: $950 $47,500
    – Real Application Clusters (RAC) $460 $23,000
    – Active Data Guard $120 $5,800
    – Partitioning $230 $11,500
    – OLAP $460 $23,000
    – Data Mining $460 $23,000
    – Spatial $230 $11,500
    – Advanced Security $230 $11,500
    – Label Security $230 $11,500

Oracle License price in US $ (per User, per CPU/CORE) + 15-20% support cost per year.

SummaryIts good to follow ‘per user licensing’ if you ve got =< 50 users. Go by ‘per Core’ if  no of users > 50

For OEM, The following packs are required.

Product Named-User License Processor License
Diagnostics Pack $70 $3,500
Tuning Pack  $70 $3,500

Summary: It may be good to buy OEM for few users as not many would be using it

Posted in Oracle | Tagged , , | Leave a comment

Oracle Database 12c : Deprecated and Desupported Features

Oracle Database Changes

Oracle Database 12c introduces changes that affect Oracle Database in general.

This section contains these topics:

Posted in Database Technologies, Oracle | Tagged , , , | Leave a comment

Windows Azure SQL Database (formerly SQL Azure)

Windows Azure SQL Database (formerly SQL Azure, SQL Server Data Services, and later SQL Services) is a cloud-based service from Microsoft offering data-storage capabilities (similar to Amazon Relational Database Service) as a part of the Azure Services Platform.

Unlike similar cloud-based databases, SQL Azure allows users to make relational queries against stored data, which can either be structured or semi-structured, or even unstructured documents. SQL Azure features querying data, search, data analysis and data synchronization.
SQL Azure uses a special version of Microsoft SQL Server as its backend.

It provides high availability by storing multiple copies of databases, elastic scale and rapid provisioning.

It exposes a subset of the full SQL Server functionality, including only a subset of the data types — including string, numeric, date and boolean.

It uses an XML-based format for data transfer. Like Microsoft SQL Server, SQL Azure uses T-SQL as the query language and Tabular Data Stream (TDS) as the protocol to access the service over internet. (The product does not provide a REST-based API to access the service over HTTP- Microsoft recommends using ADO.NET Data Services for this purpose.)

Posted in Database Technologies | Tagged , , , , | Leave a comment

AMM vs ASSM : Oracle Auto Memory Management

When you have large SGA sizes you can get considerable benefits from using HugePages. Automatic Memory Management ( AMM) and HugePages on Linux are not compatible, which means AMM is probably not a sensible option for any large systems.

Instead, Automatic Shared Memory Management and Automatic PGA Management should be used as they are compatible with HugePages.
Even so, AMM is the default for all ASM instances and should be left that way. From a database perspective, it still may be relevant for smaller, less important databases.

  • HugePages:

For large SGA sizes, HugePages can give substantial benefits in virtual memory management. Without HugePages, the memory of the SGA is divided into 4K pages, which have to be managed by the Linux kernel. Using HugePages, the page size is increased to 2MB (configurable to 1G if supported by the hardware)

Posted in Database Technologies, Oracle | Tagged , , , | Leave a comment

SQLite

SQLite is a relational database management system contained in a C programming library. In contrast to other database management systems, SQLite is not a separate process that is accessed from the client application, but an integral part of it.
SQLite is ACID-compliant and implements most of the SQL standard, using a dynamically and weakly typed SQL syntax that does not guarantee the domain integrity.
SQLite is a popular choice as embedded database for local/client storage in application software such as web browsers. It is arguably the most widely deployed database engine, as it is used today by several widespread browsers, operating systems, and embedded systems, among others.[5] SQLite has many bindings to programming languages.

For FAQ on SQLite, Check out:- http://sqlite.org/faq.html

Posted in General | Tagged , , , | Leave a comment

Why SOAP?

Why SOAP?
Here are a few reasons you may want to use SOAP.

WS-Security
While SOAP supports SSL (just like REST) it also supports WS-Security which adds some enterprise security features. Supports identity through intermediaries, not just point to point (SSL). It also provides a standard implementation of data integrity and data privacy. Calling it “Enterprise” isn’t to say it’s more secure, it simply supports some security tools that typical internet services have no need for, in fact they are really only needed in a few “enterprise” scenarios.

WS-AtomicTransaction
Need ACID Transactions over a service, you’re going to need SOAP. While REST supports transactions, it isn’t as comprehensive and isn’t ACID compliant. Fortunately ACID transactions almost never make sense over the internet. REST is limited by HTTP itself which can’t provide two-phase commit across distributed transactional resources, but SOAP can. Internet apps generally don’t need this level of transactional reliability, enterprise apps sometimes do.

WS-ReliableMessaging
Rest doesn’t have a standard messaging system and expects clients to deal with communication failures by retrying. SOAP has successful/retry logic built in and provides end-to-end reliability even through SOAP intermediaries.

Summary
In Summary, SOAP is clearly useful, and important. For instance, if I was writing an iPhone application to interface with my bank I would definitely need to use SOAP. All three features above are required for banking transactions. For example, if I was transferring money from one account to the other, I would need to be certain that it completed. Retrying it could be catastrophic if it succeed the first time, but the response failed.

Posted in General | Leave a comment