Post reply

database size

  • August 2, 2011 at 11:57 am

    #242373

    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 ...

  • August 2, 2011 at 11:59 am

    #1362434

    50 TB.

    I've seen bigger data warehouses.

    Why do you need to know?

  • August 2, 2011 at 12:00 pm

    #1362436

    All depends on how much data is stored and for how long. I'd imagine a bank like Bank Of America databases are probably big >TB (just a guess) compared to a small credit union that might only be <50 GB

  • August 2, 2011 at 12:01 pm

    #1362437

    Thanks . Just curious .

    ... how many tables and views would that be ?

  • August 2, 2011 at 12:01 pm

    #1362438

    This is a classic 'It depends'. There's no normal values for database size, table count or row count.

    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

  • August 2, 2011 at 12:02 pm

    #1362439

    chess.chess (8/2/2011)

    Thanks . Just curious .

    ... how many tables and views would that be ?

    Between 10 and 100000 with possible outliers on either side.

    Seriously, there's no normal value for things like 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

  • August 2, 2011 at 12:02 pm

    #1362440

    42

  • August 2, 2011 at 12:05 pm

    #1362444

    chess.chess (8/2/2011)

    Thanks . Just curious .

    ... how many tables and views would that be ?

    I've seen 10K tables a few times. I've heard of 30K for SAP.

    Biggest table I have now is around 20M rows, 2.5GB.

    Phone companies will hit that daily for the list of calls.

  • August 2, 2011 at 12:08 pm

    #1362446

    Ninja's_RGR'us (8/2/2011)

    Biggest table I have now is around 20M rows, 2.5GB.

    Biggest I've heard of was 100 000 000 000 rows (no idea of size or what it stored)

    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

  • August 2, 2011 at 12:08 pm

    #1362447

    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? 🙂

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • August 2, 2011 at 12:08 pm

    #1362448

    I realize that the sizes vary but I am just trying to get an idea for the average for a large application .

    Really can go as high as 10000 ?

  • August 2, 2011 at 12:09 pm

    #1362450

    yes.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • August 2, 2011 at 12:10 pm

    #1362452

    OK , thanks . Didn't expect that .

  • August 2, 2011 at 12:11 pm

    #1362453

    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?

    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

  • August 2, 2011 at 12:12 pm

    #1362455

    GilaMonster (8/2/2011)

    Ninja's_RGR'us (8/2/2011)

    Biggest table I have now is around 20M rows, 2.5GB.

    Biggest I've heard of was 100 000 000 000 rows (no idea of size or what it stored)

    US debt 😉

Viewing 15 posts - 1 through 15 (of 25 total)

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