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 <[email protected]>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 <[email protected] > >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 <[email protected] > > >wrote: > > > > > >> ** > > >> > > >> > > >> On Fri, 26 Apr 2013 09:37:19 -0400, W O > > >> <[email protected]> > > >> 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] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
