Design and Architecture

cmf-DBA15-Nov-07 11:19

cmf-DBA

15-Nov-07 11:19

Hi there !

First all sorry about my little english. My native language is spanish.

Well, reading carefully your post, seems You must to add support for Managing Locking and Concurrency.

(Follows fragments were taken from the Microsoft Best Practices Series)

...

Managing Locking and Concurrency

Some applications take the “Last in Wins” approach when it comes to updating data in a database. With the “Last in Wins” approach, the database is updated, and no effort is made to compare updates against the original record, potentially overwriting any changes made by other users since the records were last refreshed. However, at times it is important for the application to determine if the data has been changed since it was initially read, before performing the update.

Data access logic components implement the code to manage locking and concurrency.

There are two ways to manage locking and concurrency:

Pessimistic concurrency. A user who reads a row with the intention of updating it establishes a lock on the row in the data source. No one else can change the row until the user releases the lock.

Optimistic concurrency. A user does not lock a row when reading it. Other users are free to access the row in the meantime. When a user wants to update a row, the application must determine whether another user has changed the row since it was read. Attempting to update a record that has already been changed causes a concurrency violation.

Using Pessimistic Concurrency

Pessimistic concurrency is primarily used in environments where there is heavy contention for data, and where the cost of protecting data through locks is less than the cost of rolling back transactions if concurrency conflicts occur. Pessimistic concurrency is best implemented when lock times will be short, as in programmatic processing of records.

Pessimistic concurrency requires a persistent connection to the database and is not a scalable option when users are interacting with data, because records might be locked for relatively large periods of time.

Using Optimistic Concurrency

Optimistic concurrency is appropriate in environments where there is low contention for data, or where read-only access to data is required.

Optimistic concurrency improves database performance by reducing the amount of locking required, thereby reducing the load on the database server.

Optimistic concurrency is used extensively in .NET to address the needs of mobile and disconnected applications, where locking data rows for prolonged periods of time would be infeasible. Also, maintaining record locks requires a persistent connection to the database server, which is not possible in disconnected applications.

Testing for Optimistic Concurrency Violations

There are several ways to test for optimistic concurrency violations:

Use distributed time stamps. Distributed time stamps are appropriate when
reconciliation is not required. Add a time stamp or version column to each table in the database. The time stamp column is returned with any query of the contents of the table. When an update is attempted, the time stamp value in the database is compared to the original time stamp value contained in the modified row. If the values match, the update is performed and the time stamp column is updated with the current time to reflect the update. If the values do not match, an optimistic concurrency violation has occurred.

(end MS Article)

I have used datetimes instead of time stamp or version columns.

My two cents.

Hope this helps a bit.

cmf a little DBA.

Simon P Stevens16-Nov-07 3:28

Simon P Stevens

16-Nov-07 3:28

cmf,

Thanks for that. Do you have a link to where thats from?

What I want to do is pessamistic locking. Optimistic locking is no good as it would be unacceptable for my users to lose their work if a Concurrency Violation occured when they tried to save.

That document says that pessamistic locking is not possible in a disconnected enviroment (like mine). Unfortunately, what I want is pessamistic locking in a disconnected enviroment! I think my idea of using an expiry time on the locks should work well enough for my requirements, as i know that allthough it's disconnected, it will never be a long loss of connection.

If anyone can think of better solutions though, I'm open to suggestions.

Simon

cmf-DBA16-Nov-07 9:24

cmf-DBA

16-Nov-07 9:24

Hi once again...

Sure You can take a look at

http://msdn2.microsoft.com/en-us/library/ms978496.aspx[^]

It´s from:

Building Distributed Applications
Designing Data Tier Components and Passing Data Through Tiers

Patterns & Practices

Also i found this one source would be interesting:

http://www.agiledata.org/essays/concurrencyControl.html[^]

I´m start reading also there to refresh some concepts...

I see also You need to manage an special lock on resources.

Take in mind that pessimistic locking affect scalability.

But perhaps the solution deserves it.

Hope thoose reading help a bit.

cmf.

a little DBA !

Simon P Stevens19-Nov-07 10:21

Simon P Stevens

19-Nov-07 10:21

Thanks for the help.

I've read those links now, and I've got a clearer understanding of how I can implement a solution that fits my requirements. They really helped.

Thanks a lot.

Simon

Wrapping Composite Controls

cmf-DBA20-Nov-07 3:17

cmf-DBA

20-Nov-07 3:17

Good, nice to heard that.

Tristan Rhodes14-Nov-07 3:12

14-Nov-07 3:12

HI Guys -

I'm working on an application that has a number of discrete sections to its user interface. These sections are defined in terms of what they display, what methods can be performed on them, and what events are raised.

Ideally, i'd like to put all the discrete sections into standalone controls, which can be dumped into the application shell and managed using an event driven observer model.

The problem i am facing is that in some instances i am using Trees, and i'm trying to achieve the following:

* Have a hierachial instance of objects that represent my data.
* Traverse and manipulate the data tree
* Keep the TreeViews synchronised with this data
* Hide the TreeViews / TreeNodes from any calling code (It's already wrapped in a composite control).

Are there any good patterns to do this? Has anyone encountered this kind of problem before, and have experience solving it?

Cheers

Tris

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

led mike15-Nov-07 4:45

led mike

15-Nov-07 4:45

Tristan Rhodes wrote:
Are there any good patterns to do this?

Yes. Most of these patterns can found in the GOF book. Of course you should start with a MVC design and then add other patterns into that design like the Command pattern for example. With these patterns the UI components are completely isolated from the work the application does and become observers of events triggered by the operations of the system so they can maintain a valid display to the user.

Does that sound like what you were asking about?

Tristan Rhodes15-Nov-07 22:44

15-Nov-07 22:44

I think i made a bad decision at the start of the app. As i had no stand alone tree structure that raises change events, i implemented a derived tree and handled all the change events via the host form. Unfortunately, now that i have 3 seperate views of the same data, it would be more desirable to have the data seperate and give a handle to each of the controls to make it self synchronising (Via a property or something).

Would this be a good way to go? Or should the model be linked to the Observer, and that keep things synchronised with the views?

Additionaly, is it common practice to nest observers? i.e. Would you have an observer to keep three tree views and a tree model synchronised, then another observer to manage the Tree Model + the rest of the application?

Just playing with ideas on where to go in the future.

Cheers

Tris

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

led mike19-Nov-07 12:00

led mike

19-Nov-07 12:00

Tristan Rhodes wrote:
Or should the model be linked to the Observer, and that keep things synchronised with the views?

Do you know MVC? If not start with the Wikipedia page for it. In MVC, Views subscribe to notifications from the Model.

Tristan Rhodes wrote:
Additionaly, is it common practice to nest observers? i.e. Would you have an observer to keep three tree views and a tree model synchronised, then another observer to manage the Tree Model + the rest of the application?

Not sure what all that means, perhaps you are overusing "tree". There is no reason to be specific about User Interface Tree Control. Just generalize that to Views, period. What each view does to manage any controls it may own is it's business.

When the user interacts with the UI, the UI handler passes the message to the Controller in MVC. It is the Controller that coordinates that message into whatever system services pertain to that operation. Any one event may result in Model notification messages being sent. Using that design is how you might synchronize different views. Also other patterns can be used to implement synchronization like an extended Command Pattern to contain command state information.

Does that help?

Tristan Rhodes22-Nov-07 4:59

22-Nov-07 4:59

Hi Mike,

Thanks, yes, that helped. I've been doing some more research into MVC and guess i originally misinterpreted it. I've now separated the model from the view and the controller is the host form.

So what i have ended up with is:

* A Generic Tree that raises events on change and can be serialized
* A composite control set that takes an instance of the above Tree and observes it, keeping synchronized. This custom control also raises user events.
* A Controller that handles all events from all controls, and manipulates the Generic Tree; cascading changes to any observing views.

That seems to be a really nice way of doing things, and I'm really happy with it. I feel as though the penny has finally dropped for that particular way of thinking.

Cheers Big Grin | :-D

Tris

Question: Does the fact that the composite control also raises user events change its role in anyway? Or is that perfectly acceptable?

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

3D architecture

rsaint2713-Nov-07 7:56

rsaint27

13-Nov-07 7:56

Hello,

For this project I'm going to develop, I have to implement the base structure of a system that holds data taken from 3D files.
The basic structure I've implemented is:

class 3DPoint
{
//Point data
}

class 3DLine
{
List<3DPoint>...
// class methods
}

class 3DModel
{
List<3DLine>...
// class methods
}

So far this works well, and it suits my needs.

Now I want to derive these classes to allow drawing with OpenGl, because I need some specific fields like "visibility, selected, ...", and that's when I ran into some troubles, because when I derive 3DModel (gl3DModel), I'm forced to use the class 3DLine, and not the derived class (gl3DLine), and the same with 3DPoint.

Does any of you have any suggestion on how to do this?

Thanks!

Re: 3D architecture

Tristan Rhodes14-Nov-07 3:26

Calling UDDI services from DNA platform

14-Nov-07 3:26

I think you should seperate the functionality from the data objects, similar to the way you would seperate database records from the actual database provider logic / queries.

Instead, implement a renderer base class that takes the above primitives, then derive that for OpenGL / D3D.

That way you could do:

Renderer r = new D3DRenderer();
r.Render(myModels);

Hope that helps

Tris

-------------------------------

Carrier Bags - 21st Century Tumbleweed.

GuimaSun12-Nov-07 8:43

GuimaSun

12-Nov-07 8:43

Hi, my company is installing the BEA SOA platform, and the legacy platform is DNA. So, we have to make calls to service registry to discover endpoints, the service registry implements UDDI.
I can study the UDDI interfaces and encapsulate the calls, but I'd like to know if there is any component ready to use.

Thanks for any tip.

GuimaSun
www.nexsun.com.br
NEXSUN TechZone

instruction executed per second by a microprocessor

akhshay gandhi12-Nov-07 7:11

akhshay gandhi

12-Nov-07 7:11

what program i need to write to find out number of instuctions executed per second by my processor.

i thought of sending an interrupt after 1 second to an executing program(loop) which has counter, so by calculating difference between initial and final value of counter for that program(loop) we can find out instruction executed per second. but unfortunetly i don't know how to send timing interrupt.

i need suggestions and guidance.

thank you

Re: instruction executed per second by a microprocessor

Luc Pattyn12-Nov-07 7:40

Luc Pattyn

12-Nov-07 7:40

Hi,

the general question you ask needs an entire book to contain a general answer.

Here are some facts:

1.
you are in the wrong forum, it is not a software design/archiotecture issue, it depends
foremost on the specific hardware.

2.
Most microprocessors have some kind of NOP instruction, and can execute that in 1 cycle.
So a 1GHz CPU (single core, no hyperthreading, ...) could execute 1 billion of those
in one second.

3.
More complex instructions may/will take longer; more so for CISC than for RISC.
A divide instruction may take 35 cycles or so (or not be available at all).

4.
Instruction scheduling nowadays complicates matter a lot: instructions don't always
get executed at maximum theoretical speed due to scheduling constraints.

5.
Memory bandwidth issues may slow things down (code cache misses, data cache misses,
table walk delays)

6.
Other system activity may reduce the throughput you are interested in: e.g. interrupts
dealing with timer ticks, network traffic, ...

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google

Good UML tool

Oshtri Deka12-Nov-07 0:33

Oshtri Deka

12-Nov-07 0:33

Hi!
Can you recommend me good UML tool with ability of code and/or database generation?
Something affordable Big Grin | :-D

Re: Good UML tool

Tristan Rhodes14-Nov-07 3:21