• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

database alternatives?

 
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi all,
I plan an application that sends queries to a data store and generates graphs from the data. The data are a relatively large number of records and will increase by and by. Currently, they are provided in a MySQL database. I wonder what are the alternatives to a SQL database for using the data in my application.

- The application should run locally but maybe later also on a server.
- I need to make fast queries on the data (= indexing).
- The whole system should be scalable

I have no exprience with databases or datastoring yet. so, what would be the alternatives to a database? could you give me some keywords/tipps to start my search?

Thank you! Luke
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What is a "large number"? Databases are designed to store large amounts of data, and I would guess that you're not going to find a better way to store much data.
 
Lukas Benberg
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I don't know the exact number of records yet, at least a table 150.000 records with 10 fields. and it should be scalable upwards. I just was not sure what is the best practice for storing data in applications / if there are any alternatives.
 
Ulf Dittmer
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
That's a small number for a database, even if it grows ten-fold. That's not to say you won't need to pay attention to table design or indices, just to say that a DB will be able to handle this amount of data nicely.
 
Lukas Benberg
Ranch Hand
Posts: 45
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks! I will use a database then. I thought about storing it in the file system, but I think a database will be not to much effort.
 
reply
    Bookmark Topic Watch Topic
  • New Topic