Use and application of the External Databases for data organization and
storage

Iuliana Iatan; Jyoti Kumar Arora

doi:https://doi.org/10.14445/22315373/IJMTT-V4I2P501

International Journal of Mathematics Trends and Technology

Research Article | Open Access | Download PDF

Volume 4 | Issue 2 | Year 2013 | Article Id. IJMTT-V4I2P501 | DOI : https://doi.org/10.14445/22315373/IJMTT-V4I2P501

Use and application of the External Databases for data organization and storage

Iuliana Iatan ,Jyoti Kumar Arora

Citation :

Iuliana Iatan ,Jyoti Kumar Arora, "Use and application of the External Databases for data organization and storage," International Journal of Mathematics Trends and Technology (IJMTT), vol. 4, no. 2, pp. 16-2, 2013. Crossref, https://doi.org/10.14445/22315373/IJMTT-V4I2P501

Abstract

The external databases are some files which stock the information. We can create, edit or recover an immense volume of databases when we shall use the external databases for data organization and storage. AutoCAD offers the tools which allow us to work with some files that contain the external databases: we can open a database for data viewing or editing, we can bind the database records with the AutoCAD objects (lines, circles, and so on), we can execute the queries in order to recover a data subset based on some criterions. AutoCAD is designed such that to assure the access to the external database files without to use the application of database creation. AutoCAD recognizes the databases which have been created with the following Database Management Systems: Access, dBase, Excel, Oracle, Paradox, Visual FoxPro, SQL Server. We shall design an Access database in our paper.

Keywords

external databases, AutoCAD objects, Access database, OLE DB configuration file, table, record, drawing, link, query

References

[1] M. Băduț, Calculatorul în trei timpi, Ed. Polirom, |Iași, 2003
[2] B. Burchard, D. Pitzer, Totul despre AutoCAD 2000, P ed. Teora, Bucureşti, 2001
[3] C. Crișan, B. Pătruț, E. Nechita, I. Furdu, Tehnologia informației, EduSoft, Bacău, 2006
[4] I. Iatan, Curs de Access 2010, ed. MatrixRom, Bucureşti, 2010
[5] H. B. Pitzer, AutoCAD 2002, ed. Teora, Bucureşti, 2002
[6] A. Teodorescu, Lecţii de Access, grupul microINFORMATICA, Cluj-Napoca, 2002
[7] J. Wooden, Learning AutoCAD 2005, SDC Publications, 2005