X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 olap oltp


SAP HANA: From Database to Platform
At the end of 2009, SAP launched SAP HANA, an in-memory, column-row based database management system with capabilities within both OLTP and OLAP environments

olap oltp  within both OLTP and OLAP environments. In June of 2012, SAP announced that HANA had become the fastest growing technology in the company’s history. In this report, TEC Senior BI and Data Management Analyst Jorge García gives an overview of the history, functionality, and benefits and challenges of SAP HANA, and explores SAP’s strategy for the product and its place in the in-memory processing product space.

Read More


Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Documents related to » olap oltp

Analyse This


Enterprise applications have long been providing the means for businesses to collect required data and deliver it to the right people. Now that sales and marketing professionals are empowered with the right tools to better serve their customers and gather insights on all customers' interactions, the question to ask is what's next? We see the answer in a tight integration between Enterprise applications and Analytics.

olap oltp  reporting, online analytic processing (OLAP), and data mining. These technologies have traditionally been distinct and not integrated, which has resulted in segregation of user communities unable to share information. There is now an awakening to the potential as more predictive analytics capabilities are appearing embedded with packaged CRM, ERP and SCM applications, where they're accessible to a broad set of users who previously relied on spreadsheets, gut instinct, or a separate analytics department. Read More

SAP Releases HANA SPS5


During SAP's SAPPHIRE NOW conference in Madrid, the recent support pack for HANA was released (SPS5), providing additional capabilities to HANA's functionality set. Along with enhancements for mission-critical applications, SAP has worked on HANA's architecture to collapse the different layers of the platform—data and application, so that both reside within an in-memory-based architecture.

olap oltp  breakthrough performance for OLTP, OLAP, and unstructured data apps in one platform. Following up on delivery of SAP Business One on SAP HANA in the third quarter, we have now demonstrated the mission-critical OLTP capabilities of SAP HANA by delivering SAP CRM on SAP HANA. I am also proud that we have delivered application services in SAP HANA, thereby collapsing the divide between application services and database and optimizing across layers, a true example of timeless software. SAP is aiming to Read More

SAP HANA-One Technology to Watch in 2012 (and Beyond)


Did you know that SAP HANA is much more than a high-speed analytic appliance? TEC principal analyst P.J. Jakovljevic reveals how HANA is a universal database that will enable companies to analyze large volumes of operational and transactional information in real time, from virtually any data source, and that will eventually deliver an entirely new class of applications that will change the way people think, work, plan, and operate.

olap oltp  configured as either an OLAP or OLTP database, and by and large most traditional relational databases can be organized for one or the other purpose. It is quite difficult (and perhaps even pointless) to unify OLAP and OLTP worlds via currently available technologies, as each has its own specific requirements. Facebook reportedly uses multiple databases for different purposes: a relational database for user logging and data storing, a NoSQL (Not only SQL) database for unstructured data handling and Read More

Business Intelligence: Its Ins and Outs


In today's highly competitive business climate, the quality and timeliness of business information for an organization is not only a choice between profit and loss, it is a question of survival or bankruptcy. No business organization can deny the inevitable benefits of business intelligence.

olap oltp  dashboards , OLTP , OLAP , data mining , alerting and notification systems , and analytics . Under the BI umbrella all these tools are combined within a special architecture. Data Warehouses and Data Mart Because data can come from various sources, like OLTP, ERP, CRM, legacy applications, and external data sources, data can be stored in a diversified database, in different formats and structures. As a result, a data warehouse (DW), is the most important and expensive player in the whole BI system Read More

What is the Value of Real-Time Data?


What do you consider real-time information? When you pull information from your shop floor and back office, your reports should be run against live data, not data that is delayed. Too many manufacturers miss out on critical decision-making pieces of the puzzle because of a lack of timely production details. The solution to this information delay can be an online transaction processing (OLTP) system...find out more in this white paper from IQMS.

olap oltp  real-time, IQMS, live data, real-time data, OLTP, online transaction processing, shop floor information, shop floor data Read More

TDWI Checklist Report: Analytic Databases for Big Data


Many organizations in today's “big data” world are contemplating a replacement of their analytic databases and data warehouses to keep pace with new requirements for advanced analytics, and they are turning more and more to specialized analytic database management systems (DBMSs). Within the DBMS arena, there’s a slow trend away from practicing analytics with relational DBMSs that were originally designed for OLTP and towards analytic databases that provide computing architectures designed for complex queries, analytic algorithms, high performance, and terabyte-size scalability. This TDWI Checklist Report presents requirements for analytic DBMSs with a focus on their use with big data, and defines the many techniques and tool types involved.

olap oltp  Checklist Report: Analytic Databases for Big Data Many organizations in today's “big data” world are contemplating a replacement of their analytic databases and data warehouses to keep pace with new requirements for advanced analytics, and they are turning more and more to specialized analytic database management systems (DBMSs). Within the DBMS arena, there’s a slow trend away from practicing analytics with relational DBMSs that were originally designed for OLTP and towards analytic databases Read More

SCT Extends Into Business Intelligence


SCT, a leading supplier to the process industries, has extended their iProcess.SCT product set to include Business Intelligence (BI).

olap oltp  it will embed Vanguard OLAP and business analytic technologies in new iProcess.sct Business Analytics offerings, with availability for general distribution planned for September. The first two offerings will be iProcess.sct Demand Analytics and iProcess.sct Market Analytics . Further, SCT intends to launch additional offerings including one based on its actual costing capabilities. SCT states that the offerings will be tightly integrated with SCT's supply chain execution/ERP and web-based collaborative Read More

Can You Add New Life To an Old ERP System?


Getting ERP transaction data into a summarized form that is useful to knowledge workers is one way to extend the value of your ERP system. This article discusses the advantages that can be gained by moving ERP and other transaction data to a data warehouse.

olap oltp  Processing (OLAP) tool. Today, OLAP tools are available as client-server applications or can be operated from a Web browser. The data warehouse also can include information that is not in your ERP system. By adding information from outside the ERP system, IT can provide users access to ALL the transaction information that the company collects as well as whatever information they might want to collect from OUTSIDE the company. This is a significant difference and a potentially powerful advantage. Pat Read More

BI Portal from Enterprise Software Solutions Is Now a TEC Certified Application


Business Intelligence Portal (BI Portal) from Enterprise Software Solutions (ESS) has become part of TEC’s group of certified BI applications, and is now available for online evaluation in comparison with other BI software solutions in TEC’s Business Intelligence and Data Management Evaluation Center. ESS, a US-based software provider with offices in Mexico, Colombia, South Africa, and Bulgaria

olap oltp  of online analytical processing (OLAP) cubes, as well as an interesting Interactive Charts and Maps application, is just part of the wide range of functionality offered by BI Portal in support for seamless integration with Microsoft’s SQL Server for data analysis and BI deployments (see dashboard example in figure 2 below). Figure 2. Screenshot from Enterprise Software Solutions’ BI Portal Dashboard To achieve TEC certification, ESS completed TEC’s detailed questionnaire ( download sample BI RFI Read More

Lawson Enforces Its Stronghold Part1: Recent Announcements


Lawson Software, has gone past a successful IPO, and continues with new wins and with rounding up of its focused offering, while also belonging to the elite of enterprise applications vendors that have seen license revenue growth and profit in recent optimism-scant times.

olap oltp  Analytic Datamarts - New OLAP data cubes for resource utilization and time and expense analysis give users detailed views of utilization rates for better financial visibility and forecasting. Portal Interface - Role-based portal environment delivers point-and-click access to mission-critical information and enterprise applications. Offline Access - Provides disconnected access to time and expense reporting for mobile workforces. Enhanced Work Request - Improves overall flexibility, intuitiveness and Read More

Knosys "in the Kno" With ProClarity 3.0 Analytical Platform


Knosys, Inc. announced on November 6, 2000 that version 3.0 of its ProClarity® Analytical Platform and OLAP client are now available. The products were developed for Microsoft SQL Server 2000 Analysis Services, so ProClarity is completely tied to Microsoft software. In addition, Knosys has announced a partnership to collaborate with integrated enterprise and eBusiness applications vendor Epicor on development of a portal-based business intelligence solution. Epicor focuses exclusively on the mid-market.

olap oltp  ProClarity® Analytical Platform and OLAP client are now available. The products were developed specifically for Microsoft SQL Server 2000 Analysis Services. (For more information on SQL Server 2000 see What's new in Microsoft SQL Server 2000 .) The products are based on the COM (Common Object Model, a de-facto standard written by Microsoft) architecture, causing them to be completely tied to Microsoft software, including SQL Server 2000 and Commerce Server 2000. According to Clay Young, VP of Marketing Read More

Vistaar Announces Record Year


While the jury is still out on whether the price management software market is lucrative and blossoming, at least price management solutions provider Vistaar Technologies recently announced that it closed 2012 with record customer growth and expanded implementations. Vistaar’s continued leadership in the beverage alcohol industry, with a strong presence in spirits, was marked by expansion into the

olap oltp  Its new read-write in-memory OLAP engine now supports a hybrid of in-memory and disc-based technology to manage big data scale pricing problems. Vistaar can cater to the whole pricing lifecycle, including the following realms: Price planning and analytics , including segmentation into appropriate buckets to set appropriate prices. Price setting , which in certain markets includes optimization, and includes setting price lists and price guidelines, managing price structures and contract pricing, etc. It Read More

BI and BPM: It’s Not as Blurry as You Think


There seems to be a blurry line between business intelligence (BI) and business performance management (BPM) applications. Some software vendors offer solutions that actually incorporate BPM and BI within the same application, which makes it harder to distinguish between these two software solutions. The following are some—certainly not all—key differentiators between BI and/or BPM functionality

olap oltp  using specific tools like OLAP cubes, data and text mining, specific analytics etc., and delivering this information using advanced reports, dashboards, or any other advanced visualization tools (charts, maps, gauges, etc.). On the other hand, BPM uses this same BI framework to support other capabilities to define and manage business strategies. BPM tools help during the process of developing a strategy, plan, and a set of objectives to be accomplished. Normally, BPM does this by creating scorecards or Read More