Please help me with my research problem [modified]
-
Hello guys. First up, please know that it has been almost a decade since I have been anywhere close to a database, be it at work or outside. Anyway I never did anything substantial there except have a table and read/write data. So go easy on flaming if this turned out to be a n00b question or suchlike. I have to model/analyze some data for some research and I need your help to see how I can go about that. First some definitions 1. There is a set called S subscripted with n that I write as Sn where 1 <= n <= 100 2. Every Sn (i.e S for all n) is a subset of a larger set called US 3. None of the Sn is intersecting 4. It should be possible to name every Sn Now the problem 1. I have An and Bn which have one to one mapping 2. I have Cn that has many to one mapping with Bn (each element of Bn maps to one or more elements of Cn) 3. There are also other sets like Dn, En, Fn etc that have one to one mapping with Bn only and are unrelated to any other set directly I want to be able to do these 1. Given any element from UA, the relevant An (the set) must be got. If An exists, then the corresponding Bn element must be got 2. Similarly, given any element from UB, the relevant Bn must be got. If Bn exists, either from this step or step (1), all the corresponding Cn must be got along with the corresponding ones from Dn, En, Fn etc (the sets that must be considered will be told ) 3. Alternatively, any Sn must be extracted by name and all the relations for all its elements must got (i.e if An then Bn as per (2), if others then Bn only) [EDIT] Some stats - Each set will have at most 500 elements and the super set will have at most 2000. And the set count may be at most 100*50=5000 in all. I will be having an app for the front end that will do the creating, editing and querying of the database. I will be using MS Access for the backend as it is kinda “free” and already there. I will refresh on my SQL commands as I know that it will be necessary for interacting programmatically. So can you guys please help me? I need broad ideas like designing it etc more than the "code" itself. I wouldn’t mind if you suggest any other “free” databases that can make my solution simpler. I suppose using ODBC or DAO (that’s what I last remember) is going to act as a black box and I can use any dbase. And oh, I don’t know .NET. Will it be a chore then? Feel free to ask me back anything about my problem that you couldn’t understand. Thanks for your time.
...by
-
Hello guys. First up, please know that it has been almost a decade since I have been anywhere close to a database, be it at work or outside. Anyway I never did anything substantial there except have a table and read/write data. So go easy on flaming if this turned out to be a n00b question or suchlike. I have to model/analyze some data for some research and I need your help to see how I can go about that. First some definitions 1. There is a set called S subscripted with n that I write as Sn where 1 <= n <= 100 2. Every Sn (i.e S for all n) is a subset of a larger set called US 3. None of the Sn is intersecting 4. It should be possible to name every Sn Now the problem 1. I have An and Bn which have one to one mapping 2. I have Cn that has many to one mapping with Bn (each element of Bn maps to one or more elements of Cn) 3. There are also other sets like Dn, En, Fn etc that have one to one mapping with Bn only and are unrelated to any other set directly I want to be able to do these 1. Given any element from UA, the relevant An (the set) must be got. If An exists, then the corresponding Bn element must be got 2. Similarly, given any element from UB, the relevant Bn must be got. If Bn exists, either from this step or step (1), all the corresponding Cn must be got along with the corresponding ones from Dn, En, Fn etc (the sets that must be considered will be told ) 3. Alternatively, any Sn must be extracted by name and all the relations for all its elements must got (i.e if An then Bn as per (2), if others then Bn only) [EDIT] Some stats - Each set will have at most 500 elements and the super set will have at most 2000. And the set count may be at most 100*50=5000 in all. I will be having an app for the front end that will do the creating, editing and querying of the database. I will be using MS Access for the backend as it is kinda “free” and already there. I will refresh on my SQL commands as I know that it will be necessary for interacting programmatically. So can you guys please help me? I need broad ideas like designing it etc more than the "code" itself. I wouldn’t mind if you suggest any other “free” databases that can make my solution simpler. I suppose using ODBC or DAO (that’s what I last remember) is going to act as a black box and I can use any dbase. And oh, I don’t know .NET. Will it be a chore then? Feel free to ask me back anything about my problem that you couldn’t understand. Thanks for your time.
...by
It sounds like your dataset is not that large, so storing the data in Access sounds fine. You will be amazed at how easy it is to develop queries in Access to get the results you need, if you find the data to be too large or you need to share this database with others, you may have to upgrade to something more substantial, ie MS-SQL. Start with Access, it should give you enough to prototype with ... maybe even solve your problem completely. Good luck. :thumbsup:
-
It sounds like your dataset is not that large, so storing the data in Access sounds fine. You will be amazed at how easy it is to develop queries in Access to get the results you need, if you find the data to be too large or you need to share this database with others, you may have to upgrade to something more substantial, ie MS-SQL. Start with Access, it should give you enough to prototype with ... maybe even solve your problem completely. Good luck. :thumbsup:
Thanks for your response. I think each set will have at most 500 elements and the super set will have at most 2000. And the set count may be about 100 in all. So I might be able to use Access. Could you please give some pointers on the design? Some brief thing about tables etc will surely help me.
...byte till it megahertz... my donation to web rubbish