• Main Menu
  • Databases

    • ODBC (Open Database Connectivity)

      ODBC (Open Database Connectivity)

      ODBC (Open Data Base Connectivity) is an interface to access databases via SQL queries. ODBC can be used as an access tool to various databases such as MS-Access, dBase, DB2, Excel, and Text. Through these Call Level Interface (CLI) specifications of the SQL Access Group, the OBDC allows a neutral way of accessing the data

    • OLAP Cube

      OLAP Cube

      When a company or organization wants to combine all of their information and resources into one stockpile for easier analysis and research, they use the OLAP cube to comprehensively link and find the information that they need. OLAP cubes allow you to add fact sheets of information to a specific product or project and then

    • MOLAP

      MOLAP

      MOLAP is the term used to refer to multidimensional online analytical processing. It extends traditional OLAP processing through indexing directly into a multidimensional database. This allows users to view various data aggregates in different manners without the added overhead required to conduct similar operations with a relational database. Advantages and Disadvantages of MOLAP Some of

    • Free Database Software

      Free Database Software

      MySQL The MySQL database server is the world’s most popular open source database server. Over six million installations use the MySQL database server to power high volume websites and other mission critical business systems including industry leaders like NASA, Yahoo, The Associated Press (AP), Suzuki, and Sabre Holdings. MySQL is an attractive alternative to high

    • Data Mining

      Data Mining

      Data mining is usually defined as searching, analyzing and sifting through large amounts of data to find relationships, patterns, or any significant statistical correlations. With the advent of computers, large databases and the internet, it is easier than ever to collect millions, billions and even trillions of pieces of data that can then be systematically

    • Data Mart

      Data Mart

      Most people are familiar with terms like data warehousing, data mining, and data cleansing, but fewer people are familiar with data mart. A data mart is a subsection of a data warehouse that deals with specific information. Much like the chapters of a book, a data mart contains related information that deals with the same

    • Multimedia Database

      Multimedia Database

      A multimedia database is a database that hosts one or more primary media file types such as .txt (documents), .jpg (images), .swf (videos), .mp3 (audio), etc. And loosely fall into three main categories: Static media (time-independent, i.e. images and handwriting) Dynamic media (time-dependent, i.e. video and sound bytes) Dimensional media (i.e. 3D games or computer-aided

    • Transactional Database

      Transactional Database

      A transactional database is a database management system (DBMS) that has the capability to roll back or undo a database transaction or operation if it is not completed appropriately. Although this was a unique capability several decades ago, today the majority of relational database systems support transactional database operations. What is a Database Transaction? Whenever

    • Relational Database

      Relational Database

      A relational database stores data in separate tables instead of placing all data in one large table. It then allows Data Base Administrators (DBAs) to define relationships between these tables. These relationships enable DBAs to combine data from several tables for querying and reporting. This is accomplished through the use of keys, which are database

    • DSN (Data Source Name)

      DSN (Data Source Name)

      A DSN (Data Source Name) is an identifier that is used to store information relating to a database connection. DSNs can store a database’s name and server location, the directory that is used to store offline content, the database driver, and the user’s ID and password. DSNs can be used for a wide variety of

    databases
    151 queries in 0.215 seconds.