Creating new Database for a large Enterprise

Question

Creating new Database for a large Enterprise

djdhere

Grasshopper

Points: 13
More actions
August 25, 2010 at 1:23 pm

#226215

Hello All,
I need some help with creation of DB for a Bank ERP software
(Its having near about 300 branches )
Main Bank -> Their branches.
My queries are that -How we will manage this type of huge data & DB . ... We have to create DB ... branchwise? or finacial-year wise?... or single DB can manage all the things ...
I would appreciate your advice in this regards.
Regards,
djdhere

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Derrick Smith SSChampion Points: 10833 More actions · Answer 1

I assume this is a homework question, since you clearly wouldn't be working on this alone if it were a real project.

You need a lot more information than you've given here, and a lot of it comes from business requirements (how long you're legally allowed to store data on a live server, etc). For what it's worth, a project of this scale is usually handled by a good size consulting firm.

WayneS SSC Guru Points: 95460 More actions · Answer 2

Would you mind posting the name of the bank? I suddenly sense a need to move my accounts! :w00t:

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Greg Edwards-268690 SSC-Insane Points: 20680 More actions · Answer 3

djdhere (8/25/2010)
Hello All,
I need some help with creation of DB for a Bank ERP software
(Its having near about 300 branches )
Main Bank -> Their branches.
My queries are that -How we will manage this type of huge data & DB . ... We have to create DB ... branchwise? or finacial-year wise?... or single DB can manage all the things ...
I would appreciate your advice in this regards.
Regards,
djdhere

1st question

It depends....:w00t:

You need to check into hardware, with some idea of initial size and growth. So you cannot ignore redundancy and scalability.

2nd question

It also depends...

If you can get it in 1 database, and your hardware can handle it, that might mean just some partitioning. Although that may depend on the version of SQL Server too.

You may have a steep learning curve ahead. Maybe hiring some help would be wise. Nothing worse than making a mistake with other people's money. Unless this is just some class assignment.

Greg E

Sioban Krzywicki One Orange Chip Points: 27770 More actions · Answer 4

djdhere (8/25/2010)
Hello All,
I need some help with creation of DB for a Bank ERP software
(Its having near about 300 branches )
Main Bank -> Their branches.
My queries are that -How we will manage this type of huge data & DB . ... We have to create DB ... branchwise? or finacial-year wise?... or single DB can manage all the things ...
I would appreciate your advice in this regards.
Regards,
djdhere

Hire a good consultant or two and a dba.

--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams

djdhere Grasshopper Points: 13 More actions · Answer 5

Hello,

Thanks for the reply.

This is not an assignment, its a project of my company.

I am using SQL server 2008.

Thanks

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 6

djdhere (8/25/2010)
Hello,
Thanks for the reply.
This is not an assignment, its a project of my company.
I am using SQL server 2008.
Thanks

With all due respect, the questions you asked are questions that anyone qualified to carry out this project would not be asking. I would be scared if this was my bank.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 7

djdhere (8/25/2010)
Hello All,
I need some help with creation of DB for a Bank ERP software
(Its having near about 300 branches )
Main Bank -> Their branches.
My queries are that -How we will manage this type of huge data & DB . ... We have to create DB ... branchwise? or finacial-year wise?... or single DB can manage all the things ...
I would appreciate your advice in this regards.
Regards,
djdhere

Please... do the honorable thing. Tell your company that you aren't qualified to do this and that if you're the best they have for a DB Developer, tell your company that they aren't qualified for the job, either. This isn't something to screw around with.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 8

WayneS (8/25/2010)
Would you mind posting the name of the bank? I suddenly sense a need to move my accounts! :w00t:

+1

😀 :hehe:

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

djdhere (8/25/2010)
Hello,
Thanks for the reply.
This is not an assignment, its a project of my company.

I used to work for a bank. The kind of project that you're talking about here would typically need a medium-large team of experienced SQL developers, experienced front end developers and a very experienced data modeller/database architect at the very least, with an experienced DBA advising on the hardware and scalability issues. If you are doing this alone, and you're asking such basic questions, you (and your company) are in trouble.

How much experience do you have in data modelling and database design? In database development?

Please, for the sake of your career, your company and their customers, tell whoever requested this that you are not sufficiently skilled (I personally would be nervous if I'd been asked to do this), that they really need to get a skilled team (internal or consultants) or they should look at buying an off-the-shelf product.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 10

I'm curious. What is the system the bank currently has in place?

Or are they doing business with good ol' pen & paper?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.