Thank you very much Leonardo, I shall try to get the book.

Greetings.

Walter.




On Fri, Apr 26, 2013 at 1:02 PM, Leonardo Carneiro
<chesterman86@...>wrote:

> **
>
>
> Anyway, OLAP and OLTP are general database concepts, not only applied to
> Firebird. Wikipedia and other Google sources will give you enough
> informations to play with. If you want a more academic approach, you could
> look to this awesome book:
>
> http://www.amazon.com/Fundamentals-Database-Systems-Ramez-Elmasri/dp/0136086209
>
> This is one is very good book to start if you want to have a plain database
> systems knowledge.
>
> On Fri, Apr 26, 2013 at 1:53 PM, Thomas Steinmaurer <ts@...
> >wrote:
>
>
> > > Ok, thanks, it is more clear now.
> > >
> > > Where I can find more information about OLAP and OLTP, some link you
> can
> > > recommend me?
> >
> > You might get an idea what OLAP means and the article is related to
> > Firebird as well. ;-)
> >
> >
> >
> http://www.iblogmanager.com/download/misc/articles/2008_05_Aggregate_Tables_With_Firebird.pdf
> >
> >
> > Regards,
> > Thomas
> >
> > > Greetings.
> > >
> > > Walter.
> > >
> > >
> > >
> > > On Fri, Apr 26, 2013 at 9:51 AM, Mark Rotteveel <mark@...
> > >wrote:
> > >
> > >> **
> > >>
> > >>
> > >> On Fri, 26 Apr 2013 09:37:19 -0400, W O
> > >> <sistemas2000profesional@...>
> > >> wrote:
> > >>
> > >>> Hello everybody:
> > >>>
> > >>> After reading in this article:
> > >>> http://www.firebirdfaq.org/faq3/
> > >>>
> > >>> "Alternatively, you can add a second server to do long running
> reports
> > >>> (OLAP) and keep Super Server for fast transactions (OLTP)."
> > >>>
> > >>> it seems possible and desirable to have 2 Servers, one for long
> running
> > >>> reports (probably using Classic) and another for the other tasks
> (using
> > >>> SuperServer)
> > >>>
> > >>> Is that right?
> > >>>
> > >>> There are not risks of corrupting the database doing so?
> > >>
> > >> I don't think they are talking about using two servers on the same
> > >> database. My guess is it is talking about a two (or more) database
> > setup:
> > >> One is the OLTP database and the other its the OLAP / data warehouse
> > >> database. The OLTP is used for the actual 'business' side of things,
> the
> > >> OLAP for generating reports. The OLAP database is reloaded (or
> > >> synchronized) regularly from the OLTP database, but might be slightly
> > out
> > >> of date.
> > >>
> > >> Mark
> > >>
> > >>
> > >>
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> > > Visit http://www.firebirdsql.org and click the Resources item
> > > on the main (top) menu. Try Knowledgebase and FAQ links !
> > >
> > > Also search the knowledgebases at http://www.ibphoenix.com
> > >
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]