Data access


Data access is a generic term referring to a process which has both an IT-specific meaning and other connotations involving access rights in a broader legal and/or political sense. In the former it typically refers to software and activities related to storing, retrieving, or acting on data housed in a database or other repository.

Details

Two fundamental types of data access exist:
  1. sequential access
  2. random access
Data access crucially involves authorization to access different data repositories. Data access can help distinguish the abilities of administrators and users. For example, administrators may have the ability to remove, edit and add data, while general users may not even have "read" rights if they lack access to particular information.
Historically, each repository, might require the use of different methods and languages, and many of these repositories stored their content in different and incompatible formats.
Over the years standardized languages, methods, and formats, have developed to serve as interfaces between the often proprietary, and always idiosyncratic, specific languages and methods. Such standards include SQL, ODBC, JDBC, XQJ, ADO.NET, XML, XQuery, XPath, and Web Services.
Some of these standards enable translation of data from unstructured to structured.
Structures such as connection strings and DBURLs
can attempt to standardise methods of connecting to databases.