|
Thanks for the info, Eddy.
So, I think I understand.
a) using a db with server capability is what front-end/back-end means. They are independent and have to talk to one another (using tools like ADO.NET and LINQ to SQL?)
b) there can be multiple clients that connect to a back-end, which is a db with server capabilities
c) the db's server ability handles the read, write, change, etc calls from a front-end and sends back whatever is asked for
d) if I want to allow more than one PC to connect to the same db, I need a db with server capability
Is that right?
I'm guessing that choosing a server-capable db means more complicated coding of the program, but would it also mean more difficult deployment (for me) or installation (for the end users), or are there other negatives?
Is there any worth to using serverless now (for ease) but coding in such a way that transitioning to server-capable later isn't too bad?
Thanks for the link. It's bookmarked and I'll be spending hours there it looks like.
Eddy Vluggen wrote: It means that this person probably doesn't like SQL Server.
He did recommend SQL Server Compact edition, but said that it is serverless. (I tried to confirm this at the MS website but couldn't tell either way) If they're coreect and I understand what you've said, this person must've overlooked that I would want to be able to have multiple clients.
modified on Saturday, July 25, 2009 2:16 PM
|
|
|
|
|
copec wrote: a) using a db with server capability is where the concept of front-end/back-end comes from
b) there can be multiple clients that connect to a back-end, which is a db with server capabilities
c) the db's server ability handles the read, write, change, etc calls from a front-end and sends back whatever is asked for
I don't know if that's the origin of the word, but this is indeed, broadly, what a database does.
copec wrote: d) if I want to allow more than one PC to connect to the same db, I need a db with server capability
In general, yes 
copec wrote: I'm guessing that choosing a server-capable db means more complicated coding of the program, but would it also mean more difficult deployment (for me) or installation (for the end users), or are there other negatives?
There are several variables. One thing to consider is that a server is an actual application that is "always" running when the computer is powered on. That can be a bit of a performance-impact. I haven't written much installation-scripts lately, but I guess that it's as easy to install as the .NET Framework itself, just ticking the box being a prerequisite.
The central question should be whether you need a database-server (as a shared data-repository) or a local datastore (a private data-repository)
Microsoft Access has a friendly interface, and is often abused as a server. You'll find lots of rants on Access, because it's widely used. Best thing of all is that there's an upsize-wizard that upsizes the tables of your Access-database to SQL Express/Server, once you're in need of such a migration.
|
|
|
|
|
Thanks again Eddy.
Eddy Vluggen wrote: The central question should be whether you need a database-server (as a shared data-repository) or a local datastore (a private data-repository)
For now, for sure, I will only need a local datastore, but I can see that I would like to be able to (later) add the ability to have multiple client front-ends for one the datastore. Can I develop the first version in such a way that I allow myself the ability to later "plug in" multi-client ability with a minimum of rewriting, etc.?
|
|
|
|
|
copec wrote: Can I develop the first version in such a way that I allow myself the ability to later "plug in" multi-client ability with a minimum of rewriting, etc.?
Yes, hence the suggestion to start with a new project in Microsoft Access[^]. This is a local database that can easily be migrated[^] to it's bigger SQL-brother - moving the data to the server, and letting the reports fetch their data from there.
And you're welcome, off course
|
|
|
|
|
I must not have mentioned it already: I have had this db runnning in Access for over three years and have now decided to write it into a stand alone program. I'm researching and reading and trying to figure out what components and tools to use.
I've narrowed the language to VB.NET or C# with a WPF gui. I think the only main part left to narrow and decide is which SQL db to use. That's why I'm asking about the possibility/feasibility of using a local-only db for now but writing the program, etc, in preparation for the multi-client capable db later.
Are you saying that I can use any serverless SQL-style db (including Access) now and it won't take too much coding to transition and add the multi-client ability later?
Thanks again.
|
|
|
|
|
copec wrote: Are you saying that I can use any serverless SQL-style db (including Access) now and it won't take too much coding to transition and add the multi-client ability later?
Not quite; it's not as simple as throwing a switch. It is, however, quite easy to upsize. That wizard makes it a few-clicks operation to migrate your data to SQL.
The way you'd talk to them is also very similar. When you want data from Microsoft Access, you'd typical run a query over a connection to fetch that data. With SQL Express/Server, you'd also run a SQL-query over a Connection to fetch data. In both cases you'd be using a Connection-object to connect to the database, running a query and reading the results.
The main difference is that Access is specialized in fetching/updating the data in a local database, or at least with not all-too-much clients. SQL Express is the larger brother, living on a server, always present while the computer runs, ready to update it's datastore
Just introduced to 'Southern Comfort'
modified on Saturday, July 25, 2009 8:58 PM (not GMT?)
|
|
|
|
|
Thanks.
Given the similarity, does that mean that while I code the first version it's not worth concerning myself with the later addition of multi-client capability?
|
|
|
|
|
I wouldn't state it like that, but that's what a lot of people did. Many of them started out with the combination Access/VB6 and have moved to SQL Server/C# in the meantime.
Reading from the datastore will be roughly the same, but you might run into a concurrency-problem once a lot of people start meddling around with the data. You'd have to decide what happens when "user one" is changing the countryname of the Northpole to "New Southpole" and "user two" is (at the same time) changing this name to "Old Northpole".
That's rather a logical problem that you'll encounter with any database. Most of them provide locking-mechanisms, even Access (to some degree).
Some of the older applications have been converted to webapplications, utilizing ASP.NET/SQL (or PHP/MySQL). Those applications can often be used from every country, introducing differences in measurement (metric vs imperial), differences in the formatting of numbers and dates (and some locations on daylight saving time) and such.
copec wrote: does that mean that while I code the first version it's not worth concerning myself with the later addition of multi-client capability?
I'm not saying that it's not a concern, but that a lot of developers have faced these challenges before, and the problems that you're likely to encounter will probably be well-documented.
|
|
|
|
|
Ok, I won't worry too much, but I think I'll go ahead and use a db that works for both purposes.
As for the concurrency issue, I'm thinking to avoid the issue all together I would have it so that when a person tries to open the program, the program checks to see if anyone else already has it open anywhere else. If so, the program won't open and gives the person a message like "Program is open on another computer. Close the other instance and try again." I'll have to allow for stale lock data somehow though. But it totally does away with the concurrent editing problem.
|
|
|
|
|
copec wrote: If so, the program won't open and gives the person a message
That might be a bit frustrating for the user. Especially if they don't know for how long they have to wait.
copec wrote: it totally does away with the concurrent editing problem.
That's true
|
|
|
|
|
Eddy Vluggen wrote: Especially if they don't know for how long they have to wait.
The message would tell them that they have to wait until the other instance on the other computer is closed. It would be in their house, maybe the other instance is opened by their wife or husband.
Sounds ok, no?
|
|
|
|
|
copec wrote: It would be in their house, maybe the other instance is opened by their wife or husband.
Sounds ok, no?
The wife? Perhaps it's a good idea to put a password on it? 
Well, it wouldn't be as much a problem as it would be in a full office. It would be frustrating if there's "some" co-worker using it, blocking you. But that's less of a problem at home.
|
|
|
|
|
copec wrote: I would have it so that when a person tries to open the program, the program checks to see if anyone else already has it open anywhere else
How are you going to do that?
You would have to be able to check for what machines are attached to the network and for each machine check which processes it is running to see if it is running your program.
What would happen if two users on different machines simultaneously start your program?
This may not be a problem on a small home network, but if you go commercial it could be.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
riced wrote:
How are you going to do that?
Of course I don't know (yet, I hope), but I thought there would be some way the program could find out as it opens if the db was already opened by another instance of the program. Since it is a home-use app, it wouldn't be necessary to know which computer had it open, just that another one did.
Am I wrong about the feasibility/possiblity of this?
modified on Monday, July 27, 2009 2:29 PM
|
|
|
|
|
copec wrote: find out as it opens if the db was already opened by another instance of the program
For Access you could check for the existence of a .ldb file in the same directory as the .mdb. This would tell you that the db is in use (the .ldb is used by Access to control locking and removed when the last user closes the db).
For SQL Server I think you could query the master..syslogins table but I'm not absolutely certain. There may be easier ways to do this.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
|
Hi,
I am managing a large project which has mainly two parts. one ia an application being developed in JSF and Java and the other is a client server application in C#. At the end of the day the the project developed by JSF and Java will be using the second project. I don't have any idea how I can integrate the two so that they will work together. any body who can guide me in the design of the interface between the two projects and the technology I can use(if any)
|
|
|
|
|
The answer, as so often, is "It depends".
There are several options available: web services, commercial Java/.NET bridges, messaging queues (for example, MQ Series can exchange data between Java and .NET), data exchange over TCP sockets, or even something as simple and basic as a shared database.
The best option depends on your exact requirements and what you mean when you say that you want these applications to "work together".
There is plenty of information on Google about this for you to do your research and make a decision on the basis of your own requirements.
|
|
|
|
|
thanks, but let me make the thing more clear. the client application to be called by the web based application is to be windows forms application(for the sake of performance). in that case how can i use webservices? further, the web based application is to call the user interface of the client application, fill data and then wait for response.Actually, i am new to this area and may be writing simple things.
|
|
|
|
|
So, if I understand correctly:
You have a JSF web application. The user connects to this application, and then the web page they are currently viewing in the browser communicates with a .NET application running on the local machine to enter data directly into one of the forms, trigger some sort of functionality and receive some data back as a response.
If that is what you want, I think you may be out of luck. I don't think that you will be able to get a web page running in a browser to interact with a client desktop application in that way. I'm pretty sure the browser security will prevent that but there might be some way round it.
I did find this page which might be of help as it seems to be addressing the same problem:
http://stackoverflow.com/questions/126048/how-to-interact-between-web-app-and-windows-form-application[^]
|
|
|
|
|
Ok, what about using a smart client, will that work?
I think I should think of another architecture. I couldn't change the JSF web application. But I can try another means for the desktop client.
The client application is a biometric authentication application(uses face and fingerprint). The JSF web application uses this application for avoiding double registration in some system. there is also some data exchange between the two applications.
Can I develop it in ASP.net? I think it may be very slow as there is scanner and cammera interface and other computation.
Or what should i do?
The importtant thing is that the two projects should be deployed as one project(there should be some integration)
|
|
|
|
|
I am afraid, this is not going to work. From inside the web application you will not be able to access the client windows application and perform certain set of activities and data transaction. Where as the reverse is possible.
|
|
|
|
|
As a rule of thumb i would try to couple both projects as loose as possible. This makes that most future changes in one will not influence the other. So this leaves you with 2 questions for every way you can connect those projects:
1. Will it give you max. independance for both projects?
2. Gives the solution enough performance?
The technology that answers on both questions Yes is the one you're searching for...
Rozis
|
|
|
|
|
Please suggest for following issues for a web based application in ASP.NET 3.5:
1.
There is requirement for approx 10 to 20 million records entry in the database daily, or we can say that there would be around entry of 10 lakh records per table on daily basis. What would be the best Database Design, Model & Architecture in MySQL database. Need proper optimization for quick retrieval, insertion, updates & deletion. Also provide the hardware detail that would required to handle such a large database in long term.
2.
There is a scenario of inventory management of advertisements on daily basis, if there are 100,000 locations and user booked these locations for 1 year then I need to insert/update 100,000 x 365 = 36500000 records/rows in the table to maintain daily inventory. Please suggest better solution & table structures.
[Database Design, Model & Architecture for Large number of storage / insertion of records in MySQL]
|
|
|
|
|
It's part of the design. Consider this as an example;
If you have a Location-table like this;
Location Name
---------- -------
21 Floor
22 Cellar
23 Roofand a User-table;
Id Name
----- -----------
64 ajitsunny
66 E. Codd
67 Don Quichotte , with a Bookingstable like this;
Id BookedByUserId BookedLocationById BookingStart BookingEnd
----- ------------------- ---------------------- -------------- -----------
1 64 21 11.11.2011 12.11.2011
2 64 21 14.11.2011 16.11.2011
3 67 23 11.11.2011 13.11.2011
5 66 21 23.12.2012 31.12.2013
Then you can encode a booking with a single command, providing start and end-dates as parameters 
(e.g., like;)
INSERT
INTO Booking
VALUES ( 64, 21, '2011-11-11T00:00:00.000', '2011-11-12T00:00:00.000' )
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
