Performance Tuning of a Daffodil DB / One$DB -JDBC Application

Writen by Parveen Aggarwal

This article illustrates the best practices to improve the performance of Daffodil DB / One$DB JDBC Driver. This article focuses on how to improve the performance of a Daffodil DB / One$DB JDBC application using Statement, PreparedStatemnt, CallableStatement and ResultSet interfaces. Choosing the right statement interfaces and right methods according to your SQL query plays a vital role in improving the performance of a JDBC Driver.

JDBC Overview

JDBC API provides standard set of interfaces to work with databases like Daffodil DB / One$DB, Oracle, Derby etc.

Connection interface encapsulates database connection functionality, Statement interface encapsulates SQL statement representation and execution functionality whereas ResultSet interface encapsulates retrieving data which comes from the execution of a SQL query using Statement.

Following are the basic steps to write a JDBC program.

1. Import “java.sql” and “javax.sql” packages. (Import “javax.sql”, if advanced JDBC feature like XA is to be used)

2. Load Daffodil DB JDBC driver (embedded or network JDBC Driver)

3. Establish connection to database using Connection interface

4. Create a Statement

5. Execute the Statement

6. Retrieve results by using ResultSet interface

7. Close Statement and Connection

Choosing right Statement interface:

There are three types of Statement interfaces in JDBC to represent/execute a SQL query-Statement, PreparedStatement and CallableStatement. Statement is used for executing static SQL statement with no input and output parameters; PreparedStatement is used to execute dynamic SQL statement with input parameters whereas CallableStatement is used to execute dynamic SQL with both input and output parameters. One important thing to note about PreparedStatement and CallableStatement is that they can also be used for static SQL statements. However, CallableStatement is mainly meant for stored procedures.

PreparedStatement gives better performance when compared to Statement because it is pre-parsed and pre-compiled. This means that compilation and parsing of such statement is done only once by the database. Afterwards the database reuses the already parsed and compiled statement. This significantly improves the performance because whenever a statement has to be executed repeatedly, it doesn’t need to be parsed and compiled time and again. So the overload incurred by parsing and compiling the same statement can be reduced.

When there is a requirement for single request to process multiple complex statements, CallableStatement gives better performance as compared to PreparedStatement and Statement.

To read the full article please visit http://www.daffodildb.com/daffodildb-performance-tuning.html

This article has been contributed by (Mr.) Parveen Aggarwal, Technical Consultant to DSL India (http://www.daffodildb.com). With more than 6 years of industry experience in Java and allied technologies, he has an in-depth understanding of J2EE, J2ME and database management systems. Parveen is currently working on the concept of data-archiving in embedded databases. He can be contacted at parveenaggarwal@hotmail.com

What’s the Best Background Check Software?

Writen by Stanley Alpin

There are several background check softwares available online. Most of them are available in a similar price range. However, what sets good background check software apart from the myriad others are features such as:

Ease of download and compatibility: The software should be easy to download and run instantly. Free and timely software updates should be installed automatically and the software should be compatible with the different Internet-related software and operating systems.

Online help: The vendor’s website should have detailed FAQ and Help sections that explain the manner in which the software is to be used; tips and tutorials are provided and customer queries are answered.

Ease of use: A good software should be easy to use, with query fields designed to return the most pertinent results for a given search.

Legal to use: The software should be completely legal for use in all manner advertised by the company. Its sources of information should be verifiable and information it dispenses should be obtained legally.

There are other factors too that distinguish a good background check software; these include a well-updated database that draws from various resources. Also, the databases accessed have to be relevant to the type of background checks provided otherwise looking up a background is likely to turn into an exercise in futility. The background check software should facilitate checking of criminal records; looking up one’s own family history; locate listed as well as unlisted phone numbers; obtain information on birth, death, and social security numbers, find people by name, phone number; or email.

Good background check software should make it worthwhile for employers who invest time and money in it and prefer it over agencies that offer a similar service. This means that it should enable accurate screening of prospective employees and provide information on their credit scores, criminal and driving records.

There’s a plethora of services that properly created background check software connected to a database can offer. These would cover locating individuals based on their past residence, school of graduation, and year of military retirement. Greater to which a database can go back in time better are the chances of coming up with information on a lost acquaintance or colleague. There are softwares that also help people in doing a background check on organizations worldwide so one can have a fair idea of their business ethics, legal opinions, and lists of fugitives so that one can do a background check on anyone who arouses suspicion in the neighborhood.

Thus, the best software would be the one that provides reliable information on individuals, property and real estate, bankruptcies and lien, criminals, and any kind of information that is available in the public domain.

Stanley Alpin recommends Background Check Guide for more information on the best background check software.

Real Estate Software

Writen by Josh Riverside

Earlier, the purchase of real estate was looked upon as acquiring property for residential or commercial use. However, over the years this theory has changed. Today, the real estate market is a booming and profitable industry. It deals with the purchase, sale and lease of property in a much broader context. For an individual, this involves looking for a real estate agent who can help find an appropriate property and a bank that can fund the purchase. For a real estate agent, listing and updating information is difficult if done manually. Therefore, real estate software is used to make the entire process easier.

Real estate software provides automatic updates and reminders. Routine listings allow an agent to maintain accurate reports on all deals. This software helps maintain property lenders’ and mortgage brokers’ listings. An agent can successfully update changes on available real estate. Properties are categorized according to size and affordability.

Various types of real estate software cater to real estate marketing, sales and follow-up. Real estate software also incorporates presentation applications that allow real estate agents to match properties according to potential customer needs.

Some real estate software offers a complete office and administrative package that simplifies real estate management. It can also record important scheduled meetings and reminders for the successful closing of sales. These self-sufficient and easy-to-use software packages are also available with virtual tour creators. In simple terms, clients can view a potential property through computer videos.

Real estate software separates rental or sale property listings. This information can be easily accessed and updated, depending on inputs by agents. This software is an effective medium for publishing property details online, over a secured network. Real estate software eliminates the need to hire technical personnel to update and manage real estate data. Local real estate agents can gain popularity through online and offline marketing venues made available by real estate software.

Free Small Business Accounting Software

Writen by Elizabeth Morgan

Free small business accounting software primarily focuses on assets. Assets may be described as valuable resources owned by a business, which were acquired at a measurable money cost. As an economic resource, they satisfy three requirements. In the first place, the resource must be valuable. A resource is valuable if it is cash/ convertible into cash; or it can provide future benefits to the operations of the firm. Secondly, the resource must be owned. Mere possession or control of a resource would not constitute an asset; it must be owned in the legal sense of the term. Finally, the resource must be acquired at a measurable money cost. In cases in which an asset is not acquired for cash or a promise to pay cash, the question is what it would have cost had cash been paid for it.

The assets in the balance sheet are listed either in order of liquidity- promptness with which they are expected to be converted into cash- or in reverse order, that is, fixity or listing of the least liquid (fixed) first followed by others. All assets are grouped into categories; that is, assets with similar characteristics are put in one category. The assets included in one category are different from those in other categories. The standard classification of assets divides them into fixed assets, current assets, investments and other assets.

Fixed assets are fixed in the sense that they are acquired to be retained in business on a long-term basis to produce goods and services are not for resale. In contrast to fixed assets, current assets are short-term in nature. They refer to assets/resources, which are either held in the form of cash or are expected to be realized in cash within the accounting period or the normal operating cycle of the business. Investments represent investment of funds in the securities of another company.

Business Accounting Software provides detailed information on Business Accounting Software, Best Business Accounting Software, Free Small Business Accounting Software, Small Business Accounting Software Reviews and more. Business Accounting Software is affiliated with Small Business Accounting Software.

Geocadabra, the Ultimate Solution for Geometry

Writen by Ton Lecluse

Geocadabra can help the child to understand difficult objects. Especially 3D objects can be rotated, unfolded, and calculations can be done. Geocadabra is also dynamical: points, lines and circles can be dragged with the mouse. While dragging a point, the status of the object keeps the same: a midpoint will be a midpoint, also after dragging an endpoint of an edge.

Geocadabra is used nowadays in Holland and Belgium, but it is also available in English, it runs at schools in South Africa and Texas (Houston).

I am searching for more schools and pupils in English speaking countries, where Geocadabra can help understanding mathematics. Using the internet, I will support the school from distance.

Geocadabra can simply be downloaded from its website. After installing it, it will behave as a demo. But on the website you can request an autorisation, by entering your email adress (after clicking “register”). Then immediately the autorisation is emailed to you.

Of course teacher and pupil can ask me questions. Simply by emailing me the question. Together we can approve the software, when you email me your suggestions to change Geocadabra.

Geocadabra can be downloaded from

http://www.omdeschool.nl/geocadabra_english_specialoffer.htm.

On this site also several documents can be downloaded to help the child and teacher to use and understand the software.

On my Dutch privat website, http://home.planet.nl/~leclu012, more materials can be found for Geocadabra.

Ton Lecluse is the author of Geocadabra. I am developing this program since 1993, and it improves daily.

Free Alternatives to Microsoft Office: OpenOffice and Open Source Software

Writen by Glenn Haertlein

Perhaps you’re on a tight budget and you don’t want to pay big bucks for Microsoft Office. Or maybe you have to collaborate on a project across several platformsmore than just Mac and PCand you need a versatile office suite that allows you to do this. Or maybe you just plain don’t like Microsoft Office! Whatever the reason, if you’re in search of a free alternative to Microsoft Office, the best place to turn is “open source” software.

What is open source? Put simply, open source refers to programs whose source code is available to the public free of charge and open to changes and modification. On the surface that sounds dangerous. Couldn’t anybody just hack into the code and riddle it with viruses and spyware? Yes, but it is highly unlikely. Open source programs are the work of a large community of programmers who take their work and their reputations seriously. Of course an unscrupulous hack might try to sabotage an open source program, but given the peer review that reputable open source programs undergo before they are officially declared stable makes this virtually impossible.

Open source software makes for a family of programs that is incredibly dynamic and diversified. Upgrades, improvements, and even user-requested customizations are fast-paced compared to those in the commercial, closed-source marketnot to mention free in most cases. Some examples of open source software include Linux (an operating system), OpenOffice (an office suite similar to MS Office), and Joomla (a web development program). All of these programs are incredibly robust and enjoy a large community of contributors, which translates into LOTS of free customer support.

So much for the introductory crash course into open source software! What about the free alternative to Microsoft Office? Of the available free titles, perhaps the best is OpenOffice available for free from http://www.openoffice.org/. OpenOffice is a full-featured office suite that will allow you to do everything that MS Office does without the hefty price tag. It can even use and create MS Office files and Adobe .pdf’s. That said, you need to understand that OpenOffice is NOT MS Office. By that I mean that OpenOffice has its signature characteristics-and quirks. For instance, it has an unusual way of handling graphics in Writer, its word processing program. Its way of cropping graphics is not as intuitive as it could be, but it’s a small price to pay, given how powerful it is. Stride for stride, OpenOffice is every bit as good as (some would say better than) its Microsoft counterpart.

Below is a list of the programs included in OpenOffice, and the MS Office equivalent:

• OpenOffice: Writer – Word processor = MS Word
• OpenOffice: Impress – Presentation software = MS PowerPoint
• Open Office Calc – Spreadsheet = MS Excel
• OpenOffice: Base – Database program = Access
• OpenOffice: Math – Creates mathematical functions = ?
• OpenOffice: Draw – Creates vector graphics = ?

When you download OpenOffice, you have a number of options besides just which operating system you want to use it on. OpenOffice is available in a number of developmental stages, also known as builds. If you’re a software developer up for a fulfilling challenge, the latest build may be exactly what you want. The latest builds are works in progress, have the latest innovations, and require a programmer’s expertise to perfect.

For the rest of us, the latest build is probably not the best thing. The latest builds may have the latest innovations, but that also means they will be the ones most prone to crashes and bugs. If you want OpenOffice ready-to-use, download the stable version. It’s like buying the current model year car as opposed to buying the concept car. Sure the concept car is cool and will turn a lot of heads, but you don’t know if all the bugs have been worked out yet. The current model year car is still cool and still turns heads, and you can be sure it’s reliable. The stable version is the download that OpenOffice.org promotes by default. With it, you’ll get the latest and greatest available to the average user, and you’ll save yourself a lot of frustration.

OK, so OpenOffice is cheap (read free) and robust, but is it easy to learn, and is it practical? Yes. MS Office users should have few problems transitioning into OpenOffice; and its multiple platform availability makes it ideal for collaborative efforts. OpenOffice is available for Windows (2000, NT & XP), Linux, Solaris, Mac OSX (including Mac Intel), Linux PPC, and FreeBSD.

So, if you’re simply looking for a Microsoft Office alternative, looking to collaborate across several platforms, or just trying to save a few bucks, OpenOffice is an efficient and cost-effective tool worthy of your consideration.

================