Querying in MongoDB

One of MongoDB’s best capabilities is its support for dynamic (ad hoc) queries. Systems that support dynamic queries don’t require any special indexing to find data; users can find data using any criteria. For relational databases, dynamic queries are the norm. If you’re moving to MongoDB from a relational databases, you’ll find that many SQL queries translate easily to MongoDB’s document-based query language.

Related driver docs: Python, Java, Ruby, PHP, Perl


Replication in MongoDB

MongoDB supports asynchronous replication of data between servers for failover and redundancy. Only one server (in the set/shard) is active for writes (the primary, or master) at a given time – this is to allow strong consistent (atomic) operations. One can optionally send read operations to the secondaries when eventual consistency semantics are acceptable.

Two forms of replication are available, Replica Sets and Master-Slave. Use Replica Sets – replica sets are a functional superset of master/slave and are handled by much newer, more robust code.

Each shard of a Mongo cluster is a replica set.

Indexes for MongoDB

Indexes enhance query performance, often dramatically. It’s important to think about the kinds of queries your application will need so that you can define relevant indexes. Once that’s done, actually creating the indexes in MongoDB is relatively easy.

Indexes in MongoDB are conceptually similar to those in RDBMSes like MySQL. You will want an index in MongoDB in the same sort of situations where you would have wanted an index in MySQL.


See more on http://www.mongodb.org/display/DOCS/Indexes

Oracle MySQL

MySQL is the world’s most popular open source database that enables you to rapidly deliver high-performance, read-intensive applications. Oracle offers multiple MySQL commercial editions to meet your business and technical requirements. MySQL also reduces the risk, cost, and time required in developing, deploying, and managing business-critical MySQL applications. With the industry-leading, 24×7 Oracle Premier Support, you can achieve the highest levels of reliability, security, and uptime in your MySQL environment.

Oracle Financial Services

Oracle Financial Services Software, a majority-owned subsidiary of Oracle, offers a comprehensive suite of offerings encompassing retail, corporate, and investment banking, funds, cash management, trade, treasury, payments, lending, private wealth management, asset management, compliance, enterprise risk and business analytics, among others. With our process-driven approach for service-oriented architecture (SOA) deployments, we offer banks the combined benefits of interoperability, extensibility, and standardization. We also offer best-of-breed functionality for financial institutions that need to operate flexibly and competitively and respond rapidly to market dynamics in a fiercely challenging business environment. Oracle Financial Services Software has serviced over 900 customers in more than 135 countries through our portfolio of products and services.

Oracle for Business

Oracle is strongly committed to the global financial services industry. To help financial institutions, Oracle has brought together the industry’s best application and technology ecosystem for evolutionary transformation, providing customers with the largest footprint of functional assets. Oracle’s transformation strategy for financial services industry is executed through the Oracle Financial Services Global Business Unit (FSGBU), and Oracle Financial Services Software is an integral part of the Oracle FSGBU.

Oracle Fusion

Oracle Fusion Middleware 11g is the #1 application infrastructure foundation available today. It enables enterprises to create and run agile, intelligent business applications while maximizing IT efficiency through full utilization of modern hardware and software architectures. Oracle Fusion Middleware 11g is the only middleware available from any vendor that offers the following innovative design principles:

  • Complete—Work with a single, strategic partner for all middleware requirements
  • Integrated—Certified integrations with Oracle Fusion Middleware, Oracle Database, and Oracle Applications provide confidence and reduce costs
  • Hot-pluggable—Enhance your existing infrastructure and applications with interoperability that goes beyond industry standards
  • Best-of-breed—Choose from best-of-breed offerings across every product line