Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 31-08-2009
Member
 
Join Date: Jul 2009
Posts: 2
Indexed Sequential Access Method

I recently heard about Indexed Sequential Access Method I don't know much about it... Can anybody give some information on it... Please Help... What it is???
Reply With Quote
  #2  
Old 31-08-2009
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: Indexed Sequential Access Method

ISAM stands for Indexed Sequential Access Method, a method for indexing data for fast retrieval. ISAM was originally developed by IBM for mainframe computers. Today the term is used for several related concepts:
  • Specifically, the IBM ISAM product and the algorithm it employs.

  • A database system where an application developer directly uses an Application Programming Interface to search indexes in order to locate records in data files. In contrast, a relational database uses a query optimizer which automatically selects indexes.

  • An indexing algorithm that allows both sequential and keyed access to data. Most databases now use some variation of the B-Tree for this purpose, although the original IBM ISAM and VSAM implementations did not do so.

  • Most generally, any index for a database. Indexes are used by almost all databases, both relational and otherwise.
Reply With Quote
  #3  
Old 31-08-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: Indexed Sequential Access Method

Here are some ISAM Software :

Real Isam DLL 2.3
FoxPro2MySQL SYNC 1.0.0
Access2MySQL SYNC 4.4.0
blueshell Data Guy 2.02.0002
DBSync for Access & MySQL 5.0
SQLWave MySQL GUI 3.2
MySQL2PostgreSQL Sync 1.2.0
DBForms from MS Access to PHP + MySQL 2.1.1
AccessForms2Web (PHP&MySQL Editon) 1.1.0
Access-MySql 2.5
Access MySql 2.5.1
MicroOLAP Database Designer for MySQL 1.9.6
Access-MySql Converter 3.0
EngInSite MySQL Client 1.4.9.175
AccessForms2Web (PHP and MySQL Editon) 2.1.0
DBConvert for MS SQL & MySQL 2.1.0
Access2MySQL PRO 5.6.0
Reply With Quote
  #4  
Old 31-08-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: Indexed Sequential Access Method

how to use Jet OLE DB Provider 4.0 to connect to various external databases through installable ISAM drivers. Connection strings are provided for opening each ISAM database.

Open Excel
The following code opens an Excel ISAM database:
Code:
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\ExcelFile.xls;" & _
           "Extended Properties=""Excel 8.0;HDR=Yes;"";"

Open dBASE
The following code opens a dBASE ISAM database. If a dBASE file (for example, dBaseFile.dbf) is located at c:\somepath, where C is the drive, and where somepath is the folder that contains dBaseFile.dbf, as follows:

Code:
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
          "Data Source=c:\somepath;" & _
          "Extended Properties=DBASE III;"

Open Lotus 1-2-3
The following code opens a Lotus 1-2-3 ISAM database:

Code:
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath\Lotus123File.wk3;" & _
           "Extended Properties=Lotus WK3;"

Open Paradox
The following code opens a Paradox ISAM database. If a Paradox 5.0 file (for example, PdxFile.db) is located at c:\somepath, where C is the drive, and where somepath is the folder that contains PdxFile.db, as follows:

Code:
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
           "Data Source=c:\somepath;" & _
           "Extended Properties=Paradox 5.x;"
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Indexed Sequential Access Method"
Thread Thread Starter Forum Replies Last Post
Need to append a sequential number to a date field in access $Jaganmohini$ Windows Software 4 04-02-2011 07:39 PM
Why Google did not indexed my pages hAROON oR hOPE Technology & Internet 5 16-01-2011 07:06 AM
How to get indexed fast The*Conqueror Technology & Internet 4 16-01-2011 04:32 AM
First 'Sequential Day' in more than 20 years sampatakar Off Topic Chat 1 10-09-2010 10:10 AM
Help for Indexed-sequential file organized in Java Dewei Software Development 5 27-07-2010 11:43 PM


All times are GMT +5.5. The time now is 04:43 AM.