How To Choose A Database For Your Next Application ?

-

Well, it depends.

Want to know what options are available and how to choose one for your own application, read this wonderful article by James Hamilton. Though this article does not include all possible options (particularly those on the cloud), but its a nice introduction to classify databases based on what you need.

Relational databases have become so ubiquitous that the term “database” is often treated as synonymous with relational databases like Oracle, SQL Server, MySQL, or DB2. However, the term preceded the invention and implementation of the relational model and non-relational data stores remain important today.

Relational databases are incredibly rich and able to support a very broad class of applications but with incredible breadth comes significant complexity. Many applications don’t need the rich programming model of relational systems and some applications are better serviced by lighter-weight, easier-to-administer, and easier-to-scale solutions. Both relational and non-relational structured storage systems are important and no single solution is appropriate for all applications.

Source: One Size Does Not Fit All by James Hamilton (b:Perspectives)

Good to know. But before you start researching for a perfect Database for your App ..

Keep this great suggestion from 37signals in mind. I am big fan of “Getting Real”. The team behind “Getting Real” @ 37Signals suggest that you don’t worry too much about Scalability aspects early in the design of your application, as you will have lots of time later on to figure out.

In the beginning, make building a solid core product your priority instead of obsessing over scalability and server farms.Create a great app and then worry about what to do once it's wildly successful. Otherwise you may waste energy, time, and money fixating on something that never even happens.

Believe it or not, the bigger problem isn't scaling, it's getting to the point where you have to scale. Without the first problem you won't have the second.

Source: Getting Real – Scale Later

Comments

Post a Comment

Popular posts from this blog

Newsworthy News in Red October : Dow Jones & Tax Dodgers

-
Dow Jones Index crosses the symbolic 10000 figure. U.S. stocks rallied, sending the Dow Jones Industrial Average above 10,000 for the first time in a year, on better-than-estimated earnings at JPMorgan Chase & Co. and Intel Corp. Bank of America Corp., American Express Co. and JPMorgan more than doubled since the Dow slid to a 12-year low on March 9 as global financial firms began recovering from $1.6 trillion in writedowns and credit losses. International Business Machines Corp. and Hewlett-Packard Co. jumped at least 54 percent since March 9 on signs the nation was recovering from the worst recession in seven decades. Source: Bloomberg And, about 7500 International Tax dodgers file for IRS Amnesty to avoid jail Some 7,500 international tax dodgers have applied for an amnesty program that promises no jail time and reduced penalties for tax cheats who come forward, the Internal Revenue Service announced Wednesday. … The program is part of a larger eff...
Read more

USCIS Selects Final H1B Petitions by Random Selection - Almost a 50% chance for each Application

-
U.S. Citizenship and Immigration Services (USCIS) announced today that on April 12 it conducted the computer-generated random selection process to determine which H-1B petitions, subject to the congressionally mandated H-1B cap for fiscal year 2008 (FY 2008), would continue to final processing. USCIS completed this determination ahead of the preliminary schedule noted on April 3, when it announced it had received enough petitions to meet the cap for FY 2008. The 123,480 cap-subject petitions received on April 2 and 3 were labeled with unique numerical identifiers and selected randomly by computer. The chosen numerical identifiers were then transmitted to the appropriate service center for further processing. Source: USCIS Announcement Number 123,480 looks a lot better keeping in view initial estimates. A good 50% chance for each application to be selected.  Update: 3rd May 2007 Hello friends, I understand your anxiety. But don’t loose your hope and/or temper yet. Please wai...
Read more

H1B 2008:USCIS released Preliminary Numbers

-
USCIS today released the final count of number of unique pieces of mail received for H1B petitions. It received 133,000 unique pieces of mail containing H-1B petitions. I guess, each piece of mail will ' mostly ' contain more than one petition, as no company would send each petition in a seperate package and its most unlikely that a firm applies for just one petition. Probably by the end of next week, we might know the actual number of H1B petitions filed and how lucky one must be to get through the initial filter. Source: USCIS Releases Preliminary Number of FY 2008 H-1B Cap Filings  (26KB PDF) 04/05/2007 During Monday and Tuesday, USCIS received 133,000 unique pieces of mail containing H-1B petitions. This is lower that the original USCIS estimate of 150,000. USCIS based the initial estimate on amounts from manifests received along with the mail. USCIS reached the updated number following a physical count of the mail. Each piece of mail may contain more than one H-1B pe...
Read more