Which is the Best RDBMS can use at client PC?

Question

1.00/5 (1 vote)

See more:

Hello,

I have created one application in MFC. when client run the exe then I need to maintain some of the activity data to in that PC. so I nee to store in some of the file or database which can not accessed by that user and only accessible by application only.

One way to do this is store the data in the normal text file with encryption. but this will work fine with the small size data. But in my case I have 4-5 tables to manage and those data can reach to upto large MB (around 1 GB). so which RDBMS should will best suite with my requirement which work with the MFC and store large data.

Thanks in advance.

Posted 25-Apr-13 21:39pm

npdev13

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2013-04-25T23:17:00

Solution 1

Any of the well know DB systems would suit your purpose, but you need to research them to decide which is the 'best' for your needs. SQL Compact Edition is a fairly simple one and does not require a server to run on. See https://www.google.com/search?q=database+mfc[^] for suggestions from Microsoft.

Posted 25-Apr-13 23:17pm

Richard MacCutchan

Comments

npdev13 26-Apr-13 7:13am

Yes SQL compact edition is one way we can use.

Coder Block · Answer 2 · 2013-04-25T23:40:00

Basically,RDDMS is Short for relational database management system and pronounced as separate letters, a type of database management system (DBMS) that stores data in the form of related tables. Relational databases are powerful because they require few assumptions about how data is related or how it will be extracted from the database. As a result, the same database can be viewed in many different ways.

An important feature of relational systems is that a single database can be spread across several tables. This differs from flat-file databases, in which each database is self-contained in a single table.

Almost all full-scale database systems are RDBMS's. Small database systems, however, use other designs that provide less flexibility in posing queries.

now your requirement is to store data in GB or in TB following database companies or type of database not restrited on size of data.

1)MySQL
2)Oracle
3)MSSQL

Its totally depends on hardisk you provide to store data.If you have 512 MB hardisk then you can store data only of this 512MB size.;-)

but very important thing that current world totally depend on is plateform independancy.You consider database which will run on window,linux,And even on android.
so as per my knowloadge you should use

ORACLE :-)

And if you dont want to use database then you can consider the concept of binary files.