Page 1 of 1

Is Base practical for the following?

PostPosted: Sat Jul 21, 2012 1:53 am
by wh9991
I now use several very large spreadsheets as databases. Any of the spreadsheets can be more than 100 pages long. The same formula is entered into many cells. The time to do the Copy and Paste sometimes takes hours to do. Is it possible and practical to use Base instead Calc to do this?

I think you need more information to answer my question. As a start, please let me know what information you would like.

Re: Is Base practical for the following?

PostPosted: Sat Jul 21, 2012 9:55 am
by Arineckaig
Is it possible and practical to use Base instead Calc to do this?

It depends largely on the nature and design of the data. Base can link to several different RDMSs and essentially most of the latter can handle large volumes of data. On the other hand a Relational Database requires stricter logic and discipline in the design, layout and storage of data than does a spreadsheet. There is a sound introductory tutorial that will help you to assess how suitable the data may be for such a change: it can be downloaded from:
http://www.scribd.com/doc/48635562/Base-Tutorial-OOo

Re: Is Base practical for the following?

PostPosted: Sat Jul 21, 2012 10:51 am
by wh9991
What is a RDMS?

Re: Is Base practical for the following?

PostPosted: Sat Jul 21, 2012 10:55 am
by Villeroy
RDBMS is the database software (no, Base is not): http://en.wikipedia.org/wiki/Relational ... nt_systems

Re: Is Base practical for the following?

PostPosted: Sat Jul 21, 2012 11:11 am
by RoryOF
It stands for Relational Database Management System.

Re: Is Base practical for the following?

PostPosted: Sat Jul 21, 2012 11:27 am
by MichealAngelo
I appreciate you raised this query. While ding a project for McGraw University, I faced similar issues with the assignment. Please assist!

Flame icon removed. That icon means 'Tagged to a known issue' (TheGurkha, Moderator)