|
Comparison Of Data Modeling Tools
This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment. General Features {, class="sortable wikitable" style="width: auto; text-align: center;" ! Tool ! Supported data models (conceptual, logical, physical) ! Supported notations ! Forward engineering ! Reverse engineering ! Model/database comparison and synchronization ! Teamwork/repository , - , Database Workbench , Conceptual, logical, physical , IE (Crows feet) , , , Update database and/or update model , , - , Enterprise Architect (software), Enterprise Architect , Conceptual, Logical & Physical + MDA Transform of Logical to Physical , IDEF1X, UML DDL, Information Engineering & ERD , , , Update database and/or update model , Multi-user collaboration using File, DBMS or Cloud Repository (or transfer via XMI, CVS/TFS or Difference Merge). , - , ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Data Modeling
Data modeling in software engineering is the process of creating a data model for an information system by applying certain formal techniques. Overview Data modeling is a process used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations. Therefore, the process of data modeling involves professional data modelers working closely with business stakeholders, as well as potential users of the information system. There are three different types of data models produced while progressing from requirements to the actual database to be used for the information system.Simison, Graeme. C. & Witt, Graham. C. (2005). ''Data Modeling Essentials''. 3rd Edition. Morgan Kaufmann Publishers. The data requirements are initially recorded as a conceptual data model which is essentially a set of technology independent specifications about the data and is used to discuss initial requirements w ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Informix
IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings. The Informix products were originally developed by Informix Corporation, whose Informix Software subsidiary was acquired by IBM in 2001. In April 2017, IBM delegated active development and support to HCL Technologies for 15 years while keeping part of the marketing responsibilities. The current version of Informix is 14.10 and forms the basis of several product editions with variation in capacity and functionality. The Informix database has been used in many high transaction rate OLTP applications in the retail, finance, energy and utilities, manufacturing and transportation sectors. More recently the server has been enhanced to improve its support for data warehouse workloads. Through extensions, Informix supports data types that are not a part of the SQL standard. Key products As of 2020, the current versi ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Teradata
Teradata Corporation is an American software company that provides cloud database and analytics-related software, products, and services. The company was formed in 1979 in Brentwood, California, as a collaboration between researchers at Caltech and Citibank's advanced technology group. Overview Teradata is an enterprise software company that develops and sells database analytics software. The company provides three main services: business analytics, cloud products, and consulting. It operates in North and Latin America, Europe, the Middle East, Africa and Asia. Teradata is headquartered in San Diego, California, and has additional major U.S. locations in Atlanta and San Francisco, where its data center research and development is housed. It is publicly traded on the New York Stock Exchange (NYSE) under the stock symbol TDC. Steve McMillan has served as the company's president and chief executive officer since 2020. The company reported $1.836 billion in revenue, with a net in ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Netezza
IBM Netezza (pronounced ne-teez-a) is a subsidiary of American technology company IBM that designs and markets high-performance data warehouse appliances and advanced analytics applications for uses including enterprise data warehousing, business intelligence, predictive analytics and business continuity planning. Netezza was acquired by IBM on September 20, 2010 and reached end of support in June 2019. It was later reintroduced in June 2020 as part of the IBM CloudPak for Data offering. History Netezza was founded in 1999 by Foster Hinshaw. In 2000 Jit Saxena joined Hinshaw as co-founder. The company was incorporated in Delaware on December 30, 1999 as Intelligent Data Engines, Inc. and changed its name to Netezza Corporation in November 2000. Netezza announced the industry's first "data warehouse appliance" in 2003 to meet the industry's need to make use of the rapidly increasing ability to collect consumer data. In July 2007, Netezza Corporation had its initial public off ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Interbase
InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies. InterBase is distinguished from other RDBMSs by its small footprint, close to zero administration requirements, and multi-generational architecture. InterBase runs on the Microsoft Windows, macOS, Linux, Solaris operating systems as well as iOS and Android. Technology InterBase is a SQL-92-compliant relational database and supports standard interfaces such as JDBC, ODBC, and ADO.NET. Small footprint A full InterBase server installation requires around 40 MB on disk. A minimum InterBase client install requires about 400 KB of disk space. Embedded or server InterBase can be run as an embedded database or regular server. Data controller friendly inbuilt encryption Since InterBase XE, InterBase includes 256bit AES strength encryption that offers full database, table or column data encryption. This assists data controllers conform with data protection l ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Microsoft Azure
Microsoft Azure, often referred to as Azure ( , ), is a cloud computing platform operated by Microsoft for application management via around the world-distributed data centers. Microsoft Azure has multiple capabilities such as software as a service (SaaS), platform as a service (PaaS) and infrastructure as a service (IaaS) and supports many different programming languages, tools, and frameworks, including both Microsoft-specific and third-party software and systems. Azure, announced at Microsoft's Professional Developers Conference (PDC) in October 2008, went by the internal project codename "Project Red Dog", and was formally released in February 2010 as Windows Azure, before being renamed Microsoft Azure on March 25, 2014. Services Microsoft Azure uses large-scale virtualization at Microsoft data centers worldwide and it offers more than 600 services. Compute services * Virtual machines, infrastructure as a service (IaaS) allowing users to launch general-purpose Mi ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Snowflake Inc
Snowflake Inc. is a cloud computing–based data cloud company based in Bozeman, Montana. It was founded in July 2012 and was publicly launched in October 2014 after two years in stealth mode. The firm offers a cloud-based data storage and analytics service, generally termed "data-as-a-service". It allows corporate users to store and analyze data using cloud-based hardware and software. Snowflake services main features are separation of storage and compute, on-the-fly scalable compute, data sharing, data cloning, and third-party tools support in order to handle the demanding needs of growing enterprises. It runs on Amazon S3 since 2014, on Microsoft Azure since 2018 and on the Google Cloud Platform since 2019. The company was ranked first on the ''Forbes'' Cloud 100 in 2019. The company's initial public offering raised $3.4 billion, one of the largest software IPOs in history. History Snowflake Inc. was founded in July 2012 in San Mateo, California by three data warehousin ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Embarcadero Technologies
Embarcadero Technologies, Inc. is an American computer software company that develops, manufactures, licenses, and supports products and services related to software through several product divisions. It was founded in 1993, went public in 2000, and private in 2007, and became a division of Idera, Inc. in 2015. History Embarcadero was founded in October 1993 by Stephen Wong, Stuart Browning, and Nigel Myers and released a tool for Sybase database administrators in December of the same year called Rapid SQL. it later added tools for software development on Microsoft Windows and other operating systems, and for database design, development and management, for platforms including Oracle, Microsoft SQL Server, IBM DB2, and MySQL. In April 2000, Embarcadero Technologies had its initial public offering, and was listed on NASDAQ with symbol EMBT. In November the same year, the company acquired GDPro, a Unified Modeling Language software provider. In October 2005 Embarcadero acquired ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
ER/Studio
ER/Studio is data architecture and database design software developed by IDERA, Inc. ER/Studio is compatible with multiple database platforms and is used to create and manage database designs, as well as to document and reuse data assets. In 2015, Embarcadero Technologies was acquired by database and infrastructure management software company IDERA, Inc. Since the acquisition by IDERA, Inc., ER/Studio has been renamed to ER/Studio Data Architect with updated features. Features * Logical and physical design support * XML Schema generation from either the logical or physical models * Automation and scripting support * Forward- and reverse- engineering * Automated database code generation * Integration of models and metadata * Collaboration support including sub model management, repository, “where used” * Presentation formats include HTML, RTF, XML Schema, PNG, JPEG and DTD Output * Integrate model metadata with other platforms such as BI, ETL, and other modeling tools. * Da ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
CrossOver (software)
CrossOver is a Microsoft Windows compatibility layer available for Linux, macOS, and ChromeOS. This compatibility layer enables many Windows-based applications to run on Linux operating systems, macOS, or ChromeOS. CrossOver is developed by CodeWeavers and based on Wine, an open-source Windows compatibility layer. CodeWeavers modifies the Wine source code, applies compatibility patches, adds configuration tools that are more user-friendly, automated installation scripts, and provides technical support. All changes made to the Wine source code are covered by the LGPL and publicly available. CodeWeavers maintains an online database listing how well various Windows applications perform under CrossOver. Versions CrossOver Linux CrossOver Linux is the original version of CrossOver. It aims to properly integrate with the GNOME and KDE desktop environments so that Windows applications will run seamlessly on Linux distributions. Prior to version 6 it was called CrossOver Office. C ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Sybase
Sybase, Inc. was an enterprise software and services company. The company produced software to manage and analyze information in relational databases, with facilities located in California and Massachusetts. Sybase was acquired by SAP in 2010; SAP ceased using the Sybase name in 2014. History *1984: Robert Epstein, Mark Hoffman, Jane Doughty, and Tom Haggin founded Sybase (initially trading as ''Systemware'') in Epstein's home in Berkeley, California. Their first commercial location is half of an office suite at 2107 Dwight Way in Berkeley. They set out to create a relational database management system (RDBMS) that will organize information and make it available to computers within a network. *March 1986: Systemware enters into talks with Microsoft to license Data Server, a database product built to run on UNIX computers. Those talks led to a product called Ashton-Tate/Microsoft SQL Server 1.0, shipping in May 1989. *May 1991: Systemware changes its name to Sybase. *January ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
PostgreSQL
PostgreSQL (, ), also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley. In 1996, the project was renamed to PostgreSQL to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres. PostgreSQL features transactions with Atomicity, Consistency, Isolation, Durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Windows, Linux, FreeBSD, and OpenBSD. History PostgreSQL evolved from the Ing ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
