CN103699565A - Establishment method of distributed database - Google Patents
Establishment method of distributed database Download PDFInfo
- Publication number
- CN103699565A CN103699565A CN201310527711.XA CN201310527711A CN103699565A CN 103699565 A CN103699565 A CN 103699565A CN 201310527711 A CN201310527711 A CN 201310527711A CN 103699565 A CN103699565 A CN 103699565A
- Authority
- CN
- China
- Prior art keywords
- database
- user
- attribute data
- distributed database
- attribute
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses an establishment method of a distributed database. The method comprises the following specific steps: installing an SQLServer2005 and selecting a mixed mode to log on; starting an SQLServer Management Studio, logging on by use of an SQLServer ID (Identity); estabilishing a database 'SQLDemo'; in an attribute state option card of a security option user role 'sa', setting the option of whether allowing connection to a database engine as 'awarding' and setting log-on as 'starting', thereby establishing a basic database; establishing a 'my User' menu, determining user types by use of 'user Type' fields, respectively endowing different authorities, and setting an ID number as a main key, wherein the menu in the database comprises spatial data and attribute data, and the attribute data comprise geographic attribute data and a user menu of a distributed database management system. The distributed database establishment disclosed by the invention has the beneficial effects of convenience in operation, rich functions, rapidness and convenience in calling, high efficiency and reliability, thereby being a distributed database with wide applicability.
Description
Technical field
The present invention relates to a kind of foundation of database, refer to specifically a kind of foundation of distributed data base.
Background technology
In data base management system (DBMS), database is the core of whole system, the feature of distributed data base has determined the features such as its data volume is large, dispersion, isomery, and this just needs a function-stable, supports distributed function and easy to operate database to carry out physical store.SQL Server 2005 is a Large-scale Relational Database management systems, and it presents a kind of data structure of multithreading, tight with the combination of Windows, also better with compatibility and the inheritance of .Net framework.SQL Server with Visual Studio integrated on also accomplished seamless link, feature richness is provided, has called service efficiently.It has reliable, efficient, distributed, intelligent platform management feature simultaneously, more simpler than Orcale operation, and cost is lower.
Summary of the invention
The present invention, for overcoming above-mentioned technical deficiency, provides following technical scheme:
A foundation for distributed data base, installs SQL Server 2005 and selects mixed mode login.Open SQL Server Management Studio, with SQL Server identity, login, newdata storehouse " SQLDemo ", in the attribute status tab of the user role " sa " of security options, will " whether allow to be connected to database engine " and be set to " authorizing ", login is set to " enabling ".Like this, a basic database just creates.
In the present invention, set up " myUser " list, use " userType " field to determine user type, give respectively different rights, and be made as major key by No. ID.
In the present invention, the list in database has comprised spatial data and attribute data, and wherein attribute data has also comprised user's list of distributed data base management system (DDBMS) except geographical attribute data.
The invention has the beneficial effects as follows: simple operation, feature richness, calls fast, and efficient, reliable, is a distributed data base that application is very wide.
Accompanying drawing explanation
Fig. 1 sets up the diagram of " myUser " list in distributed data base process of establishing.
Embodiment
SQL Server 2005 is installed and selects mixed mode login.Open SQL Server Management Studio, with SQL Server identity, login, newdata storehouse " SQLDemo ", in the attribute status tab of the user role " sa " of security options, will " whether allow to be connected to database engine " and be set to " authorizing ", login is set to " enabling ".Like this, a basic database just creates.
List in database has comprised spatial data and attribute data, and wherein attribute data has also comprised user's list of distributed data base management system (DDBMS) except geographical attribute data.
Set up " myUser " list, use " userType " field to determine user type, give respectively different rights, and be made as major key by No. ID: see accompanying drawing 1.
The above; it is only preferably embodiment of the present invention; but protection scope of the present invention is not limited to this; anyly be familiar with those skilled in the art in the technical scope that the present invention discloses; according to technical scheme of the present invention and inventive concept thereof, be equal to replacement or changed, within all should being encompassed in protection scope of the present invention.
Claims (3)
1. a foundation for distributed data base, is characterized in that, SQL Server 2005 is installed and selects mixed mode login; Open SQL Server Management Studio, with SQL Server identity, login, newdata storehouse " SQLDemo ", in the attribute status tab of the user role " sa " of security options, will " whether allow to be connected to database engine " and be set to " authorizing ", login is set to " enabling ", like this, a basic database just creates.
2. the foundation of a kind of distributed data base according to claim 1, is characterized in that, sets up " myUser " list, uses " userType " field to determine user type, gives respectively different rights, and is made as major key by No. ID.
3. the foundation of a kind of distributed data base according to claim 1, it is characterized in that, list in database has comprised spatial data and attribute data, and wherein attribute data has also comprised user's list of distributed data base management system (DDBMS) except geographical attribute data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310527711.XA CN103699565A (en) | 2013-10-31 | 2013-10-31 | Establishment method of distributed database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310527711.XA CN103699565A (en) | 2013-10-31 | 2013-10-31 | Establishment method of distributed database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103699565A true CN103699565A (en) | 2014-04-02 |
Family
ID=50361093
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310527711.XA Pending CN103699565A (en) | 2013-10-31 | 2013-10-31 | Establishment method of distributed database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103699565A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109144978A (en) * | 2018-08-15 | 2019-01-04 | 新华三大数据技术有限公司 | Right management method and device |
| WO2019007260A1 (en) * | 2017-07-05 | 2019-01-10 | 成都牵牛草信息技术有限公司 | Method for authorizing operation permissions of form field values |
| CN112835925A (en) * | 2021-02-02 | 2021-05-25 | 北京握奇数据股份有限公司 | Embedded chip SQL statement analysis method |
-
2013
- 2013-10-31 CN CN201310527711.XA patent/CN103699565A/en active Pending
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019007260A1 (en) * | 2017-07-05 | 2019-01-10 | 成都牵牛草信息技术有限公司 | Method for authorizing operation permissions of form field values |
| US11507651B2 (en) | 2017-07-05 | 2022-11-22 | Chengdu Qianniucao Information Technology Co., Ltd. | Method for authorizing operation permissions of form-field values |
| CN109144978A (en) * | 2018-08-15 | 2019-01-04 | 新华三大数据技术有限公司 | Right management method and device |
| CN109144978B (en) * | 2018-08-15 | 2020-12-01 | 新华三大数据技术有限公司 | Authority management method and device |
| CN112835925A (en) * | 2021-02-02 | 2021-05-25 | 北京握奇数据股份有限公司 | Embedded chip SQL statement analysis method |
| CN112835925B (en) * | 2021-02-02 | 2024-03-29 | 北京握奇数据股份有限公司 | SQL statement analysis method for embedded chip |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104932657A (en) | Mobile terminal power saving mode optimizing method and device, optimizing configuration information generating method and device | |
| CN104317821A (en) | Method for checking power failure information by using image technology | |
| CN105978147B (en) | The long-range fixed value modification system of automatic safety device based on file interaction | |
| CN105827598A (en) | Method and system for strengthening WiFi security of access router | |
| CN104486357A (en) | Method for achieving role-based access control (RBAC) based on SSH website | |
| CN103699565A (en) | Establishment method of distributed database | |
| CN104363263B (en) | Internet of Things general-purpose platform based on cloud service | |
| US11490176B2 (en) | Selective delivery state change of valve of remote metering device | |
| CN106534202A (en) | Permission processing method and device | |
| CN102594798A (en) | Agent method and system for connecting databases | |
| CN104331765A (en) | Public transport company vehicle and personnel management system | |
| CN104915412A (en) | Method and system for connecting dynamic management database | |
| CN104050244A (en) | Hand-held lightning query system applied in power grid | |
| Johnson | Smart City Development in China. | |
| CN105025035A (en) | Method and system for single-point security certification | |
| CN110304179A (en) | A kind of shared bicycle indicator lamp system for stopping timely feedbacking for failure and taboo | |
| CN202395813U (en) | Agent system connected with database | |
| CN105160473A (en) | Low-voltage user line loss analysis method | |
| CN102043993A (en) | System control method for transport management system | |
| CN103761293B (en) | Message prompt method, message management system and website platform | |
| JP6001688B2 (en) | Trigger software applications using cartographic expressions | |
| CN106169746A (en) | A kind of grid power blackout early warning system and method | |
| CN113626857A (en) | Meteorological information sharing service system based on visual plug-in and use method | |
| CN103605679A (en) | Distribution database map generation operation method | |
| Zou et al. | Integrated management of internet of things in nanhai district and its application to smart city |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140402 |