|
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 (Crow’s foot) , , , Update database and/or update model , , - , 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). , - , ER/Studio , Logical, p ... [...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. It may be applied as part of broader Model-driven engineering (MDE) concept. 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 ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
PostgreSQL
PostgreSQL ( ) also known as Postgres, is a free and open-source software, free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transaction processing, transactions with atomicity (database systems), atomicity, consistency (database systems), consistency, isolation (database systems), isolation, durability (database systems), durability (ACID) properties, automatically updatable view (SQL), views, materialized views, database trigger, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Microsoft Windows, Windows, Linux, macOS, FreeBSD, and OpenBSD, and handles a range of workloads from single machines to data warehouses, data lakes, or web services with many concurrent users. The PostgreSQL Global Development Group focuses only on developing a database engine and closely related components. This core is, technically, what comprises PostgreSQL itse ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Interbase
InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies. It runs on the operating systems Microsoft Windows, macOS, Linux, Oracle Solaris, Solaris, Android (operating system), Android, and iOS. Technology InterBase is a SQL-92-compliant relational database and supports standard interfaces such as JDBC, ODBC, and ADO.NET. History Multiversion concurrency control before InterBase Multiversion concurrency control is described in some detail in sections 4.3 and 5.5 of the 1981 paper "Concurrency Control in Distributed Database Systems" by Phil Bernstein, Philip Bernstein and Nathan Goodman while employed by the Computer Corporation of America. Bernstein and Goodman's paper cites a 1978 dissertation by D.P. Reed, which describes Multiversion concurrency control, MVCC and claims it as an original work. Early years Jim Starkey was working at Digital Equipment Corporation, DEC on their DATATRIEVE 4th generation languag ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Microsoft Azure
Microsoft Azure, or just Azure ( /ˈæʒər, ˈeɪʒər/ ''AZH-ər, AY-zhər'', UK also /ˈæzjʊər, ˈeɪzjʊər/ ''AZ-ure, AY-zure''), is the cloud computing platform developed by Microsoft. It has management, access and development of applications and services to individuals, companies, and governments through its global infrastructure. It also provides capabilities that are usually not included within other cloud platforms, including software as a service (SaaS), platform as a service (PaaS), and infrastructure as a service (IaaS). Microsoft Azure supports many programming languages, tools, and frameworks, including Microsoft-specific and third-party software and systems. Azure was first introduced at the Professional Developers Conference (PDC) in October 2008 under the codename "Project Red Dog". It was officially launched as Windows Azure in February 2010 and later renamed to Microsoft Azure on March 25, 2014. Services Microsoft Azure uses large-scale virtualizati ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Snowflake Inc
Snowflake Inc. is an American cloud-based data storage company. Headquartered in Bozeman, Montana, it operates a platform that allows for data analysis and simultaneous access of data sets with minimal latency. It operates on Amazon Web Services, Microsoft Azure, and Google Cloud Platform. , the company had 10,618 customers, including more than 800 members of the Forbes Global 2000, and processed 4.2 billion daily queries across its platform. History Snowflake Inc. was founded in July 2012 in San Mateo, California, by Benoît Dageville, Thierry Cruanes and Marcin Żukowski. Dageville and Cruanes previously worked as data architects at Oracle Corporation; Żukowski was a co-founder of Vectorwise. Mike Speiser, a venture capitalist at Sutter Hill Ventures, which provided early funding to the company, was the company's first CEO. In June 2014, Bob Muglia, formerly of Microsoft, was named CEO. In October 2014, Snowflake came out of stealth mode; at that time it was us ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Embarcadero Technologies
Embarcadero Technologies, Inc. is a U.S.-based 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 the symbol EMBT. In November the same year, the company acquired GDPro, a Unified Modeling Language software provider. In October 2005 Embarcadero acqu ... [...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 * Support for wide range of relational database platforms * Support for NoSQL platforms such as MongoDB * Support for JSON and JSON schema * 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 meta ... [...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. Before version 6, it was called CrossOver Office. CrossO ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational database, relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately. Microsoft Access stores data in its own format based on the Access Database Engine (formerly Jet Database Engine). It can also import or link directly to data stored in other applications and databases. Software developers, data architects and power users can use Microsoft Access to develop application software. Like other Microsoft Office applications, Access is supported by Visual Basic for Applications (VBA), an object-based programming language that can reference a variety of objects including the legacy DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose thei ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Ingres (database)
Ingres Database ( ) is a proprietary SQL relational database management system intended to support large commercial and government applications. Actian Corporation controls the development of Ingres and makes certified binaries available for download, as well as providing worldwide support. There was an open source release of Ingres but it is no longer available for download from Actian. However, there is a version of the source code still available on GitHub. In its early years, Ingres was an important milestone in the history of database development. Ingres began as a research project at UC Berkeley, starting in the early 1970s and ending in 1985. During this time Ingres remained largely similar to IBM's seminal System R in concept; it differed in more permissive licensing of source code, in being based largely on DEC machines, both under UNIX and VAX/VMS, and in providing QUEL as a query language instead of SQL. QUEL was considered at the time to run truer to Edgar F ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
Informix
Informix is a product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) and multi-model database 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, with a number of IBM employees working on Informix also moving to HCL. As part of this arrangement IBM will continue to market and sell it as IBM Informix to their customers, with HCLTech able to market and sell it as HCL Informix. 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 be ... [...More Info...] [...Related Items...] OR: [Wikipedia] [Google] [Baidu] |
