|
XML For Analysis
XML for Analysis (XMLA) is an industry standard for data access in analytical systems, such as online analytical processing (OLAP) and data mining. XMLA is based on other industry standards such as XML, SOAP and HTTP. XMLA is maintained by XMLA Council with Microsoft, Hyperion and SAS Institute being the XMLA Council founder members. History The XMLA specification was first proposed by Microsoft as a successor for OLE DB for OLAP in April 2000. By January 2001 it was joined by Hyperion endorsing XMLA. The 1.0 version of the standard was released in April 2001, and in September 2001 the XMLA Council was formed. In April 2002 SAS joined Microsoft and Hyperion as founding member of XMLA Council. With time, more than 25 companies joined with their support for the standard. API XMLA consists of only two SOAP methods: execute and discover. It was designed in such a way to preserve simplicity. Execute Execute method has two parameters: * Command - command to be executed. It can be ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Online Analytical Processing
In computing, online analytical processing (OLAP) (), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term ''OLAP'' was created as a slight modification of the traditional database term online transaction processing (OLTP). OLAP is part of the broader category of business intelligence, which also encompasses relational databases, report writing and data mining. Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas, with new applications emerging, such as agriculture. OLAP tools enable users to analyse multidimensional data interactively from multiple perspectives. OLAP consists of three basic analytical operations: consolidation (roll-up), drill-down, and slicing and dicing.O'Brien, J. A., & Marakas, G. M. (2009). Management information systems (9th ed.). Boston, MA: McGraw-Hill/Irwin. Consolida ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Data Mining
Data mining is the process of extracting and finding patterns in massive data sets involving methods at the intersection of machine learning, statistics, and database systems. Data mining is an interdisciplinary subfield of computer science and statistics with an overall goal of extracting information (with intelligent methods) from a data set and transforming the information into a comprehensible structure for further use. Data mining is the analysis step of the " knowledge discovery in databases" process, or KDD. Aside from the raw analysis step, it also involves database and data management aspects, data pre-processing, model and inference considerations, interestingness metrics, complexity considerations, post-processing of discovered structures, visualization, and online updating. The term "data mining" is a misnomer because the goal is the extraction of patterns and knowledge from large amounts of data, not the extraction (''mining'') of data itself. It also is a buzzwo ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
SOAP
Soap is a salt (chemistry), salt of a fatty acid (sometimes other carboxylic acids) used for cleaning and lubricating products as well as other applications. In a domestic setting, soaps, specifically "toilet soaps", are surfactants usually used for washing, bathing, and other types of housekeeping. In industrial settings, soaps are used as thickeners, components of some lubricants, emulsifiers, and catalysts. Soaps are often produced by mixing fats and oils with a Base (chemistry), base. Humans have used soap for millennia; evidence exists for the production of soap-like materials in ancient Babylon around 2800 BC. Types Toilet soaps In a domestic setting, "soap" usually refers to what is technically called a toilet soap, used for household and personal cleaning. Toilet soaps are salts of fatty acids with the general formula (Carboxylate ion, RCO2−)M+, where M is Sodium, Na (sodium) or Potassium, K (potassium). When used for cleaning, soap solubilizes particles and g ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
HTTP
HTTP (Hypertext Transfer Protocol) is an application layer protocol in the Internet protocol suite model for distributed, collaborative, hypermedia information systems. HTTP is the foundation of data communication for the World Wide Web, where hypertext documents include hyperlinks to other resources that the user can easily access, for example by a Computer mouse, mouse click or by tapping the screen in a web browser. Development of HTTP was initiated by Tim Berners-Lee at CERN in 1989 and summarized in a simple document describing the behavior of a client and a server using the first HTTP version, named 0.9. That version was subsequently developed, eventually becoming the public 1.0. Development of early HTTP Requests for Comments (RFCs) started a few years later in a coordinated effort by the Internet Engineering Task Force (IETF) and the World Wide Web Consortium (W3C), with work later moving to the IETF. HTTP/1 was finalized and fully documented (as version 1.0) in 1996 ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Microsoft
Microsoft Corporation is an American multinational corporation and technology company, technology conglomerate headquartered in Redmond, Washington. Founded in 1975, the company became influential in the History of personal computers#The early 1980s and home computers, rise of personal computers through software like Windows, and the company has since expanded to Internet services, cloud computing, video gaming and other fields. Microsoft is the List of the largest software companies, largest software maker, one of the Trillion-dollar company, most valuable public U.S. companies, and one of the List of most valuable brands, most valuable brands globally. Microsoft was founded by Bill Gates and Paul Allen to develop and sell BASIC interpreters for the Altair 8800. It rose to dominate the personal computer operating system market with MS-DOS in the mid-1980s, followed by Windows. During the 41 years from 1980 to 2021 Microsoft released 9 versions of MS-DOS with a median frequen ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Oracle Hyperion
Hyperion Solutions Corporation was a software company located in Santa Clara, California, which was acquired by Oracle Corporation in 2007. Many of its products were targeted at the business intelligence (BI) and business performance management markets, and were developed and sold as Oracle Hyperion products. Hyperion Solutions was formed from the merger of ''Hyperion Software'' (formerly IMRS) and ''Arbor Software'' in 1998. History * 1981 - IMRS founded by Bob Thomson and Marco Arese * 1983 - IMRS launches financial and management consolidation software called "Micro Control" * 1985 - IMRS hires Jim Perakis as CEO; he remains in this position during growth from $1M to almost $300M * 1991 - IMRS becomes a public company and launches a Windows-based successor to 'Micro Control' called 'Hyperion' * 1992 - Arbor Software ships first version of Essbase Online Analytical processing OLAP software * 1995 - Due to the success of the "Hyperion" product IMRS changes name to "Hyperion ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
SAS Institute
SAS Institute (or SAS, pronounced "sass") is an American multinational developer of analytics and artificial intelligence software based in Cary, North Carolina. SAS develops and markets a suite of analytics software ( also called SAS), which helps access, manage, analyze and report on data to aid in decision-making. The company's software is used by most of the Fortune 500. SAS Institute started as a project at North Carolina State University to create a statistical analysis system, in fact SAS originally stood for "Statistical Analysis System", though it is no longer considered an acronym. It was originally used primarily by agricultural departments at universities in the late 1960s. It became an independent, private business led by current CEO James Goodnight and three other project leaders from the university in 1976. SAS is one of the largest privately held software providers in the world, and the company's software is used by most of the Fortune 500. The company's reve ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
OLE DB For OLAP
OLE DB for OLAP (Object Linking and Embedding Database for Online Analytical Processing abbreviated ODBO) is a Microsoft published specification and an industry standard for multi-dimensional data processing. ODBO is the standard application programming interface (API) for exchanging metadata and data between an OLAP server and a client on a Windows platform. ODBO extends the ability of OLE DB to access multi-dimensional (OLAP) data stores. Description ODBO is the most widely supported, multi-dimensional API to date. Platform-specific to Microsoft Windows, ODBO was specifically designed for Online Analytical Processing (OLAP) systems by Microsoft as an extension to Object Linking and Embedding Database ( OLE DB). ODBO uses Microsoft’s Component Object Model. ODBO permits independent software vendors (ISVs) and corporate developers to create a single set of standard interfaces that allow OLAP clients to access multi-dimensional data, regardless of vendor or data source. ODBO is c ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Hyperion Solutions Corporation
Hyperion Solutions Corporation was a software company located in Santa Clara, California, which was acquired by Oracle Corporation in 2007. Many of its products were targeted at the business intelligence (BI) and business performance management markets, and were developed and sold as Oracle Hyperion products. Hyperion Solutions was formed from the merger of ''Hyperion Software'' (formerly IMRS) and ''Arbor Software'' in 1998. History * 1981 - IMRS founded by Bob Thomson and Marco Arese * 1983 - IMRS launches financial and management consolidation software called "Micro Control" * 1985 - IMRS hires Jim Perakis as CEO; he remains in this position during growth from $1M to almost $300M * 1991 - IMRS becomes a public company and launches a Windows-based successor to 'Micro Control' called 'Hyperion' * 1992 - Arbor Software ships first version of Essbase Online Analytical processing OLAP software * 1995 - Due to the success of the "Hyperion" product IMRS changes name to "Hyperion ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Multidimensional Expressions
Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is a query language for OLAP cubes. It is also a calculation language, with syntax similar to spreadsheet formulae. Background The MultiDimensional eXpressions (MDX) language provides a specialized syntax for querying and manipulating the multidimensional data stored in OLAP cubes. While it is possible to translate some of these into traditional SQL, it would frequently require the synthesis of clumsy SQL expressions even for very simple MDX expressions. MDX has been embraced by a wide majority of Comparison of OLAP servers, OLAP vendors and has become the De facto standard, standard for OLAP systems. History MDX was first introduced as part of the OLE DB for OLAP specification in 1997 from Microsoft. It was invented by the group of Microsoft SQL Server, SQL Server engineers including Mosha Pasumansky. The specification was quickly f ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Data Mining Extensions
Data Mining Extensions (DMX) is a query language for data mining models supported by Microsoft's SQL Server Analysis Services product. Like SQL, it supports a data definition language (DDL), data manipulation language (DML) and a data query language (DQL), all three with SQL-like syntax. Whereas SQL statements operate on relational tables, DMX statements operate on data mining models. Similarly, Microsoft SQL Server supports the MDX language for OLAP databases. DMX is used to create and train data mining models, and to browse, manage, and predict against them. DMX is composed of data definition language (DDL) statements, data manipulation language (DML) statements, and functions and operators. Queries DMX Queries are formulated using the SELECT statement. They can extract information from existing data mining models in various ways. Data definition language The data definition language (DDL) part of DMX can be used to * Create new data mining models and mining structures - ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
OLEDB
OLE DB (''Object Linking and Embedding, Database'', sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft that allows accessing data from a variety of sources in a uniform manner. The API provides a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. Microsoft originally intended OLE DB as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement. Methodology OLE DB separates the data store from the application that needs access to it through a set of abstractions that include the datasource, session, command, and rowsets. This was done because different applications need access to different types and sources of data, and do not necessarily want to know how to access functionality with technology-specific methods. OLE DB is conceptually divided into ''cons ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
