There are two fundamental types of data warehouses: • Enterprise Data Warehouses (EDW) • Data Marts Enterprise Data Warehouse (EDW): The enterprise data warehouse is typically a large organization-wide database repository that crosses over every business function and includes data from every organizational unit, division, and department. In essence, an enterprise data warehouse is a […]
Data federation is a category of data integration technology that provides the ability to query and aggregate data from disparate sources in a virtual database so it can be used by business intelligence, reporting, or analysis applications in real-time. The virtual database created by data federation technology doesn’t contain the data itself. Instead, it contains […]
A completely unique data warehouse appliance is provided by Datatupia. Rather than providing a solution that provides an organization a complete data warehouse solution, Datatupia’s solution compliments existing data warehouse deployments within an organization. Dataupia’s flagship product, Satori Server Datatupia is a data warehouse appliance in the sense that it combines software and hardware components […]
Starting in 2006, a new wave of vendors emerged that focus on database management systems (DBMS) purpose-built for data warehousing that easily integrate with another vendor’s hardware. The products from these “partial-solution” data warehouse appliance vendors have been coined as “software appliances”. The software appliance has proved to be a good starting point for new […]
Complete data warehouse appliances are purpose-built data warehouse solutions and systems that encompass a whole-technology stack including: • Operating System (OS) • Database Management System (DBMS) • Server Hardware • Storage Capabilities Initially DW appliances were created with proprietary custom-built hardware and storage units. Netezza, Teradata, DATAllegro, & White Cross (now Kognito) were the first […]
Announced by CEO Larry Ellison at the 2008 Oracle OpenWorld conference in San Francisco, Oracle Exadata Database Machine is a complete database appliance with support for both transactional (OLTP) and analytical (OLAP) database systems. Delivered as a complete package of database software, operating system, servers, and storage, the Oracle Exadata Database Machine is simple and […]
At the Sapphire conference in May, 2010, SAP announced the release of its new data warehouse appliance called HANA or High-Performance Analytic Appliance. SAP HANA is a combination of hardware, storage, operating system, management software, and in-memory data query engine that is characterized by data being held in RAM rather than being read from disks or […]
Query as a Web Service (QAAWS) is a technique within the SAP Business Objects suite that allows for creation and publishing of web services. Subsequently web services are utilized to integrate data between a Business Objects Universe and an Xcelsius Dashboard. The QAAWS client tool provides the dashboard developer an intuitive wizard that to create […]
Xcelsius is the primary dashboard development tool of the SAP BusinessObjects suite of business intelligence products. Xcelsius extends the power of business intelligence environments by offering interactive devices including gauges, charts, widgets, drop-down menus, and sliders. These intuitive and user-friendly devices simplify the display of complex business data and provide decision makers with an easy […]
Register today and plan to attend the ASUG North Carolina – Virginia Chapter Meeting on Friday, March 25, 2011. Don’t miss your chance to learn from the real experience of ASUG members in your area at this educational and networking event. Registration is now open and is included as part of your ASUG member benefits. […]