Browsing articles in "SQL"
Sep
10
2012

What is an Open Source Database?

MySQL PostgreSQL

Open source is a kind of design where you can immediately access any kind of information from a set group with less hassle.  This method has been closely studied by various companies to see whether this method can be used for their business.  It has also reached technology in the form of open source database. The term itself, open source, has been gaining popularity with the development of technology, such as computers and Internet, which allows large numbers of users to tap into their sources [...]

Mar
14
2012

What is an Oracle Database?

Oracle Database

Databases are very important for web owners.  They have come a long way since the early days of computing.  Database systems have become more and more complicated.  Although the focus nowadays have shifted from making databases to maintenance, that doesn’t mean everything has been less difficult.  IT professionals nowadays are required certification by companies to make sure that they are updated.  Technology has been moving in a fast pace, and the new version is always around the corner.  One of the companies that make databases [...]

Mar
4
2012

What is JDBC or Java Database Connectivity?

Java Duke - Butler

Java Database Connectivity is basically a framework that supports the programs in order to access files from databases, flat files and spreadsheets. The Java database connectivity works by making connections with the user program and transforming into a “backstage” access to the database, regardless of the type of database management system used. Moreover, Java Database Connectivity is an application program interface for Java programs that allows users to gain access on pertinent data by the use of queries. With the use of the Java Database [...]

Mar
4
2012

What is ODBC or Open Data Base Connectivity?

ODBC Screens

ODBC is the short term used for Open Database Connectivity. It is the interface used by programmers to be able to use databases using SQL queries. ODBC is also defined as another method of accessing information that is stored in your computers or even in your office. You can use ODBC to access the databases from Microsoft Access, Excel and dBase. In the perspective of the end-user, ODBC is the best way of accessing information stored in another database without the need of understanding how [...]

Mar
4
2012

What is SQL or Structured Query Language?

SQL Database

A structured query language or SQL is a database language used to retrieve information from a database management system. The SQL is considered as the standardized language for programming, extracting and managing files from the database. The SQL is standardized by both the American National Standardized Institute (ANSI) and the International Organization for Standardization (ISO). This means that many databases support the SQL. SQL allows users to extract, edit, supplement and remove data from the database. Moreover, the SQL has a call level interface, which [...]

Jan
4
2012

What is a Database Query?

Database Query Example

People create a database because they want to organize the data in such a way that they can glean useful information from it. These data can be accessed by using a query. A query, if properly stated, will extract data from the database. For example, a businessman creates a database which contains the list of his products, their prices, and the number of people who bought them. If he wants to find out which products are most expensive, he can input a query into the [...]

Advertisements