Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any database and write it. Support ORACLE, MSSQL 6.5-2000, MySQL,SyBase, Db2 for NT, MSAccess and other ODBC databases. Load external SQL-query . Show result sets in web browser. Union query builder. The inclusion of OLAP functionality within Visual SQL-Designer helps make multidimensional analysis more affordable and brings the benefits of OLAP to a wider audience.... VisualSoft :: SQL :: Database :: DBMS :: Edit :: ODBC :: Easy :: MySQL :: Oracle :: Sybase :: Access :: QBE :: DB2 :: OLAP :: ROLAP :: MOLAP :: STORED Procedure :: Visual SQL-Designer
DAC for MySQL (also known as MySQLDAC) is the most powerful component suite for Delphi/C++Builder/MySQL. This component suite allows you to create Delphi/C++Builder applications with direct access to MySQL DB without BDE and ODBC. BLOB fields are supported. MySQLDAC was developed for easy migration of existing projects from BDE/ODBC scheme to the native one. Any MySQL library is not required.... microOLAP Technologies :: DAC :: MySQLDAC :: Delphi :: C++Builder :: Builder :: MySQL :: replacement :: TDataSet :: BDE :: ODBC :: alternative :: borland :: library :: native :: link :: DAC for MySQL Source Code
PostgresDAC is PostgreSQL BDE replacement for Delphi 4-6 and BCB 5. It allows to create Delphi/BCB5 applications with the direct access to PostgreSQL DB without BDE and ODBC. Migration friendly Interface of PostgresDAC is BDE-like and TDataSet compatible. TDBImageEx component for JPEG images in BLOBs support included in package for free (with sources). Royalty free.... microOLAP Technologies :: PostgresDAC :: Delphi :: C++Builder :: alternative :: replacement :: PostgreSQL :: JPEG :: TDataSet :: BDE :: ODBC :: borland :: inprise :: PostgresDAC Site License
PostgresDAC is PostgreSQL BDE replacement for Delphi 4-6 and BCB 5. It allows to create Delphi/BCB5 applications with the direct access to PostgreSQL DB without BDE and ODBC. Migration friendly Interface of PostgresDAC is BDE-like and TDataSet compatible. TDBImageEx component for JPEG images in BLOBs support included in package for free (with sources). Royalty free.... microOLAP Technologies :: PostgresDAC :: Delphi :: C++Builder :: alternative :: replacement :: PostgreSQL :: JPEG :: TDataSet :: BDE :: ODBC :: borland :: inprise :: PostgresDAC Source Code
4 stars (Fundamental Olap principles) - I was impressed by the quality of this book; this is probably the most complete book on OLAP theory and is a fundamental reading for professionals involved in the design of olap systems. In most cases it gives all the details and information needed to master this technology. It also contains some practical examples that are very useful to see how the theory can be applied in the real world. I didn't read the first edition, but the second edition contains new sections and many updates, like a description of SQL-99 OLAP extensions. The author chose to be vendor-independent, so all practical examples are based on a multidimensional language that he created, called Located Contents (LC). However, when I read it I had already used a couple of OLAP tools (Microsoft Analysis Services and Microstrategy), and I think that this helped me understand many of the concepts contained in the book. 4 stars (Good OLAP Methodology) - OLAP is a somewhat arcane corner of the IT universe and this book is a good guide to it for information and business professionals. It covers the basics well and provides decent exaples to get you going. Of course, the hardest part of OLAP is making the conceptual leap from relational databases and transactional processing to the world of analytical processing, but finance experts and accountants will appreciate OLAP and its ability to summarize data in a way that is hard to do in most ERP and legacy systems. 5 stars (A must read for anybody involved in Olap design) - A book which gives you a comprehensive theoretical foundation together with useful, pratical techniques to design Olap solutions. In the first half of the book the author explains you all you need to think clearly in N dimensions, in the second half he guides you through the design of a rather complex application, stepping into the purchasing process, the material inventory analysis, sales & marketing, and activity-based management. He teaches you ... John Wiley - Sons Inc :: Information Management :: Decision Making & Problem Solving :: Database Management - General :: Computers :: Computer Bks - Data Base Management :: Business & E :: OLAP Solutions- Building Multidimensional Information Systems