AppsCo Introduces Major Upgrade of Its Data Mart and Analytic Application Development Environment for Microsoft SQL Server 7.0.AppsMart 1.5 Boasts Tight Integration With Microsoft Repository, Making It Easy to Quickly Develop, Customize and Deploy SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. Server 7.0-Based Data Marts and Analytic Applications Analytic Applications are a type of business application software, used to measure and improve the performance of business operations. More specifically, Analytic Applications are a type of Business Intelligence solution. BELLEVUE, Wash.--(BUSINESS WIRE)--Oct. 12, 1999-- AppsCo Software Limited, a UK-based provider of data mart design and analytic application development solutions for Microsoft(R) SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. (TM) 7.0, announced today a major upgrade of the company's software environment that enables developers to quickly build and deploy SQL Server 7.0-based data marts and analytic applications. Using AppsMart it is possible to start your design using a best-in-class analytic application template, iterate it·er·ate tr.v. it·er·at·ed, it·er·at·ing, it·er·ates To say or perform again; repeat. See Synonyms at repeat. [Latin iter the application design to meet your requirements, and deploy the solution to Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. 7.0. AppsMart will automatically populate the data mart with sample data and integrate OLAP Services See OLAP and Microsoft SQL Server OLAP Services. , data transformation services Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS tools. (DTS (1) (Digital Theatre Sound) A digital audio encoding system used in movie and home theaters. Popularized by the movie Jurassic Park, the six-channel (5. ) and Microsoft(R) Office2000. This gives developers a rapid start, and consistent methods and techniques when implementing a data mart on the Microsoft platform. Application-Centric Data Marts AppsMart's analytic application design and management facilities include a series of proven industry standard business model templates around which developers can rapidly construct application-centric data marts. In addition, AppsMart enables solution providers to capture their domain expertise into solution templates and build "reusable" analytic applications. This offers solution providers the combined benefits of lower cost and risk through enabling a repeatable process and method of delivering data mart solutions, and enabling the rapid creation of analytic applications, significantly reducing the time-to-market for solution provider products. Tight Integration With Microsoft Repository AppsMart 1.5 is fully integrated with Microsoft SQL Server 7.0 and the Microsoft Data Warehousing See data warehouse. data warehousing - data warehouse Framework. This ensures organizations can put together an integrated data warehousing solution from AppsCo and different vendors knowing that they have been designed to work together. AppsMart includes features for star schema A data warehouse design that enhances the performance of multidimensional queries on traditional relational databases. One fact table is surrounded by a series of related tables. Data is joined from one of the points to the center, providing a so-called "star query." See OLAP. design and deployment, and the automatic generation of OLAP Services cubes, DTS packages and Office2000 reports and documentation. In addition, AppsMart 1.5 boasts unparalleled integration with Microsoft Repository, a component of SQL Server 7.0 that provides life-cycle management services to store and share software components along with their descriptive information. AppsMart's tight integration with Microsoft Repository ensures it can be seamlessly integrated with leading business intelligence and OLAP (OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. tools to provide high-end analytics and data mining over and above those capabilities provided by those in Microsoft Office Microsoft's primary desktop applications for Windows and Mac. Depending on the package, it includes some combination of Word, Excel, PowerPoint, Access and Outlook along with various Internet and other utilities. 2000. "AppsCo has developed a breakthrough product for rapidly building data marts and warehouse solutions based on Microsoft SQL Server 7.0," said Andrew Hoover, group industry manager of business intelligence and data warehousing for Microsoft Corp. "AppsMart helps customers reduce the complexity, cost and time associated with data mart development, making this an ideal complement to SQL Server 7.0." "Companies today need to implement decision support solutions much faster to meet pressing business needs," added Mark Allen Mark Allen is the name of:
World Wrestling Federation Entertainment Scores with Sales Analysis Data Mart World Wrestling Federation Entertainment, Inc. wanted to gain better insights into its financial data stored in Solomon IV, a widely used financial and business management system exclusively optimized for SQL Server 7.0. World Wrestling Federation Entertainment, headquartered in Stamford, Connecticut Stamford is a city in Fairfield County, Connecticut, United States. According to 2006 Census Bureau estimates, the population of the city is 119,261, making it the fourth largest city in the state. , implemented a SQL Server 7.0-based sales analysis data mart that is providing the company tremendous insights into the sales data contained in Solomon's Order Processing Module. World Wrestling Federation Entertainment is using the data mart, which currently contains three years of sales data, to manage its highly lucrative home video business unit. The sales analysis data mart was developed by CEP CEP congenital erythropoietic porphyria. CEP abbr. congenital erythropoietic porphyria Systems, Inc., a Microsoft Certified Solution Provider (MCSP MCSP Microsoft Certified Solution Provider MCSP Merlin Capability Sustainment Plus MCSP Member of the Chartered Society of Physiotherapists (UK) MCSP melanoma chondroitin sulfate proteoglycan MCSP Master Certified Sales Professional ) partner that specializes in software development for manufacturing, accounting and distribution systems. CEP Systems used AppsMart 1.5 to rapidly build, tailor and deploy World Wrestling Federation Entertainment's sales analysis data mart in less than three weeks. The data mart is providing World Wrestling Federation Entertainment 12 different views of sales order The sales order, sometimes abbreviated as SO, is an order received by a business from a customer. A sales order may be for products and/or services. Given the wide variety of businesses, this means that the orders can be fulfilled in several ways. information, as well as a variety of inquiry and forecasting screens and standard reports. In addition, the system is easy to use, allowing users to run special queries and create custom reports using their own tools in addition to the more than 40 standard reports that are available. "Our business users are ecstatic with the new freedom we have given them to easily analyze the sales data," said Kevin Albanese, Director of IT for World Wrestling Federation Entertainment. "They are getting views of the sales data that were previously not possible. No longer do they have to rely on IT to produce customer reports. They now go in and create exactly the view of the data they need for that particular analysis," Albanese said. "It is a very powerful tool that is allowing our users to mine our sales data for trend and demographic analysis Demographic analysis uses administrative records to develop an independent estimate of the population [1]. Demographic analysis estimates are often considered a reliable standard for judging the accuracy of the census information gathered at any time. . We are looking at targeting other strategic areas of the company as well for implementation. "From the IT perspective," Albanese added, "the implementation time was very fast. We were thrilled. In addition, it has relieved a lot of pressure from having to create custom reports for our users, allowing us to deploy those resources elsewhere." Added CEP Systems President John J. Pavain, "Our partnership with AppsCo has helped us to quickly create sales analysis data marts using Microsoft SQL Server 7.0. It allows our business intelligence consultants to custom tailor a data mart for our customers in hours instead of weeks. AppsMart 1.5 is allowing us to standardize our approach to data mart creation and optimize the use of the best practice business intelligence consulting methodologies that we have created. We look forward to developing a successful business intelligence practice using AppsMart." "The enormous business value to be realized by implementing data marts is well documented, but it is the perceived difficulty of implementation that frequently stands between wanting a mart and having one," said AppsCo CEO (1) (Chief Executive Officer) The highest individual in command of an organization. Typically the president of the company, the CEO reports to the Chairman of the Board. Brian Burnett. "AppsMart is the easiest and fastest way to create industry-specific databases leveraging the knowledge of key business decision processing requirements. Our close relationship with Microsoft ensures full integration and seamless access to the capabilities native to SQL Server 7.0 and OLAP Services." AppsMart Eases Analytic Application Development AppsMart consists of several components that work together to deliver an industry-first analytic application development solution. Solution providers start using an AppsMart template to create an AppsMart analytic application that encapsulates their domain expertise, which can then be rapidly customized using AppsMart to meet the customer's requirements. AppsMart contains a repository that allows the developer to manage meta data for analytic applications running on one or more database servers. It provides version management, documentation and facilities to manage the deployment of applications. Pricing and Availability AppsMart 1.5 is available now. AppsMart consists of Domain Expert, which enables solution providers to create analytic application products, priced at $15,000, and Developer, which enables solution providers to use AppsMart to customize template solutions or deliver integration services, priced at $8,000. AppsMart works with Microsoft Windows See Windows. (operating system) Microsoft Windows - Microsoft's proprietary window system and user interface software released in 1985 to run on top of MS-DOS. Widely criticised for being too slow (hence "Windoze", "Microsloth Windows") on the machines available then. NT and 95 operating systems, and fully supports Microsoft SQL Server 7.0. AppsMart is available through AppsCo's network of resellers and distributors. About AppsCo Software Limited AppsCo Software Limited, founded in 1998, is a leading supplier of data mart design and analytic application development tools. AppsCo provides AppsMart, an analytic application development environment. A patent pending technology, AppsMart enables data mart application builders to design data marts based on vertical market solution templates, and standard methods and processes. Backed by venture capital firms Name Location Founding date Managing Partners/Directors Specialty Capital managed 5AM Ventures Menlo Park, CA; Waltham, MA 2002 John Diekman, PhD (managing partner), Scott Rocklage, PhD (managing partner), Andrew Schwab (managing partner) life sciences $200M [1] 3i, Vertex Management Group, Scottish Equity Partnership and Grampian Enterprise Limited, AppsCo is a privately held company privately held company A firm whose shares are held within a relatively small circle of owners and are not traded publicly. . AppsCo is based in Surrey, United Kingdom, and has U.S. operations in Bellevue, Washington. More information on the company and its AppsMart solution is available on the Web at www.appsco.com, or by calling 425/957-4528. AppsCo, AppsMart and the AppsCo and AppsMart logos are registered trademarks of AppsCo Software Ltd. Other products mentioned in this document are registered, trademarked, or service marked by their respective owners. Note to Editors: Copies of previous AppsCo press releases and corporate and product information are available on AppsCo's Web site at http://www.appsco.com |
|
Printer friendly
Cite/link
Email
Feedback
Reader Opinion