CN105426371A - Database system - Google Patents
Database system Download PDFInfo
- Publication number
- CN105426371A CN105426371A CN201410474917.5A CN201410474917A CN105426371A CN 105426371 A CN105426371 A CN 105426371A CN 201410474917 A CN201410474917 A CN 201410474917A CN 105426371 A CN105426371 A CN 105426371A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- server
- client
- internal memory
- 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
Abstract
The present invention discloses a database system. The database system comprises a database server, a network server, and a client. The database server uses a memory database and is configured to store data. The network server is deployed with multiple network services for the client to invoke, wherein the multiple network services are separately used for operating the memory database, acquiring result data returned by the memory database, and feeding back the acquired result data to the client. The client comprises a searching module, wherein the searching module is configured to acquire a query condition and operate the memory database according to the query condition and by invoking a network service. According to the database system provided by the present invention, a memory database is used, and a network service is appropriately equipped, so that data analysis efficiency is greatly improved, an architecture is clear, deployment is convenient, and custom-built development can be performed according to requirements of a client. Therefore, it is convenient for the client to perform detailed control on a data analysis result at any time, and the result can be presented more intuitively.
Description
Technical field
The present invention relates to a kind of Database Systems.
Background technology
After enterprise information system begins to take shape; the sales data of retail shops is all converging to general headquarters every day; enterprise how is allowed to understand the critical data of operation in time; allow leader see crisis and opportunity behind in data, become the current focus being in the domestic retaling enterprise common concern in information-based forward position.And traditional Intellectual analysis software (being called for short BI) needs to set up data warehouse in advance, custom analysis model, writing corresponding ETL (is the abbreviation of English Extract-Transform-Load, to be used for describing by data from source terminal through extraction (extract), transposition (transform), to load (load) to process of destination) with CUBE (sql statement, i.e. a part of Structured Query Language (SQL)) relative program.The project implementation cycle is long, and implementation cost is high.Extendability is poor, and a modeling needs to consider all possibilities, when client proposes new demand, changes data structure program work amount large.
Summary of the invention
The technical problem to be solved in the present invention needs to set up data warehouse in advance to overcome Intellectual analysis software traditional in prior art, and custom analysis model, writes corresponding ETL and CUBE relative program.The project implementation cycle is long, and implementation cost is high.Extendability is poor, and a modeling needs to consider all possibilities, when client proposes new demand, changes the defect that data structure program work amount is large, and provides a kind of Database Systems.
The present invention solves above-mentioned technical matters by following technical proposals:
The invention provides a kind of Database Systems, its feature is, comprise database server, webservice server and client, database server adopts internal memory type database, and for storing data, webservice server disposition has the multiple webservice for client call, this multiple webservice is respectively used to operate internal memory type database and obtains the result data that internal memory type database returns, then the result data of acquisition is fed back to client, client comprises retrieval module, retrieval module is for obtaining querying condition, then call webservice operate this internal memory type database according to querying condition.
Preferably, webservice server has the access rights completely to database server.
WebService is network service, and it can make to operate in different application on different machines by additional, special third party software or hardware, just can need not exchange data or integrated mutually.The deployment of webservice can based on the subset X ML under such as standard generalized markup language, HTTP etc.Based on the demand of exchanges data, webService server has the access rights completely to database server.
Preferably, internal memory type database only when this multiple webservice operation by Data import to internal memory, the data reader of internal memory type database is made as the data on direct reading internal memory.
Preferably, this multiple webservice is Javawebservice.Java is a kind of object oriented program language can writing cross-platform software
Preferably, client also comprises output module, for exporting the result data of webservice server feedback with the form of form, figure and/or form.
Preferably, these Database Systems also comprise original data server, original data server is for storing raw data, database server also comprises data importing module, data importing module is for cleaning raw data, and then the valid data extracted in raw data arrange and are directed in internal memory type database and store.
Preferably, data importing module is used for valid data row to be converted to csv file, to be then directed in internal memory type database by csv file by the data importing instrument preset and to store.CSV is the english abbreviation of (comma separated value), is all text-only file usually.
On the basis meeting this area general knowledge, above-mentioned each optimum condition, can combination in any, obtains the preferred embodiments of the invention.
Positive progressive effect of the present invention is: Database Systems of the present invention are by adopting internal memory type database and being suitably equipped with webservice, thus make that data analysis efficiency improves greatly, framework is clear, deployment is convenient, and can carry out according to the demand of client the exploitation that customizes, facilitate client to carry out detailed control to the result of data analysis at any time, and result can be represented more intuitively.
Accompanying drawing explanation
Fig. 1 is the schematic diagram of the Database Systems of a preferred embodiment of the present invention.
Fig. 2 is the system flow schematic diagram of an application example of the Database Systems of application a preferred embodiment of the present invention.
Fig. 3 is the system logic architecture schematic diagram of an application example of the Database Systems of application a preferred embodiment of the present invention.
Embodiment
Mode below by embodiment further illustrates the present invention, but does not therefore limit the present invention among described scope of embodiments.
As shown in Figure 1, the Database Systems of a preferred embodiment comprise database server 3, webservice server 2, original data server 4 and client 1.
Wherein, database server 3 adopts internal memory type database and for storing data, webservice server 2 is deployed with the multiple webservice called for client 1, this multiple webservice is respectively used to operate internal memory type database and obtains result data that internal memory type database returns, then the result data of acquisition is fed back to client 1, client 1 comprises retrieval module, and retrieval module is for obtaining querying condition, then calling webservice operate this internal memory type database according to querying condition.Original data server 4 is for storing raw data, and database server 3 also comprises data importing module, and data importing module is for cleaning raw data, and then the valid data extracted in raw data arrange and are directed in internal memory type database and store.
Webservice server 2 has the access rights completely to database server 3.Internal memory type database only when this multiple webservice operation by Data import to internal memory, the data reader of internal memory type database is made as the data on direct reading internal memory.This multiple webservice is Javawebservice.Client 1 also comprises output module, for exporting the result data that webservice server 2 feeds back with the form of form, figure and form.
Data importing module is used for valid data row to be converted to csv file, to be then directed in internal memory type database by csv file by the data importing instrument preset and to store.CSV is the english abbreviation of (comma separated value), is all text-only file usually.
Use flow process and the system logic architecture of an application example of the Database Systems of application the present embodiment is described in detail below in conjunction with Fig. 2 and Fig. 3.
With reference to figure 3 system logic figure shown in, this application example comprises layer data stream, the engine layers of service data derived data form, the client presentation layer of most higher level from down to up successively.
Below first this layer data stream is described.Shown in figure 2 and Fig. 3, from the raw data file that convenience store comes, comprise main file file with selling POS data, file primary format has CSV, XML, DBF, XLS, TXT, by SSIS (MicrosoftSQLServerIntegrationServices), the instruments such as storing process or method import to raw data and store in SQLServer.Then once clean raw data, the valid data row extracted in raw data export as the CSV securing form.The csv file that previous step derives imports in memory database through the data importing instrument write as according to memory database API.
Below Report Engine and client are described.Shown in same reference diagram 2 and Fig. 3, the API that Report Engine uses memory database open, then develop according to corresponding demand and inquire about WebService accordingly, support multiple report output form, many condition query composition, performs generating report forms according to schedule.All work transfers to WebService to complete to operate memory database entirely, thus the workload of foreground client is alleviated greatly.And client goes operation memory database to obtain report data by calling statistical tables and reports engine.Supported data extracts inquiry, multiple conditional combination inquiry, instant analysis, and supports data query control of authority, and use form to carry out display data with figure two kinds of modes, form can be saved in this locality with figure, convenient and swift.
Although the foregoing describe the specific embodiment of the present invention, it will be understood by those of skill in the art that these only illustrate, protection scope of the present invention is defined by the appended claims.Those skilled in the art, under the prerequisite not deviating from principle of the present invention and essence, can make various changes or modifications to these embodiments, but these change and amendment all falls into protection scope of the present invention.
Claims (7)
1. Database Systems, it is characterized in that, comprise database server, webservice server and client, database server adopts internal memory type database, and for storing data, webservice server disposition has the multiple webservice for client call, this multiple webservice is respectively used to operate internal memory type database and obtains the result data that internal memory type database returns, then the result data of acquisition is fed back to client, client comprises retrieval module, retrieval module is for obtaining querying condition, then call webservice operate this internal memory type database according to querying condition.
2. Database Systems as claimed in claim 1, it is characterized in that, webservice server has the access rights completely to database server.
3. Database Systems as claimed in claim 1, is characterized in that, internal memory type database only when this multiple webservice operation by Data import to internal memory, the data reader of internal memory type database is made as the data on direct reading internal memory.
4. Database Systems as claimed in claim 1, it is characterized in that, this multiple webservice is Javawebservice.
5. Database Systems as claimed in claim 1, it is characterized in that, client also comprises output module, for exporting the result data of webservice server feedback with the form of form, figure and/or form.
6. as the Database Systems in claim 1-5 as described in any one, it is characterized in that, also comprise original data server, original data server is for storing raw data, database server also comprises data importing module, data importing module is for cleaning raw data, and then the valid data extracted in raw data arrange and are directed in internal memory type database and store.
7. Database Systems as claimed in claim 6, is characterized in that, data importing module is used for valid data row to be converted to csv file, to be then directed in internal memory type database by csv file by the data importing instrument preset and to store.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410474917.5A CN105426371A (en) | 2014-09-17 | 2014-09-17 | Database system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410474917.5A CN105426371A (en) | 2014-09-17 | 2014-09-17 | Database system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105426371A true CN105426371A (en) | 2016-03-23 |
Family
ID=55504584
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410474917.5A Pending CN105426371A (en) | 2014-09-17 | 2014-09-17 | Database system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105426371A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060031413A1 (en) * | 2004-04-28 | 2006-02-09 | Achim Enenkiel | Computer systems and methods for providing failure protection |
| CN101110115A (en) * | 2006-07-20 | 2008-01-23 | 阿里巴巴公司 | Method for processing merchandise information in internet and system thereof |
| CN101123032A (en) * | 2007-07-26 | 2008-02-13 | 南京大学 | Temperature monitoring system and monitoring method for computer room based on Web Service |
| CN101373474A (en) * | 2008-09-02 | 2009-02-25 | 北京开拓天际信息技术有限公司 | Magnanimity data real time processing structure and real time processing platform following with necessaries for the same |
| CN102567333A (en) * | 2010-12-15 | 2012-07-11 | 上海杉达学院 | Distributed heterogeneous data integration system |
| CN102739720A (en) * | 2011-04-14 | 2012-10-17 | 中兴通讯股份有限公司 | Distributed cache server system and application method thereof, cache clients and cache server terminals |
| CN102917038A (en) * | 2012-10-10 | 2013-02-06 | 江苏物联网研究发展中心 | Cloud computation based remote service system for medical internet of things |
| CN103092873A (en) * | 2011-11-01 | 2013-05-08 | 镇江华扬信息科技有限公司 | XML (Extensive Makeup Language) and Web Service technology based isomerous database integration method |
-
2014
- 2014-09-17 CN CN201410474917.5A patent/CN105426371A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060031413A1 (en) * | 2004-04-28 | 2006-02-09 | Achim Enenkiel | Computer systems and methods for providing failure protection |
| CN101110115A (en) * | 2006-07-20 | 2008-01-23 | 阿里巴巴公司 | Method for processing merchandise information in internet and system thereof |
| CN101123032A (en) * | 2007-07-26 | 2008-02-13 | 南京大学 | Temperature monitoring system and monitoring method for computer room based on Web Service |
| CN101373474A (en) * | 2008-09-02 | 2009-02-25 | 北京开拓天际信息技术有限公司 | Magnanimity data real time processing structure and real time processing platform following with necessaries for the same |
| CN102567333A (en) * | 2010-12-15 | 2012-07-11 | 上海杉达学院 | Distributed heterogeneous data integration system |
| CN102739720A (en) * | 2011-04-14 | 2012-10-17 | 中兴通讯股份有限公司 | Distributed cache server system and application method thereof, cache clients and cache server terminals |
| CN103092873A (en) * | 2011-11-01 | 2013-05-08 | 镇江华扬信息科技有限公司 | XML (Extensive Makeup Language) and Web Service technology based isomerous database integration method |
| CN102917038A (en) * | 2012-10-10 | 2013-02-06 | 江苏物联网研究发展中心 | Cloud computation based remote service system for medical internet of things |
Non-Patent Citations (1)
| Title |
|---|
| 《中国优秀硕士学位论文全文数据库信息科技辑（月刊）》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108536761B (en) | Report data query method and server | |
| US11575746B2 (en) | System and method for real-time cloud data synchronization using a database binary log | |
| KR101621137B1 (en) | Low latency query engine for apache hadoop | |
| CN102426589B (en) | Interlayer system used for searching database information and information searching method | |
| US8370303B1 (en) | Generating snapshots of data tables | |
| CN104102710A (en) | Massive data query method | |
| CN100587693C (en) | Method and system for obtaining data from a plurality of data pool | |
| CN106326429A (en) | Hbase second-level query scheme based on solr | |
| CN104778175A (en) | Method and system for realizing data synchronization of heterogeneous database | |
| CN104866599A (en) | Production method and system of visual report | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN104573065A (en) | Report display engine based on metadata | |
| CN102917009B (en) | A kind of stock certificate data collection based on cloud computing technology and storage means and system | |
| CN104239572A (en) | System and method for achieving metadata analysis based on distributed cache | |
| CN105930446A (en) | Telecommunication customer tag generation method based on Hadoop distributed technology | |
| CN105468720A (en) | Method for integrating distributed data processing systems, corresponding systems and data processing method | |
| CN104408171A (en) | Receipt sub-table row-correlated query device and method | |
| CN104899295A (en) | Heterogeneous data source data association analysis method | |
| CN109582695A (en) | Data general-purpose querying method and inquiry system under a kind of micro services framework | |
| CN104572856A (en) | Converged storage method of service source data | |
| US8781919B2 (en) | Data row packing apparatus, systems, and methods | |
| CN102902777A (en) | Cross data source inquiry device and cross data source inquiry method | |
| CN109271449A (en) | A kind of distributed storage inquiry system file-based and querying method | |
| CN104199978A (en) | System and method for realizing metadata cache and analysis based on NoSQL and method | |
| US20150317336A1 (en) | Data reconstruction |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160323 |
|
| WD01 | Invention patent application deemed withdrawn after publication |