Skip to navigation Skip to content
Simon Technology Blog
  • Architecture
  • Cloud
  • Database
  • Develop
  • Hardware
  • Industry
  • Language
  • Mobile
  • Opensource
  • OS
  • Web
Main Navigation

Category: Database

The database is a warehouse that organizes, stores and manages data according to the data structure. It was created more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management is no longer just It is to store and manage data, and transform it into various data management methods required by users. There are many types of databases, from the simplest tables that store various data to large-scale database systems that can store massive amounts of data. They have been widely used in all aspects.

Several common modeling tools (Rose, PowerDesigner, Visio)

1, ROSE
< /span> ROSE is directly developed from UML The birth of the design tool, it appeared to support UML modeling, ROSE did not support the database-side modeling at the beginning, but the

September 22, 2021By Simo Power Designer common, comparison, modeling, PowerDesigner, ROSE, several, tools, VISIOLeave a Comment

PowerDesigner (8) – Model Document Editor (Generate Project Documentation)

The original text is from: http://www.voidcn.com/article/p-uoilqgur-oy.html

The Model Report of PowerDesigner is a model-based, project-oriented overview document. It provides a flexible and

September 22, 2021By Simo Power Designer build, Document, editor, eight, model, PowerDesigner, projectLeave a Comment

SQL file in PowerDesigner, database table reverse generation PDM

1 Reverse PDM generation 1) Create an empty PDM model (select the corresponding DBMS) :

2) Select [Database]–[Update Model from Database…] menu:

1) In the new window, select the cor

September 22, 2021By Simo Power Designer back, database, Document, generated, PDM, PowerDesigner, SQL, tableLeave a Comment

PowerDesigner generates automatic identification of mysql statements, Name, and comments

When using PowerDesigner to design the ORACLE library table in the past, it is very convenient to generate the SQL statement to build the table. There is an option, which means that when the COMMEN

September 22, 2021By Simo Power Designer annotation, automatic, configuration, generated, Identification, mysql, PowerDesigner, statementLeave a Comment

How to use the SQLite connection in the Asset folder

How to use the SQLite connection in the Asset folder. This is called DataBaseHelper. java file

public class DataBaseHelper extends SQLiteOpenHelper
{
private static String TAG = “TAG”;
pri

September 22, 2021By Simo Sqlite Asset, connection, folders, how to use, SQLITELeave a Comment

Good and fake, also –PowerDesigner

[PowerDesigner]

Very good database design Tools, used before, let’s summarize today.

PowerDesigner is a powerful software capable of database design. It is a database modeling tool comm

September 22, 2021By Simo Power Designer fake, Good, PowerDesigner, ThingsLeave a Comment

How to add foreign keys to an existing SQLite table?

I have the following table:

CREATE TABLE child(
id INTEGER PRIMARY KEY,
parent_id INTEGER,
description TEXT); How to add foreign key constraints on parent_id? Assume that foreign keys are enabled.

Most examples assume that you are creating a table-I want to add constraints to an existing table.

September 22, 2021By Simo Sqlite Existing, How to add, SQLITE, tableLeave a Comment

PowerDesigner Using Tutorials (Text Tutorial)

1. Now start using PowerDesigner to create a database, first run the program and enter the main interface:

2.File—New Model—Physical Data Model—Physical Diagram—Model name< /strong> is set to

September 22, 2021By Simo Power Designer graphic, PowerDesigner, tutorial, useLeave a Comment

Where can I find the old SQLite version of the source file?

The downloads page on www.sqlite.org seems to have only a link to the current version. I want to get a previous version. I don’t see any obvious links to historical versions on the website (unless

September 22, 2021By Simo Sqlite file, Find, old, source, SQLITE, version, Where, You canLeave a Comment

Import SQLite Database from SDCARD to Android – No Assets folder

I am trying to import my sqlite database from sdcard or any external location to my Android application. My application requires database import so that the database schema will not change, but the

September 22, 2021By Simo Sqlite Android, Assets, database, folders, import, no, SDCARD, SQLITELeave a Comment

Posts navigation

Page 1 … Page 17 Page 18 Page 19 … Page 47
Recent Posts
  • Sencha-Touch-2 – Sencha Touch 2, Nested XML Analysis NodeValue
  • Add a separation line and format XML content
  • Is there a norm of simplified XML subsets?
  • Look at it when you write React
  • ReactJS – Present React Redux React-Router App to add the server to the Firebase hosted by the Firebase
Categories
  • Android
  • Apache
  • Apache Kafka
  • Asp
  • Auto-Test
  • Automated Build
  • Aws
  • Bitcoin
  • Browser
  • C & C++
  • C#
  • Centos
  • Cgi
  • Character
  • Cloud Service
  • Cocos2dx
  • Cordova
  • CSS
  • Data Structure
  • Delphi
  • Design Pattern
  • Dojo
  • Dubbo
  • ELK
  • Flex
  • football
  • Game
  • Hadoop
  • Hibernate
  • HTML
  • Hybrid
  • Intel
  • IOS
  • Ipad
  • iPhone
  • Java
  • Javascript
  • Jetty
  • JQuery
  • Jsp
  • Linux
  • Load Balance
  • Lua
  • Macbook
  • Macos
  • Mathematics
  • Micro Services
  • Monitoring
  • Motherboard
  • Mysql
  • Network Hardware
  • Network Marketing
  • Nginx
  • NodeJs
  • Nosql
  • Oracle
  • Os Theory
  • Performance
  • PHP
  • Postgresql
  • Power Designer
  • React
  • Redis
  • Regexp
  • Rom
  • Rss
  • Ruby
  • Search Engines
  • Shell Script
  • Silicon Valley
  • Silverlight
  • Software Design
  • Spring
  • Sql
  • Sqlite
  • Sqlserver
  • Storage
  • Storm
  • Surface
  • SVN
  • Swift
  • System Architecture
  • Tablet
  • Uncategorized
  • Unix
  • Visual Basic
  • Visual Studio
  • Web Crawler
  • WebService
  • Windows
  • Wireless
  • XML
  • ZooKeeper
Archives
  • October 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • September 2020
  • September 2019
  • August 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
© Simon Technology Blog 2025 • ThemeCountry Powered by WordPress