database size

Question

database size

Viewing 11 posts - 16 through 26 (of 26 total)

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

chess.chess SSC Veteran Points: 281 More actions · Answer 1

PaulB-TheOneAndOnly (8/2/2011)
chess.chess (8/2/2011)
Hi , what is the average size of a large database for an application like
online banking ? i.e. how many tables and MBs of data ? Just looking for an average number as I have no idea what is possible ...
HSBC centralized system or First Lake Okeechobee Natinal Bank? 🙂

HSBC centralized system

chess.chess SSC Veteran Points: 281 More actions · Answer 2

GilaMonster (8/2/2011)
chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .
The point we're trying to make is that there isn't any sensible answer to that question. System 1 has 20 tables, system 2 has 8000. What does the value 4010 say?

OK , but I don't think 20 tables sounds right for Bank of America ? Or are you saying that that is possible for Bank of America ?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

PaulB-TheOneAndOnly (8/2/2011)
chess.chess (8/2/2011)
Hi , what is the average size of a large database for an application like
online banking ? i.e. how many tables and MBs of data ? Just looking for an average number as I have no idea what is possible ...
HSBC centralized system or First Lake Okeechobee Natinal Bank? 🙂

SELECT COUNT(*) FROM sys.tables

SELECT COUNT(*) FROM sys.columns

SELECT COUNT(*) FROM sys.objects

-----------

8340

-----------

142801

-----------

17529

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

chess.chess (8/2/2011)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .
The point we're trying to make is that there isn't any sensible answer to that question. System 1 has 20 tables, system 2 has 8000. What does the value 4010 say?
OK , but I don't think 20 tables sounds right for Bank of America ? Or are you saying that that is possible for Bank of America ?

Users, accounts, account holders, transactions, couple lookup tables

Done! With tables to spare 😉

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

chess.chess (8/2/2011)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .
The point we're trying to make is that there isn't any sensible answer to that question. System 1 has 20 tables, system 2 has 8000. What does the value 4010 say?
OK , but I don't think 20 tables sounds right for Bank of America ? Or are you saying that that is possible for Bank of America ?

CREATE TABLE DataBlob (

RowID INT IDENTITY PRIMARY KEY,

FormName varchar(50),

Data XML

)

There we go, what more is necessary?

(Yes, I have heard of someone doing that)

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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

GilaMonster (8/2/2011)
chess.chess (8/2/2011)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .
The point we're trying to make is that there isn't any sensible answer to that question. System 1 has 20 tables, system 2 has 8000. What does the value 4010 say?
OK , but I don't think 20 tables sounds right for Bank of America ? Or are you saying that that is possible for Bank of America ?
CREATE TABLE DataBlob (
RowID INT IDENTITY PRIMARY KEY,
FormName varchar(50),
Data XML
)
There we go, what more is necessary?
(Yes, I have heard of someone doing that)

Edit, missed quoted:

Where is the body burried? 😉

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 7

chess.chess (8/2/2011)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .
The point we're trying to make is that there isn't any sensible answer to that question. System 1 has 20 tables, system 2 has 8000. What does the value 4010 say?
OK , but I don't think 20 tables sounds right for Bank of America ? Or are you saying that that is possible for Bank of America ?

Why not? I could do BoA's HR leave system in under 20 tables. I used to work with a credit card processing system that had < 50 tables total.

Also define 'system'. A system could use one database, it could use 30. One database could be used by 1 system, it could be used by 10 systems. Some companies go for one massive centralised system that does everything, some companies go for hundreds of little systems that each do something focused and specific. The first will have few databases with lots of tables, the second will have lots more databases with very few tables.

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

chess.chess SSC Veteran Points: 281 More actions · Answer 8

OK , thanks guys . I didn't expect there to be that much variation . But sounds like in the thousands is not unreasonable .

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

chess.chess (8/2/2011)
OK , thanks guys . I didn't expect there to be that much variation . But sounds like in the thousands is not unreasonable .

What "issue" are you facing at the moment?

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 10

Ninja's_RGR'us (8/2/2011)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
GilaMonster (8/2/2011)
chess.chess (8/2/2011)
I realize that the sizes vary but I am just trying to get an idea for the average for a large application .
The point we're trying to make is that there isn't any sensible answer to that question. System 1 has 20 tables, system 2 has 8000. What does the value 4010 say?
OK , but I don't think 20 tables sounds right for Bank of America ? Or are you saying that that is possible for Bank of America ?
CREATE TABLE DataBlob (
RowID INT IDENTITY PRIMARY KEY,
FormName varchar(50),
Data XML
)
There we go, what more is necessary?
(Yes, I have heard of someone doing that)
Edit, missed quoted:
Where is the body burried? 😉

🙂

What they were doing was using a form of Model-View design for the front end and using the database solely to store the serialised Model objects. Nothing more.

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

twdavis-893252 Ten Centuries Points: 1195 More actions · Answer 11

My peoplesoft FSCM database has 55145 tables and 261 gb

My old ERP system has 1598 and 98 gb

The both have about the same number of years on them and they have about same information just different ways of doing things. So database size and number of tables can vary a great deal depending on the software package.