Database

Posted by on in Database
Aqua Data Studio(ADS)のご紹介 先日、次期RAD Studio Architect版について、アップデートの発表がありました。 その中で非常に興味深いツールが2つ追加されます。 一つめは、データベース管理/開発ツールであるAqua Data Studio。二つめはテスト自動化ツールのRanorex Test Automationです。 今回は、そのうちのAqua Data Studio(以後、ADS)をご紹介します。 ADSは非常に強力なデータベース開発、管理ツールです。    ADSがどのようなものか、ご紹介しましょう。まず、データベースサーバーの登録を行います。   ご覧いただけるように、様々なデータベースを使うことが出来ます。OracleやMSSQLといったエンタープライズ系から、Apache DerbyやSQLiteのような組み込み向け、そして、みんな大好き(?)なExcelもあります。  データベース開発、管理ツールとしては、一通りの機能を備えています。  ビジュアルなクエリの作成。   データベースをリバースエンジニアリン...
Using "reFind" tool to migrate BDE app to FireDAC with Delphi 10.1 Two weeks ago I was contributing to a bigger Delphi migration webinar run by my colleague Stephen Ball the demonstration of actual steps of live migration of BDE-based source code to FireDAC. Migration of existing VCL projects to the latest version of Delphi is the hot topic in Delphi community. Many migration tasks can be automated. Today at the Developer Conference in Tel Aviv Embarcadero MVP Oren Aviram is demonstrating "Software Modernization Made Easy" with his powerful...
Embarcadero and the Object/Relational Mismatch - by Robin Bloor The introduction of object-oriented (OO) programming languages provoked an unfortunate schism in the world of software development. Relational databases dominated the database world and Entity Relationship (ER) modeling quickly dominated database design. This determined the target data structure for programmers when they wrote applications. However, OO languages embodied distinctly different views of data. This mismatch might have been brushed under the carpet if object databases had ever gaine...
A Data Modeler's 2016 Resolutions I generally don't make resolutions, especially at the end of a year. I'm more of a "make small changes, every day, that will make a big difference over a year" type person.  For blogs and communities, resolution making is a tradition and we all know that the holiday season is about traditions. So, dear data modelers, here are the resolutions I'd hope we'd all make for 2016. You wouldn't need to do all of them.  Just pick the ones you need to do. Make some of your own, then a plan to ma...
The Big Data Modeling Question... I was with a client for lunch one day and we asked the server "What do you have on tap?"  She was gone quite a long time, but came back and said "Beer."  It turned out she was right.  But her answer was not that helpful. One of the odd parts of every new project I have to deal with is getting everyone to understand that the question "Can you help us with a data model" results in me asking. "What do you mean by data model?" That's right, I have to ask team members what a data...

Check out more tips and tricks in this development video: