FAME (database)

Last updated

FAME (Forecasting Analysis and Modeling Environment) is a time series database released in 1981 and owned by FIS Global.

Contents

History

The FAME software environment had several development phases during its history.

Lawrence C. Rafsky founded GemNet Software Corp to create FAME in 1981. [1] It was an independent software company located in Ann Arbor, Michigan. The first version of the software was delivered to Harris Bank in 1983. The company was purchased by CitiCorp in 1984. [2] During this time, development focused on the time-series-oriented database engine and the 4GL scripting language.

Citigroup sold FAME to private investors headed by Warburg Pincus in 1994. Management focused on fixing bugs, developing remote database server access to FAME, and investing in expanding the FAME database engine. Emphasis was also placed on extending FAME by creating an object-oriented Java interface called TimeIQ that replicated many features of FAME 4GL in Java. This period also saw the release of the access point, which provides URL access to FAME objects in multiple output formats.

SunGard acquired FAME in 2004. [3]

In 2010, Sungard merged FAME and MarketMap Data into the MarketMap brand. [4]

FIS Global acquired Sungard in 2015. [5]

Toolkits and connectors

FAME Desktop Add-in for Excel: FAME Desktop is an Excel add-in that supports the =FMD(expression, sd, ed,0, freq, orientation) and =FMS(expression, freq + date) formulas, just as the 4GL command prompt does. These formulas can be placed in Excel spreadsheets and are linked to FAME objects and analytics stored on a FAME server. Sample Excel templates for research and analytics, which act as accelerators for clients, are available in the template library. The FAME Desktop Add-in was first renamed FAME Populator, then MarketMap Analytics.

FAME Connector for MATLAB: Matlab is an environment for technical computing applications that is also used in the financial sector by fixed-income analysts, equity research groups, and investment firms. Customers can store content in FAME and use Matlab to access and model their data. The Matlab-FAME Connector uses the FAME Java Toolkit to link Matlab scripts to FAME objects.

BITA Curve Connector: The BITA Curve workstation provides a platform that can link to “in-database” analytics and content warehoused in FAME. Through the BITA Curve Connector, FAME users can better visualize and work with the content that they warehouse into FAME.

R Interface: FAME customers have developed and released as free software an interface that links FAME objects to the open-source R statistical package. Originally developed at the Federal Reserve Board, features include: [6]

SASEFAME: SAS provides an interface to FAME databases called SASEFAME. This provides dynamic read-and-write access between a SAS application and FAME databases or a FAME server process

TROLL Interface: TROLL’s interface to FAME provides read and write access from a TROLL application to a FAME Server or directly to a local FAME database

Development timeline

1982–1994: GemNet introduced the first release of FAME in 1983. Citicorp purchased the company in 1984. Development milestones during this period:

Before MCADBS, users could not use a thin C HLI client to leverage the power of 4GL on a remote host via client/server TCP. The 7.5 release also introduced some important 4GL features, including PostScript Reports, and database features such as global names and formulas.

1994–2004: During this period, the focus was on improving managed content delivery to onsite FAME warehouses and hosted ASP FAME servers. Milestones included:

2004–present: After being acquired by SunGard, FAME’s development focus shifted to the 4GL scripting language and core FAME features. Milestones included:

FAME 9.2 also added new 4GL debugging features, analytical functions, graphics, and reporting improvements. Other core 4GL features included the MOVE function and new forms of the SHIFT and FILESPEC functions. The FAME SEARCH command was enhanced with the PATH option. Memory support mapped FAME databases and the TUNE CACHE MEGABYTES option helped users to better manage large volume warehouses.

FAME 9.3 also introduced new graphical features, including BUBBLE charts.

FAME 10 opens up the environment to real-time analysis with larger database storage, as well as support for new frequencies, such as millisecond and weekly patterns. New database formats increase the maximum size to 256 GB.

During this period, FAME has also focused on expanding the managed content delivered to the database, as well as out-of-the-box object models that warehouse builders can leverage when loading proprietary content.

See also

Related Research Articles

A fourth-generation programming language (4GL) is a high-level computer programming language that belongs to a class of languages envisioned as an advancement upon third-generation programming languages (3GL). Each of the programming language generations aims to provide a higher level of abstraction of the internal computer hardware details, making the language more programmer-friendly, powerful, and versatile. While the definition of 4GL has changed over time, it can be typified by operating more with large collections of information at once rather than focusing on just bits and bytes. Languages claimed to be 4GL may include support for database management, report generation, mathematical optimization, GUI development, or web development. Some researchers state that 4GLs are a subset of domain-specific languages.

<span class="mw-page-title-main">HCL Notes</span> Collaborative software platform

HCL Notes is a proprietary collaborative software platform for Unix, Windows, Linux and macOS, sold by HCLTech. The client application is called Notes while the server component is branded HCL Domino.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.

A software development kit (SDK) is a collection of software development tools in one installable package. They facilitate the creation of applications by having a compiler, debugger and sometimes a software framework. They are normally specific to a hardware platform and operating system combination. To create applications with advanced functionalities such as advertisements, push notifications, etc; most application software developers use specific software development kits.

Informix-4GL is a 4GL programming language developed by Informix during the mid-1980s. At the time of its initial release in 1986, supported platforms included Microsoft Xenix, DEC Ultrix, Altos 2086, AT&T 3B2, AT&T 3B5, AT&T 3B20 and AT&T Unix PC.

<span class="mw-page-title-main">WebObjects</span> Java web application server and framework originally developed by NeXT Software

WebObjects is a discontinued Java web application server and a server-based web application framework originally developed by NeXT Software, Inc.

Web development is the work involved in developing a website for the Internet or an intranet. Web development can range from developing a simple single static page of plain text to complex web applications, electronic businesses, and social network services. A more comprehensive list of tasks to which Web development commonly refers, may include Web engineering, Web design, Web content development, client liaison, client-side/server-side scripting, Web server and network security configuration, and e-commerce development.

Oracle Forms is a software product for creating screens that interact with an Oracle database. It has an IDE that includes an object navigator, property sheet, and code editor that uses PL/SQL. It was originally developed to run server-side in character-mode terminal sessions. It was ported to other platforms, including Windows, to function in a client–server environment. Later versions were ported to Java where it runs in a Java EE container and can integrate with Java, and web services that can be launched from a URL. Recent versions provide a means to run the forms from a desktop computer without requiring a browser.

InterSystems Caché is a commercial operational database management system from InterSystems, used to develop software applications for healthcare management, banking and financial services, government, and other sectors. Customer software can use the database with object and SQL code. Caché also allows developers to directly manipulate its underlying data structures: hierarchical arrays known as M technology.

<span class="mw-page-title-main">OpenROAD</span>

OpenROAD, which stands for "Open Rapid Object Application Development", is a fourth-generation programming language (4GL) and development suite from Actian Corporation.

Forté 4GL was a proprietary application server that was developed by Forté Software and used for developing scalable, highly available, enterprise applications.

Google Developers is Google's site for software development tools and platforms, application programming interfaces (APIs), and technical resources. The site contains documentation on using Google developer tools and APIs—including discussion groups and blogs for developers using Google's developer products.

<span class="mw-page-title-main">JADE (programming language)</span> Software development and deployment platform

JADE is a proprietary object-oriented software development and deployment platform product from the New Zealand-based Jade Software Corporation, first released in 1996. It consists of the JADE programming language, Integrated development environment and debugger, integrated application server and object database management system.

Morfik Technology Pty Ltd. is an Australian software company that was acquired by Altium in 2010.

Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network. Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

<span class="mw-page-title-main">IcCube</span>

icCube is known for its embeddable data analytics and visualization software platform tailored specifically for B2B Software-as-a-Service (SaaS) applications, i.e. Embedded analytics.

References

  1. Woods, Dan (2008-12-09). "The Humble Developer". Forbes. Retrieved 2018-11-28.
  2. Unruh, H. Kirk (1984-09-12). "Princeton Alumni Weekly, Volume 85, Issues 1-20" . Retrieved 2018-11-28.
  3. "SunGard to Acquire FAME; Adds Reference Data Solutions to its Market Data Offerings" (Press release). December 5, 2003.
  4. Chan, Vicki (24 May 2010). "SunGard Combines Fame, MarketMap Data". waterstechnology.com. Retrieved 2018-11-28.
  5. "FIS, A history of growth". 2018. Retrieved 2018-11-28.
  6. Hallman, Jeff (July 12, 2015). "fame: Interface for FAME Time Series Database" . Retrieved July 24, 2015.