Latest Articles by semaphore06

Search Engine Optimization- The Significance

Thu, 20 Sep 2007 00:00:00 -0500

From a small local business in a town to a big industry playing on an international platform, marketing has been a prime tool for any company or business to succeed. People started with using tools like write-ups, references, pamphlets and much more to convey their means or advertise themselves among a group. But now is a time where everything happens just on the click of your finger. And in this time is required marketing at the speed of light, marketing with niche concepts that are applied even before a common man would think.

With the time we are moving from a physical world to a virtual world. Companies started building up their websites to have a presence in the virtual world. But likewise there are billions of websites. What would be your identity then? In this age of Internet and Technology, getting your business visible to your customer segment is more important and this is where the Search Engine Optimization comes into picture.

Building up a website is like making a saw and optimizing your website is like sharpening that saw to use. And it is quite logical that you cannot take optimum use of your saw without sharpening it.

Search Engines are a system through which one gets the information the later wants. Search engine optimization (SEO) is the process of improving the volume and quality of traffic to a web site from search engines through search results. Usually, the earlier a site is presented in the search results, or the higher it "ranks", the more searchers will visit that site. In simple words, Search engine optimization (SEO) just means your site is as accessible as possible to the search engines to improve the chances that they will serve it up when your potential customers type in specific search terms (called keywords). The more easily search engines find your site, the higher up it appears on their results pages.

In this world, SEO is definitely a smart move for any business.

But getting your site ranked for your keywords, there are many aspects that play a key role: a proper site structure, clean coding and necessary keywords, to name a few. This requires the every page of your website to be optimized. Every page should have a proper title, genuine keywords and a perfect description that matches the page. These title, keywords and description have to be relevant for every individual page. Search engines "crawl" the Web looking for the keywords that their users enter, so putting those keywords throughout your site means your pages will be picked up during searches by the search engine. Hence you have to put your foot into your customer’s shoe to understand what keywords your customer would use to search for a particular product or service. You have to learn your customers’ mind and this will give you the best of Title and meta (Keywords and description) to optimize your website. Also, optimizing your content is equally important as that plays an important role. You may optimize your content with putting keywords in your content, giving the Heading tags to titles, giving bold effects wherever necessary, giving links (to phrases in the content) to internal pages wherever appropriate.

Also, other activities to rank up your website in search engines are submitting your website URL into more and more search engines, adding your website URL into online directories, building up links with other relevant business sites, submitting rich articles into article sites, submitting your blog pages into various blog sites, submitting Press Releases into various Press Release sites. This will both increase the traffic overall to your site and enhance your search engine rankings, since the search engines pick up on the number of times people link to and from your site and rank your website higher accordingly.

People try many techniques to boost up their website ranking in these search engines for the specific keywords. People make researches to add-on their skills to make this task easier, faster and more genuine.

There are companies that provide services for SEO to other companies. We at Semaphore Software (www.semaphore-software.com) have a dedicated team that researches on the SEO and SEM (Search Engine Marketing) activities and undertake projects to upgrade the website ranking for our clients from different businesses.

It has become very important to move ahead with the fast pace if you wish to survive your business in this global competition.

--
Ghanshyam Shah is working as Research Analyst & Project Coordinator in offshore software development company Semaphore InfoTech
www.semaphore-software.com
Ghanshyam_shah@semaphore-software.com

Source: http://www.articletrader.com

Importance of Search Engine visibility

Thu, 20 Sep 2007 00:00:00 -0500

A lot of people search the internet generally when they are in require of some service or to expand product information. Most people would do search using few keywords as they are unconscious of the brands they want to use to advantage the service or product. Also the person who is searching frequently decides before he hits the end of the search page.

Well that leaves us with only one question, how can one get good search engine visibility? How can the product or solution on extend be visible in the first page itself?

There are few tips that can really help you to achieve visibility on the search engines and that means your content is accessible to millions of Internet browsers.

First thing you will have to do is find out what words do people use to search to access a particular service or product and their related key words. Once you set your keywords you could Meta tag the same to represent the entire company’s website content.

Once you have the list of key words you have to try and use these keywords in your content of the website. The more keywords you collect and add on to your content the more will be the visibility for your website.

Regular press releases using these keywords can also do the trick. This way you have more gain more visibility and more search engines will pick up your data as it’s the latest update. Do make sure your press release has relevant and important data so that your possible client gets all wanted information. As he lands on your website he should see the expression of the information he has seen and should be satisfied with the further information he expected on your website.

Start a blog so that you and your employees add on that and they become an entire part of the domain you control on.

With a good search engine visibility you have already won the war of the markets, as most people would not even look at the other websites. So your competition is already filtered and you are ready to be the leader. So now Prepare your content filled with keywords and get ready to rule the market!

--
Shital Jethva is working as Sr.SEO in
offshore software development company Semaphore InfoTech
www.semaphore-software.com
seo3@semaphore-software.com

Source: http://www.articletrader.com

Php using smarty

Fri, 16 Feb 2007 00:00:00 -0600

Till now i developed most of my projects using asp.net. Just last month only i learned PHP (PHP: Hypertext Preprocessor) is a programming language designed for producing dynamic Web pages. PHP is an open source language and considered to be free software by the Free Software Foundation. At this time, i discovered Smarty and have been using it in my projects.

Now the question is why do we use Smarty and what is the purpose of using it...???

Traditionally, when you make a web application using php, html and php scripts are mixed in one file.
More often than not, a programmer finishes a complete project, and someone suggests that the font and background colors chosenhe/his choose don't match with their requirement. The programmer would then hasve to search through dozens of php files and alter the HTML that was embedded within simply to change the appearance of the web site and change all other properties. Editing the php files greatly increases the chance of generatinge new errors or bugs. It will much easier when you separate your HTML from your PHP code and will also make it much easier to reuse your PHP code down the road in other projects.

So the above solution can be applied by using Smarty technology as, it allows you to change the appearance of your web site by changing an HTML template file. It also allows you to do simple if statements, dynamic repeating blocks, and variable substitution.

The basic use of Smarty is for separation of business logic and presentation logic, generates web content by the placement of special Smarty tags within a document. So it allows the presentation of a web page to change separately from the back-end, thus allowing applications to be developed in a more organized fashion. Using this development model, designers are hidden from the back-end coding and PHP programmers are hidden from the presentation coding.

Tasks of both designer and programmer are is as follows :

Programmer's Tasks:

-> Fetching data from database by firing simple queries to it.
-> Manipulate or validate the data by performing business logic on it.
-> The best thing is that we can change the data access method like from MySql to another without interfering with designer's work.

Designer's Task:

->Creating HTML pages without affecting php scripts , only concerned is with placing content elements on the right place where the programmer has agreed to provide.

Some of the attractive features of using smarty areis as follows :

1) Fast : Smarty is extremely fast by doing Template Compiling, means it reads the templates, creates php scripts and include the php files which is finally compiled by php engine..The best thing is that the templates are parsed only once by smarty if it is not modified again.. this results in to fast compilation and better performance.

2) Catching : Smarty has built-in catching of your template outputs. It catches the output of the template contents and thus saves the overhead of retrieving the data from data source.

3) Variable Modifiers : Smarty provides variable modifiers in order to modify the contents of a variable like converting string to uppercase or lowercase or truncating etc things like that very easily

4) Template Function : Smarty provides some builtin and custom functions like looping function like if statements or for loops etc.Or just write a simple one line code which will generate a radiobuttons or calendar or other form controls which make things faster and more simple.r.

Smarty is a great tool for both designers and developers. By using Smarty you can reduce the site development and maintenance times. If you are a developer you no longer need to mix PHP code with HTML code. Just take care of business logic and leave the HTML to the designer

Now the matter of debugging the smarty php scripts. Nusphere provides PHP Editor for editing and debugging..Ii’ss latest verison is PhpEd version 4.6.2 has been released with full support for PHP 5.2.

The definitive resource for learning Smarty is smarty.php.net,where you will get all the stuffs related to Smarty.

I'm still learning about it, so I'm in no way an expert, but if you have any questions, please feel free to ask.

Thank You,

--
Author:

By Nishant Bharathan

Nishant Bharathan is working as a Jr. Programmer at Semaphore Infotech Pvt. Ltd, India. He has 8 months Experience in .net programming. You can contact on email: nishant@semaphore-software.com.

Source: http://www.articletrader.com

Expected output is not available in spite of putting all the efforts like SRS / SDD, data dictionary,

Fri, 16 Feb 2007 00:00:00 -0600

DO:

1. Follow the company coding standard.

2. Read the SRS / SDD carefully and understand the forms.

3. Understand and write down the instruction of the functional and technical requirement of the form. This is very important since we are developing enterprise application for multiple branches and locations of different hierarchy.

4. Ask concerned PL in case of any doubt at any point of time so that problems / errors do not pop up during testing / implementation.

5. Find out the pre – requisite and post – requisite of the form.

6. Put the valid & sensible data into the required masters and transactions.

7. Do the coding such a way so that maintenance of the forms will be easier. I.e. If length of the field is changed then form should take care of it automatically.

8. Minimize the scrolling of the form.

9. Do proper alignment of all the controls.

10. Do not delete any data at any point of time.

11. In data search / find window give at least four to five columns which make sense to users with respect to the context of the field’s and form’s requirement.

12. Enable and disable the controls with respect to the context of the data. I.e. if application is forwarded to other location then do not enable edit or delete button.

13. Take the maximum advantages of database objects like triggers, functions and stored procedures.

14. Share your technical expertise when you achieve something which is abnormal in routine coding.

15. Avoid multiple trips to the database server.

16. Think of a copy of static data to the client side. I.e. District data / system parameter data are not changed very often so keep such data on the client side.

17. Load your changes on the test server and test your changes on test server without fail.

18. Set combo box width to the maximum length of the data being displayed in the list.

19. Same way, make sure that controls have enough space to display data when we take help of select / find window.

20. Height of the text box / combo box / list box should vary with respective labels. I.e. when labels occupy two lines.

21. Give meaningful message when any condition fails or any event takes place. Also message should be picked up from database according to the message no.

22. Understand the internal relation among the fields and enable / disable the field. Also accept the valid data with the context of data in the previous fields.

23. Have the complete environment for development. I.e. Install the font and required files.

24. Have code review with technical leaders and seniors and take care of all the points / suggestions / comments without fail.

25. For data maintenance have one sample program with all the possible conditions. I.e. For master / detail transaction have one sample program.

26. Get back to the concerned PL if you find any problem as per SRS / SDD.

DONT

In next sequence…….

Conclusion:

In nut shell every programmer has to be analyst programmer. Do work with commitment. Check your work with all the possible combination of valid and invalid data. Do not assume that form will work 100 % right without 100 % test.
Sanjay Tamboli is working as a Programmer at Semaphore Infotech Pvt. Ltd, India. You can contact on email: sanjay@semaphore-software.com.

Source: http://www.articletrader.com

An Introduction to ERP

Fri, 16 Feb 2007 00:00:00 -0600

Information technology has transformed the way we live live in and the way we do business. Since last decade, I.T. has made a drastic change in our life. As compared to earlier stage, when computer was used just as a typewriter, nowadays users have become more intelligent and IT literate. Now the user knows that a PC can do many more things rather then just typing a letter in a word processing software or making balance sheets in excel. They expect more things out of their PC. During this phase of industry, every one of us must have heard the word ERP in one or the other form. It may be in title of any IT magazine or may be a point of discussion in any IT Seminar or may be in an advertisement of big IT Company. Thus in any form, we all have been through this word. In this short article, I’ll try to concisely explain the basic yet important concepts relevant to ERP.

What is ERP ?

ERP is one of the most widely implemented business software systems in a wide variety of industries and organizations. ERP is the acronym of Enterprise Resource Planning. ERP is just not only a software. ERP definition refers to both; ERP software and business strategies that implement ERP systems.

ERP implementation utilizes various ERP software applications to improve the performance of organizations for

1) resource planning,

2) management control and

3) operational control.

ERP software consists of multiple software modules that integrate activities across functional departments - from production planning, parts purchasing, inventory control and product distribution to order tracking. Most ERP software systems include application modules to support common business activities like finance, accounting and human resources.

ERP Systems

ERP is much more than just a computer software. An ERP System includes ERP Software, Business Processes, Users and Hardware that run the ERP software. An ERP system is more than the sum of its parts or components. Those components interact together to achieve a common goal - streamline and improve organizations' business processes. Most important factor for ERP system is the users. Successful implementation of any ERP System more depends on intelligent users who are going to use them, because any standard ERP Software would consist hundreds of input information for any particular business activity. Thus good knowledge of each entity of system to the users is most important factor in ERP Software.

History of ERP

Enterprise Resource Planning (ERP) is the evolution of Manufacturing Requirements Planning (MRP) II in 1980s, which was mainly related to Manufacturing Industry and was designed to control manufacturing process and planning the required production with efficient output. Where as MRP is the evolution of Inventory Management & Control conceived in 1960s, which was mainly designed for management of Stocks in any particular industry. ERP has expanded from coordination of manufacturing processes to the integration of enterprise-wide backend processes like production planning and scheduling of delivery. In terms of technology, ERP has evolved from legacy implementation to more flexible tiered client-server architecture.

Benefits of ERP

ERP software attempts to integrate business processes across departments ionto a single enterprise-wide information system. The major benefits of ERP are improved coordination across functional departments and increased efficiencies of doing business. The implementations of ERP systems help to facilitate day-to-day management as well. ERP software systems are originally and ambitiously designed to support resource planning portion of strategic planning. In reality, resource planning has been the weakest link in ERP practice due to the complexity of strategic planning and lack of adequate integration of ERP with Decision Support Systems (DSS).

Famous ERP Software

No one from IT industry will be unknown from the word SAP. SAP is the most successful ERP Software. To name more here are some examples:

PeopleSoft
www.peoplesoft.com

SysPro
www.syspro.com

ORION Enterprise
www.3i-infotech.com

Matrix
www.matrixinfosystems.com

(In the past, we have implemented Matrix ERP solution for one of our clients)

ERP Failures

I couldn’t conclude my brief guide to ERP without mentioning ERP failures. The failures of Crore rupees ERP projects are reported once in a while even after many years of ERP implementation.

There are four components of an ERP System –

1) ERP software,

2) Business Processes that ERP software supports,

3) Users of ERP systems, and

4) Hardware and Operating Systems that run ERP applications.

The failures in one or more of those four components can cause the failure of an ERP project. Discussions on each of the four topics will require new article, so I may come up with same in my next article.

--
Author:

By Premal Vala

Premal Vala is working as a Project Leader
for Semaphore Infotech Pvt. Ltd, a renowned IT company based at
Ahmedabad,
w:st="on">India
. He has around 10 years of experience in
the field of Information Technology. Working on ERP is his main area of interest.
Apart from this, he is also fond of Video movie recording and editing/mixing
of Audio/Video. You can contact on email: premal@semaphore-software.com.

Source: http://www.articletrader.com

Customer Interaction

Fri, 16 Feb 2007 00:00:00 -0600

Now-a-days customers are being semester thaen before They always want their satisfaction to the exteant. As the technology have been advanced & one has all the tools that he/she could satisfisfactorily used fored the customer’s rearmament. But it is very important that the customer comes to you will get the right information and assuranceed that he would get his work done with your you proper guidancely. Therefore I am giving you 3 basic contents to interact with your client……..

(1) Appearance & Behavior while first marketing :

Here,ar by Appearance I do not mean that one should have a smart, handsome look, I think a customer wants you to look gentle and behave gently. You should be wearing formal dress. There must be an eye contact while talking to the customer. Otherwise he would feel that he is not valuable to you.

(2) Your Speech :

Though you are the master of the web-designing or whatever the work you do everyday, . But if you can’t express how good you can do for the customer, it will not workthat by sealing the customer will not believe you. Start to talk to the customer very gently. Hence It is said that “ well begin is half done. “ Then Start talking about your work from basic, because he doesn’t know the technical aspects. He will always rely upon your advices. Make him understand what you are speaking, by giving example. So we should represent our views very clearly to our customers.

(3) Be noble & honest to your customers :

As everyone knows “ Honestly is the best Policy. “ According to this statement you can only reach your destination by being noble and honest. Your client will only trust you if you are honest. Dishonesty works for a bit but not all the way to success. The solution is to be honest and maintain credibility at the same time.
Semaphore Infotech Pvt. Ltd

--
Author:

Shaunak Mistry

Shaunak Mistry is working as a web developer at Semaphore Infotech Pvt. Ltd, India. He has more than 2 years Experience. You can contact on email: shaunak@semaphore-software.com.

Source: http://www.articletrader.com

A Beginner's Guide to Search Engine Optimization

Fri, 16 Feb 2007 00:00:00 -0600

What is SEO?

SEO stands for Search Engine Optimization. This term is used to explain the marketing technique of developing a website to boost up its chances of being ranked in the top results of a search engine once an appropriate search is undertaken. There are lot many important factors while optimizing a website, which include its content and structure of the website’s copy and page design/layout, the HTML meta-tags and the submission process.

What is SEM?

SEM stands for Search engine marketing which provides an effective method of highly targeted visitors to the web site. The search engine marketing pages make available access to the collective understanding of all the top search engine marketing experts with frequently updated articles, links to resources, and announcements of new tools and services.

Why SEO?

SEO is an abbreviation of Search Engine Optimization. This is the process of structuring a web page so that it is found, read, and indexed by search engines in the most effective manner possible.

This makes the site and its content eye-catching, appropriate and observable to search engines and web searchers.

It can happen with your web site if people cannot easily locate it. Traffic volume, if it is not existed at all, slows to a crawl. Potentially valuable customers never even know you are there.

Conclusion:

It’s a need to do SEO for your web site as if you wish to increase the traffic volume on your site & get it crawl easily and soon.

justify">Shweta Shah is working as a web developer at Semaphore Infotech Pvt. Ltd, India. She has more than 6 months Experience in web desgining. You can contact on email: shweta@semaphore-software.com.

Source: http://www.articletrader.com

Windows VISTA RC2 build 5744 - from my eye

Fri, 16 Feb 2007 00:00:00 -0600

Friends, I have installed Windows Vista RC2 build 5744 last week and I want to share my experience with you all.

I believe that the operating system is good enough and worth upgrade from XP SP2, yet final edition of Windows Vista is expected in January 2007.

As I clean installed it on a clean partition on Intel Pentium 4 with HT. Windows Vista RC2 build 5744 required more than one hour to be installed. I hope this process will be streamlined and the installation time will be reduced in next final release.

After installation, it takes some time to give you final desktop because of its building data feature, for easy search in future. It gathers file in one centralized data source, so when ever you do search in future, it will go through results veary fast….at the other end its resource hog feature

Now I have installed Vista, I searched for improvements and new features. I found some of them are very useful and it attracted me for various reasons.

Now I got New improved Internet Explorer 7 in windows Vista with great features, great fast engine….spam protection, anti phising, pop up blocker and many more…

Also I got Windows Media Player 11 with really nice look and feel….lot of new features, Sounds Gadgets Connectivity, CD-DVD Ripper and many more…

Windows Photo Gallery is nicely improved, it is much better thant the current gallery of Windows XP. One good feature is Vista's Flip 3D function. Using this, you can load up your open windows as 3D view on the screen, you can scroll through them with the mouse.

There is a new and improved GUI-AERO, creating a screen with see-through, 3-D-like elements. Aero would only lash out if your PC is having an outdated graphics card carrying less video memory.

The mailing application is designed with style appeal in mind….Vista's new Mail system, which replaces Outlook.

I am impressed with the Network and Sharing Center feature. With this you can connect to the Internet very smoothly.

RC2 continues offering the great options that Microsoft must convince home and professional users to upgrade is Vista Gadgets, the eye catching small utilities that are set on the right side of your desktop.

Other great feature is RAM Boost; you can use your PEN Drive or USB Thumb Drive as RAM when ever you need more memory….it sounds great….now no need to buy extra memory for one application.

Microsoft has also improved the control-panel settings. It also appears to selection of aero theme options.

My 128-MB graphics card runs Vista fine. Vista 's GUI continues to improve. Microsoft is yet changing colors, shapes, opacity, and positions of icons, applications in terms with end-user perspective rather than by developers

Performance-wise, RC2 looks and feels good. In my mid segment system, it works fine enough.

My conclusion is that with RC2, Vista is increasingly looking like a Great combination of Professional functionality and entertainment; it will rock corporate users as well as home users and children. In near future, this OS will overtakecome as one of the best OS in all over the world.

--
Author:

Yusuf Gandhi

Yusuf Gandhi is working as a project Leader at Semaphore Infotech Pvt. Ltd, India. He has more than 5 years Experience. You can contact on email: yusuf@semaphore-software.com.

Source: http://www.articletrader.com

Cracking the Mysteries of Sybase SqlAnywhere with .NET integration

Thu, 15 Feb 2007 00:00:00 -0600

.NET developers can add the powerful capabilities of SQL Anywhere Anywhere Technology to their applications by using .NET programming interfaces and web services.

SQL Anywhere Studio makes the most of the services provided by .NET to let developers add its capabilities to their applications using the. sSupport integration with .NET1.0, 1.1, 2.0 and ADO.NET 1.0, 2.0

Making data available through .NET

SQL Anywhere implements ADO.NET that provides an interface to relational data.

ADO.NET is the preferred data access component for the Microsoft .NET Framework

The In ado.net data provider is being used to facilitate the integration of data with .NET applications

The sSupported Providers are

The Adaptive Server Anywhere ADO.NET Provider

This provider is a native interface to the database, meaning that there is no intermediate bridging technology.which implements the iAnywhere.Data.AsaClient namespace

The UltraLite ADO.NET Provider

It makes the ADO.NET programming model available for UltraLite database access

The UltraLite ADO.NET Data Provider implements the iAnywhere.Data.UltraLite namespace

Moving data to wherever it is needed

SQL Anywhere also provides web services, used by Microsoft .NET and other enterprise integration platforms as an XML-based mechanism for distributioned access to information over Internet protocols.

It provides both the ability to build web services in the database and the ability to access external web services from the database.

SQL Anywhere databases can act as web service clients, meaning that they can collect and integrate information from many locations.

The ability of Adaptive Server Anywhere to return the result sets of SELECT statements and stored procedures as XML provides a foundation for web services.

You can expose stored procedures or queries in your database as web services.

SQL Anywhere provides MobiLink data synchronization for "always available" data access in occasionally connected environments. Synchronization logic can be implemented using .NET programming languages.

SQL Anywhere includes QAnywhere messaging software that provides a .NET interface to application-to-application messaging for mobile computing.

Development tool

As a part of an effort to provide more comprehensive support and integration with .NET, Sybase has released a new development tool that works in any .NET environment.

Sybase DataWindow .NET2.0 is being offered to allow developers to use the use of a single tool to incorporate data access, complex logic, and data presentation into .NET applications.

DataWindow creates point-and-click environments for easy data retrieval.

.NET's holistic approach will should help developers to be more productive, and it also should allows faster and more flexible modification of enterprise applications for the .NET environment.

Conclusion

SQL Anywhere Studio provides a wide range of .NET support applications.

The ADO.NET interface is fully supported in both Adaptive Server Anywhere and UltraLite databases. Adaptive Server Anywhere can act both as a provider of web services and can access external web services and make them available to client applications. You can import, export, and store XML in your Adaptive Server Anywhere database and make existing data available in XML form.

MobiLink gives you full accessability to the functionsality of the .NET Common Runtime Languages by allowing you to write your synchronization scripts in any of the supported .NET languages, and QAnywhere brings messaging to desktop and mobile devices with a .NET programming interface.

--
Author:

By Dhori Alpesh

Dhori Alpesh is working as a Programmer at Semaphore Infotech Pvt. Ltd, India. He has more than 1 year Experience in .net, oracle, sql, mysql. You can contact me on my email alpesh@semaphore-software.com.

Source: http://www.articletrader.com

How to overcome record locking in SQL Server in case of concurrent access of data

Thu, 15 Feb 2007 00:00:00 -0600

In Most of multi-user ASP.NET application problem arises when two users are trying to access same data. For an example, if User A is modifying data and at the same time user B is trying to read data. Here we can’t be not say sure that whether user B gets the old original data or newly updated data. There are two options way to overcome this problem

1. By using Record locking (Pessimistic Concurrency)

2. Compare with original data (Optimistic Concurrency)

1. Pessimistic Concurrency: In pessimistic Concurrency when user A intendshas a chance to edit record, an application l will lock that record and does notn’t allow any one to usetouch it until user A complete his changes and save it. So we give guarantee that no user can read/update data while user A is editing the data. In pessimistic concurrency, user has to wait till record is locked by other user. One way to achieve this is : Put isLocked field with each record. Now when user A opens the record for editing, the field isLocked is set to true mode and after saving record set it to false mode. But problem arises when if user A opens record to view theit contents and closes the browser before saving it e record it to database. Now this record will consider as locked. To solve this problem we have to add one more field Timestamp with each record. Timestamp field define expiration time of record and user must edit the record within expiry ofiration time limit. Alternatively, we require two fields flag AND a timestamp.The flag indicates the lock state, and the time is the expiryation time.Then create one SQL job that runs and checks the expiryation times and automatically unlocks records that will showare past time of expiryexpiration.

2. Optimistic Concurrency: Here no locking concept is used. Anyone can read and modify the record at anytime and you don’t give chance to anyone towill take your chances that the record is not modify the recordsmodified by someone else before you takehave the a chance to modify and save it. The one solution is not to lock the record but keep a snapshot of the value that is editable and when the user submits it will compare the old snapshot with what is in the existing record and if it does not match, the new record would not be saved and send an alert to the user that the data is old and needs to be refreshed for them to submit their work Here the problem arises when there are more fields exist in record .Sso we need to compare all fields with their original value. This is very time consuming process. So to overcome this problem we add one Timestamp field with each record. The value of timestamp field will be modified everytime a change is made to a record that contains such a field. Now compare timestamp value with original timestamp value if both are same then we can say that now changes made with the record else send and alert message to the user that the data is old and needs to be refreshed for them to submit their work In Optimistic concurrency user doesn’t require to wait to do their changes so it provide better performance compared to with pessimistic concurrency. Suggestion: If you are not concerned with the performance then use pessimistic concurrency else use optimistic concurrency to overcome problems of concurrent access of data.

--

Author:

By Bhumit Patel

Bhumit Patel is working as a Programmer at Semaphore Infotech Pvt. Ltd, India. You can contact me on my email bhumit@semaphore-software.com.

Source: http://www.articletrader.com