• Main Menu
  • Databases

    • 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

    • Database Normalization

      Database Normalization

      Database normalization is the process of organizing data into distinct and unique sets. The purposes of normalization are to: Reduce or eliminate storage of duplicate data Organize data into an efficient and logical structure The process of normalization involves determining what data should be stored in each database table. By tradition, the process of normalization

    • 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

    • Data Dictionary

      Data Dictionary

      A data dictionary is an integral part of a database. It holds information about the database and the data that it stores, i.e., the meta-data. Any well designed database will surely include a data dictionary as it gives database administrators and other users easy access to the type of data that they should expect to

    • Data Management

      Data Management

      Data Management is a broad field of study, but essentially is the process of managing data as a resource that is valuable to an organization or business. One of the largest organizations that deal with data management, DAMA (Data Management Association), states that data management is the process of developing data architectures, practices, and procedures

    • 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

    • 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

    102 queries in 0.316 seconds.