Is Base practical for the following?

Getting your data onto paper - or the web - Discussing the reports features of Base

Is Base practical for the following?

Postby wh9991 » Sat Jul 21, 2012 1:53 am

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.
OpenOffice 3.3 on WindowsXP
wh9991
 
Posts: 80
Joined: Tue Dec 27, 2011 2:19 am
Location: Winooski, Vermont, USA

Re: Is Base practical for the following?

Postby Arineckaig » Sat Jul 21, 2012 9:55 am

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
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
AOOo 4.1.5 & LO 6 on MS Windows 10 MySQL and HSQLDB
Arineckaig
Volunteer
 
Posts: 828
Joined: Fri Nov 30, 2007 10:58 am
Location: Scotland

Re: Is Base practical for the following?

Postby wh9991 » Sat Jul 21, 2012 10:51 am

What is a RDMS?
OpenOffice 3.3 on WindowsXP
wh9991
 
Posts: 80
Joined: Tue Dec 27, 2011 2:19 am
Location: Winooski, Vermont, USA

Re: Is Base practical for the following?

Postby Villeroy » Sat Jul 21, 2012 10:55 am

RDBMS is the database software (no, Base is not): http://en.wikipedia.org/wiki/Relational ... nt_systems
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27098
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Is Base practical for the following?

Postby RoryOF » Sat Jul 21, 2012 11:11 am

It stands for Relational Database Management System.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29437
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Is Base practical for the following?

Postby MichealAngelo » Sat Jul 21, 2012 11:27 am

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)
OpenOffice 3.1 on Windows XP
MichealAngelo
 
Posts: 1
Joined: Sat Jul 21, 2012 11:20 am


Return to Reporting

Who is online

Users browsing this forum: No registered users and 0 guests