Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


The following is a reply to my query from a private source:

Data bases are for fixed data columns and standardized input methods and
require manipulation by sql type query tools. Unless you are getting
automatic feeds of significant amounts of data from your world wide
operations I don't see what it would do for you. If you are putting together
a business then a data base would be a good thing even if it is simple, but
those are available pre-canned and some are open source. Unless you are
doing something far more complex than I imagine spread sheets should serve
you well and spread sheets have reporting capabilities.

In reality, the reason just about every company went to data bases was that
it centralized and standardized the data it needed and made it available to
each different level of management in order that they could do their jobs
and analyze their results.

The complexity of data bases arises from how data is loaded and validated
and the number of users, which is generally every employee of a corporation.
Big companies have petabytes or more of data to manage and parallel and
redundant servers are required to ensure business continuity.

The other use for data bases is like firefox which has it's own mysql
database built in to manage stuff like cookies and cache and run under
control of the firefox program.

Regardless, a lot of small companies keep some data on incomplete data bases
that they got free or cheap and accumulate, compile, analyze and report
their data from spread sheets for which they either write macros or use the
spread sheet's native reporting tools.

To demonstrate the similarities check out this video tutorial.
<http://www.youtube.com/watch?v=yO2oQhinZ4Y>

What it implies of course is that if you have many spread sheets and they
are formatted in such a way as to correlate inter-relationships you could
import them all into your data base and manipulate that data into a report.
Fancy data base features include data entry windows for individual
contributors and complex reporting engines that can generate charts and
graphs as well as specific answers to pre-determined questions.




--
View this message in context: 
http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006603.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.