|
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!
|
|
|
|
|
If there are any, what is the difference between Data Warehouse and Database?
|
|
|
|
|
|
I don't want the answer of Google I would like the answer of developers. Google is an advertising and media company  .
|
|
|
|
|
Google Search engines returns also articles, blog posts, etc., written by developers.
|
|
|
|
|
Well... it's the same you know.
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.
|
|
|
|
|
The purpose.
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.”
― Christopher Hitchens
modified 27-Jun-14 4:23am.
|
|
|
|
|
Hello,
I'll have to create a new database. It's a classic membership database. I need to create tables to allow my users to identify with Facebook, Google, Windows, ...
I'm not the first one to create this kind of database. I would like to know if it exists a website with samples, helpers or pattern of classic database design (in UML or ERM).
Thank you,
|
|
|
|
|
|
Thank you. It's exactly what I'm looking for.
|
|
|
|
|
|
Hi,
I ahve an HR software (.NET application) and I would like to save employee documents such as legal docs and letters given to the employee in his records.
Do you recommend to save in within MySQL as blob in PDF or images? or you prefer to save in on the local drive with a link to it in MySQL?
Technology News @ www.JassimRahma.com
|
|
|
|
|
Reasons to save in the DB:
One point of backup.
Referential integrity.
Can't as easily be tampered with.
Reasons to save in the file system:
Keeps the size of the database down.
Easier to edit the documents.
|
|
|
|
|
Hi everyone,
I need storeprocedure for sunday to saturday week report generation and
every day have sub report like Fin_inDate and Fin_outdate.
please anyone send me that sp.
like example: Sunday Monday
Tuesday...........................
Fin_Indate Fin_outdate
Fin_Indate Fin_outdate
|
|
|
|
|
|
Hi Everybody,
I installed mysql on Fedora 20 and I can access to mysql with java on eclip
however I would like to access mysql from other machine and I have used Windows 8 to access to mysql on fedora
I tried to configure on fedora (virtual machine) : Edit my.cnf File. But I can not access to mysql
please see following photos
There is a photo on fedora
<a href="https://onedrive.live.com/?cid=9581B52553DE3427&id=9581B52553DE3427%215729&v=3">Fedora</a>
There is error on Windows OS
<a href="https://onedrive.live.com/?cid=9581B52553DE3427&id=9581B52553DE3427%215730&v=3" >Windows 8</a>
Thanks
Thong LT
|
|
|
|
|
Hi
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,
SMA
|
|
|
|
|
sma123# wrote: 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.
Stop right there; that is not poor performance. Something taking a lot of time does not mean that it does not perform.
What's the size of a single record? Just use Google to look up the size of each field that has no length. Now multiply that by the amount of records. Now take into consideration that it is a Crystal Report, not some text-only output.
You could start with pasting the query here; you'd also want to download a profiler for Sql, and/or use SQL Management Studio to see if you can optimize the query.
That's the fetching-the-data part. The other part would be getting the fetched data into a report-format. If you do not need all the fancy stuff that CR provides, then try writing a simple HTML-report.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I agree with Eddy, this is not a performance problem, seems more like a poor implementation of user requirements.
Am I correct in understanding that the report fetches 55 million records, but does it display that much data ?
Displaying 55 detail records per page would generate a 1 million page report. Really ? Does the user need to see all of that data ?
Is there any way to create summary data at an off-peak time so the report can generate from that summary data ?
What about implementing an asynchronous report generator where the user selects the input parameters, then "kicks off" the report in the background. The report could generate an HTML or PDF report, then send an email to the requestor with a hyperlink to the report when it is complete.
You would be surprised how agreeable a user would be to a solution like this. They kick off a report, then they can move on to something else while it generates. The email tells them when it is done.
Hope these ideas help. 
|
|
|
|
|
David Mujica wrote: I agree with Eddy, this is not a performance problem, seems more like a poor implementation of user requirements.
I think your answer is more correct however.
David Mujica wrote: Really ? Does the user need to see all of that data ?
No user needs to see that. Even if they say they want to see it they in fact want to look something up and that is what one should do instead.
|
|
|
|
|
More complete and definitely friendlier 
|
|
|
|
|
That is not a report it is a data dump and should not be produced via a reporting tool. Dump the data via CSV direct to the hard drive and give it to the user unformatted.
As suggested, this is a lousy implementation of the user requirements, go back and find out what the user wants with that many records.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
What would you call a field that can have the states Public or Private, as in being a publicly or privately owned/operated business?
modified 23-Jun-14 4:47am.
|
|
|
|
|
In programming, Public, Private (and friends) are called access modifiers, the state achieved by assigning one of them called accessibility level - that may give you a name, like:
AccessLevel
Accessibility
Access
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
