This is an HTML version of the ebook and may not be properly formatted. Please view the PDF version for the original work.
An excerpt is a selected passage of a larger piece, hence this is not the complete book.
HTML Format is ideal for: Immediate preview in any browser, Translations
PDF Format is ideal for: PC's & Macs, iPhone, and Printing
The ePub format is ideal for the Sony Reader, Barnes & Noble Nook, BeBook, Bookeen, COOL-ER, Hanlin eReader, Hanvon and many other ebook readers
Note: For VIP Members Only.
Mobipocket Format is ideal for: Amazon Kindle, Mobile Phones, Blackberry, Palm, IRex, ILiad, Hanlin, BeBook and other mobile devices
Note: For VIP Members Only.
The Text (TXT) format is the simplest format and can be read in any word processor. Plus it is printable.
Standard Members enjoy free HTML views and 5 PDF/TXT accesses per month. For Unlimited Access, please upgrade.
for more, click on http://www.vkinfotek.com/
Develop your own Database Software
In this ebook, I will run you through the important steps involved in developing client/server
database application software. Most of the applications we see today, technically speaking, are
client/server application softwares.
Before we go further, let us know more about client/server applications.
Client/Server applications have become predominant in enterprise wide computing. This is because
Client/Server computing provides an open and flexible environment where mix-and-match is the
A Client/Server network is used to accomplish many business needs. They are:
a. To record accounting transactions like purchases, sales, receipts, payments in a company.
Note that, different users enter these transactions simultaneously using the client computer.
The client computer may be running a windows application or a web application. The
Client/Server application, should support recording of these transactions into a central
Database server confirming to all security and database integrity requirements of an
b. To extract business intelligence reports from the data in the database server.
c. To enable users to share resources like printers and fax machines.
As enterprise wide computing becomes more sophisticated, the CIO of a company has a challenging
job involving maintenance of hardware and networks, upkeep issues like registry clean up, setting up
and updating policies, regular backups, etc., ensuring that the Client/Server business application is
up and running. A complex job like this requires an understanding and a grasp of all the issues like
hardware, networks, network operating systems, protocols and more.
Client / server application development can be broadly categorized as:
Installing and setting up windows operating system for development and production environment
Installing and setting up database server - sql server
Front end design and development
Back end database design and development
Understanding the Client/Server architecture
On the client side of this architecture, we find a fairly simple Front-end application. On the server
side, we find an intelligent engine. The server is designed to accept queries from the front-end
application – usually in the form of calls to stored procedures and return the requested information.
We will see now in detail what are the responsibilities of client and a server.
The client application is responsible for connection management, data capture, data retrieval, data
presentation, and error management.
Connection Management: Client/Server applications establish a connection with the server to
submit queries, retrieve result sets. In this architecture, the client makes a hard connection with the
server over a local area network (LAN) or a wide area network (WAN) – even if the connection is
READ THIS BOOK AS
* For VIP Members Only. To access these formats usable with Kindle, Sony Reader, iPad and other readers, please upgrade