473,236 Members | 1,718 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,236 software developers and data experts.

Basic design question for a distributed application - How to access application's data

JB
Hi All,

I need to write my first "distributed" application and due to my lack
of knowledge and experience in that area, I'm stuck on the first big
design decision. Reading a lot on distributed applications, remoting,
etc didn't help me much for that particular issue.

The main data the application manipulates is a list of Queries. A
query is a custom object containing an SQL statement and some
parameters to allow the query to run (e.g. DB connection params,
etc).
My server is where my list of queries will reside. It will be a
windows service as it needs to run permanently.
My client will display that list of queries and enable the user to
add, delete and modify the queries in the list. The client will also
initiate the running of all the queries (i.e. tell the server to run
all the queries sequentially).
What would be the recommended design as far as the list of queries is
concerned:

- A "shared" style where my list of queries on the server is accessed
(by reference) and modified by the client. i.e. from the client I
would do something like:
QueryRef = Server.List(3) 'Get a reference on the 3rd Query in the
list
QueryRef.SQL = "Select * from TABLE1" 'Directly modify the reference
i.e. the Query itself
And how can that be implemented in .Net with VB or even C#?

- A "message" style where my list of queries on the server will not be
accessed directly but through some sort of Get/Set messages like:
QueryCopy = Server.GetQuery(3) 'Get a copy of the 3rd Query locally in
my client
QueryCopy.SQL = "Select * from TABLE1" 'Modify the copy of the Query
Server.SetQuery(3, QueryCopy) 'Send the changes to the server

- Or is there a better type of design?

If anybody could shed some light over this or point me to a good
source of information, I would greatly appreciate it.

Thanks & Regards
JB

Aug 30 '07 #1
4 1639
JB <jb*********@gmail.comwrote in news:1188496386.258493.51480
@y42g2000hsy.googlegroups.com:
Or is there a better type of design?
Do you queries change a lot ... or are they static?

Passing the query to the client introduces a lot of security issues -
basically someone could issue a DELETE FORM TABLE and you'll be in hot
water ;-)

Have you considered web services too?
Aug 30 '07 #2
JB
On 30 Aug, 19:46, Spam Catcher <spamhoney...@rogers.comwrote:
JB <jb.bross...@gmail.comwrote in news:1188496386.258493.51480
@y42g2000hsy.googlegroups.com:
Or is there a better type of design?

Do you queries change a lot ... or are they static?

Passing the query to the client introduces a lot of security issues -
basically someone could issue a DELETE FORM TABLE and you'll be in hot
water ;-)

Have you considered web services too?
The queries won't change much once they're created on the client and
run a couple of times for testing.
Also it's a simple application so security is not the prime concern.
I haven't really considered web services as the client and server will
reside on the same network/same platform.
Aug 31 '07 #3

I would just store the query`s in a database and use notification services
to the service to synchonize the changed query strings

1 . A RDBMS ( SQL 2005 ) with a database with a table MyQuery`s
and columns like QueryId ( GUID ) | QueryString

2. the service loads on start the dataset with the query`s , and gets
notified by notification services when on of the query`s changes and reloads
the new versions

3. Client program wich can send commands to the service ( through
remoting ) , and can manipulate the dataset with querys in the RDBMS

just a thought :-)


HTH

Michel


"JB" <jb*********@gmail.comschreef in bericht
news:11*********************@y42g2000hsy.googlegro ups.com...
Hi All,

I need to write my first "distributed" application and due to my lack
of knowledge and experience in that area, I'm stuck on the first big
design decision. Reading a lot on distributed applications, remoting,
etc didn't help me much for that particular issue.

The main data the application manipulates is a list of Queries. A
query is a custom object containing an SQL statement and some
parameters to allow the query to run (e.g. DB connection params,
etc).
My server is where my list of queries will reside. It will be a
windows service as it needs to run permanently.
My client will display that list of queries and enable the user to
add, delete and modify the queries in the list. The client will also
initiate the running of all the queries (i.e. tell the server to run
all the queries sequentially).
What would be the recommended design as far as the list of queries is
concerned:

- A "shared" style where my list of queries on the server is accessed
(by reference) and modified by the client. i.e. from the client I
would do something like:
QueryRef = Server.List(3) 'Get a reference on the 3rd Query in the
list
QueryRef.SQL = "Select * from TABLE1" 'Directly modify the reference
i.e. the Query itself
And how can that be implemented in .Net with VB or even C#?

- A "message" style where my list of queries on the server will not be
accessed directly but through some sort of Get/Set messages like:
QueryCopy = Server.GetQuery(3) 'Get a copy of the 3rd Query locally in
my client
QueryCopy.SQL = "Select * from TABLE1" 'Modify the copy of the Query
Server.SetQuery(3, QueryCopy) 'Send the changes to the server

- Or is there a better type of design?

If anybody could shed some light over this or point me to a good
source of information, I would greatly appreciate it.

Thanks & Regards
JB

Aug 31 '07 #4
JB <jb*********@gmail.comwrote in news:1188545918.691006.240760
@z24g2000prh.googlegroups.com:
I haven't really considered web services as the client and server will
reside on the same network/same platform.
Web services is much simplier than remoting to implement. Also using web
services should have no bearing if it's a local or remote application ...
it's great for building SOA (service oriented architecture) applications.

Remoting is good too - but it depends on the type of data you're planning
to transfer.
Aug 31 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Rob S | last post by:
I have UDB 8.1 Personal Edition installed. I'm using Development centre to develop JAVA Stored Procedues. I am unable to debug them. I have installed IBM Distributed Debugger and have set...
50
by: Jay Balapa | last post by:
Hello, Currently my application has three tiers- 1. Presentation Layer (Asp.Net / Win Forms/ Pocket PC UI.) This predominantly contains User Controls, Custom Controls and Win/Web Forms. I...
14
by: Steve | last post by:
Sorry in advance for my ignorance. Any help would sure be appreciated. I'm writing a fairly simple application with VB.Net and am obviously a bit of a newbie. This application will be used by 1,...
13
by: Robin Haswell | last post by:
Hey people I'm an experience PHP programmer who's been writing python for a couple of weeks now. I'm writing quite a large application which I've decided to break down in to lots of modules...
2
by: ozcankanbur | last post by:
How can I run an asp.net project on distributed servers? (WEB SERVER / APPLICATION SERVER / DATABASE SERVER) My asp.net project runs with ui.dll,biz.dll and data.dll so you know all the assemblies...
20
by: Brad Pears | last post by:
I am completely new to vb .net. I am using visual Studio 2005 to redo an Access 2000 application into a .net OO application using SQL Server 2000 - so a complete rewrite and re-thinking of how...
8
by: Chris Asaipillai | last post by:
Hi there I have some questions for those experienced Visual Basic 6 programmers out there who have made the transition from VB6 to Vb.net. How long did it take you to learn at least the basic...
4
by: dgleeson3 | last post by:
Hello all I am creating a VB.Net distributed SQL server 2005 application. Each computer in the system has a database with a table of users and their telephone numbers. Each computer has a...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.