- Feature Articles
- CodeSOD
- Error'd
-
Forums
-
Other Articles
- Random Article
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
I have a database with a single table, with a single row that holds the contents of the flat file. Any queries to that table is sent with SOAP messages to a server that puts the query in a distributed message queue. An outsourced worker reads that message, types in the SQL query and faxes the answer to my fax machine, that happens to be placed on a wooden table.
Admin
The user interface, SQL Server Managment Studio Express, is free too.
Admin
You better think again
Admin
I agree. And don't forget that "Server" uses a capitalized S, that also implies a noun.
Admin
FREE BEER!!
Admin
I consulted at a large telecom, which had an Oracle site license, so they could install Oracle anywhere in the company and it incurred no additional costs. That lead to an Oracle everywhere philosophy and vendors that used Oracle were heavily favored. My guess is that your product may have been sold to that particular telecom.
Admin
You're an idiot. We all know we are talking about Microsoft SQL Server and not MySQL or anything else when someone says "SQL Server" Apparently you are the only one having trouble with that.
Admin
Related to specific project: Not overhead. Not related to specific project: Overhead.
I think you can see how this might be a slightly more functional approach, unless you're taking the contract bridge approach to financial management.
There's a difference between "sometimes" and "unconditionally;" illustrated, in this case, by the assertion that the tactic worked. I guess we all basically have three choices: (a) Try it anyway, because it's "sometimes" the right thing to do. (b) Move to a less horrible part of the world. (c) Ignore (a) and (b), and wear your Total Wuss badge with pride.It probably helps if, like snoofle, you're somewhere helpful up the hierarchy and have enough history with various bosses to increase the chances of (a) working.
Admin
I have a wooden table that I use as a database... I carve records into it with a router and clear data with a belt-sander. That's how real programmers do it...
Admin
Feh.
At $ORKPLACE-3, the boss told a client that some techs would bring his printer to the office to fix it. No tech was available so I (project leader) was sent to pick it up.
On the premises, I saw what the problem was: an optical sensor blocked by a piece of paper. So I removed it and fixed it on the spot in less than 5 minutes.
Of course the client was pleased to have his printer back immediately.
Not the big boss, though, who lambasted me over my own boss for “not keeping to our word — what will the client think of us if we can’t keep our [my] promises???”.
Admin
Probably the same thing that happens if the Oracle server goes down while real time records are streaming by...
You can never totally eliminate failures. You just manage risk.
Admin
Sugar dissolved in water is also a solution.
Admin
Oracle is better because it has more configuration options - currently about eighty bazillion of them, and if you get all of them set correctly (for your application) then it will be marginally more efficient.
Admin
The concept that, with effectively zero latency on an in-memory queue, you are far less likely to lose data than by relying on a transactional system (that, in its lower layers, depends upon exactly the same techniques), is lost on these morons.
Apparently, it's lost on snoofle too. Which is sad, because he normally makes sense. Perhaps over-reliance on databases causes premature senility.
Admin
Better tell that to gnu: To quote from gnu.org: <quote> SQL Server is a free portable multiuser relatational database management system. It supports the full SQL89 dialect and has some extensions from SQL92. It provides multiuser access and transaction isolation based on predicative locks. The working OS: UNIX. The working language: C . It also uses RPC, shared memory and message queues. </quote>
While it is not normal, some people do referer to their MySql/PostgreSQL/SysDB/Oracle as simple "SQL server"
Admin
Re overhead and all that...things are rarely pure.
Example: If I make and sell widgets at retail for a single fixed price my support staff may be considered "overhead". After all, they don't produce the product and if the product was perfect they wouldn't be necessary. If I start charging an hourly rate for support those same people, doing the same jobs, are now producing revenue and are not overhead.
Flip side: If I have a successful product fully deployed, and no expected need for an upgraded or enhanced version of that product, keeping SW developers on the payroll can be pure overhead.
Beyond that I'll just say that the vacation thing was highly unprofessional. If you can't explain your value to your employer using reason and logic you should move on.
Admin
Just create a table called dual2. But here's the tricky part. Instead of one column and one row, make it TWO rows and TWO columns. Dummy and Dummy2.
Handle that cost based optimizer!
Admin
Oracle doesn't require Windows to run.
Also locks are not precious commodities like they are in SQL Server (aka writers don't block readers in Oracle). Transactions take as long as they need, and other sessions are not blocked while someone updates the tables. In my opinion this is one of the single best reasons to stay far away from MS.
Admin
Besides from ethylene glycol (never mind that base could also be propylene glycol), antifreeze contains corrosion protection additives. It has specific pH. Aluminum engines and radiators require different additives than brass radiators. Those who were using orange antifreeze, learned it the hard way, when the cooling system got clogged and engine failed.
Admin
P.S. What MySQL do you use? The one from Microsoft?
Admin
Yeah, and I'm sure MS is still pissed that Oracle was able to brand it's database as Oracle x. Even if most people imply 'Microsoft Sql Server' when they say Sql Server, you sure get far more ambiguous google results if you only refer to it as 'Sql Server'
I have a pet hate for co-opting everyday words for software unless it's well and truly obscure.
I prefer referring to aforementioned SQL software as MSSQL as it's shorter to type.
Admin
So ambiguous that the whole first page of Google is about Microsoft SQL Server. I am not defending MS for usurping a word such as "server" but I am more annoyed by people who refer to other database products as "SQL server" because they don't know it is a brand. In my opinion if you have not heard about MS SQL Server you should not talk about databases at all. You can hate it but you should be aware about it before talking about database products.
Admin
Wow dude, that is WAY too cool if you ask me. Pretty neat stuff.
Jt www.Ultimate-Anonymity.com
Admin
If you have an application with a small dataset but high performance requirements, and a large budget that requires you to somehow "use Oracle" in there like the OP, take a look at the Oracle TimesTen in-memory database. Its a real screamer, though not cheap. As long as you can fit your entire database in memory, you're set.
Admin
Wouldn't using locking hints in the queries solve that issue? In most cases, I don't think I would want to read a record while it was in the middle of a transaction.
Admin
Quote button is there for a reason...anyway:
Wouldn't using locking hints in the queries solve that issue? In most cases, I don't think I would want to read a record while it was involved in a running transaction.
Admin
Why do people assume Oracle is the best? Because people that don't understand make the decisions, and they think in terms of "Bad" "Good" "Best" - so Oracle simply makes sure they are perceived as the best (mostly with high cost more than functionality).
Admin
So that the prophesy may come true.
I have a wooden table right here that is holding the contents of multiple flat files.
Victory Lap
Admin
Admin
The Free Online Dictionary gets more specific: The operating expenses of a business, including the costs of rent, utilities, interior decoration, and taxes, exclusive of labor and materials.
Neither matches your formula above, since one is inclusive and the other exclusive. However, let's go with that formula. How much time each day is actually spent doing work related to a specific project? Speaking for myself, I would say on average about five. The rest is spent in team meetings, departmental meetings, meetings of various company-sponsored committees for which I've volunteered, birthday celebrations, doing research, studying, using the restroom, reading TDWTF, reading and answering email, consulting with teammates, and other generalities. I don't smoke, but for those who do, factor in a smoke break of five to 15 minutes' duration at least twice per day; more often if they can get away with it.
So for about three hours per day, by your formula, a developer is overhead.
Admin
You are an idiot. Please stop talking.
Admin
This is hugely simplistic and broad. By this definition, EVERYTHING in business could be considered to be an overhead.
Overhead is, more specifically, those costs incurred by a business which cannot be attributed directly to the output of a product.
Electricity is a simple example of an overhead. HOWEVER, if a company produces only one product, electricity is NOT considered overhead. Why? Because the electricity used in the production of this product CAN be directly attributable to the costs of creating that product. It becomes part of the production costs of the product.
"Overhead" is really just a way to make cost accounting easier and more practical. Once the business starts making two products, it is infeasible and frankly not worthwhile to start metering the amount of kilowatt hours spent on making each product. Instead, estimates are used.
It is hard to attribute the amount of electricity that went into making each product, so its' treated as an overhead. There are ways of assigning estimated proportions of overhead to each product, but that's beside the point here - it's still overhead.
Same from above applies. If the business produces only one product, none of these are overheads. It is easy to directly attribute each of these costs to the production of that one unit.
This is a bit tricker, but the real question is - does it help the accounting process to go into this much detail? The answer is most certainly no, and it would be impossible to do anyway.
You can charge employees times between different projects - eg one project for 5 hours and another in 3 hours - but you wouldn't go down to the level "well this is a meeting, so its overhead.. but the other time he wrote some code, so it's a production cost". You'd say they were production costs and be done with it.
Admin
Not only is it not normal, it's wrong. "SQL Server" is a registered trademark of Microsoft. Their database product is called "Microsoft® SQL Server®". Sybase's product is called "Sybase® Adaptive Server®". Oracle's product is called "Oracle® Database", probably because the word "database" is too generic to trademark.
All part of Microsoft's annoying habit of trademarking the generic term (their active server pages product is called Active Server Pages, their reporting services product is called Reporting Services, etc).
To the "Is Oracle better than SQL Server" argument: Verizon are running a 7.7 TB database in Microsoft SQL Server. Some anonymous company is running a 6.8 TB database in Sybase Adaptive Server Enterprise. Elsevier are running a 9.6 TB database in Oracle RAC. The Land Registry for England and Wales are running a 23 TB database in IBM DB2. None of these database products are toys.
Some of these high numbers, as well as the high numbers at the Transaction Processing performance Countil, are running on Windows. Some are running on flavours of Linux. Some are running on Solaris. None of these operating systems are toys.
B
Source: Winter Corporation "2005 Winter TopTen Award Winners" (www.wintercorp.com).
Admin
I agree. Oracle is very sophisticated and is good for many things, but I find that many people buy it when SQL would have sufficed or PostgreSQL. heck, even MySQL would have worked. In other cases, I have seen massive DW's built on Oracle and they used none of the DB features like bitmap indexes, dimensions, partitioning, materialized views, and Oracle OLAP etc... they had no idea how to design it or use those features to allow it to scale.
If you are going to pay for Oracle, make damn sure you need it, and if you do, make sure you use the right feature to solve the problem!
Admin
just as Lotus Notes is the "best" email program for corporate use.
Admin
I predict a humorous comment involving "wooden" and "hard on".
Admin
Actually Sybase has the guiness world record:
http://www.sybase.com/detail?id=1056945
1 PByte
Admin
The real WTF is not storing the CDRs. In some (maybe all) jurisdictions that is like throwing away money if the customer ever decided to dispute the bill.
Admin
But there is a significant difference between someone knowing a little about a product and its function (oils) than someone just parroting keywords (oracle).
One of my good mates was a mechanic by trade and employed for someone else at the time - the place switched from using Mobil-1 as their default shop oil to a Caltex oil - this was motivated by money (better deal from Caltex than Mobil) as any mechanic would be - to make a profit. However oils are formulated differently - several high kilometre engines began smoking before their next service intervals in part due to the difference in effectiveness of the detergents used in the oils (cleaning soot built on on the bores of the engines allowing oil to get past the rings and thus smoke to come out the exhaust).
My point here is that your analogy is crap. Oils vary quite significantly in make up, tolerance to heat (impacts service intervals) and are something that you should be aware of and they are all made differently and you should check (and chastise if necessary) your mechanic's choice of oil.
Admin
I see that the same as if you used Sql server and your client googled sql server vs oracle chastise you for not using oracle
Admin
Err, no. Overhead are all costs that are not directly linked to turning a profit. A in-house programmer working for an hotel might be considered overhead, a programmer working for a progamming firm most certainly isn't overhead.
Admin
Not its not! Its Compact Disc Recordable!
Admin
create table wooden (<column><type>....) go
Admin
Admin
Admin
Oh yeah. And just what brand of wrench do you insist on?
Admin
Admin
True
Admin
Admin
Oracle uses versioning. If you read from a table that is updated by someone else but not yet commited, your query will return the old values from before the update.