|
Why don't you look at providing a Many:Many relationship between the songs and artists. Ok, sure this is best performed back in the data, but you can then easily place a "LINK" class between the Songs and Artists. That way you don't have a true circular reference but you will reap the benefits.
Songs (1) ---> (M) SongArtistLink (M) <--- (1) Artists
I'm using this approach in our own in-house solution on a number of various entities. In the songs class, add a Readonly Artists property which references the "LINK" class. In the artists class, add a Readonly Songs property which references the "LINK" class.
We've seen no perceived or measurable performance penalties using this approach and because the link is done in "data" you can then query the data at any time using any of the available tools.
Hope this helps.
Edward Steward
edwardsteward@optusnet.com.au
|
|
|
|
|
Thanks, I had been considering this, and I think that it provides the most flexible solution and models the relationship correctly, artist is no more part of the song than say driver is of a car, they just have a loose relationship which is best modelled as that.
Thanks again,
Richard
|
|
|
|
|
Cool. The best thing I like about a M:M relationship (link table) is that is easy to replicate that model out to other entities. i.e. Songs & Albums, Artists and genres, etc.
One of the things that I quite enjoy is the fact that I can use a single link table for multiple relationships. This is because we use a GUID as a primary key due to our replication needs.
Edward Steward
edwardsteward@optusnet.com.au
|
|
|
|
|
I have an object model in line with GOF Composite pattern. The database has 2 tables presently. One to store the component(composite or primitive) and the other to store association/relationship. Looking some direction/advice on how to go about loading the composite from database. Thanks.
|
|
|
|
|
See if this[^] helps you get started
|
|
|
|
|
|
I'm in need of a little push in the right direction and I'm hoping some experts on this forum can help in getting me going in that direction.
I would like to develop a cross-platform application which would run as a client-program only but has the potential of running as a client-server program.
The application is basically a game application that needs a database-layer, an application layer, and a GUI layer.
The requirements are the following: Cross platform a must. Intuitive GUI. Easy access to Database so user can make whatever changes are necessary. Separate layers so that work can be done on one layer and not effect another.
When it came to the GUI layer I would like to use WxPython for the GUI. In researching this product it does exactly the things the application design requires however does WxPython interface with C++? C#? How does it interface? Sockets? Events? The answers here will determine how the logic layer will be built.
Also not sure which Database to use. I'm comfortable with SQL databases but again, the database must be cross-platform compatible (if that makes a difference anyways with the database). Perhaps XML would work better. Last attempt with XML proved to be slow but was using Java as the logic layer. Could have something to do with it, maybe not.
I will continue to browse through the articles here to see if anything can be of help, but for those who are far more experienced in this stuff, if you have general information that could help I would be much appreciative.
Thanks for any help! 
|
|
|
|
|
brdavid wrote: The application is basically a game application
brdavid wrote: Cross platform a must.
What platforms? Nintendo? WII? PlayStation.....?
That's a tall order and I am not sure apps for Games use a Database so where does that requirement come from?
brdavid wrote: I will continue to browse through the articles here to see if anything can be of help, but for those who are far more experienced in this stuff, if you have general information that could help I would be much appreciative.
I suggest you seek out more Gaming specific information sources.
|
|
|
|
|
led mike wrote: What platforms? Nintendo? WII? PlayStation.....?
Windows XP/2000 possibly Vista
Mac OSX
Linux (popular distros such as Ubunto)
Perhaps the use of the word "game" is misleading. This is a Windows "type" application that revolves around a "roleplaying" game. The application does nothing more than automate tasks, print sheets, calculate numbers, run random generators, update the database, run queries from the database and so on. So this is pretty much a standard application, and less of a "game".
|
|
|
|
|
brdavid wrote: The application is basically a game application that needs a database-layer, an application layer, and a GUI layer.
Cross-platform for what ? the database layer, the application layer or the GUI layer ?
anyway, doing cross-platform development is a challenge, you need to do the following, have at least an expert for each type of platform you want to develop on; these people will help you write platform specific code and help you create an abstraction layer between your "engine" and the different platforms.
For example, file access, graphics, DB, ...
For the GUI part, you can use a toolkit that is supported by all platforms, the upside is that it can be faster to develop, but your application will look ugly on all platforms, those kind of toolkit usually do not support native look-and-feel.
|
|
|
|
|
True, but I guess my main area of interest right now is if anyone knows of any leads where WxPython and C++ and a database are used either in a multi-tier application or perhaps single tier.
Thanks!
|
|
|
|
|
How about FireBird[^] for the database layer, that's cross-platform and allows you to use SQL. It has interfaces for Mono & MS.NET as well as C, C++ etc. The upper language choices are really a matter of preference.
|
|
|
|
|
hi everybody,
Iam new to design pattern concept , I want to know in which scenario we are using singleton pattern in our appl.
I need exact scenario because i had some examples and gone the theory in books
i want applicable knowledge in application development.
Thanks in advance for replay,
|
|
|
|
|
Hi shakeela,
one of the case you can use singleton pattern is to create a connection for your data base application.
satyaki mishra
|
|
|
|
|
satyaki mishra wrote: one of the case you can use singleton pattern is to create a connection for your data base application.
I don't believe that statement is particualrly helpful
|
|
|
|
|
And it's quite controversial use.
[ My Blog] "Visual studio desperately needs some performance improvements. It is sometimes almost as slow as eclipse." - Rüdiger Klaehn "Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe
|
|
|
|
|
dnh wrote: And it's quite controversial use.
What use? His post is completely absent any use model, or any other contextual references, and therefore not helpful.
|
|
|
|
|
"one of the case you can use singleton pattern is to create a connection for your data base application."
Ok, if I was asking about singletons this wouldn't help me. In that I agree with you. But I believe that he is talking about scenario when you have class that manages connection to db, and creates connection in constructor. If that class is singleton, only one instance is created, so only one connection is created (which is usually very expensive operation). But then there's a pooling and you will have connection opened for whole lifetime of the singleton object, sometime you'll connect to db even when you don't need to etc. Which is why I say this is not the supercleanest use of singleton pattern.
[ My Blog] "Visual studio desperately needs some performance improvements. It is sometimes almost as slow as eclipse." - Rüdiger Klaehn "Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe
|
|
|
|
|
dnh wrote: Which is why I say this is not the supercleanest use of singleton pattern.
It's a perfectly fine design when the use model is a single user desktop application connecting to a desktop database. Your post also lacks specific use model information required to draw any conclusion as to the accuracy of your statement.
|
|
|
|
|
led mike wrote: It's a perfectly fine design when
Isn't that little word "when", and what follows it, proving my point? (but then again, I've just came from work  )
[ My Blog] "Visual studio desperately needs some performance improvements. It is sometimes almost as slow as eclipse." - Rüdiger Klaehn "Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe
|
|
|
|
|
shakeela wrote: i want applicable knowledge in application development.
That is "experience" and we can't give that to you.
|
|
|
|
|
shakeela wrote: I want to know in which scenario we are using singleton pattern
When dumped by ones girlfriend or significant other.
|
|
|
|
|
shakeela wrote: I want to know in which scenario we are using singleton pattern in our appl
Here is one scenario[^]
But, my plans for this series will remove the singleton pattern later.
|
|
|
|
|
I consider singletons as evil!
If there has to exist really one one instance of a class then I use a manager pattern (don't know if this patter has a real pattern name):
I request the "singleton" from a Manager that will return me the instance. Depending on configuration and other things it will return me a singleton or a new instance. Furthermore I request interfaces which allows the replacement of "singletons" either for testing (mocks) or changed requirements or if it is a base functionality that is used in different projects.
Much more flexible.
-^-^-^-^-^-
no risk no funk ................... please vote ------>
|
|
|
|
|
Sounds like you are using the Factory Pattern to generate the singleton.
Urs Enzler wrote: Furthermore I request interfaces which allows the replacement of "singletons" either for testing (mocks)
Very useful for that.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
