There are differences in query keywords and functionality; also differences in datatypes (MySQL does not have a Guid datatype). Also MySQL has some strange calculation bugs when dealing with DateTime values. Escaping reserved keywords uses different characters. Etc...
You cannot simply replace MS SQL Server and MySQL, you'll need to adjust your application to the database!
For some reason I won't explain here it happens that companies or countries block some websites. Some companies block everything except professional website like this one (codeproject) or Microsoft or universities, ... But blogs are blocked.
That the reason I don't like when people answer to go to check on Google or other search website.
A traditional transactional database is made for storing data. These databases are generally highly normalized to keep the referential integrity, but might be to slow for analytical queries.
A data warehouse is optimized for analysis of the data. The data is therefore often stored in a denormalized and/or aggregated form. To make sure the referential integrity is kept intact they usually pull their data from a transactional database.
There is not a straight answer to that question as there are many different forms of data warehouses.
Also a data warehouse is a database so the question does not really make sense.
The data warehouses I have worked with differ from non data warehouse databases in the following manner:
A data warehouse keeps transactional data so that the state of a database at any point in time can be recreated.
As a consequence data warehouses contain a lot of data as every single change, at the column level, illicits the creation of a new row.
Data warehouses can contain raw, staging and warehouse schemas to enable the verifying of data before it is placed in the data warehouse.
A data warehouse is generally used where one wants to be able to have an audit trail of the contents of the database.
That's my t'penneth.
“That which can be asserted without evidence, can be dismissed without evidence.”
Currently we are using crystal report to display the data whihc is internally fetching almost 55,234,22 records from DB. Since it the no of records are huge it is taking almost 7 minutes to display the report which is very poor performance in nature.
Can anyone suggest me some useful sites to make it faster and can recommend some free tool to measure the exact point which is causing the issue?
Thanks & Regards,
Last Visit: 31-Dec-99 19:00 Last Update: 8-Feb-23 10:06