Unknown kinds of data sounds to me somewhat fishy. Your examples, of course, are all knowns. For goods and services careful analysis and normalization are important and I think you can get away from EAV modelling (which I think will cause mor problems than it solves) for core data. The rest co...
Dont use MySQL, a relational database is not used for the solution of this type of problem. Use a document or NoSQL database such as MongoDB or possibly RavenDB on windows.
Or alternatively use PostgreSQL.
If you have a base set of attributes you can build inheritance into your tables
create ta...
Some people go out of their way to create trouble :-P
Just to clarify that.... The only difference between synchronous_commit being on or off is that it waits for the standby to say it has committed before returning this to the client. If your answer to "the slave went down" is to turn replication off, you are getting nothing out of the additional guarantee that synchronous commit gives you, which is that once the commit is finished the data exists on at least x number of servers. You will have far fewer issues by simply not offering the guarantee in the first place than by offering it except when you don't. — Chris Travers36 mins ago
(Doing streaming replication and synchronous commit with only one backup server gives you failure anytime either system goes down....)
Ok, the cube is basically a stacked 2d array of of matrixes. A row is represented by products, and the columns by continent. Which means a x, y cell is the measure that relates to a product for that country. However, the third dimension.. the z axis represents time
So the matrix is organized (or stacked) by the time dimension
The first 2d matrix gives me all products per continent for the year 2000, the next 2001 etc..
well you have three dimensions so you have three one dimensional slices and three 2 dimensional slices, and the data could be aggregated in other interesting ways too
Maybe it would be helpful if we looked at how the data would probably be stored in a star schema?
The DBA side is tied in because we put a lot of weight on the db.
I think one of the things you will find is that working with databases exposes you to business problems in a way that, say, network engineering doesn't
Business being business decision making and management problems
networking may expose you to operational problems in the same way however O.o
(and then you get to learn enough to run your own business)
Most of it is nothing magic, but accounting is pretty technical. You can almost approach it like programming.
Most of it is just knowing when to ask questions
and in terms of avoiding it, a good place to start would be working for a web business where you are involved more in service delivery and less on the accounting side.
anyway I have to take off for a bit. If you need anything leave a message here and I will get to it when I get back
To trigger CAPTCHA while editing, asking, or answering:
The minimum window is 5 seconds
The maximum window is 40 minutes
There is a maximum of:
one edit every 30 seconds
one answer every 60 seconds
one question every 60 seconds
To trigger CAPTCHA while doing performing other actions, ther...
> There is a maximum of: > one answer every 60 seconds O'rly?
Please; stop adding unnecessary tags to questions. This just makes it look like you're doing it to get the badges. Myself and others will continue to remove them and roll them back if need be. Reference. — FreshPrinceOfSO18 hours ago
There are a number of tags for SQL key words. And I think that makes sense, mostly. However, many of those keywords are not very selective or descriptive by themselves as they are very common words. As SO grows, many of them are competing with other fields. I started editing a new tag wiki on sql...
@JNK I agree but the remaining ones are the few added by the questioners, one here and one there. The only user who has been consistently adding silly tags in all the questions he answers, is that guy. That is still obvious in the query tag: stackoverflow.com/tags/query/topusers
I am installing Oracle 11g so I can work through practice excerises. I am following the installation walkthrough at link.
In the terminal when I run chown -R oracle:oinstall database
I get Operation not permitted
How to I fix this so I can install the database?
Don't know why everybody try to re-implement the wheel, cause there is alreday a function
as answer here which give you :
SELECT o.OrderId, GREATEST(o.NegotiatedPrice, o.SuggestedPrice) FROM Order o
I didn't find any info when I bingled it but I might have missed it
I don't have 20k rep, yet today I noticed the delete option on a question.
I thought the vote to delete privilege doesn't start until 20k?
Dont use MySQL, a relational database is not used for the solution of this type of problem. Use a document or NoSQL database such as MongoDB or possibly RavenDB on windows.
Or alternatively use PostgreSQL.
If you have a base set of attributes you can build inheritance into your tables
create ta...
To trigger CAPTCHA while editing, asking, or answering:
The minimum window is 5 seconds
The maximum window is 40 minutes
There is a maximum of:
one edit every 30 seconds
one answer every 60 seconds
one question every 60 seconds
To trigger CAPTCHA while doing performing other actions, ther...
How to rollback all active transactions on Oracle DB?
I execute query and see 4 transcations in ACTIVE status.
SELECT *
FROM V$TRANSACTION
I am installing Oracle 11g so I can work through practice excerises. I am following the installation walkthrough at link.
In the terminal when I run chown -R oracle:oinstall database
I get Operation not permitted
How to I fix this so I can install the database?
Don't know why everybody try to re-implement the wheel, cause there is alreday a function
as answer here which give you :
SELECT o.OrderId, GREATEST(o.NegotiatedPrice, o.SuggestedPrice) FROM Order o
