Pro Mark Data

Data Outsourcing India asked:


Offshore outsourcing refers to the increasing trend of relocating entire business functions to either self-owned or third-party service providers, typically in low-cost locations. Many companies and organizations today prefer to outsource works to offshore locations, as it proves to be a cost effective and more profitable option, and removes management headaches as well.

Data Outsourcing India Divisions offer most comprehensive range of high quality and low cost services ideally suited to every volume range applications. We have skilled and experienced teams to efficiently handle any type of complex data with extreme dynamism, we have expertise for data entry, online data entry, offline data entry, data mining, data cleansing, data digitization, data processing, data conversion, html conversion, adobe pdf conversion, image processing, graphics editing, eNewsLetter design, internet marketing, photo manipulation, data capturing from web, OCR, document scanning, data indexing, web content production, web research, online form processing, catalog processing, email / live chat support, product data entry (for OScommerce, Yahoo Stores, eBay listings, Amazon listings, CRE Loaded, 3d Cart, Volusion, MarketLive, Monster Commerce, AspDotNetStoreFront eCommerce, Xcart eCommerce and other custom built administrative interfaces), website design, electronic presentations.

Our expertise covers a wide range of offshore DATA PROCESSING (forms processing, insurance claim processing, rebate processing, (eCatalog) electronic catalog processing, information processing, transaction processing, resumes processing), offshore DATA CONVERSION (word conversion, adobe pdf conversion, html conversion, xml conversion, xhtml conversion, OCR conversion, text conversion, catalog conversion, directory conversion) and offshore DATA ENTRY (image data entry, book data entry, patient records data entry, coupons data entry, hand written text data entry, receipt data entry, bill data entry, directory data entry, remote desktop data entry, double key data entry) reliable services.

www.dataoutsourcingindia.com

(New Delhi) INDIA

Data Recovery Services asked:


 

It’s a fact that these days more people are capable of recovering their own data in the event of a logical problem. Users are well educated with information freely flowing over the internet as well as software which provides an easy point and click interface or even a good set of instructions. Some companies advertise data recovery as a prime service when all they can do is recover the data in the event of logical failures or viruses. The harm comes to the customer when they either open the drive or make matters worse thus destroying the data or going to the next level and outsourcing. When outsourcing occurs the data is usually passed to a third party and the customer has no knowledge, not only do they have to pay the data recovery fee they have to pay the extra price added by their chosen recovery company.

HDRC (India) has worked in partnership with Droid.IT (UK) to write a data recovery course using HDRC physical data recovery tools. This form of data recovery education is distributed at low cost from HDRC website and on DVD. The main course offered is the 14 day online course (Note the course can be studied offline when purchasing the DVD package).

The course was written with computer shops offering logical recovery services and forensic technicians unable to access data from damaged hard drives in mind. It takes them to the next level; physical data recovery training enables them to carry out most of the jobs they would have to send to other companies thus increasing their own list of services and revenue.

If you search the internet and try to get the information required to start your own recovery center you may then find that what you have learned is outdated. Our computer data recovery training is the hard disk recovery training course you are seeking if you wish to learn at home, work or in your own time. The course covers many aspects of physical data recovery training the end user to recover data from electronic PCB failures, damaged read write heads, USB storage devices and much more.

HDRC offers a full range of courses, for those who don’t know anything about hard drives we suggest you spend some time doing logical recovery research on Google or Wikipedia. We do also offer a logical data recovery course combined with physical data recovery training in our 45 day course. We will be changing our data recovery education packages to recommend the number of hours required to study. Many people already working do not have the time to complete the course in the time frames and the time frames seem long. As the course is deliverable on DVD anyone can study at their own pace.

The training does include training on HDRC products demonstrating in 36 videos how to open the hard drive as well as how to transplant read write heads or platters. When the hard drive is seized your only option for recovery is often to swap the platters to a working donor, can you locate an exact match? Don’t worry we cover all angles in our training, the only issue not covered in depth is firmware which would entail a course all of its own.

Salvationdata asked:


After bringing the failed drive back to life, as a data recovery professional, you know now you need to recover the damaged file system by using data recovery tools; and maybe you know also you need to do a disk imaging in order to work from an accurate, stable hard drive image.

Unfortunately, traditional disk imaging tools and methods are designed for and work on good HDDs only, not the patient HDDs that are unstable or inaccessible because of media defects and instable head, which are common challenges of Stage 2 in practice. Even more, with those traditional imaging tools, the time involved and the ordinary user-level repeated-read access to the media bring a risk of damaging the disk and head, making data lost irretrievable.

But now there’s a better way: The disk probing equipment included in the Data Compass suite bypassing the disk-level problems such as multiple bad sectors, damaged surfaces, malfunctioning head assembly, or corrupted servo info, In the meantime you can use the default software or any other defined software you have been familiar with (R-studio, Winhex, any) to perform file recovery. Through the Data Compass, problem drives will become intact hard drives and ready for file recovery attempts..

What can Data Compass do?

Data recovery from physically damaged HDDs is what Data Compass designed for.

* Data recovery from HDDs with severe multiple BAD sectors, which appear because of platter surface scratch or malfunction or instability of the magnetic head assembly (MHA).

* Data recovery from HDDs that start to produce “clicking” sounds, which may be caused by corruption of sector servo labels or a MHA malfunction. If some heads or surfaces are damaged it is possible (before installation of MHA replacement) to create a copy of data using the remaining good surfaces or drive heads.

* Availability of tools for logical analysis of FAT and NTFS file systems in the software complex allows data recovery in cases, when a drive is functional and only logical data structure is corrupted.

* When used with malfunctioning drives, Data Compass complex often allows selective extraction of data necessary to your customers without reading all data from a drive (”recover data by file” without creating a complete disk image) saving a lot of time. In some cases, when drive malfunctions cause constant self-damage (like scratches on disks or instable MHA) these are the only means to accomplish this task. With the ShadowDisk technology adopted, users need not to worry about the drive degradation problem.

Customer Reviews Of Data Compass:

“The SalvationDATA Data Compass easily helps me get rid of SA bad sectors which can’t be repaired by other drive restoration products we’ve been using before, because it gives access to user data area directly by using its Analog technology which virtually boot the hard drive SA-independently.”

- Yimei Cao, Lead Data Recovery Engineer CBL Data Recovery Technologies Inc. www.cbltech.com

“Data Compass helps us to restore data from hard drives suffer from sever bad sectors, which are not able to be recovered from other tools in the DR market. Especially, by using the advanced Service Area (SA) emulation technology, it accesses the data from firmware defective hard drives directly. Also, multiple settings of the reading algorithm enables the optimization of data recovery from hard drives with poor performance of Head & Disk Assembly (HDA)”

- Zijian Xie, Research and Development Manager Computer Science Labs, UK. www.computersciencelabs.com

Data Compass with Data Compass Explorer is now the premier choice amongst the Data Recovery Industry for fast and effective extraction of data from hard drive’s with severe unreadable sectors, media degradation and failing read/write heads. It is now officially my favourite tool in my vast collection of data recovery solutions and it is only going to get better over time once the new functions are completed. I especially look forward to the head selection function and the future Seagate, Western Digital firmware bypassing options. I’m so impressed I am considering ordering several more in the near future.

Michael Owen, Managing Director Datatrack Labs Ltd. www.datatrack-labs.co.uk

“I’ve started playing with settings of Data Compass and found it quite easy to use. I’ve already carried out a couple of data rescue tests with success and I’m quite satisfied about the performance of the tool.”

- Filippo Corsi Computer Discount Siena www.computerdiscount.it

“I received my Salvation Data Compass last week and I would like to share my experience with you.When I saw the release of Salvation Data Recovery Data Compass I was a bit skeptical about the ROI of this product. Since I’ve been in Data recovery for over 4 years and I manage to do most of my job with my current equipment (PC3K ISA, HDD Duplicator etc…) After reading spec and cases study about this product I decide to go ahead and try it.”

- Francis Parent-Valiquette. www.tux-tech.ca

For More: http://www.salvationdata.com/data-recovery-equipment/data-compass.htm

Recover Data asked:


There is nothing more frustrating than losing your important documents which you’ve created spending precious time. You might have heard the term “Data Recovery” if you are somewhere related with this circumstance. The Concise meaning of the term is to extracting lost, deleted data from damaged, failed, corrupted, or inaccessible hard drives when it cannot be accessed normally with the help of various Data Recovery Software available in the market which is capable of recovering data which has been lost due to many reasons.

Reasons of Data Loss

Data Loss is a fatal situation in which you cannot get access to your important data which has been stored on your hard drives. This data can be your Business Documents, Music files, Personal Pictures and important Emails or anything. What’s the reason for such loss and what steps do we take to overcome to this situation? This Question will come to your mind first when your hard drive gets corrupted.

Before proceeding to the preventions we should first take a look to some of the major causes which led to certain stage of disaster.

Major Reasons of Data Loss

• Virus Attacks - “Virus Attacks increases at the rate of nearly 300-500 new Trojans and viruses every month”. In daily life you are at an ever-increasing risk to become infected with a virus. To prevent yourself against a viral threat is to install an Anti-virus program on your system and scan it regularly to keep yourself update whether your system is infected.

• Hardware or System Problems - When powering on your computer you might hear clicking, buzzing, scrapping and ratting sounds. These are the noises that come when the motor, electronic boards or magnetic platters get damaged due to any electric failure or a head crash. Alternately, the drive might also refuse to spin and results in inaccessible data.

• Human Error - Accidental deletion and overwriting is one of the main reason of data loss that more often happens. This event occurs when you overwrite any existing data or emptied the recycle bin. This is the data loss event of human error category.

• Software Malfunction - Data can also be lost due to some technical defect of failure of some software running on the computer.

• Natural Disaster – Natural disaster can have devastating effect on the physical drive. Data Recovery Software rescued data from fires, floods, lightening strikes and subsequent power surges. The best way to prevent your important data from the arrival of such an unpredictable event is to keep the backup of your documents once in a week.

These are the main five reasons of data loss, from which you should be aware of to avoid your valuable data from being lost. You can prevent yourself from such situation by taking some simple and easy steps.

Ways to Prevent Data Loss

Here I will recommend you some major points to prevent against Data Loss:

• Back-up important data regularly - Using CDs or even an external USB hard drive for data storage can potentially save you from having to hire a data recovery service to perform hard drive data recovery on your hard drive or RAID server.

• Install some sort of Anti-Virus – Viruses infects your computer by reading an infected e-mail, by sharing an infected file and by visiting websites that take advantage of security flaws to compromise and destroy your data.

• Placement of your computer system - Keep your computer system in safe, dry and dust free area to prevent physical damage to the computers.

• Use power surge protectors - A power surge is one of the most common occurrences that can damage your data and potentially cause a hard drive failure.

• Shut down your computer - Always close your programs before shutting down your computer. If you just turn off your computer without properly closing your files, you run the risk of loosing your data.

Conclusion

Trust your data on professionals not hawkers. Do not wait for the worst to happen just call in the professional or choose Do-it–yourself Data recovery Software by searching the terms like “Data Recovery, Data Recovery Software” on the Google toolbar. We at Recover Data assure you to provide best and professional Data recovery software to help you retrieve data or information that has previously been deleted. It can also help you recover any data that has been lost because of virus attacks, power surge, software failures, and more.

George Smith asked:


Data entry is a fastest growing industry. Every business needs accurate data to be successful. Especially today, the pace of business makes it absolutely essential to have up-to-date, detailed information at your fingertips fast.

And so for this reason, getting an access to comprehensive and up-to-date information is a must, as accurate and relevant information is an asset to any kind of scenario, whether it is a small business or big, whether your business is in an infancy state or it is a multinational corporation.

How to prepare data:

Data Preparation involve logging the data in; checking the data for accuracy; entering the data into the computer; transforming the data; developing and documenting of a database structure that assimilates the range of measures. Data entry service providers also provide customized data entry services and suiting the requirements of client companies.

Data entry can be done manually by an individual by adding data by means of typing, and it can also be executed electronically by means of machine that will add data in the database. It is the process of entering data into the computer (spreadsheets and database) which embraces keyboard entry, scanning and voice identification.

There are different types of data entry, such as: data entry for insurance claim, legal formalities, and entry for cards, books, and images. By and large, data entry can be differentiated into two major forms – online and offline data entry.

Data entry can be applied to any process that converts data from one form to another. These services covers almost all business and professional services like data conversion, online and offline data entry, document and image processing, image entry, insurance claim entry, data entry outsourcing, offline as well as online data entry jobs. And also to collect huge data related to certain topics and then to present them in meaningful & easy to understand presentations.

Data entry services also include:

• Online data entry

• Offline data entry

• Data capture and conversion

• Document processing and management

• Medical data entry

• Insurance claim processing

• Outsourcing Data Entry etc.

Every business entails the need of an exact and correct data so they can boom-well in their business. Data entry services cover every aspect of business starting from the scratch as entering data, image Capturing, Imaging Services, Data Catalogue, Image Processing, Image Editing, Document Processing, forms processing etc. So, you can say that data entry services can help you in each and every aspects of your business.

Kishor asked:


 

DATA WAREHOUSE AND ITS APPLICATIONS IN AGRICULTURE

K.P.Wagh                                                                               Dr. Satish R. Kolhe                

Assistant Professor                                                                 Reader                                    

Gf’s GCOE Jalgaon                                                                NMU Jalgaon                         

Kishorwagh2000@yahoo.com                                               srkolhe2000@gmail.com       

 

A Data warehouse is a repository of integrated information, available for queries and analysis.  Data and information are extracted from heterogeneous sources as they are generated.  This makes it much easier and more efficient to run queries over data that originally came from different sources. In other words Data warehouse is a database that is used to hold data for reporting and analysis. 

 Economic foundation and productivity growth depends on agricultural sectors. Agriculture is the driving force behind the way of live and source of earnings for the majority of peoples. More than 60 percents of population are living in rural areas and the majority are farmers. The rural communities as a main producer for country food productivity and food security earn only 11 percents of Gross Domestic Product (GDP). The arrival of information age guides this country to new development strategies.

National Electronics and Computer Technology Center (NECTEC) in collaboration with the Ministry of Agriculture, has launched “Agriculture Information Network” as a response to the unmet information requirements of the agricultural sector. Farmers should gain benefit from the contents provided which include risk assessment, agriculture warning system and agricultural knowledge base, which aim to improve technology, productivity, income and stability of India agriculture sector through the age of Information Technology. The data warehouse consists of common databases and geo-spatial databases from various departments and organizations in the country and abroad. Farmers can get access to the contents through Internet by themselves or from groups of professional people called “Information Brokers”.

 

Keywords: Data Warehouse, Agriculture, IT

 

 

1.    Introduction

A  Data  warehouse [1] is  a  repository  of  integrated  information,  available  for  queries  and analysis.  Data  and  information  are  extracted  from  heterogeneous  sources  as  they  are generated.  This  makes  it  much  easier  and  more  efficient  to  run  queries  over  data  that originally came from  different  sources.  In other words Data warehouse is a database that is used to hold data for reporting and analysis. 

  

Goals of Data Warehousing

To facilitate reporting as well as analysis Maintain an organizations historical information Be an adaptive and resilient source of information Be the foundation for decision making

  

Data Warehouse Architecture

Data warehouse Architecture comprises of

Operational source systems A data staging area One or more conformed data marts A data warehouse database

 

Operational Source Systems

Operational  source  systems [1]  are  developed  to  capture  and  process  original  business transactions.  These  systems  are  designed  for  data  entry,  not  for  reporting,  but  it  is  from here the data in data warehouse gets populated.

 

Data Staging Area

Data staging area  is where  the  raw operational  data is  extracted,  cleaned,  transformed and combined  so  that  it  can  be  reported  on  and  queried  by  users.  This area lies between the operational source systems and the user database and is typically not accessible to users.

 

Data staging is a major process that includes the following sub procedures:

Extraction

The extract  step  is  the  first  step  of  getting  data  into the  data  warehouse  environment. Extracting means reading and understanding the  source data,  and  copying  the pas  that are needed to the data staging for further work.

Transformation

Once  the  data  is  extracted  into  the  data  staging  area,  there  are  many  transformation steps, including

 

1.  Cleaning the data by correcting misspellings, resolving domain conflicts, dealing with         missing data elements, and parsing into standard formats.

2.  Purging selected fields from the legacy data that are not useful for data warehouse.

3.  Combining  data  sources  by  matching  exactly  on  key  values  or  by  performing  fuzzy    matches on non-key  attributes.

4.  Creating  surrogate  keys  for  each  dimension  record  in  order  to  avoid  dependency  on legacy  defined  keys,  where  the  surrogate  key  generation  process  enforces  referential integrity between the dimension tables and fact tables.

5.  Building the aggregates for boosting the performance of common queries.

Loading and indexing

At  the  end  of  transformation  process,  the  data  is  in  the  form  of  load  record  images. Loading  in  the  data  warehouse  environment  usually  takes  the  form  of  replicating  the dimensional  tables  and  fact  tables  and  presenting  these  tables  to  bulk  loading facilitates each  recipient  data mart.  Bulk  loading  is a very important  capability  that  is to  be  contrasted  with  record-at-a  time  loading,  which  is  far  slower.  The target data mart must then index the newly arrived data for query performance.

 

Data Mart

Data  mart  is  a  logical  subset  of  an  enterprise-wide  data  warehouse.  For example, a data warehouse for a retail chain is constructed incrementally from individual, conformed data marts dealing with separate subject areas such as product sales. Dimensional  data  marts  are  organized  by  subject  area  such  as  sales,  finance,  and  marketing  and  coordinated  by  data  category  such  as  customer,  product,  and  location. These  flexible  information  stores  allows  data  structures  to  respond  to  business  changes-product  line  additions,  new  staff  responsibilities,  mergers,  consolidations,  and acquisitions.

  

Data Warehouse Database

A data  warehouse database  contains  the  data  that  is  organized  and  stored  specifically  for direct  user  queries  and  reports.  It  differs  from  an  OLTP  database  in  the  sense  that  it  is

designed primarily for reads not writes. An  OLAP  application  is  a  system  designed  for  few  but  complex  (read  only)  request.  An OLTP  application  is  a  system  designed  for  many  but  simple  concurrent  (and  updating) requests.

 

Metadata

Metadata defines the content and location of the data in the data warehouse, relationships between the operational databases and the data warehouse and the business views of the data in the data in the warehouse as accessible to the end-user tools. Metadata is searched by user to find the subject areas and the definitions of the data.

For decision support, the pointers required to data warehouse are provided by the metadata. Therefore, it acts as logical link between the decision support system application and the data warehouse. Thus, any data warehouse design should assure that there is a mechanism that populates and maintains the metadata repository and that all access paths to data warehouse have metadata as an entry point. In other words there should be no direct access permitted to the data-warehouse data if it does the user metadata definitions to gain the access. Meta data definition can be done by the user in any given data warehousing environment. The software environment as decided by the software tools used will provide a facility for metadata definition in a metadata repository.

 

OLAP Vs OLTP

 

OLTP (Online Transactional Processing)

OLTP servers handle mission-critical production data accessed through simple queries Usually handles queries of an automated nature OLTP applications consist of a large number of relatively simple transactions. Most often contains data organised on the basis of logical relations between normalised tables

• OLAP (Online Analytical Processing)

OLAP servers handle management-critical data accessed through an iterative analytical investigation Usually handles queries of an ad-hoc nature supports more complex and demanding transactions contains logically organised data in multiple dimensions

 

2.    Warehouse Schema Design

Dimensional modeling is a term used to refer a set of data modeling techniques that have

gained popularity  and acceptance for  data  warehouse  implementation.  Dimensional modeling is one of the key techniques in data warehousing.  Two types of tables are used in dimensional modeling: Fact tables and dimensional tables

 

 

 

Fact Tables  

These are used to record actual facts and measures in the business.  Facts are numeric data items that are of interest to the business.  Example, telecommunication- length of call in minutes, average number of calls.

 

Dimensional Tables 

Dimensional tables establish the context of the facts.  Dimensional tables store fields that describe the facts.  Example, telecommunication- call origin, call destination.  A schema is a fact table plus its related dimensional table.

  

3. Crucial Decision in Designing a Data Warehouse

The job of designing and implementing a data warehouse [3] is very challenging and difficult one, even though at the same time, there is a lot of focus and importance attached to it. The designer of the data warehouse may be asked by the top management:”take all enterprise data and build a data warehouse such that the management can get answer to all their questions”. This is daunting task with responsibility being visible and exciting. But how to get started? Where to start? Which data should be put first? Where is that data available? Which query should be answered? How would bring down the scope of project to something smaller and manageable, yet be scalable to gradually upgrade to upgrade to comprehensive data warehouse environment finally?

The recent trend is to build data marts for before a real large data warehouse is built. People want something smaller, so as to get manageable results before proceeding to the real data warehouse.

RALPH KIMBALL identified a nine step method as follows:

Step 1: Choose the subject matter.

Step 2: Decide the what the fact table represents.

Step 3: Identify and confirm the dimension.

Step 4: Choose the facts.

Step 5: Store precalculation in the fact table.

Step 6: Define the dimension and tables.

Step 7: Define the duration of database and periodicity of updation.

Step 8: Track slowly the change in dimension.

Step 9: Decide the query priorities and query modes.

All the above steps are required before the data warehousing is implemented. The final step or step 10 is implemented a simple data warehouse or data mart. The approach should be ‘from simpler to complex’. First only a few data marts are identified, designed and implemented. A data warehouse then will emerge gradually.

Let us discuss the above mentioned steps in detail. Interaction with the user is essential for obtaining answers to many questions. The user to be interviewed includes top management, middle management, executives, as also operational users, in addition to sales force and marketing teams. A clear picture emerges from the entire project on the data warehousing as to what are their problems and how they can be possibly solved with the help of data warehousing.

4.  Various Technology Considerations

The following or technological issues [3] are required to be considered for designing and implementing a data warehouse:

1. The hardware platforms for Data Warehouse

2. DBMS for supporting data warehouse

3. Communication and network infrastructure for a Data Warehouse

4. The system management /operating system platforms

5. The software tools for building, operating and using Data Warehouse

  

Hardware Platform

Organization normally tend to utilize the already existing hardware platform for data warehouse development however the disk storage requirements for a data warehouse will be significantly large, especially in comparison with single application.

If data warehouse or data mart is small in data size, normal Pentium server will be probably sufficient with not very high reliability standards. However for a regular large data warehouse application the server has to be specialized for the tasks associated with a data warehouse. A mainframe, for example is well suited for this purpose, as a data warehouse server. What are the features required for a successful data warehouse server? Firstly it should be able to support large data volume and complex query processing. In addition, it has to be highly scalable. As the user population keeps on growing, the network traffic and the access traffic increase significantly. Therefore, the requirement of data warehouse server is the scalable high performance for data loading and ad hoc query processing as well as the ability to support large database in a reliable and efficient manner. If the querying is going to be on a large public data network then multiprocessor configuration will be required for parallel query processing. In case of a complex server of configuration with multiple processors and large I/O bandwidth a proper balance needs to be made between I/O and processing power.

 

DBMS Selection

Next to hardware solutions a factor most critical is the database selection. This determines the speed performance of the data warehousing environment. The requirement Of a DBMS for data warehousing and requirement are scalability and high volume storage and processing and throughput in traffic.

            The majority of established RDBMS vendors have implemented various degree of parallelism in their products. Even though all the vendors have implemented various degrees of parallelism in their products. Even though all the well known vendors-IBM, ORACLE SYBASE-support parallel database processing, some of them have improved their architectures so as to better suit the specialized requirement of the data warehouse. The RDBMS products provide additional modules for OLAP cubes. The correct choice of OLAP server DB server and web server can be made by the designer or user of Data warehouse depending on the requirement.

 

Communication and Networking Infrastructure

Data warehouse can be internet enabled or intranet enabled as the choice may be. If web enabled the networking is taken care by the internet. If only Intranet based then the appropriate LAN operational environment should be accessible to all the identified users. Thus network expansion may be required as per the needs. In web enabled data warehouses, issues of security privacy and accessibility need to be considered carefully .Accordingly web enablement facilities should be ensured in the software tools used for data warehouse development.

  

Stages in Implementation

A data warehouse cannot be purchased and installed. Its implementation requires the integration of implementation of many products. Following are the steps of the Data Warehouse implementation:

Step 1: Collect and analyze business requirement.

Step2: Create a data model and physical design and data warehouse after deciding the                

            appropriate hardware platform.

Step 3: Define the data sources

Step 4: Choose the DBMS and software platform for data warehouse.

Step 5: Extract the data from operational data sources, translate it, clean-up and load into the      

            data warehouse model or data mart.

Step 6: Choose database access and reporting tools.

Step 7: Choose database connectivity software.

Step 8: Choose the data analysis (OLAP) and presentation (client GUI) software.

Step 9: Keep refreshing the data warehouse periodically.

  

Access Tools

With the exception of SAS(of SAS institute), all the Data Warehouses /OLAP vendors are not currently providing comprehensive single-window software tools capable of handling all aspects of data warehousing project implementation .SAS alone meets the requirement largely independently as it has its own database internally with a capability of import data from any vendor DBMS software. Therefore one can implement a data warehousing and data mining solution independently with SAS.

The best way to choose a group of tools is to understand the capability and compatibility of different type of access to the data and reporting by selecting best tool in market for that kind of access. The types of access and reporting are as follows:

1. Time series analysis 2. Data visualization, graphing, charting and pivoting 3. Complex textual search (text mining) 4. General stastical analysis. 5. Artificial intelligence techniques for hypothesis testing, trends discovery, identification and validation of data clusters and segments(also useful for data mining) 6. Mapping of specifial information into geographic information system 7. Ad hoc user-specific queries 8. Predefined repeatable queries 9. Drilling down interactically 10. Reporting the analysis by drilling down 11. Complex queries with multi-table forces, multilevel sub-queries, sophisticated search criteria.

In some applications, the user requirement may exceed the capability of tools. A number of query tools are available in the market today which enables an ordinary user to build customized reports by easily composing and executing ad hoc queries without any necessity to have the knowledge of the underlying design details or data base technology, SQL, or even the data model

  

5.  Its Applications in Agriculture

  

Project: Agriculture Information System Network (AGRISNET)

Department of Agriculture and Cooperation (DAC) [2] have taken steps to establish “Agricultural Information System Network (AGRISNET)” in collaboration with NIC. The Proposal recommends (i) the state-of-the-art IT infrastructure requirements to establish AGRISNET as the INTRANET over NICNET, (ii) development of databases and information systems for decision support for evaluation, monitoring and policy formulations, and (iii) human resources development, (iv) multi-media based training and demonstration of transfer of technology to strengthen Farm Research and Education using broadcast VSATs, (v) special interest groups in respect of subjects, problems, programmes, schemes, etc, and above all, to make Indian Agriculture on-line for INTERNET and INTRANET access through AGRISNET Nodes. AGRISNET Nodes are envisaged to be established at 

  • DAC Hqrs (Krishi Bhawan), 

  • DAC Attached Offices and its regional offices, 

  • DAC Subordinate Offices and its regional units, 

  • DAC Public Sector Undertakings (NSC&SFCI) and sub-units, 

  • DAC Autonomous Organizations, 

  • Apex Cooperative Organizations 

  • State Agriculture Departments 

  • NCT/UT Agriculture Departments 

  • District Agriculture Offices and 

  • Block Agriculture offices 

In this direction, IFFCO has taken up a project in association with Indian Space Research Organisation (ISRO) to utilise satellite based remote sensing data and Geographical Information Systems (GIS). Attention may be drawn to the fact that the developed countries have been utilising precision farming with the help of IT tools for a long time. While this will take a long time for our country due to small holdings, it is to be noted that GIS has an invaluable role to play even in the existing conditions. Remote sensing and GIS information can provide warnings on evolving crop stresses, crop vigour, etc.

The IFFCO-ISRO GIS project extends support for efficient and timely availability of IFFCO’s fertiliser to farmers though better logistics & efficient operations. It endeavours to provide farmers’ advisory services to provide decision support to farmers on land related issues, weather, etc. In addition to the GIS based services, effort is being made to create databases that contain information of interest to the farmers. These include recommendation on package of practices for major cereals, pulses, horticulture, floriculture and animal husbandry, etc.Information on all the inputs such as seeds, fertiliser, sources, current availability, prices, availability of credit, alternatives available and terms and conditions, etc. are sought to be provided. An important service envisaged is to provide access to the nearest expert in case of stress or any other problem witnessed in the crops. Facilities are sought to be provided to encourage and share farm experiences by forging various crop forums. Many of the agricultural extension services are also proposed to be made online using aspects of multimedia.

In order to encourage farmers to obtain best possible price, information on various agricultural output markets (mantis) is also being provided. The objective of this activity is to provide status of price at different mandies to facilitate farmer to move his produce to the mandi where he can expect better price. Other areas of interest to farmers such as distance education, location specific news, etc. are also planned. Access to other related sites of interest such those relating to courts, health, etc. are also sought to be provided.

  

6.  Conclusions

Analytical exploration of vast amount of agricultural data can best be support by appropriate application of Data Warehousing and OLAP technologies. A Data Warehouse provides efficient and reliable structure of storage for vast amount data while OLAP techniques provide mechanisms for analysis of this data.

 

7.  References

[1] Data warehouse and its applications in Agriculture, Anil Rai, Indian Agricultural Statistics Research Institute Library Avenue, New Delhi.

[2] Information Technology in Agriculture, S.C. Mittal.

[3] Data Warehousing concepts, Techniques, Products and Applications, C.S.R.Prabhu.

 

  

Data Recovery Software asked:


Have you ever experienced disk failure, Loss of important data can put you in most adverse condition and even cause business failure? Following are some of the salient features of tools which made Datarecoverysoftawre.com leading developer of Data Recovery Software for Windows.

User friendly: Our development team has made design of software so simple that even people without having much knowledge of computer can easily use the application. Interactive graphical user interface (GUI) has made the tool quite user friendly.

Robustness: There are numerous causes that can cause data loss; loss of important data can be really devastating. The software is efficient enough to recovery data from damaged hard disk, what so ever is the cause hard disk failure.

Time saving: Data Doctor’s Recovery Software offers perfect alternate of time taking physical data recovery process carried out in cost laboratories. The application is easy to install and can recover all your lost files and folders with in no time.

Flexible: Data Recovery Software for FAT is flexible enough to recover more than 300 different types of files from disaster stricken computer hard disk, where other folders undelete tool or file rescue program fails even to display lost data.

Windows Compatibility: Data Doctor’s recovery tools are compatible to all major versions of Microsoft® Windows™ operating systems from 2000 to VISTA including latest Windows 7. The application can be easily install/uninstall with few clicks of mouse.

Easy to use: Data Recovery Software for FAT contains simple and well guided help manual. The Inbuilt help manual offers step by step instruction to the user and enable him to easily understand software functionality with having advance computer skill.

More Info At: http://www.datarecoverysoftware.com/datarecoverysoftware/data-recovery-fat.html

Download URL: http://www.datarecoverysoftware.com/downloads/fat-data-recovery-demo.exe

Data Recovery Software asked:


Data Doctor Recovery TM is pioneer in developing windows data recovery software which offers economical and faster way of do it yourself recovery process. We are leading developers of professional and user interactive data recovery software and have maintained outstanding records in the field of data recovery. Following are some of the remarkable features of datarecoverysoftware.com which makes it noticeable within the crowd of software providers.

Easy to use: Data Recovery Software for Memory Cards contains simple and well guided help manual. The Inbuilt instruction manual offers step by step assistance to the user and enables him to easily understand software functionality without having advance computer skill.

Windows based: We continuously work in Data Doctor’s Lab to develop updated versions of data recovery software to make it compatible to all new editions of Microsoft® Windows™ operating systems. Our latest Data Recovery Software for Memory Cards can be easily installed in Windows 7 based system.

24X7 helpline: Our well equipped technical support team is pledged to provide online support 24 hours a day and 7 days a week to our valuable customer all around the globe. Data Doctor Recovery has maintained remarkable 99% customer satisfaction rate.

Flexible: Data Recovery Software for Memory Cards is flexible enough to recover more than 300 different types of files from disaster stricken multimedia storage cards, where other card undelete tool or file rescue program fails even to display lost files.

Automated: Data Doctor’s advance tool provides thumbnail preview of all lost and deleted files and folders before starting recovery process, in order to facilitate users to have selective of complete data recovery.

More Info At:

 http://www.datarecoverysoftware.com/datarecoverysoftware/data-recovery-memorycards.html

Download URL:

http://www.datarecoverysoftware.com/downloads/memory-card-data-recovery-demo.exe